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
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.
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 of completion
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.
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)
Students are required to bring their personal laptop and a refillable water bottle.
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.