Microsoft Excel
Excel for Advanced Users
Master LAMBDA, dynamic arrays, Power Query, Power Pivot/DAX, VBA automation, and professional dashboards.
Instructor
Bogdan IonescuExcel for Advanced Users is a advanced Microsoft Excel course on PluQuiz AI featuring 6 modules and 36 lessons across approximately 15 hours. Last updated March 2026.
About this course
Overview of what this course covers and who it is for.
Master advanced Excel techniques including dynamic arrays, LAMBDA functions, Power Query, Power Pivot with DAX, VBA automation, and professional dashboard design. This course transforms experienced Excel users into power users who can build enterprise-grade analytical solutions.
What you will learn
Outcomes
Build custom reusable functions with LAMBDA and dynamic arrays
Automate data import and transformation with Power Query
Create relational data models and DAX measures with Power Pivot
Write VBA macros to automate complex workflows
Design interactive executive-ready dashboards
Combine all tools into end-to-end business intelligence solutions
Study pace
At 60 minutes per day, you would finish in 3 weeks.
Prerequisites
Recommended background before you start.
Solid understanding of basic Excel formulas (SUM, IF, VLOOKUP), experience with PivotTables and basic charts, and familiarity with data organization and spreadsheet structure.
Full curriculum
What’s inside
- Beyond VLOOKUP: XLOOKUP & Advanced LookupsFree Preview25m
- The LET Function: Clean, Readable Formulas25m
- Dynamic Arrays Revolution25m
- Combining Dynamic Array Functions25m
- LAMBDA: Create Your Own Functions25m
- LAMBDA Helper Functions25m
- Introduction to Power QueryFree Preview25m
- Data Cleaning & Transformation25m
- Advanced Transformations25m
- Merging & Appending Queries25m
- Parameters & Functions in Power Query25m
- Automating Refresh Workflows25m
- Introduction to Power Pivot & Data ModelsFree Preview25m
- Building Relationships25m
- DAX Fundamentals25m
- The CALCULATE Function25m
- Time Intelligence with DAX25m
- Advanced DAX Patterns25m
- Getting Started with VBAFree Preview25m
- VBA Building Blocks25m
- Loops & Arrays25m
- Working with Objects25m
- Error Handling & UserForms25m
- Real-World Automation Projects25m
- Dashboard Design PrinciplesFree Preview25m
- Advanced Charts & Visualizations25m
- PivotTables & PivotCharts for Dashboards25m
- Slicers, Timelines & Interactive Controls25m
- Conditional Formatting & Data Bars25m
- Building a Complete Dashboard25m
- Combining Power Query + Power Pivot + DashboardsFree Preview25m
- Excel & External Applications25m
- Python in Excel25m
- Performance Optimization25m
- Auditing & Best Practices25m
- Capstone: Building a Business Intelligence Solution25m
Your instructor
Learn directly from the author of this course.
Bogdan Ionescu
Course creator
More in Microsoft Excel
Popular courses picked for learners with similar interests.
Frequently asked questions
How long does Excel for Advanced Users take to complete?
Excel for Advanced Users contains 6 modules. Most learners complete it in 15 hours.
Is Excel for Advanced Users free?
Yes — Excel for Advanced Users is free to enroll.
1
Students enrolled
Mar 2026
Published
