Creating Interactive Excel Dashboards
Master Interactive Dashboard Design and Data Analysis
What you'll learn
- Understand the basics of dashboards
- Learn to work with pivot tables
- Master designing interactive dashboards
- Use Power Query for data analysis
- Analyze data to support decisions
- Design interactive dashboards
About this course
In this course on creating interactive dashboards and data analysis using Excel, we will cover the fundamentals and advanced concepts of data analysis and dashboard creation using one of the most popular and powerful tools in the world, Microsoft Excel. We will start by learning how to import, clean, and prepare data for analysis. Then, we will delve into learning the various functions and formulas that can be used for data analysis. After that, we will learn how to create interactive dashboards that present data in clear and understandable visual ways. Regardless of your background or experience level, this course is designed to equip you with the skills needed to analyze data and create dashboards efficiently.
Expected outcomes
- Create professional dashboards using Excel.
- Analyze data using PivotTables and Power Query.
- Design interactive charts that support presentations and reports.
- Implement comprehensive final projects using real data.
Course content
1Excel Dashboards
20 lectures
- The Introduction6:23
- Pivot Table16:39
- Pivot Tables & Relationships9:57
- Pivot Table & Slicer6:49
- Count & Distinct Count in Pivot Tables4:54
- Dashboard design (Part 1)11:05
- Dashboard design (Part 2)25:21
- Column - Bar chart35:41
- Buttons - Icons15:41
- Percentage11:09
- Pareto - Combo Chart6:26
- YOY29:00
- Percentage Charts and Values6:47
- Actual Vs Target5:11
- Power Query (Part 1)22:28
- Power Query (Part 2)33:04
- Final Project (Part 1)38:33
- Final Project (Part 2)22:09
- Final Project (Part 3)8:18
- Final Project (Part 4)11:47
2Appendices
1 attachments
- Download the Attachments
Instructor
Mohamed Khalaf
This course is part of the diploma
