Posted by
Andy Brown
on 06 December 2024
Last month we blogged in detail about the new GROUPBY and PIVOTBY functions in Excel. This month we have 4 lighter new features: focus cells, colour pickers, Draw and Hold and some new templates.
Posted by
Andy Brown
on 03 July 2024
You can now add a checkbox to a cell with a single mouse-click. They look good, although it's hard to ensure that only one checkbox in a range is selected.
Posted by
Andy Brown
on 08 May 2024
You can now add Copilot to your 365 licence, although it isn't cheap - this review looks at whether the benefits outweigh the costs.
Posted by
Andy Brown
on 03 April 2024
Microsoft would much prefer it if everyone switched to a subscription model for Office licensing, but they aren't abandoning the sale of standalone software applications just yet.
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 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 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 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 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 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 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 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!