Group data in POWER QUERY: automatically group data in excel
In this easy Excel for beginners tutorial we look at POWER QUERY in Excel and how to use it to automatically group data from an external source. Using the group by power query is a powerful excel tool. Data could come from another table or workbook or (as in this example) from the web. Use power query transform data to automate your spreadsheet and become and excel expert!
You can follow along with the video from a blank workbook and using the link we used:
https://www.worldometers.info/world-p...
0:00 Introduction
0:19 Where to find the options to import data and open Power Query editor
0:56 Importing data
2:00 Importing data into Power Query editor (Transform Data)
2:22 Group data with Conditional Column
4:53 Load your data
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other videos and playlists!
INDEX, MATCH and variations on IF playlist: • INDEX tutorial: Learn all you need to...
Links to our other videos on importing data from the web and nested IF / IFS functions:
IMPORT data from the web: • Excel for beginners: IMPORT data from...
Nested IF statements - what are they and how do I use them?: • Excel for beginners: Nested IF statem...
IFS function - an alternative to a nested IF statement: • Excel for beginners: IFS function - a...
Power Query Videos:
Clean up and transform data ATOMATICALLY using POWER QUERY: • Power Query clean up data: automatica...
Split data in multiple columns into separate rows using POWER QUERY: https://studio.youtube.com/video/5yZe...
