Classroom Instructor Led Microsoft Excel Training 832-852-3196

Google Sheets Introduction

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


Date Location Price Registration
December 27, 2024
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Class is Full. Waiting List
January 1, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Class is Full. Waiting List
February 26, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
April 23, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
June 18, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
August 13, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
October 8, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
December 3, 2025
9:15 AM to 5:00 PM
The Woodlands, TX $425.00 Register
Live Online Classes Schedule


Date Location Price Registration
December 27, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List
January 23, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List
March 20, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
May 15, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
July 10, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
September 4, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
October 30, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
December 25, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List

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.

Contact Us

Phone

832-852-3196

Office Address

2002 Timberloch Place, Suite 200

The Woodlands, TX 77380

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.