excel(4)
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
Read2024.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
Read2023.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
Read2023.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