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.

These courses are required to be completed prior to starting this course:

  • Getting Started with Spreadsheet Modeling and Business Analytics
  • Harvesting Spreadsheet Data
  • Visualizing and Communicating Insights in Excel
  • Making Predictions and Forecasts with Data
  • Using Prescriptive Analytics in Excel

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

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a section to enroll in

Type
2 week
Dates
Aug 26, 2020 to Sep 08, 2020
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Sep 23, 2020 to Oct 06, 2020
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Oct 21, 2020 to Nov 03, 2020
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Nov 18, 2020 to Dec 01, 2020
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Dec 16, 2020 to Dec 29, 2020
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jan 13, 2021 to Jan 26, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jan 27, 2021 to Feb 09, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Feb 10, 2021 to Feb 23, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Feb 24, 2021 to Mar 09, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Mar 10, 2021 to Mar 23, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Mar 24, 2021 to Apr 06, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Apr 07, 2021 to Apr 20, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Apr 21, 2021 to May 04, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
May 05, 2021 to May 18, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
May 19, 2021 to Jun 01, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jun 02, 2021 to Jun 15, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jun 16, 2021 to Jun 29, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jun 30, 2021 to Jul 13, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jul 14, 2021 to Jul 27, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Jul 28, 2021 to Aug 10, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Aug 11, 2021 to Aug 24, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Aug 25, 2021 to Sep 07, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Sep 08, 2021 to Sep 21, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Sep 22, 2021 to Oct 05, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Oct 06, 2021 to Oct 19, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Oct 20, 2021 to Nov 02, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Nov 03, 2021 to Nov 16, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Nov 17, 2021 to Nov 30, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Dec 01, 2021 to Dec 14, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Dec 15, 2021 to Dec 28, 2021
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Type
2 week
Dates
Dec 29, 2021 to Jan 11, 2022
Total Number of Hours
10.0
Course Fee(s)
Standard Price $769.00
Required fields are indicated by .