YOUR EVERYDAY GOOGLE SHEETS TOOLKITDo more with
Do more with
Google Sheets.
Turn “how do I do this?” into done. Practical tutorials, formulas, and shortcuts for the work on your screen.
team-directoryEXAMPLE SHEET
▦A little formula. A clear answer.↗
ƒx
=FILTER(A2:C5, B2:B5="Sales")ABC
1NameTeamLocation
2MayaSalesLondon
3JordanDesignAustin
4AlexSalesToronto
5SamFinanceBoston
＋ Team directory ▾2 matching rows
Just the rows you need.One formula. No manual sorting.
CHOOSE YOUR NEXT MOVE
What’s on your sheet today?
A quick fix or a new skill.
There’s a good place to start.
01 / TUTORIALS↗
That task on your list?
Let’s get it done.
Clean up data, organize your sheets, and solve the everyday problems that slow you down.
Explore tutorials ↗02 / FUNCTIONS↗
Find your formula.
Syntax that makes sense.
Examples you can use.
03 / SHORTCUTS↗
Fewer clicks.
More progress.
Useful keys for your everyday workflow.
Find a shortcut ↗PUT IT TO WORK
All tutorials ↗One useful thing to learn today.
DATA ENTRY
Create a Yes / No dropdown in Google Sheets
Consistent answers start with a simple choice.
Read the guide ↗FORMULAS
Count the cells that contain text
Choose the right formula for the data you have.
Read the guide ↗FORMATTING
Give your sheet a cleaner look
Learn how to remove gridlines in Google Sheets.
Read the guide ↗THE FUNCTION LIBRARYThere’s a formula
There’s a formula
for that.
Start with the essentials. Build up to the clever stuff.
Explore all functions ↗TAKE THE NEXT STEPMake the repetitive
Make the repetitive
parts automatic.
Get to know Google Apps Script and what it can do for your sheets.
Explore Apps Script ↗