Google Sheets Quick Tips
30mIntermediate2020-09-08
Authors
Jess Stratton
LinkedIn Learning Staff Author, Tech Consultant
Course details
Get quick, bite-sized answers that tell you exactly what you want to know about working with Google Sheets. These short tutorials help Google Sheets users with their most urgent questions. Follow along with Jess Stratton as she shows you how to be more efficient with Google Sheets in minutes. Learn how to format text and other data types, add reference sheets and hyperlinks, move rows, rotate cell data, protect your worksheets, and apply conditional formatting correctly. Jess also helps you convert Sheets files to Excel and back again, share files with others, and use version history and the Undo feature to undo changes and restore older versions of your workbooks.
Topics include:
Wrapping text
Collaborating with others on a spreadsheet
Freezing and locking panes
Auto-filling data quickly
Rotating cell data
Formatting spreadsheets
Protecting sheets
Inserting links
Filtering views
Undoing unwanted changes
Topics include:
Wrapping text
Collaborating with others on a spreadsheet
Freezing and locking panes
Auto-filling data quickly
Rotating cell data
Formatting spreadsheets
Protecting sheets
Inserting links
Filtering views
Undoing unwanted changes
Skills covered
Google SheetsSpreadsheetsGoogleBusiness Software and Tools
Concepts
0. Introduction
- 01 - Calculate data quickly with Google Sheets
1. Google Sheets Quick Tips
- 02 - Text wrap
- 03 - Add and reference sheets
- 04 - Change view options
- 05 - Freeze and lock panels
- 06 - Fill in a series of data
- 07 - Select specific rows or columns
- 08 - Move rows or columns
- 09 - Quickly insert multiple rows and columns
- 10 - Rotate cell data
- 11 - Copy cell formatting
- 12 - Create a named range
- 13 - Create and manage drop-down lists
- 14 - Merge cells
- 15 - Explore data
- 16 - Hide and unhide columns, rows, and sheets
- 17 - Protect an entire sheet
- 18 - Summing rows
- 19 - Adjust row height and column width
- 20 - Apply conditional formatting
- 21 - Insert a link into a cell
- 22 - Change sort order
- 23 - Align cells
- 24 - Filter views
- 25 - Download as Excel format
- 26 - Convert an Excel file to Sheets
- 27 - Rename and move a sheet
- 28 - Share a file
- 29 - View version history
- 30 - Undo unwanted changes
- 31 - Set alternating colors