Google Sheets Introduction is unfortunately unavailable

Thankfully we have 1 other Google Apps Class for you to choose from. Check our top choice below or see all classes for more options.

Google Sheets Introduction

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$295
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 7

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

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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 about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

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.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

1 Top Choice

Intro to Google Ads

at General Assembly - Near North Side 444 N Wabash Ave 5th Fl, Illinois City, Illinois 60611

Google AdWords is designed to help you reach potential customers at the exact right moment. This workshop will walk you through what you need to know to get started with this highly powerful, highly technical, advertising platform. Students will learn keyword audience targeting, how to design effective ad copy, and how to estimate you ad’s success....

Thursday Dec 12th, 6pm - 8:30pm