Duration

Google Sheets

1 day

INTRODUCTION

This one-day class will show you how to create, edit, share, and print documents with Google Sheets. The class is recommended for users who would like to get to know Google Sheets in more depth or who are converting to Google

Workspace from another office suite such as Microsoft Office.

TARGET AUDIENCE

If you have never used a spreadsheet program before, you should not take this class. The class is fast-paced and assumes you understand the basic spreadsheet concepts. You know how to do things in Microsoft Excel--now you just need to learn how to do the same things in Google Sheets.

PRE-REQUISITE

To ensure your success in this course, you should have end-user computer skills, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.

9:00am-10:30am

Module 1: Getting Started

Signing in to Google Apps

Using the Google Apps Menu

Accessing Sheets from Drive

Making a Copy of a Spreadsheet

Understanding the Display Screen

Using the Menu and the Toolbar

Using Help

Module 2: Entering Data

Changing the Active Cell

Selecting a Range of Cells

Creating and Naming a New Spreadsheet

Inserting, Renaming and Deleting Sheets

Course Outline :: Google Sheets::

Entering Constant Values and using Autofill

Modifying Cell Contents

Closing a Spreadsheet

10:30am-10:45pm Morning Break

10:45pm-12:30pm

Module 3: Using Formulas

Entering Formulas

Using Autofill with Formulas

Using the SUM Function

Using Common Functions

Correcting Formula Errors

Module 4: Modifying Sheet Data

Copying and Pasting Constant Values and Formulas

Cutting and Pasting Constant Values and Formulas

Checking Spelling

Using Find and Replace

Working with Versions

Viewing Details

12:30pm-1:30pm Lunch

1:30pm-3:30pm

Module 5: Formatting Worksheets

Formatting Numbers

Formatting Text

Formatting Cells

Aligning Cell Contents

Using Paint Format

Using Alternating Colors

Changing the Theme

Using Conditional Formatting

Module 6: Modifying Columns and Rows

Moving Columns or Rows

Resizing Column or Rows

Inserting Columns or Rows

Deleting Columns or Rows

Course Outline :: Google Sheets::

Hiding Columns or Rows

Grouping Columns or Rows

Freezing and Unfreezing Columns or Rows

Using Zoom

3:30pm-3:45pm Afternoon Break

3:45pm-5:00pm

Module 7: Printing Worksheets

Previewing a Sheet for Printing

Working with Print Settings

Inserting Page Breaks

Creating Headers and Footers

Repeating Row and Column Headers

Printing a Sheet

Module 8: Creating Charts

Creating a Chart

Changing the Chart Location and Size

Working with the Chart Editor Setup Options

Working with the Chart Editor Customize Options

Programme scope, delivery arrangements and suitability are confirmed during enquiry.