Log On/Register  

855.838.5028

Google Sheets

Duration: 2 Days
Module Price: $180

Data analysis and management has never been more important than in today’s world. In this class, users will be introduced to the Google Sheets interface as well as to the tools available for both managing and analyzing data. Users will also learn to take advantage of web-based features like real-time collaboration and search.

 

Module 1: Sheets Essentials & Intro to Formulas and Functions

  • Introduction to the Sheets Interface 
  • Searching the Menus
  • Navigating and Selecting Cells
  • Keyboard Shortcuts
  • Entering and Editing Data
  • “Explore”
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving the Workbook File
  • Introduction to Google Drive
  • Overview of the Formulas Bar
  • Building Basic Formulas
  • Using Simple Functions
  • Copying Formulas/Functions with the Autofill Command
  • Using Relative and Absolute Cell References in Calculations

 

 Module 2: Formatting, Spreadsheet Design, Page Setup, & Printing

  • Inserting Rows & Columns
  • Moving, Copying, and Pasting Data
  • Using Autofill to Complete a Series of Values
  • Cell Alignment & Rotation; Word Wrap
  • Formatting Worksheet Data/Using Cell Design
  • Using Sheets Templates/Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, and Move/Copy
  • Freezing or Splitting Panes
  • Hiding Rows/Columns
  • Spell-Checking your Worksheets
  • Setting Print Options through Page Setup
  • Using the Full-Screen View
  • Printing your Worksheet
  • “Download As” Options
  • Publishing Sheets to the Web
  • Sending Google Sheets as Emails

 

 Module 3: List/Pivot Table Essentials & Charting

  • Overview of List Design
  • Single and Multi-Level Sorting
  • Filtering Records in a List
  • Search by Filter
  • Custom Filter Views
  • Inserting Data Charts
  • Formatting and Editing Chart Elements
  • Adding/Removing Data from a Chart
  • Inserting Sparkline
  • Alternating Colored Rows
  • Creating Pivot Tables from Lists
  • Filtering within Pivot Tables
  • Working with Pivot Charts

 

 Module 4: Creating Advanced Functions

  • Creating and Applying Names in a Worksheet
  • Using the IF Function
  • Introduction to Nesting Functions
  • VLOOKUP Functions
  • Summary-Based Functions: SUMIF(S), COUNTIF(S), and AVERAGEIF(S)
  • Using the IFERROR Function
  • Text Functions: Left, Right, and Mid
  • Concatenate and Split Text-To-Columns
  • Sharing and Managing Permissions
  • Real-Time Collaboration
  • Finding and Managing Sheets Add-Ons
  • What are Scripts?

Data analysis and management has never been more important than in today’s world. In this class, users will be introduced to the Google Sheets interface as well as to the tools available for both managing and analyzing data. Users will also learn to take advantage of web-based features like real-time collaboration and search.

 

Module 1: Sheets Essentials & Intro to Formulas and Functions

  • Introduction to the Sheets Interface 
  • Searching the Menus
  • Navigating and Selecting Cells
  • Keyboard Shortcuts
  • Entering and Editing Data
  • “Explore”
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving the Workbook File
  • Introduction to Google Drive
  • Overview of the Formulas Bar
  • Building Basic Formulas
  • Using Simple Functions
  • Copying Formulas/Functions with the Autofill Command
  • Using Relative and Absolute Cell References in Calculations

 

 Module 2: Formatting, Spreadsheet Design, Page Setup, & Printing

  • Inserting Rows & Columns
  • Moving, Copying, and Pasting Data
  • Using Autofill to Complete a Series of Values
  • Cell Alignment & Rotation; Word Wrap
  • Formatting Worksheet Data/Using Cell Design
  • Using Sheets Templates/Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, and Move/Copy
  • Freezing or Splitting Panes
  • Hiding Rows/Columns
  • Spell-Checking your Worksheets
  • Setting Print Options through Page Setup
  • Using the Full-Screen View
  • Printing your Worksheet
  • “Download As” Options
  • Publishing Sheets to the Web
  • Sending Google Sheets as Emails

 

 Module 3: List/Pivot Table Essentials & Charting

  • Overview of List Design
  • Single and Multi-Level Sorting
  • Filtering Records in a List
  • Search by Filter
  • Custom Filter Views
  • Inserting Data Charts
  • Formatting and Editing Chart Elements
  • Adding/Removing Data from a Chart
  • Inserting Sparkline
  • Alternating Colored Rows
  • Creating Pivot Tables from Lists
  • Filtering within Pivot Tables
  • Working with Pivot Charts

 

 Module 4: Creating Advanced Functions

  • Creating and Applying Names in a Worksheet
  • Using the IF Function
  • Introduction to Nesting Functions
  • VLOOKUP Functions
  • Summary-Based Functions: SUMIF(S), COUNTIF(S), and AVERAGEIF(S)
  • Using the IFERROR Function
  • Text Functions: Left, Right, and Mid
  • Concatenate and Split Text-To-Columns
  • Sharing and Managing Permissions
  • Real-Time Collaboration
  • Finding and Managing Sheets Add-Ons
  • What are Scripts?
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):