Udemy

Advanced Microsoft Interactive and Dynamic Excel Dashboard

Enroll Now
  • 1,759 Students
  • Updated 4/2025
4.3
(149 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
15 Hour(s) 12 Minute(s)
Language
English
Taught by
Ismaila Mumuni Omeiza
Rating
4.3
(149 Ratings)

Course Overview

Advanced Microsoft Interactive and Dynamic Excel Dashboard

2023 (Edition) Start an Advanced Excel Dashboard Today using Power Pivot, DAX, Power Query and Advanced Excel Functions

If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.


This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).


Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.


Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.


This course is 100% practical


Microsoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)


Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.


If you are ready to learn with me, let's join the class and see how creative you could be in the few days to come as you begin the class.


Remember you have life Time access to this course.

This course will be updated frequently with the new dashboard.

be free to ask questions should you got stuck in any of the steps.


I am already waiting for you in the class, nice to have you.




Course Content

  • 9 section(s)
  • 101 lecture(s)
  • Section 1 Getting Started
  • Section 2 Advanced Power Query In Excel for Data Cleaning and Transformation
  • Section 3 How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports
  • Section 4 DAX Pack (common DAX functions)
  • Section 5 Advanced Customer Dashboard in Excel using DAX and Excel Functions
  • Section 6 Adidas Sales Dashboard
  • Section 7 Full Dynamic HR (Human Resources) Dashboard
  • Section 8 Bonus Dashboard( Adventure Works)
  • Section 9 New Sales Dashboard Bonus

What You’ll Learn

  • Learn how to write DAX (Data analysis Expression) to create advanced dashboard in Excel
  • Learn how to use Power Pivot and Power Query in Excel for advanced data Analysis
  • Mix formula and function with Pivot Table to create interacive dashboard
  • How to use data to make business decisions
  • How to market your new dashboard skill
  • How to create Portfolio to showcase your dashboard to prospective Employers


Reviews

  • M
    Mosima Ngwetjana
    4.5

    very informative and good example and explanation for a beginner

  • K
    Krushna chandra Panda
    5.0

    This powerful knowledge will give you the idea on how to create a dashboard.Thank u

  • D
    Darko Domonji
    5.0

    Perfect :-=)

  • K
    Kehinde Ogunseun
    5.0

    Great

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed