Google Sheets Tips
Merging cells is a neccessary skill for any spreadsheet user. Follow this guide for a few methods of how to merge cells in Google Sheets...
This guide will show you how to count colored cells in Google Sheets with a custom formula, an addon, and a built in function....
Sometimes you need to be able to view more of your sheet at once. This guide will teach you to how to zoom out in Google Sheets and to zoom in when you're done....
Sometimes, I need to select more than one item in a drop-down list in my spreadsheet. It’s not a built-in function. So how do you do it? I’ll show you how to make multiple selection drop-d...
To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....
Adding a Google Sheets hyperlink is easy. Follow this guide to learn 3 different ways to do it in asa little as a few seconds....
Import stock prices into Google Sheets from any CSV file. My video shows how to do it, step by step (including where to find stock data)....
To calculate age in Google Sheets, use the DATEDIF or YEARFRAC formulas. Follow along for screenshots and full formula explanations....
Here's how to hide gridlines in Google Sheets with the view menu or the print menu. The guide also shows how to show lines in specific cells....