• Live Instruction

• Hands-on, Guided Activities

• LIVE Remote or Classroom Delivery

What’s Included

  • Small class sizes
  • A digital Google Sheets training manual
  • Certificate of course completion
  • FREE retake valid for 12 months
  • Virtual Lab (LIVE Remote)

Onsite Google Sheets training available countrywide.

Book Course

GOOGLE SHEETS COURSE OUTLINES

Detailed Course Outline

Getting Started with Google Sheets
  • Navigate the Google Sheets User Interface
  • Use Google Sheets Commands
  • Create, Save and Download a Basic Spreadsheet
  • Spreadsheet Settings
  • Enter Cell Data
  • Use Google Sheets’ Help
Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
Modifying a Spreadsheet
  • Insert, Delete, and Adjust Cells, Columns and Rows
  • Search for and Replace Data
  • Use Proofing Tools
Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles
  • Adding Borders and Colors
  • Apply Basic Conditional Formatting
  • Create and Use Templates
Printing Spreadsheets
  • Preview and Print a Spreadsheet
  • Set Up the Page Layout
Managing Workbooks
  • Manage Sheets
  • Manage Workbook and Sheet Views
  • Manage Workbook Properties

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Excel Level 2 - Introduction

Building upon knowledge gained from Sheets 1, our intermediate-level Sheets class teaches you to control data – a skill that is a significant benefit to your organization. You will learn to analyze massive amounts of data, extract actionable information from it, and present the information clearly using more advanced features than previously covered.

Recommended Preparation: Sheets 1

Book LIVE Remote Book Classroom Download PDF
$294 -or- 2 Tickets(click for more info!)

Detailed Course Outline

Working with Functions
  • Working with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Subtotal Data
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advance (sic) Chart Features
Using Pivot Tables and Pivot Charts
  • Create a Pivot Table
  • Analyze Pivot Table Data
  • Present Data with Pivot Tables

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Three Class Discount

Buy any three classes and receive 20% off.

The Training to YOU Three Class Discount is a terrific way for an individual to purchase multiple classes for a discount. Whether you are looking for a series of classes like Excel 1, 2 & 3 or a variety of classes such as Google Sheets, Docs and Slides the Three Class Discount is the way to go!

State of Arizona employees are eligible for an additional discount.

Three Class Discount

Training to YOU Tickets

Tickets are a great way to reduce the cost of training your team. Save up to 45% by purchasing your training in bulk.

We are now providing a custom-made registration portal for each organization that purchases 50+ training tickets. These portals allow supervisors and employees to schedule training easily and information workflows keep everyone in the loop.

Ticket Info

Give us a call

We are happy to answer any questions you may have.

Call us

(602) 266-1500

TRAINING TO YOU


Class Ratings
4.9 stars from 1984 reviewers:

 

“Instructor is very patient and helpful. Takes time to help student catch up if lagged a little behind. Plan to take Access Level 3 later. Training to You has always been  great.  Have taken classes in the past few years.”

— J.P. took Access 2 Database Design, Advanced Input and Retrieval

“My Instructor was great. He was knowledgeable and attentive throughout the course. He presented lofty concepts in a manner that was easy to understand and apply in real life. I look forward to my next course! ”

— C.K. took Access 1: Data Structure and Input and Retrieval

“We appreciate Training to You providing the training on site at our office. This was an excellent training for us to train the majority of our team. Thank you to our instructor for his patience and willingness to assist us with our questions.”

— K.P. took Access 2 Database Design, Advanced Input and Retrieval

GOOGLE SHEETS TRAINING FAQ

Training to YOU is dedicated to providing the best online and in-person Google Workspace training. Find answers to some of our most frequently asked questions below, or contact us should you require further assistance.

This depends on your current level of experience. Most will benefit from starting at the beginning with Sheets 1 which is the perfect introduction to the core concepts, terminology and navigation of the application. Before you decide to start with a course later in the series, we recommend reviewing the full list of topics covered by downloading the PDF outline for that course below the course description. 

LIVE Remote training classes can be taken anywhere using your own devices. This method provides the same hands-on experience you would get in the classroom, minus the commute.

Classroom training is taken at our facility in downtown Phoenix. We provide everything you need to take the class – including refreshments and technical assistance by onsite support staff. All you need to bring is yourself.

Instructors may or may not be present in the classroom.  A hands-on experience will be provided for each participant regardless of the location chosen.

You will need:

  • A stable, high-speed internet connection (wired is recommended over Wi-Fi whenever available)
  • A PC or laptop with mouse and keyboard
  • A second monitor (preferred) or device (screen size should be large enough to view instructor’s share)
  • Speakers or headphones are a must and a microphone is recommended.

Click here for full setup instructions, including links to test your system and network.

If you do not have the resources above, consider taking your class in-person at our training center and we will provide everything you need.

Refer to your confirmation email to see the start and end times for your class.

The actual class end time may vary from the scheduled end time due to class size and student skill level.

All times are in MST for Phoenix, AZ where Daylight Savings Time is not observed.

See the local time in Phoenix here for clarification.

LIVE Remote students may begin joining the virtual classroom 15 minutes prior to the scheduled start time.

Classroom participants are encouraged to arrive at our facility about 15 minutes before the scheduled start time.

Students that arrive late will be asked to reschedule.