Microsoft Excel - Dashboards & Data Analytics

Build interactive Excel dashboards and analyze data using Power Query, PivotTables, and core Excel tools

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.

Description
Embark on a focused, hands-on journey with “Microsoft Excel – Dashboards & Data Analytics,” a professionally designed course by Anjan Banerjee — a Microsoft Certified Educator and Excel Expert with decades of real-world data analysis experience. This comprehensive program is thoughtfully divided into two powerful segments, guiding learners from core Excel analytics to dynamic dashboard creation.

In the first part of the course, you’ll work with Excel’s traditional toolset — cleaning raw data, using lookup functions, filters, subtotals, and building insightful visualizations. These foundational techniques form the bedrock of professional dashboard design.

The second part unlocks the advanced capabilities ofPower Query and PivotTables, where you’ll learn to automate data preparation, connect multiple datasets, and build dashboards that refresh at the click of a button — a must-have skill in modern business intelligence.

To support your learning, the course includesdownloadable practice filesso you can apply what you learn immediately. AFinal Assessment Testat the end allows you to evaluate your progress and reinforce your understanding. With lifetime access across all devices, this course adapts to your schedule and pace.

Whether you're an analyst, manager, student, or Excel enthusiast looking to harness the power of data, this course is built for you. Develop a practical, job-ready skill set and gain the confidence to turn raw data into interactive dashboards and clear business insights.

Enroll now and master the art of data storytelling with Excel — with expert guidance from Anjan Banerjee!

Who this course is for:
- 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.
More Info