Category: Get & Transform
How To Get All Sheet Names From All Workbooks In A Folder
It’s a task I’ve had to do before. Get a list of all the sheet names in a workbook...
Read More
How to Deal with Changing Data Formats in Power Query
Power Query is an amazing tool since it allows you to set up a query once and then refresh it...
Read More
The Complete Guide to Power Query
What is power query? Power Query is a business intelligence tool available in Excel that allows...
Read More
How To Access A JSON API With Power Query
In this post I’ll show you how to hack into tons of top secret government data using Excel....
Read More
How To Generate All Possible Combinations Of Items From Two Lists
Given two separate lists of items, how can you create a list of all possible combinations from...
Read More
How To Get A List Of File Names From A Folder And All Subfolders
This post will explore how we can easily create a file inventory from a folder and all of its subfolders using Power Query.
Read More
