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 of Power 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 includes downloadable practice files so you can apply what you learn immediately. A Final Assessment Test at 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.