These are the exercise files used for Google G Suite Essential Training course.
The course outline can be found in
https://www.tertiarycourses.com.sg/google-drive-essential-training-in-singapore.html
https://www.tertiarycourses.com.my/google-drive-essential-training-in-malaysia.html
Module 1 Overview of G Suite
- What is G Suite?
- Overview of G Suite Applications
- Sign in to G Suite
Module 2 Google Sheets
- Creating Google Sheets from Templates
- Navigating Google Sheets
- Formating
- Filter, Sort and Freeze
- Functions and Formulas
- Pivot Table
- Creating and Configuring Charts
- Collaborating on Google Sheets
Module 3 Google Docs
- Creating Google Doc from Templates
- Navigating Google Doc
- Paint Tool
- Insert Image, Table and Drawing
- Collaborating on Google Docs
Module 4 Google Slides
- Creating Google Slides from Templates
- Navigating Google Slides
- Insert Image, Video and Table
- Insert Diagram and Animation
- Transition
- Import Theme
- Edit Master Template
- Collaborating on Google Slides
Module 5 Google Form
- Navigating Google Form
- Add items to Questions
- Redirect Answers
- Select Theme
- Form Setting
- Send Form
- Responses
- Unlink Form
Module 6 Google Calendar
- Create a New Calendar
- Create a New Event
- Edit an Event
- Calendar Setting
Module 7 G Suite Admin (Optional)
- Admin Dashboard
- Company
- Apps
- User
- Device Management
- Admin Roles
- Groups
- Domains
- Reports
- Security
- Data Migration