Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel- Create Dashboards and Master Power Query
Rating: 4.4 out of 5(45 ratings)
148 students

Microsoft Excel- Create Dashboards and Master Power Query

Learn Power Query, Pivot Tables, and Excel formulas by building a real sales dashboard - no prior experience needed.
Created byAmit Marmari
Last updated 3/2023
English

What you'll learn

  • Learn how to create dashboard from scratch
  • Mastering Microsoft Excel fundamentals
  • Get to know Excel's basic formulas
  • Mastering Pivot Tables and Charts
  • Mastering Power Query and get to know the tool - as it also useful for Power BI

Course content

6 sections60 lectures3h 4m total length
  • Preview and Advertisement0:55
  • Setting Expectations0:50
  • Introducing the tables4:23
  • Excel + Computer's Basics15:24

Requirements

  • No prior Microsoft Excel knowledge required
  • Microsoft Excel installed

Description

Build a complete Excel sales dashboard in 3 hours - even if you've never used Power Query before.

This is the most direct path from "I know basic Excel" to "I built a dashboard my manager actually uses." No filler, no 30-hour theory marathons - just the exact skills employers and managers care about, taught through a real project.


By the end of this course, you'll be able to:

✓ Connect and clean messy data with Power Query (the #1 skill ChatGPT can't do for you)

✓ Build dynamic Pivot Tables and Pivot Charts that update automatically

✓ Use the Excel formulas that actually matter at work (XLOOKUP, SUMIFS, INDEX/MATCH, and more)

✓ Design a professional sales dashboard from scratch - one you can put on your resume

✓ Understand WHY each step matters, not just which buttons to click


Who this course is for:

- Beginners who want to stop Googling Excel formulas every 5 minutes

- Junior analysts preparing for their first dashboard project at work

- Anyone tired of asking AI to "just do it" and wanting to actually understand what's happening


Why this course is different in 2026:

AI can write formulas. AI can't build judgment. This course teaches you to think like an analyst - to know which data matters, how to structure a dashboard people actually use, and why one approach beats another. That's the skill that makes you valuable.


Includes:

- 3 hours of focused, no-fluff video lessons

- Downloadable Excel files to follow along

- Lifetime access and free updates

- Udemy's 30-day money-back guarantee


P.S. - I want to thank Daniel Harosh for editing this course. You are amazing.

Also, this course is dedicated to my late friends, Eytam Magini and Tomer Morad. I miss you guys.

Who this course is for:

  • Microsoft Excel users
  • Dashboard builders - beginners to pros
  • Power BI users