Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google Sheets Quick Tips

via LinkedIn Learning

Write review

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Scrimba

Free courses from frontend to fullstack and AI

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Get quick, bite-sized answers that tell you exactly what you want to know about working with Google Sheets.

Syllabus

Introduction

Calculate data quickly with Google Sheets

1. Google Sheets Quick Tips

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

Reviews

4.7 rating at LinkedIn Learning based on 389 ratings

Start your review of Google Sheets Quick Tips