Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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