Welcome to issue 18 of the Sheets Insiders membership. You can see the full archives here. Chart Tutorial Inspired by this Ikea chart (half way down), I wanted to see if we could recreate it in Google Sheets. It turns out, with some creative chart techniques, we can do a pretty good job! Here’s the final chart … Continue reading Sheets Insiders 18: Advanced Chart Tutorial
Welcome to Annual Review number 10! Ten! TEN!! Ten years in business. Ten years working for myself. As I write this, I still can’t quite believe that it’s been ten years. In some ways it feels like only yesterday that I was wearing a suit to an office on K-Street in Washington DC, and yet, … Continue reading 2024 In Review And A Look Forward To 2025
This is a guest post from Kyle Horst of Kirksville Web Design. Introduction Google Sites is an amazing app for bringing together information across an organization’s Google Workspace domain. However, Google Sites doesn’t natively have a CMS, databases or even a decent option for basic tables. Therefore, Google Sheets is hugely important for building a … Continue reading How to Use Google Sheets in Your Google Sites
Welcome to issue 4 of the Sheets Insiders membership program. You can see the full archives here. In this issue, we’re looking at AI tools and using them for data analysis and generating formulas. It’s a fascinating time to work with these tools. They’re changing and improving on a weekly basis, so whether you’ve tried … Continue reading Sheets Insiders 4: AI Experiments
Welcome to issue 3 of the Sheets Insiders membership program. You can see the full archives here. You know what’s better than a great spreadsheet? A great spreadsheet with a button! A user interface (UI) is the way people interact with software. Here I’m using it to refer to the interactive elements we can add … Continue reading Sheets Insiders 3: User Interface Template