AVERAGE is one of those easy functions in Excel. Like, super easy! It has just one argument, the cells, or numbers to be averaged. So what’s the problem? It’s too easy to get wrong, yet we might not notice for weeks, months, years or ever. Look at the screenshot below. The result of each method Read More
Titles are an overlooked aspect of many charts. A bland title misses out on so much rich information which could be used to enhance a users understanding of the report. Here is an example of bad and good chart titles: The 2nd chart title adds additional insight and provides a much richer experience for the Read More
AutoFilters are a great feature in Excel. Often they are a quicker way of sorting and filtering data than looping through each cell in a range. This post provides the main lines of code to apply and control the AutoFilter settings with VBA. Adapting the code to your needs Every code snippet below is Read More
“Not again…” I think to myself every time I change the minimum and maximum values of a chart axis. It’s such a tedious task, and I know I’ll be doing it again at a future point. It only takes a few seconds, but all that time starts to add up. There are various chart objects Read More
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
If you read a lot of Excel blogs and sites, you will see a common topic arise which encourages us all to use the INDEX MATCH formula combination, rather than VLOOKUP. I’m not going to disagree with that recommendation, however I feel the question of “Why is INDEX MATCH better than VLOOKUP?” is often not 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
Excel Add-ins are mini-software applications which provide Excel with enhanced functionality and automation features. Whilst they can be created by third-party suppliers, even Microsoft themselves develop add-ins to provide additional functionality. Add-ins can take a number of forms: Excel Add-ins – typically these are Excel files saved with .xlam or .xla file types. They can 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
In Excel 2010, Microsoft introduced a new function called AGGREGATE. It is one of the most powerful functions in Excel, yet I’ve rarely seen it used in a real-life scenario. My aim with this post is to show you how good AGGREGATE is, so that you can make use of its power. What does Read More