Advanced Excel for Data Analysts (Intermediate)
Creator: Reinhard Eugene June 30, 2026What You'll Learn
- Automate data import and cleaning from diverse sources like web pages and local files using Power Query.
- Transform raw data by promoting headers, replacing values, filling blanks, and correcting data types efficiently.
- Build relational data models in Excel using Power Pivot to connect multiple tables without duplicating data.
- Create custom measures with DAX to perform complex calculations directly within your data model.
- Normalize messy data for use in Power Pivot, ensuring clean and efficient models.
- Design dynamic Excel dashboards that leverage connected data for robust and interactive reporting.
About This Course
You're likely familiar with VLOOKUP or XLOOKUP for pulling data, but they can slow down your files and duplicate information when dealing with larger datasets. This course shows you how to move beyond these limitations by thinking like a database, connecting data efficiently using Power Query and Power Pivot. You will learn to automate data cleaning, build robust relational models, and create custom calculations that perform efficiently. This approach lets you build dynamic, interactive dashboards without writing thousands of slow, duplicating formulas, transforming how you analyze and report data.
Who this is for: This course is for intermediate Excel users and data analysts who regularly work with large datasets and want to build more robust, efficient reporting systems. You should be comfortable with basic Excel functions and data manipulation.
Modules
01: Power Query Introduction & Automation
78 min
02: Mastering Power Query M Language & Errors
46 min
03: Mastering Power Pivot & Relational Data Models
85 min
04: Data Normalization for Robust Models
19 min
05: Creating Dynamic Excel Dashboards
45 min
01: Power Query Introduction & Automation
78 min
02: Mastering Power Query M Language & Errors
46 min
03: Mastering Power Pivot & Relational Data Models
85 min
04: Data Normalization for Robust Models
19 min
05: Creating Dynamic Excel Dashboards
45 min
Final Quiz
Covers all 5 modules. Pass with 80% or higher to complete the course.
New To YouVersity?
This course is built from real YouTube videos, structured into modules with quizzes and progress tracking. Original creators keep every view and every ad dollar — courses just send them focused, motivated viewers.
- Structured modules
- Free to enrol
- Progress saved across devices
- Quizzes after each section
Ready To Start?
Begin the first module now. No credit card needed
Before You Decide
Playlists don't have quizzes, don't track progress, don't pull videos from multiple channels into a sequence, and don't give you a certificate. A playlist is a list. This is a course.
The videos are still free. What costs money is the structure around them: modules in the right order, quizzes built from the content, progress that follows you across devices, and a certificate at the end. You could piece all of that together yourself. Or you could have it built in minutes.
They're yours. Permanently. Every certificate you earned stays dated, valid, and shareable whether you're still subscribed or not. Cancelling doesn't touch anything you've already completed.
Install it from the Chrome Web Store. When you're on any YouTube video, click the YouVersity icon to save it to your library. Once you've saved enough, turn your library into a structured course. It's a second way to create courses: instead of typing a topic, you hand-pick the videos yourself.
The opposite. Videos stay embedded on YouTube. Every view in a course is a real view on their channel with their ads. We send them focused, motivated viewers who actually watch to the end. Creators keep everything they already earn, plus new traffic.
Probably not. Most people take two or three. At $9 a month, even one course is worth it compared to buying individually. The 30 is a ceiling, not a homework assignment.
Related Courses
Google Analytics 4
Learn how to set up, navigate, and use Google Analytics 4 from scratch. Covers account setup, property configuration, understanding the new event-based data model, reading reports, tracking conversions, building audiences, and using explorations for deeper analysis. For marketers, business owners, and anyone who needs to understand their website traffic and user behaviour.
Notion for Work (Beginner → Intermediate)
Learn how to use Notion to organize your work, manage projects, and build systems that actually stick. This course takes you from setting up your workspace to using databases, templates, and automation to work more efficiently as an individual or team.
Reinhard E.
ChatGPT for Everyday Work
Put ChatGPT to work on the tasks that eat up your week, with no technical background required. Learn how to write prompts that get useful answers, draft emails and documents, summaries long material, and build simple, repeatable workflows. Finish saving hours every week and knowing exactly when to trust the output and when to check it.
Mistura A.