Google Sheets 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.

Prerequisites:

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.

Who Should Not Attend:

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.

Course Outline

The Basics

• How to create a Google Sheet
• Finding your way around a Google Sheet
• Adding data onto the sheet

Cell formatting

• Adding cell borders
• Filling the cells with colours
• Changing the position of the data in the cells (justification)
• Putting the data in bold
• Changing the font, font size, and selecting text wrap
• Text rotation

Formatting your data

• Changing to currency format
• Changing to percentages
• Accounting and financial formats

Functions and formulas are your friends!

• So, what are Google Sheet formulas?
• What are functions?

Controlling rows and columns (part 1)

• Changing row size of rows and columns
• Selecting the whole row or column
• Inserting a row or column
• Deleting a row or column
• Inserting specific cells
• Deleting specific cells
• Splitting text into columns

Controlling rows and columns (part 2)

• Selecting multiple rows or columns
• Deleting unwanted rows and columns
• Hiding and unhiding rows and columns
• Freezing rows and columns
• Grouping rows and columns

Cell references - Absolute & relative

Moving, copying & pasting data

• Moving cells
• Copying and pasting cells
• Paste special
• Quick sequential numbers

Moving beyond one sheet

• Renaming sheets
• Adding colors to the sheet tabs
• Duplicating sheets
• Adding sheets
• Deleting sheets
• Moving sheets
• Moving the tabs to find a particular sheet
• Hiding sheets
• Sheet tab menu
• Adding references to other sheets

Sharing, printing and downloading

• Printing sheet(s)
• Controlling what to print
• Scale
• Margins
• Custom page breaks
• Formatting
• Headers and footers
• Downloading a spreadsheet in different formats
• Emailing a spreadsheet
• Sharing a spreadsheet

Filtering your data

• Filter - By value
• Filter - By condition
• Filter View
• Duplicating a filter

Conditional Formatting & Custom Formulas

• Conditions
• Custom formula

Sorting your data

• Randomize range

Merging cells

• Merge all
• Merge vertically and horizontally

Notes and comments

• Adding notes
• Editing a note
• Deleting a note
• Adding comments
• Replying to a comment
• Resolving a comment
• Editing a comment
• Deleting a comment
• Comments - Tab info
• Assigning actions via Comments

Sparklines

• Inserting basic sparklines (line graphs)
• Adding extra options to your sparklines
• Line graphs
• Changing sparkline chart type

Creating charts (part 1)

• Creating and inserting a simple chart
• Data
• Chart types
• Stacking Data
• Range
• X-Axis and Series
• Rows and Columns
• Customize your chart
• Chart Style
• Chart & Axis Titles
• Series
• Legend
• Horizontal Axis
• Vertical Axis

Creating charts (part 2)

• Adding a new series to a chart
• Creating charts with two different scales
• Editing the title, subtitle and axis titles

Alternating colors

Adding Links

• Linking a sheet
• Linking a specific cell
• Linking to a range of cells
• Linking to an external site

The Explore tool

• Insert a chart
• Editing the data range
• Asking questions about your data
• Quickly formatting your data

Data Validation

• Setting up data validation to check for a valid for a date
• Checking data meets a ‘numbers’ criteria and rejecting invalid entries
• Setting up a “list of items” validation
• Setting up a “list from a range” validation
• Open-ended lists
• Drop-down menu in alphabetical order
• Creating a drop-down list which can be added to