Welcome to ONLC Training Centers
  1. Home
  2. Courses
  3. Google Workspace
  4. Google Sheets
  5. Google Sheets Data Analysis and Visualization

Google Sheets Data Analysis and Visualization Course

Class Dates
(click date for class times)
(click Enroll for locations)
4/1
Class Dates and Times
04/01/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!

  

Register Soon!
Registrations on or after Wednesday 3/26 incur a late registration charge to cover book shipping and provisioning costs.
Before 3/26$295
On/After 3/26$345
Last Reg Date3/27
4/28
Class Dates and Times
04/28/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
 
5/27
Class Dates and Times
05/27/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Early Notice Class
Early Notice classes have enrollments that suggest that the class will run as scheduled.
 
6/23
Class Dates and Times
06/23/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
7/21
Class Dates and Times
07/21/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
Fee:  $295

Savings options:

 Learning Credits
Need a price quote?

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

Need a class for a group?

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

Email Alert

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

Train from your home or office

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


  1. Home
  2. Courses
  3. Google Workspace
  4. Google Sheets
  5. Google Sheets Data Analysis and Visualization

Google Sheets Data Analysis and Visualization Course

 

Overview

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.

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.

Course Outline

Working with Data

  • Sorting Data
  • Filtering Data
  • Using Filter Views
  • Grouping Data
  • Inserting Links
  • Working with Links
  • Working with Data Validation

Importing and Manipulating Data

  • Opening a Microsoft Excel Workbook in Google Sheets
  • Importing a Table or List on a Web Page into Google Sheets
  • Importing Data
  • Removing Duplicates
  • Trimming Whitespace
  • Using Cleanup Suggestions
  • Using Column Stats
  • Splitting Text into Columns
  • Randomizing a Range of Data

Creating and Working with Pivot Tables

  • Understanding Pivot Tables
  • Creating a Suggested Pivot Table
  • Creating a New Pivot Table
  • Creating a Pivot Table using Explore
  • Using VLOOKUP to Add a Column to a List
  • Using the Pivot Table Editor
  • Viewing Cell Details
  • Creating a Calculated Field
  • Using Slicers
  • Creating a Chart from a Pivot Table

Working with Formatting

  • Working with Custom Formats
  • Using Conditional Formatting
  • Creating a Custom Formula with Conditional Formatting
  • Using Alternating Colors
  • Changing the Theme
  • Working with Explore

Sharing Spreadsheets

  • Sharing a Spreadsheet
  • Sharing a Link to a Spreadsheet
  • Publishing to the Web
  • Protecting Sheets and Ranges
  • Working with Comments
  • Downloading Spreadsheets in Other Formats
  • Emailing a File

Using Google Sheets Data in Other Google Apps

  • Pasting a Sheets Range into Docs or Slides
  • Pasting a Sheets Chart into Docs or Slides
  • Inserting a Sheets Chart into Docs or Slides
  • Working with Linked Objects
  • Creating and Modifying a Chart in Docs or Slides
  • Pasting a Docs or Slides Table into Google Sheets
  • Creating a Form in Sheets
  • Working with Form Data

Working with Special Chart Types

  • Becoming Familiar with Special Chart Types
  • Creating a Geo Chart
  • Creating a Waterfall Chart
  • Creating a Histogram Chart
  • Creating a Radar Chart
  • Creating a Gauge Chart
  • Creating a Scorecard Chart
  • Creating a Candlestick Chart
  • Creating an Organizational Chart
  • Creating a Tree Map Chart
  • Creating a Timeline Chart
  • Creating a Table Chart
  • Creating a Combo Chart
  • Creating a Sparkline

 

View outline in Word

XGA1SD

Attend hands-on, instructor-led Google Sheets Data Analysis and Visualization 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 Google Sheets 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
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect