In today's data-driven world, Google Sheets has become an essential tool for organizing, analyzing, and collaborating on data. This 2-day beginner's course introduces participants to the fundamentals of Google Sheets, from navigating the interface to creating formulas, managing data, and collaborating effectively. By the end of this course, attendees will have the skills and confidence to harness the power of Google Sheets in their professional and personal projects.

Participants are expected to bring laptops with internet access.

Objective

By the end of this course, participants will be able to:

• Navigate the Google Sheets interface with ease and confidence.
• Perform basic data entry, formatting, and calculation tasks.
• Use essential formulas and functions to analyze data efficiently.
• Organize and filter data for better insights and decision-making.
• Create basic charts and visual representations of data.
• Collaborate on Google Sheets with others, including sharing and setting permissions.
• Apply simple data protection measures and utilize add-ons to enhance functionality.

Outline

Day 1: Introduction and Core Skills

Module 1: Introduction to Google Sheets

• Overview of Google Sheets and its applications
• Benefits of cloud-based spreadsheet software

Module 2: Navigating the Interface

• Understanding the Google Sheets layout: menus, toolbar, rows, columns, and cells
• Creating, saving, and accessing sheets

Module 3: Data Entry and Formatting Basics

• How to enter and edit data
• Formatting text, numbers, and dates
• Adjusting row/column sizes and merging cells

Module 4: Basic Formulas and Functions

• Introduction to essential formulas: SUM, AVERAGE, and COUNT
• Using formulas across rows and columns
• Hands-on practice exercises

Day 2: Advancing Skills and Practical Applications

Module 5: Data Organization Techniques

• Sorting data in ascending/descending order
• Filtering data for specific insights
• Freezing rows and columns for better navigation

Module 6: Intermediate Functions and Formulas

• Exploring VLOOKUP, COUNTIF, and IF statements
• Practical scenarios and exercises

Module 7: Conditional Formatting and Data Visualization

• Applying conditional formatting to highlight data trends
• Creating basic charts: bar, line, and pie charts

Module 8: Data Cleaning and Protection

• Removing duplicates and using the UNIQUE function
• Protecting data with permissions and restricted editing

Who should attend

This course is designed for:

• Professionals who are new to Google Sheets and want to learn how to manage data more effectively.
• Small business owners and entrepreneurs who need to organize and analyze their business data.
• Administrative and support staff looking to improve their data management and reporting skills.
• Anyone interested in gaining foundational skills in Google Sheets for personal or professional use.
• No prior experience with Google Sheets or other spreadsheet software is required.

Dwight Nuwan Fonseka's Profile

Head Data Analyst | Data Governance & AI | CAIP | CDSP | ACLP

Dwight Fonseka is a seasoned data analytics professional with over a decade of experience in big data, predictive modeling, and AI. Holding a Master’s in Education (NTU), a degree in Biotechnology (NUS). He is a Certified AI Practitioner (CAIP), Certified Data Science Practitioner (CDSP), and ACLP-certified trainer with extensive experience delivering data-driven insights and practical applications across industries.

Dwight has held roles such as Senior Data Analyst and Data Governance Officer at Plano Pte Ltd, specializing in healthcare analytics and machine learning. As an adjunct trainer, he delivers practical courses in data visualization, data storytelling, deep learning, and AI business models, using tools like R, Python, Tableau, and RapidMiner.

Notable Topics Trained:

• Data Analytics & Visualization (R, Tableau, Excel)
• Machine & Deep Learning (RapidMiner, DeepCognition)
• Data Governance & AI Business Models
• Predictive Analytics & Data-Driven Decision-Making