Google Sheets Formula & Functions - Basics to Advanced
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
RM560.00
HRDC Claimable
Workshop
Full-Time
Offline
1 day of class: 10am - 6pm
Upcoming Courses
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
What payment methods do you accept?
We currently accept debit card and credit card. 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.
Who can I refer to get more insight of 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 reply in enquiries over the weekend. Or you can follow our social media accounts @airasiaacademy (Facebook, Instagram, Linkedin)
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
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.
RM560.00
HRDC ClaimableWorkshopFull-TimeOffline1 day of class: 10am - 6pmCourses You May Like
Instructor-Led Courses
Dashboarding with Looker Studio - Basic to AdvancedKhor Siew Fei • English • Workshop •
CertificationRM560.00Offline
Google Slides - Basic to AdvancedKhor Siew Fei • English • Workshop •
CertificationRM280.00Offline
Google Docs - Basic to AdvancedKhor Siew Fei • English • Workshop •
CertificationRM280.00Offline
Google Forms - Basic to AdvancedKhor Siew Fei • English • Workshop •
CertificationRM560.00Offline