The term “rounding difference” commonly describes something insignificant; it rarely raises cause for concern. However, when you discover that Excel rounding and Power Query rounding are different, you suddenly realize that it can be a bigger issue than you first thought. This post explains the different rounding methods in Excel and Power Query, and how Read More
Category: Blog
Excel can calculate the wrong results: WARNING
The old proverb is that “a bad workman blames his tools”. As Excel is such a popular tool, it gets a lot of blame when the person using it is actually at fault. However, it is not always a person who is to blame; Excel can calculate the wrong results all by itself! In this Read More
6 ways to make Excel sheets very hidden (invisible)
This week, while working on a project, I wanted to hide a worksheet in Excel. However, I didn’t want users to unhide it or even know it was there. I wanted to make the Excel sheets very hidden (i.e. invisible to other users). I’m sure many users know how to hide a sheet. However, most Read More
5 quick ways to embed a Word document in Excel
I’m going to say it… Excel is not the right tool for lots of jobs 🤫. While I know authors have written entire books in Excel, it’s not great for text. Excel is not a text editor and has not been designed for that purpose. Therefore, a common question arises: How to embed a Word Read More
Get to know Power Query Close & Load options
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
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