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...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
May 01, 2024 to May 14, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 15, 2024 to May 28, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 29, 2024 to Jun 11, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 29, 2024 to Jun 11, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 29, 2024 to Jun 11, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jun 12, 2024 to Jun 25, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jun 26, 2024 to Jul 09, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jul 10, 2024 to Jul 23, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jul 24, 2024 to Aug 06, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Aug 07, 2024 to Aug 20, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Aug 21, 2024 to Sep 03, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Sep 04, 2024 to Sep 17, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Sep 18, 2024 to Oct 01, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Oct 02, 2024 to Oct 15, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Oct 16, 2024 to Oct 29, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Oct 30, 2024 to Nov 12, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Nov 13, 2024 to Nov 26, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Nov 27, 2024 to Dec 10, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Dec 11, 2024 to Dec 24, 2024
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Dec 25, 2024 to Jan 07, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jan 08, 2025 to Jan 21, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jan 22, 2025 to Feb 04, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Feb 05, 2025 to Feb 18, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Feb 19, 2025 to Mar 04, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Mar 05, 2025 to Mar 18, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Mar 19, 2025 to Apr 01, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Apr 02, 2025 to Apr 15, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Apr 16, 2025 to Apr 29, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Apr 30, 2025 to May 13, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 14, 2025 to May 27, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
May 28, 2025 to Jun 10, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jun 11, 2025 to Jun 24, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Type
2 week
Dates
Jun 25, 2025 to Jul 08, 2025
Total Number of Hours
10.0
Course Fee(s)
Standard Price $1,380.00
Required fields are indicated by .