Name: Microsoft Excel - Dashboards & Data Analytics
Availability: InStock

What You'll Learn

Understand what Excel dashboards are, how they work, and their value in business reporting.
Learn to clean and organize raw data to prepare it for meaningful analysis.
Create dashboards using Excel’s native tools like sorting, filtering, grouping, and basic visual formatting.
Build professional dashboards that include interactive features such as drop-downs and buttons.
Use charts effectively to visualize key metrics and insights.
Apply conditional formatting and cell linking to enhance dashboard presentation.
Work with Power Query to load, clean, and transform data from multiple sources.
Use append, merge, group, and split operations in Power Query to handle complex datasets.
Create advanced dashboards with PivotTables and PivotCharts for dynamic, update-ready reports.
Evaluate your learning through a final assessment designed to reinforce key concepts covered in the course.

Requirements

No Prior Excel Knowledge Required
It is recommended to have Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Microsoft 365 Excel installed on your computer to actively participate in and follow along with the instructor's lectures.

Anyone who wants to learn how to build professional dashboards in Microsoft Excel.
Students, working professionals, business analysts, and managers who need to summarize and visualize data effectively.
Excel users looking to move beyond formulas and charts into real-world dashboard and data analysis applications.
Beginners with basic Excel knowledge who want to build confidence in data cleaning, organization, and reporting.
Individuals interested in mastering Power Query and PivotTables for powerful, automated data analysis.
Anyone preparing for data-driven roles or upskilling in business intelligence and reporting.

Empowering people on their journey to success.

4.6 Instructor Rating

1,566 Reviews

24,553 Students

18 Courses

19.99 FREE 100% OFF

Limited time offer

Certificate of Completion

Full Lifetime Access

Access on Mobile & TV