Power Query For Beginners
Power Query For Beginners
Welcome back to Day 6 of 30 Day Excel Analyst – transforming your analytical skillset in 30 days.
Power Query is one of the most powerful features Excel offers the modern analyst. It’s an absolute must if you’re engaged in data management tasks in Excel. Well, this week is data management week, so let’s explore the potential of Power Query in Excel. I’m not a Power Query expert so, even if you’re a beginner, you should be able to engage with this session – I fully expect to learn a few things myself …
Watch the video HERE
Yesterday, we saw how Power Query can be used to import data to Excel from an external data source. We pulled data from a Google sheet (which houses responses to the online form we created,) but you could pull data from a multitude of data sources: a sheet in the same Excel file, another Excel file, some kind of online database. The possibilities are endless. And yes, multiple queries can be set up simultaneously, which means you can ‘merge’ datasets together using Power Query. Cool!
That’s for another day. For now, let’s look through around 8 things beginners can accomplish in Power Query to dramatically simplify your data management work in Excel.
This session should include, but probably won’t be limited to:
Re-ordering columns
Changing row order
Splitting column entries with a ‘delimiter’
Adding custom calculation columns
Grouping rows
Cleaning and trimming text
Adding an index column (with a suffix or prefix)
Adding date and time columns
Did you enjoy getting started with Power Query? Let me know how you got on in the comments below ...
READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY