There is nothing more frustrating than finding out a previous employee has used passwords to protect an Excel file, and it turns out nobody else knows the password. Or maybe it’s worse when it’s your file, your password and you’ve forgotten it. Either way… you’re stuffed! However, before you give in, let me share some ideas on how … Read more
Titles are an overlooked aspect of most charts. Bland titles miss out on so much rich information that could enhance a user’s understanding. So, in this post, we look at how to create dynamic chart titles in Excel. Here is an example of bad and good chart titles: Hopefully, you agree the second chart provides a … Read more
I encountered a situation recently where I needed to convert text to a formula in Excel. I was expecting to find a function that would achieve this. We can convert text to a range using the INDIRECT function, so there has got to be a function to convert text to a formula… right? Well… no… yes, … Read more
In Excel, Power Query updates when we click the refresh button. This is great if we only want up-to-date data at that point in time. However, there are many scenarios where we want Power Query to automatically refresh. So, how can we achieve that? There are built-in options and VBA options. We will look at … Read more
VBA in Excel gives us access to parts of the Windows environment. Therefore, there are many file-based activities we can achieve with VBA Macrs in Excel. One common method is using VBA to copy files from one folder to another. In this post, we look at 10 examples of how to achieve this. Table of … Read more
Over the past few months, I have seen many videos showing how to create multiple folders at once using a .bat file (also known as a batch script). Often these videos leverage Excel to create the folder paths. Then, they undertake various manual actions to get the .bat file into the correct location, so they … Read more
Excel has a dirty little secret – The data validation does not stop a user from entering an incorrect value. That’s pretty shocking, as that’s the whole point of data validation. 😲 Many of us rely on data validation to ensure other users only provide valid data entry. However, many are not aware of how … Read more
Copying, pasting, and moving cells are simple everyday tasks for Excel users. But what if something already occupies the area we want to paste to? We must perform the move-move-move shuffle by moving something into a temporary location before placing everything into its final destination. Wouldn’t it be better if there were a simple way to swap ranges … Read more
Power Automate Desktop is a Microsoft tool for automating processes in a desktop environment. It’s a really powerful tool, but suffers from one significant drawback… it has limited Excel actions. However, Microsoft has given us the ability to run Excel macros from Power Automate Desktop; therefore, this gives us the power to do almost anything … Read more
Some Excel features hide in plain sight. They are there, but nobody thinks to click the button. In this post, we are covering one of those features. We are looking at how to create separate sheets for each item in a PivotTable field with the Show Report Filter Pages feature. Excel users love PivotTables because … Read more