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.
Posted by
Andy Brown
on 13 August 2013
A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!
Posted by
Andy Brown
on 12 August 2013
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Posted by
Michael Allsop
on 24 May 2013
Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.
Posted by
Andy Brown
on 04 April 2013
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Posted by
Michael Allsop
on 17 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!