Posted by
Andy Brown
on 12 October 2023
After 25+ years of using and training in Excel, I have nothing new to learn. Or that's what I thought, until on a recent course a delegate asked me why I was merging cells to make titles ...
Posted by
Andy Brown
on 29 August 2023
If you subscribe to the Excel Beta Preview channel (and are lucky) you can now insert Python code within Excel. The rest of us may have to wait a bit for the official release, but the wait will be worth it, as this blog shows.
Posted by
Andy Brown
on 07 June 2023
While browsing through forums (as one does) we found what must surely be the most complicated Excel formula. At 1,860 characters long - and combining some of the most complicated Excel functions - it's a true Excel monster. Unless you can do better?!
Posted by
Andy Brown
on 25 April 2023
When you select part of a formula in Excel, a values preview tooltip now appears showing you what the results would be for this if you calculated it (removing the need for you to press the F9 key).
Posted by
Andy Brown
on 27 February 2023
Learn how to get individual Excel cells to contain sparklines to show trends, how to display column charts or win/loss charts instead, how to play about with grouped charts, how to change sparkline formatting and how to customise sparkline axes.
Posted by
Andy Brown
on 01 February 2023
You've always been able to add images within worksheets, but now for the first time you can add them within cells - which is strangely satisfying!
Posted by
Andy Brown
on 01 February 2023
Microsoft have sneaked in a new short-cut key to invoke the Power Query Editor, but in the course of researching this we also unearthed 4 other key combinations which we suspect even diehard Excel users may not know about.
Posted by
Andy Brown
on 15 September 2022
Did you know that you could combine range names and legacy Excel 4 functions to list out the worksheets or range names in your workbook - wthout using macros? I didn't either - here's how to do this, and much more!
Posted by
Andy Brown
on 02 September 2022
Four examples of using spill arrays to introduce elegance solutions into your spreadsheets.
Posted by
Andy Brown
on 26 July 2022
A new Excel feature allows you to get data from pictures (you can even review the suggestions before finally inserting the data into your spreadsheet).
Posted by
Andy Brown
on 26 April 2022
What happens when you try to defy gravity in Python, and why Excel sometimes creates worksheets with foreign names
Posted by
Andy Brown
on 26 April 2022
Changes are coming to your version of Excel! The navigation pane is excellent, while sheet view will help you work on files being reviewed in isolation.
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.
