This training program will give participants the fundamental abilities to utilise the Google Sheets application effectively. Covering topics such as spreadsheet formatting and utilising diverse formulas and functions, participants will acquire the skills and knowledge to proficiently utilize Google Sheets in their daily operations. Practical guidance, including hands-on exercises, will empower participants to employ best practices while navigating the application confidently.
Upon completion, participants will be able to:
Learners will be able to utilise the fundamental features of Google Sheets
Learners will be able to break and organise extensive amounts of data
Learners will be able to solve real-life spreadsheet challenges with ease
Module 1: Introduction to Google Sheets
Participants will understand the spreadsheet interface and use key features to design effective reports.
Module 2: Filtering & Cleaning Data
Participants will filter, organise, and clean spreadsheet data for accurate analysis.
Module 3: Conditional Formatting & Data Validation
Participants will apply formatting rules and validation controls to improve data accuracy and visibility.
Module 4: Essential Functions
Participants will use cell references, criteria-based formulas, logical functions, and IF statements effectively.
Module 5: LOOKUP Functions
Participants will retrieve and match data accurately using VLOOKUP and XLOOKUP.
Module 6: Pivot Tables
Participants will create and optimise Pivot Tables to summarise and analyse data efficiently.
Duration
1-day program
Methodology
Instructor-led training with hands-on practical exercises.
Target Audience
Suitable for fresh graduates or anyone who requires basic knowledge and skills in Google Sheets application.
Course Level
Beginner — designed for those requiring basic knowledge and skills in Google Sheets.
Pre-requisites
No formal prerequisites; basic computer literacy is recommended.
Progress withCompassion.
We exist at the intersection of technical mastery and human development, because we believe these are not two separate things. They never were.
