Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #353, your Monday morning espresso, in spreadsheet form! Today we're looking at the shape of data. It's foundational concept that underpins pivot tables and charts in Google Sheets. Once you understand the difference between wide data (for charts) and tall data (for pivot tables), you'll be off to the races! This week is all about the pros and cons of each data shape. Next week, I'll show you how to use formulas and...
12 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #352, your Monday morning espresso, in spreadsheet form! If you're a parent, then you've undoubtedly watched a lifetime's worth of Disney movies. You can appreciate the genius storytelling, rich characters and beautiful visuals. (But I'm sure you'd also be content to watch a film once, not 10 times!) Anyway, there's a scene in the Disney film Ratatouille where Remy bites into a strawberry and a piece of cheese at the...
19 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #351, your Monday morning espresso, in spreadsheet form! Thankfully, I'm fully recovered from the pneumonia I had last month. Sadly, we had to cancel our trip to Europe to see my family. But, the silver lining was an unexpected week at home with no agenda. So we stained the back deck, cleared out the garage, and built some raised beds in the garden. My younger self would have spent the week wallowing, annoyed at the...
26 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #350, your Monday morning espresso, in spreadsheet form! I'm happy to report that I'm feeling a lot better now than I did this time last week. Thanks to modern medicine and plenty of rest, I'm well on my way back to normal (whatever that is these days!). Thanks to the many of you who sent well wishes, it was very much appreciated 🙏. ➜ News I.Google are adding a new setting to Google Forms to allow form responders to...
about 1 month ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #349, your Monday morning espresso, in spreadsheet form! Last week was a total bust. I started going downhill on Sunday. Then, I was sick in bed on Monday and Tuesday. On Wednesday night, my wife took me to ER, where I was diagnosed with pneumonia. It's been a rough few days but I'm feeling better now and recovering. I still have a way to go but at least I'm heading in the right direction. I hope to get all systems up...
about 1 month ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #348, your Monday morning espresso, in spreadsheet form! Every year I support my sister-in-law's fundraiser for Takoma Elementary School by donating a bundle of all my courses. The full retail price is $999 and at the time of sending this email the current bid is $250. It's a great opportunity to grab all my courses for a reduced price and support a good cause. Place your bid here! ➜ News I.Gemini in Google Sheets just...
about 2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #347, your Monday morning espresso, in spreadsheet form! Redwoods are incredible trees. Not only for their vast size, but also how long they've been alive. I was fortunate to bike through the redwoods in 2014 with my brother. Such magnificent trees! But why am I talking about redwoods? Well, I wanted a nice picture for the example in today's newsletter. Originally, I was going to use company logos, but then I thought...
about 2 months ago • 2 min read
Brought to you by: Hi Reader, Happy Monday! Welcome to the Google Sheets Tips newsletter #346, your Monday morning espresso, in spreadsheet form. This week's tip comes from a reader who emailed in with a question about Tables in Google Sheets. The answer was yet another benefit to using Tables that I hadn't previously noticed. Check it out below, after this week's news and sponsor message. ➜ News I.Staying with Tables... For developers, Tables are now part of the Google Sheets API...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #345, your Monday morning espresso, in spreadsheet form! A couple of weeks ago I was looking over a Google Sheet with my wife (we help each other with business problems). My wife was extracting town names from a list of addresses and used the Smart Fill feature to automate it. She extracted the first two examples and then Smart Fill did the rest. "Woah, hang on a sec", I said "show me that again." I didn't realize that...
2 months ago • 1 min read