Course Outline

Introduction

Google Sheets Overview

  • What is Google Sheets?
  • Features of Google Sheets
  • Comparison of Google Sheets and Excel

Fundamentals of Google Sheets for Government

  • Creating, sharing, and formatting spreadsheets
  • Working with pivot tables
  • Sorting and filtering data
  • Utilizing find and replace functions

Functions and Formulas for Government

  • Creating and using functions and formulas
  • Implementing lookups

Data Visualization for Government

  • Generating charts and graphs

Advanced Google Sheets for Government

  • Pulling data from various sources
  • Creating macros to automate tasks
  • Utilizing add-ons to enhance functionality

Summary and Next Steps for Government

Requirements

  • A foundational knowledge of computer systems for government

Audience

  • Data analysts for government
 14 Hours

Number of participants


Price per participant

Upcoming Courses

Related Categories