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
- What is Google Sheets?
- Key features of Google Sheets
- Comparison between Google Sheets and Excel
Fundamentals of Google Sheets
- Creating, sharing, and formatting spreadsheets
- Working with pivot tables
- Sorting and filtering data
- Utilizing find and replace functions
Functions and Formulas
- Creating functions and formulas
- Using lookup functions
Data Visualization
- Creating charts and graphs
Advanced Google Sheets
- Pulling data
- Creating macros
- Using add-ons
Summary and Next Steps
Requirements
- A fundamental understanding of computer operations
Audience
- Data analysts
14 Hours