Previous Lecture
Complete and continue
Modern Excel for Business: Advanced Formulas, Power Query & Dashboards
Next-Gen Formulas & Dynamic Arrays
Replacing VLOOKUP with XLOOKUP & Multi-Criteria Lookups
(14:44)
Dynamic Array Magic: FILTER, UNIQUE, SORT & SEQUENCE
(21:30)
Creating Custom Reusable Functions with LAMBDA & LET
(10:24)
Automating Data Workflows with Power Query
Introduction to Power Query: Connecting & Transforming Raw Files
(20:22)
Combining Multiple Files from a Folder with 1-Click Refresh
(09:28)
Advanced Transformations in Power Query and Introduction to M Code
(11:19)
Data Modeling & Executive Dashboards
Building Relationships in the Power Pivot Data Model
(21:24)
Writing Basic DAX Measures for Year-Over-Year Analytics
(11:27)
Designing an Interactive Executive KPI Dashboard with Slicers
(16:14)
Lecture
Dynamic Array Magic: FILTER, UNIQUE, SORT & SEQUENCE
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Forgot Your Password?
Login
Don't have an account?
Sign up