Learn
Beginner Topics
These beginner topics are for people who have never used Google Sheets before, people who have used sheets a little, and people who have spent a lot of time in google sheets, but used it in limited ways. Click on the heading below to visit the page with step by step instructions on each topic.
Orienting yourself in Google Sheets
Adding checkboxes in cells
Creating dropdown menus within a cell
Hiding & unhiding columns and rows
Sorting and filtering columns
Formatting numbers (dates, currency, etc)
Freezing Headers
Dragging cells
Alternating colors in rows
Cell Borders
Color coding tabs
Conditional formatting
Fill color
Paint format tool
Text formatting
Text wrapping
Deleting extra rows & columns
What are formulas & functions?
Getting Started with Formulas
Adding cells together
Sum function
If function
Counta function
Countif function
Chart & graph overview
Sharing your spreadsheet
Link sharing
Changing someone’s level of access
Protected Sheets & Ranges
Additional sharing & privacy settings
Intermediate Topics
These intermediate topics are for people who have mastered the beginner topics and are looking to do more in Google Sheets.
Intermediate training guides coming soon! Topics may include:
Absolute references ($)
Adding checks to your document to see error status in real time
Advanced conditional formatting
Concatenate function
Connecting different sheets
Concatenate function & char(10)
Filter function
Generating unique IDs
Join & split functions
Making dashboards
Nesting formulas
Protected sheets & ranges
Query function
Sort function
Unique function
& More!