Overview

This course is an introduction to the features of Google Sheets. It covers an overview of the Sheets interface, performing calculations, modifying a worksheet to present relevant data, print setup, and manipulating a workbook to better view the data.

Objectives

Upon successful completion of this course, you will be able to create and develop Google Sheets spreadsheets to work with and analyze data.

Audience

This course is intended for students who wish to gain the foundational understanding of Google Sheets that is necessary to create and work with electronic spreadsheets.

Prerequisites

To ensure success, students will need to be familiar with using computers and should have experience using a keyboard and mouse. Students should also have an active G Suite (Google) account.

Outline

Lesson 1: Getting Started with Google Sheets

Topic A: Navigate the Google Sheet User Interface
Topic B: Use Google Sheet Commands
Topic C: Create, Save, and Download a Basic Spread-sheet
Topic D: Spreadsheet Settings
Topic E: Enter Cell Data
Topic F: Use Google Sheets’ Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Spreadsheet

Topic A: Insert, Delete, and Adjust Cells, Columns and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing Tools

Lesson 3: Modifying a Spreadsheet

Topic A: Insert, Delete, and Adjust Cells, Columns and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing Tools

Lesson 5: Printing Spreadsheets

Topic A: Preview and Print a Spreadsheet
Topic B: Set Up the Page Layout

Lesson 6: Managing Workbooks

Topic A: Manage Sheets
Topic B: Manage Workbook and Sheet Views
Topic C: Manage Workbook Properties