In this post, we are looking at the Power Query Close & Load options. This is part of a series designed to get you up and running with Power Query quickly. So far in the series, we have only loaded data into Excel via a Table. But there are lots of other options to explore. Read More
Category: Blog
Use the Power Query editor to update queries
This post looks at how to use the Power Query editor to edit existing queries in Excel. We’ve seen some of this in a previous post of this Power Query series, but now we’ll go a lot deeper. Download the example file I recommend you download the example file for this post. Then you’ll be Read More
VBA Copy File – 5 examples to copy and paste
Visual Basic gives us access to parts of the Windows environment; therefore, there are lots of file-based activities we can achieve with VBA. One of these is to use VBA to copy a file. In this post, we look at 5 examples of how to achieve this. Copy a file VBA In this post, we Read More
Refresh Power Query in Excel: 4 ways + advanced options
Previously, we looked at how to import data from various file formats and load it into Excel using Power Query. In this post, we move on to consider how to refresh that data. Refreshing data is important as it enables us to build a query once and use it over and over (that is automation Read More
Get data into Power Query – 5 common data sources
OK, let’s get started with Power Query. The first thing we need to do is get data into Power Query. In this series, it is our first real look at Power Query; we are also going to use this as an opportunity to explore the user interface. This post is structured into two main parts: Read More
Introduction to Power Query
The party was already 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 at Read More
VBA Rename File: 5 code examples
VBA allows us access to the windows environment to rename a file. In this post, we will look at 5 examples of renaming files with VBA. Rename a File VBA To rename a file with VBA we use the Name command. Example 1: Renaming a file This example renames a file from Example File.xlsx to Read More
Remove excess spaces in Power Query
I showed various methods to remove additional spaces in Excel in a previous post. One of the methods involved creating a custom function in Power Query. As this is a more advanced method, I wanted to go a bit deeper and describe the method to remove excess spaces in Power Query. Excel TRIM vs. Power Read More
CSV to Excel: Power Automate & Office Scripts
CSV files are a common file format; they are regularly used to export data from IT systems. Excel desktop can convert CSV to Excel with ease. However, in the online world of Office 365, things aren’t quite so simple. The online world provides us with new automation opportunities not available in a desktop environment. As Read More
7 ways to remove additional spaces in Excel
The space character for an Excel user can be a real problem. When exporting data from various IT systems, that export will often include extra spaces around values. Finding and removing additional spaces is a crucial skill for every Excel user. We often can’t see the space characters, but Excel sees them. This can cause Read More