arrow_back
Session 1 - Learning Path - Introduction to PQ
Session 1 - Working Files
Session 2 - More in-depth and first query
Session 2 - Working Files
Session 3 - In and Out of Query
Session 3 - Working Files
Session 4 - Around M Functions
Session 4 - Working Files
Session 5 - Analysis of M Functions, Excel.CurrentWorkbookFn
Session 5 - Working Files
Session 6 - Deepdive into Excel.CurrentWorkbook Fn
Session 6 - Working Files
Session 7 - Deepdive into Excel.Workbook Fn
Session 7 - Working Files
Session 8 - In-depth into List, Custom Functions etc
Session 8 - Working Files
Session 9 - Dyanmic Path, Files, Column Names etc.
Session 9 - Working Files
Session 10 - Append Multiple Folders, Sub Folders files
Session 10 - Working Files
Session 11 - Merge Queries in PQ, All Types of Join
Session 11 - Working Files
Session 12 - Fuzzy Matching, Merge with More Keys
Session 12 - Working Files
Session 13 - Pivot, Unpivot, Split, GroupBy
Session 13 - Working Files
Session 14 - Relative Size Factor, Merge within Query
Session 14 - Working Files
Session 15 - Case Study leveraging VBA, GPT and PQ
Session 15 - Working Files
Session 16 - Custom Functions in Excel and Power Query
Session 16 - Working Files
Session 17 - Connect Web Data and Google Form Data
Session 17 - Working Files
Session 18 - Case Study - Dealing with Consistent Headers
Session 18 - Working Files
Session 19 - Reconciliation of 2 Datasets - Leveraging AI for Comments
Session 19 - Working Files
Session 20 - Deep Dive into Custom Functions - Web Data Automation
Session 20 - Working Files
Session 21 - Automation of Currency Rate Extraction from Web
Session 21 - Working Files
Session 22 - Deep Dive into Pdf Data Import, Transform and Analysis
Session 22 - Working Files
Session 23 - Deep Dive into Meta and Connect to Mail Exchange
Session 23 - Working Files
Session 24 - Deep Dive into Connecting Tally to PQ
Session 24 - Working Files