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
