Get quick, bite-sized answers that tell you exactly what you want to know about working with Google Sheets.
Overview
Syllabus
Introduction
- Calculate data quickly with Google Sheets
- Text wrap
- Add and reference sheets
- Change view options
- Freeze and lock panels
- Fill in a series of data
- Select specific rows or columns
- Move rows or columns
- Quickly insert multiple rows and columns
- Rotate cell data
- Copy cell formatting
- Create a named range
- Create and manage drop-down lists
- Merge cells
- Explore data
- Hide and unhide columns, rows, and sheets
- Protect an entire sheet
- Summing rows
- Adjust row height and column width
- Apply conditional formatting
- Insert a link into a cell
- Change sort order
- Align cells
- Filter views
- Download as Excel format
- Convert an Excel file to Sheets
- Rename and move a sheet
- Share a file
- View version history
- Undo unwanted changes
- Set alternating colors
Taught by
Jess Stratton