Creating Interactive Excel Dashboards

Master Interactive Dashboard Design and Data Analysis

4.8(52)5h 27m21 lectures2 sections

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

1

Excel Dashboards

20 lectures
  1. The Introduction6:23
  2. Pivot Table16:39
  3. Pivot Tables & Relationships9:57
  4. Pivot Table & Slicer6:49
  5. Count & Distinct Count in Pivot Tables4:54
  6. Dashboard design (Part 1)11:05
  7. Dashboard design (Part 2)25:21
  8. Column - Bar chart35:41
  9. Buttons - Icons15:41
  10. Percentage11:09
  11. Pareto - Combo Chart6:26
  12. YOY29:00
  13. Percentage Charts and Values6:47
  14. Actual Vs Target5:11
  15. Power Query (Part 1)22:28
  16. Power Query (Part 2)33:04
  17. Final Project (Part 1)38:33
  18. Final Project (Part 2)22:09
  19. Final Project (Part 3)8:18
  20. Final Project (Part 4)11:47
2

Appendices

1 attachments
  1. Download the Attachments

Instructor

Mohamed Khalaf

Mohamed Khalaf

Data analysis and business intelligence specialist, lecturer, and trainer in statistical analysis programs.
3,768 students6 courses