Sheets – Supported – Half Day

$ 240.00

Module Duration: 3.5 Hours

Class Agenda

Resource Setup 30 Minutes
Training Session 3 Hours
Breaks Prescribed by Instructor

The ability to work with and analyze data is critical to the success of your organization – and Google Sheets is a solution to do just that. Learn to navigate the application confidently while creating and developing spreadsheets that employ the most popular features Sheets has to offer. Later modules teach you to control data – a skill that is a significant benefit to your organization. You will learn to analyze massive amounts of data, extract actionable information from it, and present the information clearly using more advanced features.

Module 1

  • Navigate the Google Sheets User Interface
  • Use Google Sheets Commands
  • Create, Save and Download a Basic Spreadsheet
  • Spreadsheet Settings
  • Enter Cell Data
  • Use Google Sheets’ Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
  • Insert, Delete, and Adjust Cells, Columns and Rows
  • Search for and Replace Data
  • Use Proofing Tools

Module 2

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles
  • Adding Borders and Colors
  • Apply Basic Conditional Formatting
  • Create and Use Templates
  • Preview and Print a Spreadsheet
  • Set Up the Page Layout
  • Manage Sheets
  • Manage Workbook and Sheet Views
  • Manage Workbook Properties

Module 3

  • Working with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Subtotal Data

Module 4

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Create Charts
  • Modify and Format Charts
  • Use Advance (sic) Chart Features
  • Create a Pivot Table
  • Analyze Pivot Table Data
  • Present Data with Pivot Tables
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955


Scroll to Top