Google Sheets Data Analysis and Visualization Course Outline
(1 day)
Special Note to New Hampshire ResidentsThis 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.
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
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
XGA1SD
Facebook
LinkedIn