Category: Power Query

In this part of the Power Query series, we will be taking a quick look at the Close & Load options.  So far, we have only used the default option which loads the output of the query into a new worksheet.  But there are plenty of other options we could use instead. We won’t get Read More

In this part of the Power Query series, we will look at how to edit queries.  We’ve seen a small piece of this in a previous post, but now we’ll go a lot deeper. Download the example files It may be tempting to just read the text below, but you will retain the information much Read More

In the previous part of this Power Query series, we took a first look at how to import data from various file formats and load it into Excel.  Now, in this part, we move on to consider how we can refresh the data, which enables us to build a query once and use it over Read More

OK, Let’s get started with Power Query.  The first thing we need to do is import some data.  As this is our first real look at Power Query, we are going to use this as an opportunity to explore the user interface. This post is structured into two parts: Using data in the same workbook Read More

The party would already be in full swing; I was going to be late.  Not fashionably late, just late. When I finally arrived, rather than the usual “What time do you call this?“, I received the “Hey; you made it, that’s amazing. It’s great you could come. Let me show you around“. Nobody looked down Read More