Classroom Instructor Led Microsoft Excel Training 512-522-1265‬

Google Sheets Introduction

Class Schedule
Overview

This course is ideal for complete novices, those who have basic knowledge of Google Sheets or are self-taught. The course will provide you with the skills you need to work quickly and produce functional and well formatted spreadsheets. This course is often used to benchmark Google Sheets skills and ensure a level of understanding for new hires at companies. Students will leave feeling confident about creating professional worksheets with the software and be able to navigate the interface intuitively and productively.

Price

$425 per Student

CPE Credits

8 CPE Credits

Prerequisites

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.

Duration

1 Day

Class Outline
Getting Started with Google Sheets
  • Working with the Excel Environment
  • Title Bar
  • Ribbon and Ribbon Tabs
  • Quick Access Toolbar
  • Worksheet Views
  • Backstage View
Cell Basics
  • Understanding Cells
  • Select a Cell
  • Select a Cell Range
  • Inserting Cell Content
  • Deleting Cell Content
  • Cutting & Pasting Cell Content
  • Drag and Drop Cells
  • Completing Series with Fill Handle
Modifying Columns, Rows, and Cells
  • Changing Column Width
  • Changing Row Height
  • Inserting & Deleting Columns and Rows
  • Hiding & Showing Columns and Rows
  • Wrapping Cell Text
  • Merging Cells
Formatting Cells
  • Font Type, Size, Color, and Decorations
  • Cell Borders and Fill Colors
  • Cell Alignment and Styles
Cell Formats
  • Number Formats
  • Percentage Formats
  • Date Formats
Tables
  • Tables Overview
  • Creating Tables
  • Adding & Removing Data
Pivot Tables
  • Pivot Tables Overview
  • Creating Pivot Tables
  • How Pivot Tables Work
  • Slicing and Dicing
Intro to Formulas
  • Formulas Overview
  • Mathematical Operators
  • Cell References
  • Creating Formulas
  • Copying Formulas
Creating More Complex Formulas
  • Order of Operations
  • PEMDAS
Relative and Absolute Cell References
  • Relative References
  • Absolute References
  • Cell References Across Worksheets
Functions
  • Functions Overview
  • Parts of a Function
  • Function Arguments
  • Using Functions
  • Function Library
IF Function
  • IF Function Overview
  • IF Function Arguments
  • Using the IF Function
XLOOKUP Function
  • XLOOKUP Function Overview
  • XLOOKUP Function Arguments
  • Using the XLOOKUP Function
UNIQUE Function
  • UNIQUE Function Overview
  • UNIQUE Function Arguments
  • Using the UNIQUE Function
FILTER Function
  • FILTER Function Overview
  • FILTER Function Arguments
  • Using the FILTER Function
Charts
  • Charts Overview
  • Chart Components
  • Chart Layout and Styles

Google Sheets Introduction Schedule

In-Person Classes Schedule
This class currently has no scheduled public sessions. Since there are no public dates available, you can choose to schedule a private one-on-one class or arrange a private group class. For more information on these options, on the top menu bar click on Private Classes or 1 on 1 Classes.

Date Location Price Registration
Live Online Classes Schedule
This class currently has no scheduled public sessions. Since there are no public dates available, you can choose to schedule a private one-on-one class or arrange a private group class. For more information on these options, on the top menu bar click on Private Classes or 1 on 1 Classes.

Date Location Price Registration

Don't see a Class Date that works for you?

Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

Request New Class Date

Contact Us

Phone

512-522-1265

Office Address

9600 Great Hills Trail
Suite 150W
Austin, TX 78759

Mailing Address

PO Box 712
Aledo, TX 76008