We’re back for another set of quick Excel tips. These tips featured on Twitter initially, so there is only a short description with each video, but it is incredible what can be achieved with a small animated image and 280 characters or less. Quick Excel Tip #21 Insert a line break inside a Custom Read More
In this post, I want to share the answer to a question I received from a reader. They had recently been upgraded to Excel 2016 from Excel 2010 and were struggling to open multiple instances of the Excel application. Each instance of Excel can have it’s own application settings (such as calculation modes). This is Read More
Welcome to the second batch of quick Excel tips to enable you to use Excel more efficiently. This isn’t like a sequel in a film franchise, where the first film is good, and all the sequels are rubbish. The tips are presented in no particular order, so depending on how you use Excel these ten Read More
When building Excel-based tools and applications it is often useful for the user to select a color. Whilst it is possible to build a custom UserForm, Excel’s native Color window is more than suitable for most circumstances. Excel’s native color picker: To show the Color window, you might think we could use the Macro Recorder, but Read More
Sometimes it is the small things which make the biggest differences. The following tips are small, some of them very small, but they might save you a lot of time and a lot of annoyance. Quick Excel Tip #1 If the formula Tooltip box is in the way, you can move it. Click on Read More
Every office I have ever worked in has been an equipment battleground. It didn’t matter what the equipment was; it just had to be better than everybody else. A new keyboard, a bigger screen, even a mouse mat with a wrist rest was enough to make everyone else jealous. I was once lucky enough to Read More
Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas. I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly. But wait! Back away from the close button, there is another option. For Read More
At the start of this year, I wrote a post entitled Turn a string into a formula with EVALUATE. This post used an Excel 4 Macro as a possible option for turning a string into a formula. These types of Macros were superseded when VBA was introduced in Excel version 5, hence why any macros Read More
If you speak to anybody who works in the accountancy field, they will always be talking about the “month end”. In all medium and large companies there will be a process at each month end which requires statements to be issued and reports to be distributed. This monthly process fills most finance people with a Read More
In this post, I want to cover one of the most powerful lookup functions available in Excel, INDEX MATCH MATCH. Actually, to call it a function is poor terminology, as it is three functions used together within a single formula. Before digging into this formula, let’s look at when to use it. The screenshot above Read More