Google Sheets Course: Organize and Analyze Data Easily

Want to master Google Sheets? Learn how to create, edit, and format spreadsheets to organize and analyze data efficiently.

Learn to:

Features:

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Google Sheets Course Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
Sheets Fundamentals
Create Spreadsheets Start new spreadsheets in Google Sheets	Not Started	Not Started	Not Started
Open a Spreadsheet Open and view spreadsheets in Google Sheets	Not Started	Not Started	Not Started
Navigate Spreadsheets Move quickly through Google Sheets tabs	Not Started	Not Started	Not Started
File Management Organize, save, and control your spreadsheets	Not Started	Not Started	Not Started
Print Spreadsheets Print spreadsheets from Google Sheets	Not Started	Not Started	Not Started
Get Help Access Google Sheets help and support	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Edit Spreadsheets			Account Required
Select Cells and Ranges Highlight multiple cells in Google Sheets
Edit Cell Data Edit and update cell content in Sheets
Cut, Copy, and Paste Data Copy and paste data quickly in Google Sheets
Undo, Redo, and Repeat Reverse or redo actions in Google Sheets
Use Paste Special Use paste special options in Google Sheets
Insert and Move Cells Add or move columns in Google Sheets
Delete Cells Delete cells or rows from Google Sheets
Hide Rows and Columns Hide or show columns in Google Sheets
Find and Replace Text Search and replace text in Google Sheets
Check Spelling Fix spelling errors in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Format Spreadsheets			Account Required
Format Text Clear or apply text formatting in Sheets
Align and Merge Cells Merge and align cells in Google Sheets
Cell Borders and Background Colors Add borders and colors to your cells
Format Numbers and Dates Change number and date formats in Sheets
Adjust Row Height and Column Width Resize rows and columns for better layout
Freeze Rows and Columns Lock rows in Google Sheets for reference
Copy Formatting Copy styles with Format Painter in Sheets
Apply Conditional Formatting Highlight data using conditional rules

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Formulas and Functions			Account Required
Formula Basics Learn basic formulas in Google Sheets
Autofill Fill data automatically in Google Sheets
Sums and Averages Add or average numbers in Google Sheets
MIN and MAX Identify min and max values in Google Sheets
COUNT Count specific values in Google Sheets
Insert Functions Add and use functions in Google Sheets
Absolute and Relative Cell References Use absolute references in Google Sheets
Cell Range Names Create named ranges for easy formulas

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Sheets and Data			Account Required
Insert, Rename, and Delete Sheets Add or remove sheets from your workbook
Duplicate, Move, and Hide Sheets Manage and organize sheets in Google Sheets
Sort Data Sort Google Sheets data alphabetically
Filter Data Filter and organize data in Google Sheets
Data Validation Add data validation rules to Google Sheets
Protect Spreadsheets Lock cells from unwanted edits

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Insert Objects			Account Required
Insert a Chart Create a chart in Google Sheets easily
Customize a Chart Customize chart labels and design
Insert Images Insert images into Google Sheets cells
Insert Links Add hyperlinks in Google Sheets cells

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Share, Collaborate, and Convert			Account Required
Upload and Convert Spreadsheets Convert Excel files to Google Sheets
Download and Email Spreadsheets Export Google Sheets as Excel or PDF
Share Spreadsheets Collaborate and manage access in Google Sheets
Collaborate Comment and edit with others in Google Sheets
Work with Versions View and restore Google Sheet version history
Add-Ons Extend Google Sheets with powerful extensions

Student Downloads

Concise, easy-to-use guide for quick learning and reference.

Step-by-step illustrated reference guide.

Exercises and examples referred to in the Student / Instructor Guide.

Instructor Downloads

Lesson plans, instructions, and tips for delivering great classes.

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Your Name

For verified skills in: Google Sheets

Issued on November 24, 2025