Discover Classes. Earn Rewards.

Google Sheets Introduction

Learn how to create, edit, share, and format documents using Google Sheets in this one-day course. Perfect for users converting to G Suite or wanting to deepen their knowledge of Google Sheets. Boost your productivity and collaboration skills with this essential tool.

  • Beginner
  • 18 and older
  • $295
  • 1320 Tower Rd, Chicago, IL
  • 6 hours & 45 minutes

Start Dates (1)

  • $295
  • ONLC Schaumburg @ 1320 Tower Rd 1st Fl, Chicago, IL 60173
  • 6 hours & 45 minutes
2 seats left
Book
Showing 11 of 1

Class Description

Description

What you'll learn in this google apps training:

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 G Suite 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 colors
  • 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

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at ONLC Training Centers (7)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 2950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

ONLC Training Centers

ONLC Training Centers

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...