Level curriculum

Level 6: Modern Excel and Power Tools

Explore Power Query, Power Pivot, dynamic arrays, LET, and LAMBDA.

1 course
65 modules
260 lessons

Courses in this level

1 of 1 course

Level 6Power Query, M Language & Modern Excel Dynamic Arrays

Comprehensive 65-chapter professional masterclass in Power Query, Modern Excel Dynamic Arrays, M Language functional programming, automated data pipelines, Data Model DAX, Office Scripts, and Power Automate.

₹999

65 modules260 lessons

Show 65 modules

Module 1: Introduction to Modern Excel4 lessons

Module 2: Excel Tables and Structured References

4 lessons

Module 3: Data Types and Data Quality4 lessons

Module 4: Modern Excel Data Management4 lessons

Module 5: Formula Foundations4 lessons

Module 6: Modern Logical Functions4 lessons

Module 7: Modern Aggregation Functions4 lessons

Module 8: Modern Lookup Functions4 lessons

Module 9: Modern Text Functions4 lessons

Module 10: Modern Date and Time Functions4 lessons

Module 11: Error Handling and Formula Auditing4 lessons

Module 12: Excel Data Preparation Project4 lessons

Module 13: Dynamic Array Fundamentals4 lessons

Module 14: FILTER Function4 lessons

Module 15: SORT and SORTBY4 lessons

Module 16: UNIQUE Function4 lessons

Module 17: TAKE, DROP, CHOOSECOLS and CHOOSEROWS4 lessons

Module 18: VSTACK, HSTACK, TOROW and TOCOL4 lessons

Module 19: EXPAND, WRAPROWS, WRAPCOLS and Array Utilities4 lessons

Module 20: LET Function4 lessons

Module 21: LAMBDA Custom Functions4 lessons

Module 22: MAP, REDUCE, SCAN and MAKEARRAY4 lessons

Module 23: BYROW and BYCOL4 lessons

Module 24: Dynamic Formula Engineering4 lessons

Module 25: Modern Formula-Based Reporting Project4 lessons

Module 26: Introduction to Power Query4 lessons

Module 27: Power Query Editor Interface4 lessons

Module 28: Importing Data from Excel4 lessons

Module 29: Importing CSV and Text Files4 lessons

Module 30: Importing Data from Folders4 lessons

Module 31: Power Query Data Types4 lessons

Module 32: Removing Unnecessary Data4 lessons

Module 33: Filtering and Sorting in Power Query4 lessons

Module 34: Text Transformation4 lessons

Module 35: Number and Date Transformation4 lessons

Module 36: Fill, Replace, Group and Aggregate4 lessons

Module 37: Pivot and Unpivot4 lessons

Module 38: Merge Queries4 lessons

Module 39: Append Queries4 lessons

Module 40: Power Query Fundamentals Project4 lessons

Module 41: M Language Fundamentals4 lessons

Module 42: M Data Structures and Types4 lessons

Module 43: M Functions and Parameters4 lessons

Module 44: Advanced Table Transformations4 lessons

Module 45: List and Record Operations4 lessons

Module 46: Custom Columns and Conditional Logic4 lessons

Module 47: Custom Reusable Power Query Functions4 lessons

Module 48: Dynamic File and Folder Pipelines4 lessons

Module 49: Parameters and Configuration4 lessons

Module 50: Web and External Data Sources4 lessons

Module 51: Error Handling and Data Quality4 lessons

Module 52: Query Folding and Performance4 lessons

Module 53: Privacy, Credentials and Data Sources4 lessons

Module 54: Refresh, Dependencies and Maintenance4 lessons

Module 55: Advanced Power Query Project4 lessons

Module 56: Power Query with Modern Excel Formulas4 lessons

Module 57: Power Query with PivotTables and Dashboards4 lessons

Module 58: Power Pivot, Data Model and DAX Introduction4 lessons

Module 59: Modern Excel Automation Ecosystem4 lessons

Module 60: Office Scripts Fundamentals4 lessons

Module 61: Power Automate and Excel Integration4 lessons

Module 62: Refreshable Business Reporting System4 lessons

Module 63: Sales and Inventory Analytics Project4 lessons

Module 64: Finance and HR Reporting Project4 lessons

Module 65: Final Enterprise-Style Capstone4 lessons

Clear all filters

Power Query & Modern Excel: Complete Basic to Advanced (Hinglish)

Open course