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
Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this … 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.
