PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples

AAA Excel’s Power 182,025 4 years ago

Video Not Working? Fix It Now

0:00 Intro ------------------------------------------------------------------------- 3:27 PQB01: Introduction "Get & Transform" Automate Data Transformation To download excel workbook: https://drive.google.com/open?id=1pxKig7LjeGHteKlDO-9db_0DNBb4RzDf ------------------------------------------------------------------------- 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=1z7XQt3ZpkkJd7bwLn5b5Gh7nmY_vNFkA ------------------------------------------------------------------------- 29:47 PQB03:Extract from excel workbook & consolidate multiple worksheets in 1 pivot table Excel file: https://drive.google.com/open?id=1nCEKWmc22zif742VDB8-npelh4EWlH8D Data file: https://drive.google.com/open?id=1X_AlOBN109oFz09t6esjIrfLlZXNB4_b ------------------------------------------------------------------------- 42:28 PQB04:Extract data from a folder contains “CSV files” automatically update new data Excel file: https://drive.google.com/open?id=1a9ZYOUh9XDUjdJ6wjdKht75wYjVXMuEv CSV files: https://drive.google.com/open?id=10ZlclQDxYTM_k5YECZRQc2DyCS93xydq https://drive.google.com/open?id=14bvkAYB6QgQE-SnAOAOR_l2V0C8psRnl https://drive.google.com/open?id=17G-dVi6pMOGtrP84W7WZ5CvFdY1tANSF ------------------------------------------------------------------------- 58:41 PQB05: Extract data from Access Database and load to excel data model Excel file: https://drive.google.com/open?id=1tGp54EmFHb-os7LprLnBa9ngpn74NJxj Access database: https://drive.google.com/file/d/1jC-fbi6OvSzD8yVVPqIkrmMG4uZamLjM/view?usp=sharing ------------------------------------------------------------------------- 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-VdGrs5L8mHQ6Qtl6JA4rSxd11YegeZ/view?usp=sharing Power BI file: https://drive.google.com/open?id=1peh3hNs01jchSNjCdL-WI5JCR6OTcwRf ------------------------------------------------------------------------- 1:46:45 PQB06: Connect to the web with power Query Excel file: https://drive.google.com/open?id=1Qasvb3qr9UCbPXy1ABuY3LAgMkQJoffl ------------------------------------------------------------------------- 1:58:05 PQB07: Split Column to Rows - Automate & Organize Chaotic Input Data Excel file: https://drive.google.com/open?id=1gWYyxxgicdJIyU6GKr_EbhpO5-ThJEON ------------------------------------------------------------------------- 2:12:05 PQB08: Append data from 3 different Tables Excel file: https://drive.google.com/open?id=1Y5gkQQQKI8cuSAW4c1En426A-iNXmHLN ------------------------------------------------------------------------- 2:26:07 PQB09: Merge Queries: V-lookup in Power Query CSV: https://drive.google.com/open?id=18BJt2FIZRPlPIay-P92dCZB3nQ0AmqoU Excel: https://drive.google.com/open?id=1ygaBTfUtBtClzm4clnSlhFZ1qtKEFuEz ---------------------------------------------------------------------- 2:40:28 PQB10: Merge Queries: Compare between 2 tables Excel file: https://drive.google.com/open?id=1Nxza_0Bdjp_td47cARPDnIJv9dt3hA-- ---------------------------------------------------------------------- 2:58:00 PQB11: Merge Queries: Left Outer - Solve duplicate issues Excel file: https://drive.google.com/open?id=1e74c45_547iZQ_D7M35ZhqIcYksciS_r --------------------------------------------------------------------- 3:10:10 PQB12: Merge Queries: Replace Sum-if Excel file: https://drive.google.com/open?id=14p8QjgMKzuKCiBs5ZY1fwiT9Eo1OTL4B --------------------------------------------------------------------- 3:20:01 PQB13: Merge Queries: 2D search using Formulas (V-lookup + Match) & Power Query Excel file: https://drive.google.com/open?id=14V7Hsa82gd9r1iMBpTuysKyHXCzLFhDR --------------------------------------------------------------------- 3:40:44 PQB14: Excel.CurrentWorkbook() to extract data & “Group by” to Summarize data Start file: https://drive.google.com/file/d/1gdq2J3rlUCMQglfd-ACjonO0rnzzmnYj/view?usp=sharing End file: https://drive.google.com/file/d/1YGCa7VMYzEVN9cCT2s5jLdLv6YVGKTjt/view?usp=sharing Additional data: https://drive.google.com/file/d/1mV3fo5SCTA6IWCq8eu_VaI8UVGdrZak-/view?usp=sharing --------------------------------------------------------------------- 4:06:20 PQB15: Dynamic Filter with PQ, criteria input from excel & customized refresh button Working files: https://drive.google.com/drive/folders/1x_yaP9sj-67fHJjpzDTyy3Mo9DXyJQcA?usp=sharing --------------------------------------------------------------------- 4:30:49 PQB16: Manage Queries: Duplicate, Reference or Append Working files: https://drive.google.com/drive/folders/1ZGNcO8PWcVHQWUYl4IM2PrjQsNJcm0nE?usp=sharing --------------------------------------------------------------------- To subscribe: https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

Comment