Video - How To Use XLOOKUP
How to use XLOOKUP function in Excel - a more powerful version of VLOOKUP!
My thoughts and opinions on technology & business.
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!
Case Study - Saving Time with Automated Call Summaries
How I used Microsoft Power Automate and ChatGPT to automate cleaning and summarising call transcripts for an investment company.
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.
Case Study - Increasing Revenue With Custom Data Exports
How I used custom automation to help a business create custom, automated exports for their customers.