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
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