Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
In this post, I want to show you something amazing: how a simple equation — the logistic map — can lead to incredible outcomes, and even to chaos. And we’ll explore this with Google Sheets so you can follow along (please download the template at end of the post). But first, we begin our story … Continue reading Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets
The text rotation feature in Google Sheets rotates text in a cell, so it can be angled in any direction. Find text rotation under the menu: Format > Rotation
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 → The Google Sheets checkbox is an interactive widget in a cell that can be checked or unchecked. A … Continue reading How To Use Checkboxes In Google Sheets
The FLATTEN Function in Google Sheets flattens all the values from one or more ranges into a single column. For example, in the following image, the four columns of data are stacked on top of each other by the single FLATTEN function in cell A6: FLATTEN Function Syntax =FLATTEN(range1,[range2,…]) It takes one or more range … Continue reading The FLATTEN Function in Google Sheets
Dot plots are simple charts consisting of dots plotted on a simple scale, typically used to show small counts or distributions. Dot plots are one of the simplest statistical charts, only suitable for small-sized data sets. They’re helpful for understanding the “shape” of your data by highlighting clusters, gaps, and outliers. (A histogram is better … Continue reading Dot Plots In Google Sheets