Google Sheets brings spreadsheet power to the cloud with real-time collaboration, making it a favourite for teams and data work alike. This program equips participants with practical Google Sheets skills, covering how to build, calculate, analyse, and collaborate on spreadsheets in the cloud.
As cloud spreadsheets and collaboration grow, Sheets skills are valuable across roles. This course combines Sheets technique with data and collaboration practice and introduces emerging features in Google Sheets.
Course Objectives
Upon the successful completion of this program, attendees will be able to:
- Navigate the Google Sheets interface
- Enter and format data
- Apply formulas and functions
- Apply common Sheets functions
- Use references and ranges
- Sort and filter data
- Apply conditional formatting
- Create charts
- Use pivot tables
- Apply lookup functions
- Collaborate in real time
- Apply comments and sharing
- Use data validation
- Connect and import data
- Apply Sheets automation basics
- Apply emerging features in Google Sheets
Course Outline
- Module 1: The Google Sheets Interface
- Module 2: Entering & Formatting Data
- Module 3: Formulas & Functions
- Module 4: Common Sheets Functions
- Module 5: References & Ranges
- Module 6: Sorting & Filtering Data
- Module 7: Conditional Formatting
- Module 8: Creating Charts
- Module 9: Pivot Tables
- Module 10: Lookup Functions
- Module 11: Real-Time Collaboration
- Module 12: Comments & Sharing
- Module 13: Data Validation
- Module 14: Connecting & Importing Data
- Module 15: Emerging Features in Google Sheets
Who Should Attend
This course is intended for anyone who wants to build, analyse, and collaborate on spreadsheets using Google Sheets. No prior advanced experience is required.
Registration & Inquiry
For more details & inquiry, please contact us at:
