Resources
Resources
May 16, 2023
Why are two identical-looking values not equal to each other?
If you're having trouble with a formula for no apparent reason, it might be because of the data itself.
Read Article →
.png)
Resources
May 15, 2023
Excel and AI usage in the workplace
An Acuity Training investigation into AI in Excel and the most popular tools used.
Read Article →
Resources
May 12, 2023
Extracting text from a string in Excel
It used to be challenging, but thanks to Microsoft's new function set, it's become a breeze.
Read Article →
Resources
April 28, 2023
An alternative to conditional formatting: custom formatting
You don't have to clog up the conditional formatting window with a gazillion different rules.
Read Article →
Resources
March 31, 2023
3 ways to create a numbered list to keep track of to-do tasks
Creating a numbered list may sound easy, but some methods are far better than others.
Read Article →
Resources
March 24, 2023
How to use multiple criteria in the FILTER function
It's not immediately obvious how to use FILTER to narrow down a dataset based on more than a single criterion, but once you know how it's simple!
Read Article →
Resources
March 21, 2023
A better way of calculating running totals
Exploring the old and a new way that takes advantage of Excel's modern calculation engine.
Read Article →
Resources
March 10, 2023
Highlight the active row and column in an Excel worksheet
Ever lose track of where you are in a worksheet? Here's an ingenious way of ensuring you're looking at the right cell.
Read Article →
Resources
March 2, 2023
Why FILTER instead of XLOOKUP?
The FILTER and XLOOKUP functions can be used in similar ways, but there is an important difference you should be aware of.
Read Article →
19-23 May 2026
One week, two premier events
Join the European Excel Week - from learning and mastering new skills at Global Excel Summit to elite performance at the Excel Esports European Open.
.avif)