Create rich and interactive dashboard


Learn how to build a fully interactive and a self-service business intelligence dashboard using Microsoft Excel.


20% OFF ($24 → $19)



Data visualization and Dashboard design skills have become a sought-after skill and valuable to businesses in almost all industries.

A dashboard is a visual representation of key metrics that allow users to quickly view and analyze data in one place.

Dashboards not only provide consolidated data views, but serves as a self-service business intelligence tool, where users are able to explore data and discover insights quickly. 

Using a Business Intelligence tool like Microsoft Excel, you can develop rich and interactive dashboards and reports. In this course, you will learn how to use Microsoft Excel to analyze and visualize data to design interactive and automate reports and dashboards.

Your ability to design and develop a compelling and automated dashboards and reports will help you stand out at the workplace and help you accelerate your career.

Who should enroll?

This course is designed for individuals who use data in the business setting. If you are responsible for presenting data in your day-to-day job, or a data analyst, then this course is for you.


What you'll learn:

  • Report theme customization
  • Data analysis using PivotTables
  • Data visualization
  • Pivot charts and graphs
  • Dashboard Design
  • Workbook and worksheet protection.


Benefit of this course

  • A guided learning approach.
  • Hands-on and highly practical.
  • Downloadable Dataset and the Completed Dashboard.
  • High quality videos.
  • Access to support from instructor.
  • Certificate of completion.
  • Lifetime access to videos


Prerequisites:

  • To get the most of the course, you need Microsoft Excel 2010 or later version for Windows or Mac. This course is filmed with Excel for windows, However, if you are Mac user, you can still follow the lessons.
  • You know how to work with basic formulas and functions in Excel.
  • Basic knowledge of PivotTables is required. If you are need to PivotTables, you can check our free Excel fundamentals course.

Note: This course is not for complete beginners. If you are a complete beginner or new to Excel, we encourage you to check our free Excel fundamentals course before signing up for this course.

Sample Lesson

Connecting slicers to multiple Pivot tables for interactivity

Course Content