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
- Defining Google Sheets
- Key features of Google Sheets
- Comparison between Google Sheets and Excel
Google Sheets Fundamentals
- Creating, sharing, and formatting spreadsheets
- Working with pivot tables
- Sorting and filtering data sets
- Utilizing find and replace functions
Functions and Formulas
- Developing functions and formulas
- Implementing lookup functions
Data Visualization
- Generating charts and graphs
Advanced Google Sheets
- Retrieving external data
- Developing macros
- Integrating add-ons
Summary and Future Directions
Requirements
- Fundamental computer literacy
Target Audience
- Data analysts
14 Hours
Testimonials (1)
Everything! This will be very helpful with my role.
