Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Advanced Google G Suite Training

G Suite is a set of intelligent apps hosted on Google Cloud. G Suite includes Sheets, Docs, Slides, Form, Gmaill, Calendar, Drive, Hangout and Meet. With G Suite, With you can collaborate with co-workers or customers no matter where you are. You can create documents, spreadsheets and presentations from anywhere. You can share them with teammates and work together on the same file, at the same time. You store all your work in one place and quickly find what you need with Google-powered search. 

This advanced G SuiteTraining followed from the G Suite Essential Training, you will learn the main features of the folloiwng G Suite apps:

  • Advanced Formulas and Functions in Google Sheets
  • Financial Functions in Google Sheets
  • Statistical Functions in Google Sheets
  • Google Sites
  • Googel Hangouts
  • G Suite Admin

After your registered for the course, you can apply SSG grants below

Click here to apply SkillsFuture Credit for Individual

Click here to apply WSG Absentee Payroll for Company
Course Code: CRS-N-0046250

Course Booking

$298.00 (GST-exclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

Module 1 Advanced Google Sheets Formula and Functions

  • Conditional Formating
  • Filter, Sort and Freeze
  • Random Numbers
  • Sum, Averages and Count
  • Conditional Sum, Average and Count
  • Absolute Referencing
  • Named Range
  • Ranking
  • Vlookup
  • Advanced Lookup Operations
  • Date and Time
  • Pivot Table
  • Creating and Configuring Charts
  • Collaborating on Google Sheets

Module 2 Analyzing Financial Data with Google Sheets

  • Loan Payment
  • Cumulative Principal and Interest
  • Net Present Value (NPV) 
  • Internal Rate of Return (IRR)

Module 3 Statistical Analysis with Google Shees

  • Permutation and Combinations
  • Basic Statistical Summary
  • Statistical Distributions
  • Correlation
  • Linear Regressoin

Module 4 Google Sites 

  • Create a Site from Templates
  • Add Form and Survey
  • Add Calendar
  • Add Phone and Video
  • Publish at Site

Module 5 Google Hangout

  • Send Message to a Group
  • Record a Video Meeting
  • Create a Group
  • Greate and Message Bots
  • Broadcast Webinar or Live Events
  • Share Presentations

Module 6 G Suite Admin

  • Admin Dashboard
  • Company
  • Apps
  • User
  • Device Management
  • Admin Roles
  • Groups
  • Domains
  • Reports
  • Security
  • Data Migration

Who Should Attend

  • Companies planning or going to migrate from Microsoft to Google Drive platform
  • Small business owners planning to use Google Apps for Work
  • Companies that want to use Google form for survey
  • People who want to learn Google Drive, Google Spreadsheets, Google Doc, and Google Presentation

Prerequisite

Prerequisite

This course is a intermediate course. Basic G Suite knowledge is assumed ;

Software Requirement

Pls sign up a Google G Suite  account on https://gsuite.google.com.sg/

Trainers

Google G Suite Trainer

Ms Eve Tan has been in 3D industry for 4 years. She is one and only Asian modulator in
Josef Prusa facebook support team. She is also nominated for Woman in 3D Printing Singapore Ambassador in promoting event and seminar to let all women stay connected.

Ms Eve is a graduate ACTA trainers in Singapore IAL institute and currently conducting 3D Printing and scanning for skill future and WDA course.. She have graduate from ACC Institute of Human Services obtain Psychology Counselling, Singapore Polytechnic in CEO, she also ongoing her part-time upgrading on Moscow Institute of Physics and Technology in Post-Graduate Programs, she is keen on learning and upgrading herself during her spare time.
She has been doing all support and teaching to all buyer which they have purchase Prusa MK2,MK2S,MK3.
She also created her own 3D Home Desk Machine which is easy to fix and user friendly and with special feature of Non Break printing module in her own 3D printer in 2014.

She is proficient in :

  • Fusion 360, 
  • Visual Coding 
  • Repetier, 
  • Mesh mixer and inksvg. 
  • simplify3D
  • Sketchup Make
  • 3D Printing Skill 
  • Google Drive & GSuit
  • & more…..

She love to conduct lesson in a fun and creative way to students, by example hydroponic planting systems, kitchen items, feasible stationery items and so on

Mailchimp TrainerNabihah is a BSc Science graduate with a penchant for learning. She has managed a student organisation and is now involved in managing the running of an adult educational learning centre. Moving away from the scientific world, she is now looking to enter the digital sphere. Her first foray into the digital marketing world is with a video production company, working on a project with MOE. She has also been involved in a UX project with an emerging photography start-up company. Nabihah is fascinated by tech and how organisations are using it to harness their technological power to their fullest potential.

Chief Trainer in Tertiary CoursesDr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 1997 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

Google Driver TrainerAs a passionate Speaker, Trainer and Facilitator, Ben has reached participants from diverse backgrounds, age groups and organizations. He has spoken, trained and mentored more than 100,000 individuals. Ben started his career in the IT field, pursued his interest in Culinary Arts, explored Sales and eventually found his calling in Training and Education. He has previously joined various training organizations such as MindChamps and worked in non-profit organizations like CARE Singapore where he focused on helping learners discover and hone their unique strengths and potential.

As an expressive and experiential trainer, Ben has the ability to bring out the camaraderie in a room who were previously strangers. Ben’s diverse background is most valuable when contextualizing lesson plans to different learner profiles. He has first hand experiences in many areas and with people from all walks of life. These real life anecdotes and stories inspire the learners on possibilities for their own lives. Ben is also well-versed in getting learners to participate in creative activities to experience the application of concepts taught in class.

Ben’s students have often described him as engaging, genuine and open. He has the gift of using storytelling to transfer key learnings to his audience as well as the ability to turn complicated knowledge to fundamental points for his learners. Driven by his passion for learning and application of life skills in his own life, Ben brings the positive energy that inspires his learners to apply strategies to better nagivate their journey of self-discovery and career exploration.

Google Apps, Google Drive TrainerMr. Tan Wee Giap has several years of software development experience in Windows and Windows Phone. He is also familiar with Google Apps and has done a far amount of Google App Script development. Having taught in a secondary school for 4 years in Computer Applications such as MS Office, Scratch, Inkscape, etc, he has acquired the pedagogy to help him deliver the lesson more effectively.

Google Drive Trainer

Mr Gerald Ong is keen on pursuing a facilitator / curriculum developer role in the Learning & Education Industry and is an MOE-Registered Instructor and a MOE-registered relief teacher. He has spent 6 years as a salesperson selling products and services to B2B and B2C customers. Through his journey as a salesperson, he learnt many technical and soft skills.

He completed his Diploma in Mechanical Engineering at Singapore Polytechnic in 2007, and graduated with Bachelor of Commerce in Marketing from Murdoch University, Australia in 2014 and has recently completed his Cert IV in Training & Education from Australia-International Institute of Workplace Training, along with his WSQ Advanced Certificate in Training & Assessment from Institute of Adult Learning, Singapore. He finished his primary and secondary education in both St Gabriel’s Primary & Secondary Schools.

Google Drive TrainerGavin is currently the Managing Partner of Disruptive Digital, a full-service digital agency based in Singapore offering creative, innovative & effective digital marketing campaigns that are driven by ROI.

He is a proven and certified digital marketing professional with over 8 years of experience in strategy consulting and/or marketing strategy across multiple industries. He has strong passion for and knowledge of technology, emerging media, and the Internet with specific interactive strategy experience.

His deep passion for entrepreneurship and online marketing had led to the inception of his first agency, Chris Cooper Group, in October 2008.

Write Your Own Review

You're reviewing: Advanced Google G Suite Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Advanced Excel Essential Training

Advanced Excel Essential Training

7 Review(s)
$228.00 (GST-exclusive)
Google G Suite Essential Training

Google G Suite Essential Training

24 Review(s)
$248.00 (GST-exclusive)
Statistical Data Analysis Training with Excel

Statistical Data Analysis Training with Excel

14 Review(s)
$298.00 (GST-exclusive)
Visual Basic Application (VBA) for Excel Training

Visual Basic Application (VBA) for Excel Training

7 Review(s)
$248.00 (GST-exclusive)