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: Formatting a Worksheet

Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles
Topic E: Adding Borders and Colors
Topic F: Apply Basic Conditional Formatting
Topic G: Create and Use Templates

Lesson 2: Printing Spreadsheets

Topic A: Preview and Print a Spreadsheet
Topic B: Set Up the Page Layout
Lesson 3: Managing Workbooks
Topic A: Manage Sheets
Topic B: Manage Workbook and Sheet Views
Topic C: Manage Workbook Properties