Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
How to build funnel charts in Google Sheets using tricks with the chart builder tool, sparklines, the REPT formula and finally, and best of all, how to build a tool to create these charts automatically using Apps Script.
Recreating Tufte’s famous weather chart using Google Sheets data and the Google Charts API. This chart encapsulates the historic min/max range, the normal range, the 2015 temperature and any occasions when the 2015 temperature was a record min or max.
These charts show the performance of all the teams that have competed in the Premier League since its inception, the 1992-93 season (Leicester highlighted blue as the current 2015/16 champions): AFC Bournemouth Arsenal Aston Villa See the dynamic version and read about how I created this chart in Excel in this in-depth tutorial I wrote. … Continue reading A history of the Premier League in 47 Excel charts
Welcome to the Sheets Insiders newsletter #43, your exclusive, members-only publication. This is the final Sheets Insiders email 😥 I want to start by saying a huge thank you for being part of Sheets Insiders this past year: Most importantly, as a member, you will always have 24/7 access to the all the workshop replays, videos, tutorials, … Continue reading Sheets Insiders 43: The last one…
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)