Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
Welcome to issue 26 of the Sheets Insiders membership. You can see the full archives here. This week, we’re looking at… shh, don’t tell anyone… it’s secret… *glances left, glances right* we’re looking at the world of hidden, undocumented functions. Gasp! These are secret functions hidden in Google Sheets that aren’t officially documented anywhere. This … Continue reading Sheets Insiders 26: Undocumented Functions
New course Stop dabbling with Gemini. Start building AI systems. One-off prompts → repeatable workflows Gemini across all your Workspace tools Automations and agents that save hours NotebookLM, vibe coding, Gemini Gems $149 Get instant access → Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of … Continue reading When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets
In this post, we’re going to take a 40,000 ft view of the Artificial Intelligence (AI) landscape and see how you can use it alongside Google Sheets to boost your productivity. And, at the end of the post, I’ll answer the question about whether I think the AI hype is justified. Before looking at what … Continue reading What AI Can Do For You As A Google Sheets User. Is The Hype Justified?
Recursion in Google Sheets is now possible with the introduction of Named functions, LAMBDA functions, and LET functions. In this post, we’ll explore the concept of recursion and look at how to implement recursion in Google Sheets.
The XLOOKUP function in Google Sheets is a new lookup function in Google Sheets that is more powerful and flexible than the older lookup functions like VLOOKUP or HLOOKUP.