excel(4)

/ Date/ Name
2024.08.12 VLOOKUP, XLOOKUP and INDEX MATCH explained by building

Summary:

Learn the difference between VLOOKUP, XLOOKUP and INDEX MATCH by building one small price lookup sheet, with the mistakes that trip people up.

Topics:

Build with AI 5 min read

Read
2024.01.26 AI for spreadsheets: formulas, scripts and clean-ups

Summary:

How to use an AI assistant to write spreadsheet formulas, clean messy columns and draft small scripts, without trusting numbers you haven't checked.

Topics:

Build with AI 6 min read

Read
2023.08.17 Spotting duplicates with AI-written formulas

Summary:

Find and mark duplicate entries in Google Sheets or Excel using COUNTIF, UNIQUE and conditional formatting, with AI writing the formulas and you checking them.

Topics:

Build with AI 5 min read

Read
2023.07.05 Excel macros and VBA written by AI

Summary:

How to get a working Excel macro out of ChatGPT without knowing VBA, how to run it safely on a copy, and the mistakes that corrupt real data.

Topics:

Build with AI 6 min read

Read