Loading...

Course Description

Organizations have a tremendous amount of data at their disposal to help them develop strategic plans and make informed business decisions. Helping people make sense of that data quickly and easily, however, can be a challenging proposition. In this course, you will examine how to use built-in Excel tools and create custom Excel-based dashboards to turn data into a valuable organizational asset.

As you work through this course, you will get hands-on practice implementing a variety of functions and techniques to develop Excel-based analytical tools. By applying intelligent design principles, you will build dashboards that clearly guide user input and provide results dynamically, giving users the ability to specify the data they want to see and providing output in a flexible format. You will implement strategies to create dashboards that can effectively handle many types of data and offer an informative and user-friendly interface with a combination of numeric and graphic outputs. By the end of this course, you will have acquired an assortment of tools, practices, and techniques you can utilize to grow your portfolio of dashboard development skills.

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

  • Making Data Usable

Faculty Author

Kathryn Caggiano

Benefits to the Learner

  • Use PivotTables and PivotCharts to get answers to quantitative questions quickly by partitioning, extracting, summarizing, and visualizing data
  • Develop Excel-based dashboards with best design practices to promote clarity, usability, and robustness
  • Build customized dashboards in Excel to dynamically display numeric and graphic output for data over time
  • Build customized dashboards in Excel to analyze frequency data, allowing for inputs on multiple criteria

Target Audience

  • Finance professionals
  • Data analysts
  • Data scientists
  • Business analysts
  • Engineers
  • Managers and executives
  • Students who need in-depth Excel knowledge

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
May 22, 2024 to Jun 04, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Jul 17, 2024 to Jul 30, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Sep 11, 2024 to Sep 24, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Type
2 week
Dates
Nov 06, 2024 to Nov 19, 2024
Total Number of Hours
16.0
Course Fee(s)
Standard Price $1,199.00
Section Notes

IMPORTANT COURSE INFORMATION

  • The courses in this certificate use Microsoft Excel 2016 for Windows. We highly recommend you use this version of Excel so you can easily replicate the tools and functions demonstrated in the course.
Required fields are indicated by .