In this tutorial, Excel Off The Grid uncovers how to harness the full potential of Power Query to combine and transform data from multiple Excel sheets into a single, structured dataset.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.