Let me show you a unique use case for pivot tables – building maps!
Can you guess which city this is?
It’s Washington D.C. and it’s also a pivot table in Google Sheets. The image on the left is the map built with a pivot table. The image on the right is a screenshot of Washington D.C. from Google maps.
Look closely and you might just be able to see the Google Sheet row and column headings around the map.
Continue reading Mapping data with Pivot Tables in Google Sheets…yes, really! 🌎
A collection of formatting tips for tables in your Google Sheets.
Let’s start with a simple table, completely devoid of any formatting:
Go for bold, center-aligned and wrap the text, so it all shows.
Continue reading Format your Google Sheet tables so they look
Sep 18 announcement: Whew! This was a big task, but today I’m proud to announce that my video training courses are bang up-to-date! I sent out emails to students earlier today, announcing updates to 40 videos in my Google Sheets training courses.
Read on for more details.
Continue reading Updates to the Google Sheets Training Courses
Conditional formatting is a super useful technique for formatting cells in your Google Sheets based on whether they meet certain conditions.
For example, you could use it to apply background colors to cells based on the value in the cell.
You can go further than this though, and apply the formatting across an entire row, based on the value in a single cell.
For example, if the continent is “Africa” in column C, you can apply the background formatting to the entire row (as shown by 1 and 2):
Five steps to apply conditional formatting across an entire row
It’s actually relatively straightforward once you know the technique using the $ sign (Step 5).
Step 1. Highlight the data range you want to format
The first step is to highlight the range of data that you want to apply your conditional formatting to. In this case, I’ve selected
Continue reading How to apply conditional formatting across an entire row in Google Sheets
Are you drowning in data, but not using it to make better decisions?
Do you run a small business and want to use your data to inform your strategy?
Has your business migrated from Excel to Google Sheets, and you’re looking to further your skills?
My new course, Data Analysis with Google Sheets, is now open for enrollment!
In this course, you’ll learn how to:
- Understand and describe what your data tells you
- Predict what things might look like in the future
- Understand your customers to better serve them
- Discover what factors affect your business
- Best practices for doing all of this…
- …and much, much more!
Continue reading My new course, Data Analysis with Google Sheets, is open for enrollment!