Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
With the new Sheets Canvas feature, we can build professional-looking interactive dashboards directly in our Google Sheets, using nothing more than natural language prompts. It s a huge upgrade from how we used to build dashboards in Sheets. Previously, we clumped together charts and used formatting tricks such as borders and background cell colors to try Continue reading Build Dashboards and…
Unfortunately, I missed the Google Next conference this year. It looked like a great event with loads of exciting announcements, including significant ones for Google Workspace. The big shift in 2026 is the evolution from AI assistance (Gemini helping you) to Agent workflows (Gemini doing things for you). Here’s a list of the most interesting Continue reading Google Sheets and Workspace Updates…
Why spend hours crafting formulas yourself if Gemini can do it for you? For the better part of two decades, I ve viewed my spreadsheet work through the lens of a craftsperson, rather than as a corporate analyst. The grid of cells was my canvas and the formula my brush. I pushed the limits of what Continue reading Is Formula Writing Dead? (And why we shouldn t mourn it) The post Is Formula Writing…
Most of us are sitting on an absolute goldmine of unstructured data. Think about it: years of client reports, research notes, project documentation, YouTube videos or, in my case, a decade s worth of newsletter archives. Usually, this information just sits there dormant. Why? Because it’s spread all over the place, too tedious to search through Continue reading How to Build a Content Engine with…
Welcome to my 2025 Annual Review, which marks my eleventh year of working for myself in this little corner of the internet. I guess that makes me something of a veteran in this online, creator space. (I certainly feel like a dinosaur next to all the kids half my age cranking out viral memes!). As I Continue reading 2025 In Review And A Look Forward To 2026 The post 2025 In Review And A Look…
Reference table for custom number format color palette. Also available as a Google Sheet. Code Name Example Color Hex Red Green Blue [color1] black 1 #000000 0 0 0 [color2] white 2 #FFFFFF 255 255 255 [color3] red 3 #FF0000 255 0 0 [color4] green 4 #00FF00 0 255 0 [color5] Continue reading Custom Number Format Color Palette Reference Table The post Custom Number Format Color Palette Reference…
Status arrows are little up or down symbols added to data that make it quick and easy to understand what s happening. They re a useful way to highlight changes in your data. Consider the following sales data which has a % change column: Now take a look at the same data with colors and arrows added Continue reading Status Arrows in Google Sheets The post Status Arrows in Google Sheets appeared…
The AI Function in Google Sheets brings the power of Gemini AI directly into your cells. It uses Gemini s large language models (LLMs) to process the text prompts and return helpful responses. It s akin to using a prompt in the chat window of Gemini, but with the convenience of being accessible in your Sheet. And Continue reading How to use the AI Function in Google Sheets (with 10 examples) The…
Did you know that by changing the URL of a Google Sheet we can change how it behaves? In this post, we look at 11 incredibly useful URL Tricks for Google Sheets. For example, we can create a URL that automatically downloads the Sheet as a PDF. Or create a template ready for copying. And Continue reading 11 Incredibly Useful URL Tricks for Google Sheets The post 11 Incredibly Useful URL Tricks for…
OpenAI recently launched their agent tool called Operator. It s an AI powered tool that can navigate the web and perform tasks for you using its own browser. It can click, type, scroll, and generally interact with web pages the way you or I would. Naturally, I tested it out with a Google Sheets project to Continue reading I Let OpenAI Operator Manage My Google Sheet: Here’s What Happened. The post…