Welcome to ONLC Training Centers

Google Sheets Data Analysis and Visualization Course Outline

 (1 day)
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

This one-day Google Sheets Data Analysis 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, database lookups, working with date fields, queries 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.

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.

Course Outline

Working with Data
Converting an Sheets File to Google Sheets
Importing Data from a Text File
Exporting Data
Converting Text to Columns
Using Filters
Sorting Data
Using Text Functions
Working with Hyperlinks
Working with Data Validation

Creating and Working with PivotTables
Understanding PivotTables
Creating a PivotTable using Worksheet Data
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Using a Report Filter
Formatting a PivotTable
Using VLOOKUP to Add a Column to a List

Enhancing PivotTables
Working with Summary Functions
Creating a Slicer
Applying Filters
Creating a Calculated Field
Creating a PivotChart

Using Styles, Themes, and Templates
Using Themes
Using Templates

Working with Formatting
Creating and Using Custom Formats
Applying Conditional Formatting
Creating a New Conditional Formatting Rule
Working with Conditional Formatting Rules
Using the Explore Tool

Working with Specialty Charts
Creating a Treemap Chart
Creating a Histogram
Creating a Candlestick Chart
Creating a Map Chart
Creating a Waterfall Chart
Creating a Gauge
Creating a Combo Chart
Creating a Sparkline
Creating a Dashboard

Using Sheets Data in Other Google Apps
Understanding Pasting, Linking and Embedding
Pasting an Sheets Range into a Docs Document
Pasting an Sheets Chart into a Docs Document
Pasting an Sheets Range into Slides
Pasting an Sheets Chart into Slides
Creating a Chart in Docs or Slides
Modifying a Chart in Docs or Slides

Sharing Spreadsheets
Sharing a Spreadsheet
Creating Comments
Assigning Comments
Working with Comments

View outline in Word


Attend hands-on, instructor-led Google Sheets Data Analysis and Visualization training classes at ONLC's more than 300 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 Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $295

Savings options:

 CEA Apps Saver
Need a price quote?

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

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name