Posted by
Andy Brown
on 20 April 2022
Get a preview of the 3 text functions and 11 array functions coming to your version of Excel very soon!
Posted by
Andy Brown
on 23 February 2021
Details of an impressive new Excel word search system which allows you to recreate a randomised grid every time you recalculate your formulae!
Posted by
Andy Brown
on 21 December 2020
You can now create and use anonymous functions in Excel (usually called "Lambda functions"). Learn how to add to the stock of Excel functions without having to learn any programming code!
Posted by
Andy Brown
on 24 October 2020
The new Excel LET function lets you create variables to store the results of calculations, making formulae easier to read and quicker to calculate.
Posted by
Andy Brown
on 24 September 2020
The XLOOKUP function has at least 7 advantages over an equivalent VLOOKUP function, as this blog shows. Convert to XLOOKUP now, and then convert your colleagues!
Posted by
Andy Brown
on 14 February 2020
Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.
Posted by
Andy Brown
on 14 October 2019
It's fairly easy to create a simple Excel worksheet to chart your weight, but this master class shows you lots of tips and tricks to make the final result quicker to create and easier to use.
Posted by
Andy Brown
on 14 August 2019
Want to make a worksheet inexplicably change colour, and display strange text in cells? This blog explains how you can do this using the Normal style.
Posted by
Andy Brown
on 14 August 2019
The previous blog listing great OOH moments in Excel omitted one of the biggest - the absolute quickest way to create a chart.
Posted by
Andy Brown
on 17 June 2019
This month it's Shaun's turn to nominate the five best short-cut tips in Excel.
Posted by
Andy Brown
on 17 June 2019
When you discover a new short-cut key, should you share it? This blog shows a way to bring up Intellisense for the arguments to user-defined functions in Excel VBA.
Posted by
Andy Brown
on 14 June 2019
When you're copying worksheets containing range names, Excel can detect conflicts and take you into a seemingly endless loop of Yes/No dialog boxes. This blog explains why this happens, and how to get out of the loop!
Posted by
Andy Brown
on 09 May 2019
All trainers live for that moment when someone's face lights up, as they learn something new which will change their working life for the better. This blog lists my 5 biggest such OOH moments from our Excel training courses. How many of these tips do you know?
Posted by
Andy Brown
on 08 December 2017
Did you know that you can automatically generate multiple versions of a pivot table, with each one configured to filter by a different item? We didn't - this blog is an attempt to apologise for our oversight!
Posted by
Andy Brown
on 01 June 2017
There are a few ways to find the differences between two Excel worksheets. This blog considers 3 methods (using Excel formulae, using Query Editor and using the Inquire add-in).
Posted by
Andy Brown
on 26 January 2017
This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.
Posted by
Andy Brown
on 16 May 2014
Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.
Posted by
Andy Brown
on 01 November 2013
Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!
Posted by
Andy Brown
on 01 November 2013
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
Posted by
Andy Brown
on 01 November 2013
The SUMPRODUCT function is one of the hardest ones to understand in Excel, but it's also pretty useful. This blog gives clear examples of how to use SUMPRODUCT for conditional sums, weighted averages and the like.