Google Sheets

Create spreadsheets quickly with Google Sheets to organize and analyze data easily.

  • Get Certified · CPD Accredited
  • Learn by Doing
  • 4.9 3209 students
Google Sheets Course Outline 7 modules · 4 hours
Skill Pre-assess Lesson Post-assess Improvement
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 Improvement
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 Improvement
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 Improvement
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 Improvement
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 Improvement
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 Improvement
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

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Certificate of Verified Skills

Your Name

For verified skills in: Google Sheets

Issued on October 13, 2026

Master Google Sheets Skills

Unlock powerful skills to boost your productivity and career growth.
Start learning today — sign up for free!

Sign Up Free

Post-Assessment

Verify you’ve mastered this

Simulation: Correct answer.

Answer:

Pre-Assessment

See if you already know this

: .