google sheets
VLOOKUP and XLOOKUP in Google Sheets: Which to Use
VLOOKUP and XLOOKUP both pull matching data from another table. Here is how each works, where VLOOKUP trips people up, and when INDEX and MATCH still help.
Google Sheets Formulas for Beginners: The Ones to Learn First
A short, practical tour of the Google Sheets formulas worth learning first, how cell references work, and what to do when a formula returns an error.
Google Sheets Add-ons Worth Trying (and How to Vet Them)
Add-ons can extend Google Sheets with import tools, cleanup helpers and automation. Here are the categories worth trying and a safe way to vet any add-on before you install it.
How to Build a Simple CRM in Google Sheets
A simple CRM in Google Sheets can track contacts, deals and follow-ups with a few columns, drop-down lists and formulas. Here is how to set one up in an afternoon.
How to Clean Messy Data in Google Sheets, Step by Step
Imported spreadsheets are rarely tidy. Here is a safe step-by-step way to remove extra spaces, split columns, fix dates and numbers, and drop duplicates in Google Sheets.
How to Build a Simple Budget Spreadsheet in Google Sheets
A simple budget spreadsheet needs only two tabs and a few formulas. Follow these steps to log expenses, total them by category and month, and see what is left to…
How To Divide In Google Sheets
Help guide for How To Divide In Google Sheets in Google Sheets. Learn how to use this feature and more with our comprehensive guides.
How To Format Background Color In Google Sheets
Help guide for How To Format Background Color In Google Sheets in Google Sheets. Learn how to use this feature and more with our comprehensive guides.
How To Count Cells Containing Specific Text In Google Sheets
Learn how to count cells containing specific text in Google Sheets with COUNTIF and wildcards, step by step, with simple examples.