Course Outline

Introduction

Overview of Google Sheets for Government

  • What is Google Sheets?
  • Key Features of Google Sheets
  • Comparing Google Sheets to Microsoft Excel

Fundamentals of Google Sheets for Government Operations

  • Creating, Sharing, and Formatting Spreadsheets
  • Working with Pivot Tables
  • Sorting and Filtering Data
  • Using Find and Replace Functions

Functions and Formulas in Google Sheets for Government

  • Creating and Utilizing Functions and Formulas
  • Implementing Lookup Functions

Data Visualization with Google Sheets for Government

  • Creating Charts and Graphs

Advanced Features of Google Sheets for Government

  • Pulling and Managing Data
  • Creating and Using Macros
  • Leveraging Add-ons for Enhanced Functionality

Summary and Next Steps for Government Users

Requirements

  • A fundamental knowledge of computer systems

Audience

  • Data analysts for government
 14 Hours

Number of participants


Price per participant

Upcoming Courses

Related Categories