Google Sheets Data Analysis and Visualization

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 our 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
• 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
• Working with Conditional Formatting Rules
• Using Alternating Colors
• Changing the Theme
• Working with Explore

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

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

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