Resources

You don't have to clog up the conditional formatting window with a gazillion different rules.

Creating a numbered list may sound easy, but some methods are far better than others.

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!

Exploring the old and a new way that takes advantage of Excel's modern calculation engine.

Ever lose track of where you are in a worksheet? Here's an ingenious way of ensuring you're looking at the right cell.

The FILTER and XLOOKUP functions can be used in similar ways, but there is an important difference you should be aware of.

Further research by Acuity Training investigating people’s Excel usage, including the most popular features and their level of proficiency.

Navigating your workbook tabs can be a hassle, but the solution is Verti Tabs — a free add-in that vertically stacks your worksheets in a discreet pop-up.

Considerations to make when choosing which program to use for analysing data and creating reports.