My thoughts and opinions on technology & business.

Video - How To Use XLOOKUP

How to use XLOOKUP function in Excel - a more powerful version of VLOOKUP!

Video - Formatting Excel Pivot Tables

How to use the Tabular View of Pivot Tables in Excel. This allows you to summarise the data in Pivot Tables as normal, but format them to look like a normal table/grid so it's easy to copy and paste the data out!

6 Problems Custom Automation Solves

Automation does so much more than save time. Here are 6 types of problems that custom automation can solve for your business.

5 Google Sheets Functions for Automation

The five key Google Sheets functions you need to know to automate your spreadsheets. VLOOKUP, INDEX, ARRAYFORMULA, SUMIFS and QUERY.