Excel Power Query Tutorial - Grouping Tables of Data
Grouping tables of data with Excel Power Query is the focus of Part 5 of my Power Query tutorial series. In this video I demonstrate how to characterize groups of data to enhance the power of your data analyses. ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData ★★★ My online data analysis courses ▶ https://school.daveondata.com ----------------------------------------------------------------------------------------------------------------------- Video Resources ----------------------------------------------------------------------------------------------------------------------- Get the Excel workbook used in this video: 💻 https://github.com/DaveOnData/ExcelPo... ----------------------------------------------------------------------------------------------------------------------- Additional Power Query Tutorial Videos ----------------------------------------------------------------------------------------------------------------------- What is Excel Power Query AND Why it Matters to You! (Part 1): 📺 • What is Excel Power Query AND Why it Matte... Excel Power Query - Add Column From Examples (Part 2): 📺 • Excel Power Query Tutorial - Add Column Fr... Excel Power Query - Add Custom Column 1 (Part 3): 📺 • Excel Power Query Tutorial - Add Custom Co... Excel Power Query - Add Conditional Column (Part 4): 📺 • Excel Power Query Tutorial - Add Condition... Excel Power Query - Transforming Nested Tables (Part 6): 📺 • Excel Power Query Tutorial - Transforming ... ----------------------------------------------------------------------------------------------------------------------- Excel Analytics Training ----------------------------------------------------------------------------------------------------------------------- 👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 • Introduction to Business Analysis with Exc... 💥 Learning R programming is easy for Excel users! 💥 📺 Check out the video: • Learning R Programming Is Easy! (Full Webi... Stay healthy and happy data sleuthing! #ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryGroupingTables
Excel Power Query Tutorial - Transforming Nested Tables
Excel Power Query Tutorial - Add Column From Examples
Power Query Unpivot - fix 4 common data layouts (incl. workbook)
Excel Power Query Tutorial - Add Conditional Column
Reduce Steps in Power Query - Tips Only the Pros Know!
Stop Sending Ugly Pivot Tables to Your Boss
Smart Way to Combine CSVs with Inconsistent Headers in Power Query
Excel Power Query Tutorial - Merging Tables (VLOOKUP Alternative)
How to use Microsoft Power Query
What is Excel Power Query AND Why it Matters to You!
Power Query was HARD until I learned these 7 Tips
Easily Compare Multiple Tables in Power Query
Excel Power Query Tutorial - Add Custom Column 1
Fix multi row headers in Power Query & native Excel
Summarizing Data with Group By in Power Query
How to easily automate boring Excel tasks with Power Query!
Excel Power Query Course: Power Query Tutorial for Beginners
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
SQL vs. Power Query – What You Should Use for Python in Excel in 2024!
