Advanced Excel Power Query and M Masterclass - Clean and Transform Data
Advanced topics and mini projects in Power Query and the M formula language in Excel.
Created by John Bura
01
Skill level
All levels
02
Sections
8
03
Lectures
40
04
Instructor
John Bura
What's inside
This course includes.
✓
8
Sections
✓
40
Lectures
✓
40
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 00 Course overview 3 lectures
00 Course Overview - Advanced Excel Power Query And M
Locked
01 What Are Power Query And M
Locked
Course overview - Source Files
Locked
+ 01 Build expressions with let 4 lectures
01 Build Nested Let Expressions
Locked
02 Build A List With A Sequence
Locked
03 Build An Unnamed Record
Locked
Build expressions with let - Source Files
Locked
+ 02 Build expressions with each 7 lectures
01 Work With The Each Keyword
Locked
02 Generate A List
Locked
03 Find An Entry In A Record
Locked
04 Select Items From A List
Locked
05 Serialize A Column
Locked
06 Find Best Match Of Values
Locked
Build expressions with each - Source Files
Locked
+ 03 Build M functions to perform tasks 7 lectures
01 Build A Function
Locked
02 Build A Closure
Locked
03 Build A Function In A Record
Locked
04 Count Fibonacci Numbers With A Recursive Function
Locked
05 Remove Html Tags
Locked
06 Build A For Each Loop
Locked
Build M functions to perform tasks - Source Files
Locked
+ 04 Work with tables in M 8 lectures
01 Select A Column From A Table
Locked
02 Select A Value At A Row And Column
Locked
03 Select Row Where A Condition Is Met
Locked
04 Cross Join Tables
Locked
05 Join Tables On A Key
Locked
06 Change Column Types
Locked
07 Fill A Table With Random Values
Locked
Work with tables in M - Source Files
Locked
+ 05 Pivot a table 3 lectures
00 What Is Pivoting
Locked
01 Pivot A Table
Locked
Pivot a table - Source Files
Locked
+ 06 Build expressions with evaluate 4 lectures
01 Build An Expression With Evaluate
Locked
02 Build A Nested Evaluate Expression
Locked
03 Use Global Library Functions
Locked
Build expressions with evaluate - Source Files
Locked
+ 07 Work with matrices in M 4 lectures
00 How To Multiply Matrices
Locked
01 Build Matrices In M
Locked
02 Multiply Matrics
Locked
Work with matrices in M - Source Files
Locked
Description
About this course.
Power Query
- Free tool part of Excel and Power BI
What is it for?
- Automate manual and repetitive tasks
- Solve data analysis problems that require complex formulas
- Easy to import and transform data in ways Excel finds hard
- Designed to pull data from a source
- Modify it
- Return the modified version
What you can do with Power Query?
- Import data from different sources
- Transform and clean data
- Load data as a basis for reports
Import data from different sources
- Another workbook
- Text file
- Folder
- Sharepoint drive
- Databases
- ...
Example
- Can make a PivotTable from 50 million records
Power Query Editor
- Graphical script editor
- Part of Excel and Power BI
Course Curriculum
- Advanced topics in Power Query and M.
Experience
- Excel experience recommended
- No Power Query or programming experience required
- Programming experience will help
What You’ll Need
- A PC computer
- Power Query isn’t available on Excel for Mac
What You’ll Need
- A free trial or paid license of Excel
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Advanced topics and mini projects in Power Query and the M formula language in Excel.