Power Query Full Course (Beginner to Advanced) | 5 Hours

0:00 Intro ------------------------------------------------------------------------- 3:27 PQB01: Introduction "Get & Transform" Automate Data Transformation To download excel workbook: https://drive.google.com/open?id=1pxK... ------------------------------------------------------------------------- 17:04 PQB02: Extract data from current workbook, and create dynamic unique list To download excel workbook: Start: ttps://docs.google.com/spreadsheets/d/1G1dA8JJxVWUCDiQutMX53MSWn1Y4HFpe/edit?usp=sharing&ouid=110580770751308536617&rtpof=true&sd=true Finish: https://drive.google.com/open?id=1z7X... ------------------------------------------------------------------------- 29:47 PQB03:Extract from excel workbook & consolidate multiple worksheets in 1 pivot table Excel file: https://drive.google.com/open?id=1nCE... Data file: https://drive.google.com/open?id=1X_A... ------------------------------------------------------------------------- 42:28 PQB04:Extract data from a folder contains “CSV files” automatically update new data Excel file: https://drive.google.com/open?id=1a9Z... CSV files: https://drive.google.com/open?id=10Zl... https://drive.google.com/open?id=14bv... https://drive.google.com/open?id=17G-... ------------------------------------------------------------------------- 58:41 PQB05: Extract data from Access Database and load to excel data model Excel file: https://drive.google.com/open?id=1tGp... Access database: https://drive.google.com/file/d/1jC-f... ------------------------------------------------------------------------- 1:19:35 PQB05.5: Power Query in Power BI. from access database to an interactive dashboard Access database: https://drive.google.com/file/d/17-Vd... Power BI file: https://drive.google.com/open?id=1peh... ------------------------------------------------------------------------- 1:46:45 PQB06: Connect to the web with power Query Excel file: https://drive.google.com/open?id=1Qas... ------------------------------------------------------------------------- 1:58:05 PQB07: Split Column to Rows - Automate & Organize Chaotic Input Data Excel file: https://drive.google.com/open?id=1gWY... ------------------------------------------------------------------------- 2:12:05 PQB08: Append data from 3 different Tables Excel file: https://drive.google.com/open?id=1Y5g... ------------------------------------------------------------------------- 2:26:07 PQB09: Merge Queries: V-lookup in Power Query CSV: https://drive.google.com/open?id=18BJ... Excel: https://drive.google.com/open?id=1yga... ---------------------------------------------------------------------- 2:40:28 PQB10: Merge Queries: Compare between 2 tables Excel file: https://drive.google.com/open?id=1Nxz... ---------------------------------------------------------------------- 2:58:00 PQB11: Merge Queries: Left Outer - Solve duplicate issues Excel file: https://drive.google.com/open?id=1e74... --------------------------------------------------------------------- 3:10:10 PQB12: Merge Queries: Replace Sum-if Excel file: https://drive.google.com/open?id=14p8... --------------------------------------------------------------------- 3:20:01 PQB13: Merge Queries: 2D search using Formulas (V-lookup + Match) & Power Query Excel file: https://drive.google.com/open?id=14V7... --------------------------------------------------------------------- 3:40:44 PQB14: Excel.CurrentWorkbook() to extract data & “Group by” to Summarize data Start file: https://drive.google.com/file/d/1gdq2... End file: https://drive.google.com/file/d/1YGCa... Additional data: https://drive.google.com/file/d/1mV3f... --------------------------------------------------------------------- 4:06:20 PQB15: Dynamic Filter with PQ, criteria input from excel & customized refresh button Working files: https://drive.google.com/drive/folder... --------------------------------------------------------------------- 4:30:49 PQB16: Manage Queries: Duplicate, Reference or Append Working files: https://drive.google.com/drive/folder... --------------------------------------------------------------------- To subscribe:    / @aaaexcel