[closed] Do data administrators work with Microsoft Office programs like Excel?
Hello,
My name is Aimee and I am a current business senior major in college. I have a major of administration and a concentration of management. I love to learn more about business and some applications of data administration. My goal is to go into management or become some type of office assitant, so I am dedicated to learning more about managing data. Do these type of professionals need a know how to use excel and data management programs? If so, what can I do now as a student to prepare myself for the great opportunity? I would like to become part of a group of administration professionals to lead the others. #business-administration #business-management
1 answer
syed’s Answer
Data in an Excel workbook can come from two different locations. The data may be stored directly in the workbook, or it may be stored in an external data source, such as a text file, a database, or an Online Analytical Processing (OLAP) cube. This external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in to, and access the external data source.
The main benefit of connecting to external data is that you can periodically analyze this data without repeatedly copying the data to your workbook, which is an operation that can be time consuming and prone to error. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.