This post was born from my ongoing experimentation/obsession with the SPARKLINE function in Google Sheets. We’ll see how to create a Join-The-Dots game in Google Sheets using only the built-in formulas, no code.
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?
In this post, we’ll build a named function that creates a miniature bullet chart in Google Sheets, as shown in this GIF: Bullet charts are variations on bar charts that show a primary measure compared to some target value. They’re highly effective because they capture a lot of information in a small, neat design. To … Continue reading Bullet Chart in Google Sheets with Sparklines and Named Functions
In this post, we’ll look at how to create a Google Sheets Drop-Down Menu. Here’s an example of a drop-down menu to record the status of deals in a real estate deal pipeline: Drop-down menus are great for data entry and making your Sheets dynamic. In this post, we’ll explore both of these techniques with … Continue reading How To Create A Google Sheets Drop-Down Menu
This is a guest post from Josh Cottrell-Schloemer. Google Sheets is an incredibly powerful spreadsheet tool for pulling, processing, and presenting data. But many people don’t realize that you can also use it to build interactive dashboards. With a bit of creativity we can go from this: To this: The skills to build this type … Continue reading Making Google Sheets look less like… Google Sheets
