Rambot

Google Sheets Formula & Functions - Basics to Advanced

Khor Siew Fei

This training will take your Google Sheets skills to the next level. You will learn how to customise sheet layouts, use advanced formulas and functions, and create pivot tables to analyse data. You'll also discover how to automate tasks with macros and use add-ons to extend the functionality of Goog...

+ show more

Price
RM560.00
HRDC Claimable, corporates only

Workshop
Full-Time
Classroom
1 day of class: 10am - 6pm
Upcoming Courses
Start Date
21 Mar 2024
Buy now
Start Date
23 Apr 2024
Buy now
Start Date
28 May 2024
Buy now
Who Should Attend This Course

This course is best for individuals who want to enhance their skills and knowledge in using Google Sheets formulas and functions. It is ideal for beginners who want to learn the basics and progress to advanced techniques. Additionally, professionals, analysts, data scientists, and anyone who regularly works with data in Google Sheets can benefit from this course.

Prerequisites

English Language Proficiency

Google Sheets Features and Data Type - You will be able to set up configuring time zone, locale, and collaboration in Google Sheets, utilising version control, applying formatting options, understanding rows, columns, and cell referencing, reformatting data types, their differences, limits, and formatting for specific needs.

Basics Formula & Commonly Used Formula - You will be able to utilise basic formulas in Google Sheets.

Advanced Formula - You will familiarise and practice navigating through VLOOKUP, XLOOKUP, INDEX MATCH, IMPORTRANGE, and UNIQUE -- employing conditional formatting, creating dynamic drop-down lists with data validation, as well as performing data cleaning tasks using the Remove Duplicates function.

Pivot Table and Macros in Google Sheets - You will be able to create pivot tables for various scenarios, automate tasks with Macro, and utilise ChatGPT to generate app scripts for automating tasks in Google Sheets.

Certificate

Certificate of completion

  1. What payment methods do you accept?

    We currently accept both debit cards and credit cards. We're also happy to announce that we now have interest-free* instalment plans!

    *Interest-Free Instalment plans are currently available for ILT courses only, and applies to Maybank and Public Bank credit card holders, with a minimum purchase of RM500 and above.

  2. To whom can I refer to gain more insight into the courses?

    You may drop us a WhatsApp message at 010-5008787. Kindly take note that our working hours are 9 am - 6 pm from Monday to Friday and our friendly team will reply to you as soon as we can. However, do expect a slight delay in replying to enquiries over the weekend. Or you can follow our social media accounts @airasiaacademy (Facebook, Instagram, Linkedin)

  3. What do you need to bring during the class?

    Students are required to bring their personal laptop and a refillable water bottle.

Meet your instructor
Khor Siew Fei

Siew Fei is the Google Workspace (formerly known as GSuite) trainer with Redbeat Academy. With 10 years of experience in Airasia with ICT background as well as Google Project Manager, he has transformed Airasia's office productivity environment into the Google environment.

His expertise lies in change management, focused around operations and training for the Airasia Group's digital transformation. Today, he is the Microsoft and Google productivity tool expert and he is always ready to share his knowledge through his hands-on sessions.

Price
RM560.00
HRDC Claimable, corporates only

Workshop
Full-Time
Classroom
1 day of class: 10am - 6pm