Google Sheets - Beginner

Overview

About this course

Self-paced lessons on Google Sheets basics: entering data, formula basics, formatting, managing and printing spreadsheets.

Curriculum

Curriculum

10 modules

Introduction

What is Google Sheets?
Opening Google Sheets
Importing and Converting Spreadsheets to Sheets
Navigating the Sheets User Interface
Understanding Sheet Components
Using the File Menu
Creating a Spreadsheet
Saving a Spreadsheet
Accessing Help

Navigating a Spreadsheet by Mouse or Keyboard
Working with Cell and Ranges
Using Various Data Selection Techniques
Working with Common Sheet Commands
Working with Copy and Paste
Understanding Data Types
Formatting Values
Using the Autofill Handle
Inserting Links

What are Formulas and Functions?
Understanding the Components of A Formula
Understanding Calculation Hierarchy and the Order of Operations
Creating Basic Formulas
Working with Basic Functions and Autosum
Using Cell References
Using Explore

Formatting and Aligning Data
Modifying Columns and Rows
Using Borders and Fill
Using Paint Format
Inserting Notes or Comments
Inserting Checkboxes

Using Zoom Tools
Working with Sheets
Working with Spreadsheet Tabs
Hiding and Unhiding Spreadsheets
Sorting Sheets Data
Filtering Sheets Data
Using Filter Views
Using Freeze Panes

Using Find and Replace
Using Spell Check
Preparing a Spreadsheet for Printing
Changing Spreadsheet Settings
Finalizing Printing
Downloading and Emailing Files
Sharing a Spreadsheet

Inserting a Chart
Formatting a Chart
Moving and Sizing a Chart

Inserting Images
Creating Drawings

Course Recap

Who it's for

Who it's for

New Google Sheets users who want a solid grounding.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.