Loading...

Course Description

Have you ever had to do an analysis of data but found that the data you needed was not all in one place? It could be online, in separate Excel files, or you might find that it's in different formats. It could take hours to convert and organize everything you need. In this course you will learn Excel's options for data management and modeling to relate data from multiple sources quickly and create interactive dashboards that answer dozens of questions. You will be able to import data from different Excel workbook files into one file or even import data in different formats like Notepad for the web and different databases.

You are required to have completed the following course or have equivalent experience before taking this course:

  • Getting Started with Spreadsheet Modeling and Business Analytics

Faculty Author

Donna L. Haeger, Professor of Practice, Cornell Dyson School

Benefits to the Learner

  • Create a (data model) relational database from multiple data sources
  • Power Pivot using data from different sources
  • Import and relate data from different sources
  • Add interactivity to your data sets with dashboards

Target Audience

  • Anyone who manages functional or financial data to inform business decisions
  • Managers and executives responsible for resource allocation and reporting
  • Analysts interested in developing a business management mindset to make their analyses and data visualizations more meaningful to stakeholders
  • New analysts or people interested in moving into an analyst role
  • Individuals and entrepreneurs who need to visualize data or want a refresher on using a modern version of Excel
  • People in office support roles, administrative and executive assistants
  • People providing support at any level

Accrediting Associations

Applies Towards the Following Certificates

Loading...
Cornell Dyson School
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .