Introducing the IMAGE function
Remember when we had to use hacky methods to insert pictures into cells? No longer. A new function is born — it’s called IMAGE. That’s right, Excel has taken another leaf out of Sheets’ book with a long overdue but…
An Alternative to Formulas
Still writing formulas? You won’t be soon. Slight exaggeration. Anyway… Excel Formula Bot is a free AI-based generator that converts your plain English (or Spanish) instruction(s) into a formula. The creator, David Bressler, claims to have built it ‘without a…
Oz du Soleil — BBC Radio 5 Live Interview
I’ve just extracted the segments of Oz du Soleil‘s BBC Radio 5 Live interview broadcast today (after frantically searching for them). Du Soleil was on in recognition of All-Star Battle, the hugely successful Excel esports tournament featured on ESPN2. He set…
How to use the Watch Window
Important values strewn across a workbook are difficult to track. Whilst opening additional windows or splitting your view into panes are two ways of combatting the endless scrolling and tab switching — they’re not perfect. An alternative is the Watch…
Extract Data From a Picture
Want to digitise that document, receipt or book page? Data from Picture is an Excel feature that allows you to extract the text from an image and insert it into a worksheet. It’s already possible to do this in Excel…
Extend Excel’s Functionality with Kutools
Kutools is an Excel add-in with over 300 features and functions that simplify, automate, and expand on what is available natively. For example, you can: It’s the last point I wanted to pay particular attention to, as these chart templates…
