Embark on a journey to mastering Google Sheets with our essential training course. This course is meticulously designed to provide you with a comprehensive understanding of Google Sheets and its powerful features, transforming you into a proficient user capable of harnessing the full potential of this versatile spreadsheet tool. Whether you're managing data, creating charts, or performing complex calculations, our expert instructors will guide you step-by-step, ensuring you gain practical skills that are immediately applicable to your daily tasks and projects.

Our Google Sheet Essential Training covers a range of topics, from basic spreadsheet navigation and formatting to advanced data analysis techniques and automation with Google Sheets. You'll learn how to efficiently organize and analyze data, create visually appealing charts and graphs, and automate repetitive tasks to save time and boost productivity. By the end of the course, you'll be confident in your ability to leverage Google Sheets to its fullest, giving you a competitive edge in today's data-driven world. Sign up now and unlock the full potential of Google Sheets!

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M824

Topic 1: Spreadsheet Basics

• Introduction

• Pre work: Creating a Google drive account

• Pre work: Creating a copy of my spreadsheet templates!

• Spreadsheet basics

• Toolbar walkthrough

• Data types in Spreadsheets

• Navigating Spreadsheets with shortcuts

• Simple formatting tricks – beautify your Spreadsheets

Topic 2 Introduction to functions

• Get familiar with SUM, COUNT, AVERAGE, COUNTA, MIN, MAX

• Activity

Topic 3: Conditional Functions

• IF Statement

• AND / OR statements

• IF’s and nesting IF

• Conditional formatting

• Conditional arithmetic functions (eg: SUMIF)

Topic 4: Pivot Tables, Sorting & Filtering

• Introduction to raw data and the new section format

• Pivot tables

• Sorting and filtering

Topic 5: Charts & graphs

• Creating charts and graphs in Google Sheets

Topic 6: Data Validation & introduction to Dynamic Models

• Data validation

• Creating basic dynamic model

• Data validation and intermediate modelling

Topic 7: Errors, IF Error and Creating named ranges

• Errors that we need to know and how to fix them

• IFERROR formula

• Named ranges

Topic 8: VLOOKUP, Lookup and Index Match

• Vlookup

• Hlookup

• Index Match

Topic 9: Text functions

• Adding words together and changing their case

• Extracting first and last names from a cell

• Left function

• Right function

• Len function

• Trim function

Topic 10: Date & time functions

• Edate, EOMonth

• Interactive calendar

Topic 11: Rounding and Randomizing

• Randomizing using RAND and RANDBETWEEN

• ROUND, ROUNDUP and ROUNDDOWN