Google Sheets Data Analysis and Visualization is unfortunately unavailable

Thankfully we have 41 other Google Classes for you to choose from. Check our top choices below or see all classes for more options.

Google Sheets Data Analysis and Visualization

at ONLC Training Centers - Online

(7)
Course Details
Price:
$295
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this google training:

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

  • Uploading an Excel Workbook into Google Sheets
  • Importing an HTML Table or List into Google Sheets
  • Importing Data
  • Removing Duplicates
  • Sorting Data
  • Trimming Whitespace
  • Splitting Text into Columns
  • Filtering Data
  • Using Filter Views
  • Grouping Data
  • Using Text Functions
  • Inserting Links
  • Working with Data Validation

Creating and Working with Pivot Tables
  • Understanding Pivot Tables
  • Adding a Suggested Pivot Table
  • Adding a Pivot Table
  • Adding a Pivot Table using Explore
  • Editing a Pivot Table
  • Using a Pivot Table Filter
  • Viewing Cell Details
  • Formatting a Pivot Table
  • Using VLOOKUP to Add a Column to a List
  • Working with Summary Functions
  • Sorting a Pivot Table
  • Applying Filters
  • Creating a Slicer
  • Creating a Calculated Field
  • Creating a Chart from a Pivot Table

Working with Formatting
  • Working with Custom Formats
  • Customizing Conditional Formatting
  • Creating a New Conditional Formatting Rule
  • Working with Conditional Formatting Rules
  • Using Alternating Colors
  • Changing the Theme
  • Using the Explore Tool

Exploring Additional Chart Types
  • Becoming Familiar with Additional 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 Combo Chart

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

Sharing Spreadsheets
  • Sharing a Spreadsheet
  • Using Advanced Sharing Options
  • Using Notification Rules
  • Protecting Sheets and Ranges
  • Sharing a Link to a Spreadsheet
  • Collaborating with Suggesting Mode
  • Working with Comments
  • Downloading Spreadsheets in other Formats
  • Emailing a Spreadsheet as an Attachment


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.
Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (4)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

41 Top Choices

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways In-depth understanding of how Google Analytics can improve the student’s...

Tuesday Jul 14th, 12pm - 7pm Eastern Time

Online: Getting More Out of Google

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

Go beyond basic search and explore the various ways to find information with Google. Learn about Advanced Search, Image Search, and much more. Must register with a valid email address. Public Notice & Disclaimer During this Program, you may be using a third-party platform such as Google Hangouts Meet, Zoom, Screenleap, or Vimeo for the purpose...

Monday Jul 6th, 2:30pm - 3:30pm Eastern Time

Free

Introduction to Google Ads

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Thursday Jul 16th, 4pm - 7pm Central Time

Google Ads Introduction

This class is temporarily being offered remotely.

at Computer Training Source, Inc. - Naperville 2135 City Gate Ln Ste 300, Naperville, Illinois 60563

Google Ads allows individuals and organizations to advertise on the Internet. In this course, students will learn how to create and navigate a Google Ads account, create and manage ad campaigns, work with keywords, write ads, manage bidding and budgets, launch and manage ads and will also be able to create financial and performance reports. 

Tuesday Jul 7th, 9am - 4pm Central Time

Google Analytics: Key Concepts and Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Google Analytics for Beginners: Key Concepts and Quick Wins Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in...

Friday Jul 24th, 12pm - 3pm Central Time

Google Ads Part 2

This class is temporarily being offered remotely.

at Computer Training Source, Inc. - Naperville 2135 City Gate Ln Ste 300, Naperville, Illinois 60563

Google Ads allows individuals and organizations to advertise on the Internet. In this course, students will learn how to create and navigate a Google Ads account, create and manage ad campaigns, work with keywords, write ads, manage bidding and budgets, launch and manage ads and be able to create financial and performance reports. About Our Classes:...

Wednesday Jul 8th, 9am - 4pm Central Time

Google Analytics Introduction

This class is temporarily being offered remotely.

at Computer Training Source, Inc. - Schaumburg 1821 Walden Office Sq Ste 400, Schaumburg, Illinois 60173

Google Analytics is a suite that is integrated with Google’s data to help draw conclusions about the effectiveness of your site content, promotions and advertising campaigns. This class will go over how to implement Google Analytics, how to manage your accounts, perform reports and in-depth analysis with specific reports.

Thursday Jul 9th, 9am - 4pm Central Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including...

Tuesday Jul 14th, 9am - 4pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

July 14th Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways: In-depth understanding of how Google Analytics can improve...

Tuesday Jul 14th, 9am - 4pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered participants will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this...

Tuesday Jul 14th, 9am - 4pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways In-depth understanding of how Google Analytics can improve the student’s...

Tuesday Jul 14th, 9am - 4pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered participants will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this offering...

Tuesday Jul 14th, 10am - 5pm Mountain Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Tuesday Jul 14th, 11am - 6pm Central Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways In-depth understanding of how Google Analytics can improve the student’s...

Tuesday Jul 14th, 12pm - 7pm Eastern Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways In-depth understanding of how Google Analytics can improve the participant’s...

Tuesday Jul 14th, 12pm - 7pm Eastern Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Learn how to use your Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. You will learn the lean smart way to gain customer insights and then turn these into actions that will drive your business forward. Takeaways In-depth understanding of how Google Analytics can improve the participant’s...

Tuesday Jul 14th, 12pm - 7pm Eastern Time

Introduction to Google Ads

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

This 3-hr crash workshop will walk you through the strategy, campaign build, and optimization skills you need to get started with Google AdWords - the world's most powerful and effective advertising platform. By the end of the class you will have identified business goals and high intent keywords, set up you own campaign, played around with the Adwords...

Thursday Jul 16th, 2pm - 5pm Pacific Time

Introduction to Google Ads

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including...

Thursday Jul 16th, 3pm - 6pm Mountain Time

Introduction to Google Ads

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this...

Thursday Jul 16th, 4pm - 7pm Central Time

Introduction to Google Ads

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

Want a hands on workshop for Google AdWords? This 3-hr crash workshop will walk you through the strategy, campaign build, and optimization skills you need to get started with Google AdWords - the world's most powerful and effective advertising platform. By the end of the class you will have identified business goals and high intent keywords, set up...

Thursday Jul 16th, 5pm - 8pm Eastern Time