Welcome to ONLC Training Centers

Google On-Demand: Sheets Formulas and Functions Course

Price:$175

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.


Google On-Demand: Sheets Formulas and Functions Course

 

** This is an ONLC On-Demand, self-study course, 180-day, 24/7 access via the internet **

(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time, there are no set dates. This On-Demand (self-study) training course includes expert lectures and demonstrations that cover the same content that is included in our instructor-led (ILT) class.
Note: The 180-day course access period begins at time of purchase.

Overview

This one-day Google Sheets Functions class will show you some of the amazing things that Google Sheets can do. While Google Sheets is easy to use at an introductory level, it also has significant power to do more complex things. Covered in this class are advanced features and functions for conditional processing (IF statements and conditional functions), dealing with text, working with date fields and much more! You will be amazed by all of the advanced features that you never knew were available in Google Sheets.

Who Should Attend

The class is for Google Sheets Power Users.

Prerequisites

Before taking this class, we recommend that you have experience creating worksheets in Google Sheets or have taken ONLC’s Introduction to Google Sheets class.

Do You Still Prefer a Live, Instructor-led Class?

Already know On-Demand, Self-Study training is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the link below:
Google Sheets Formulas and Functions Instructor-led course

Duration

You have 24/7 access for 180-days to this digital course that includes 3h 27m of video presentation. As a traditional course it would be a 1-day class.

Course Outline

Working with Sheets and Spreadsheets

  • Viewing, Renaming, and Color-Coding Sheets
  • Manipulating Sheets
  • Creating Linked Formulas Between Sheets
  • Using Snap to View Multiple Spreadsheets
  • Using IMPORTRANGE

Understanding Functions

  • Using Absolute Cell References
  • Creating and Using Named Ranges
  • Working with Functions
  • Working with the Google Sheets Functions List

Working with Additional Functions

  • Using Statistical Functions
  • Using Math Functions
  • Using Financial Functions
  • Using Date Functions
  • Using Filter Functions
  • Using Text Functions

Working with Logical Functions

  • Using the IF function
  • Using Nested Functions
  • Using Multiple Conditions with the IF Function
  • Using the IFS Function
  • Using the SWITCH Function
  • Using the IFERROR Function

Working with Lookup and Reference Functions

  • Using HLOOKUP and VLOOKUP Functions
  • Using the MATCH Function
  • Using the INDEX Function
  • Nesting the INDEX and MATCH Functions
  • Using INDEX MATCH MATCH
  • Using INDEX MATCH & MATCH

 

View outline in Word

GGA1SF

Attend hands-on, instructor-led Google On-Demand: Sheets Formulas and Functions training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of G Suite Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com