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

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

Currency: SGD  
Menu
  • Home
  • Advanced Excel Essential Training

Advanced Excel Training in Singapore

Advanced Excel Essential Training

136 Review(s) | Add Your Review

Dive deep into the advanced functionalities of Excel with our Advanced Excel Essential Training. This course covers pivotal tools such as PowerPivot and PowerChart, enabling participants to harness the full potential of Excel for superior data management and analysis.

Grasp the intricacies of What-If Analysis and Power Query, pivotal for dynamic forecasting and streamlined data extraction. With hands-on learning and expert guidance, you'll be poised to transform raw data into meaningful insights, ensuring you stand out in any data-driven environment.

Certificate

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

Funding and Grant Applications

Click the links below to apply. Note that you need to register the course first.

SkillsFuture Credit

For individuals, please submit your SkillsFuture Credit

SSG TG and AP Application

For companies, please fill in the required details for grant application. SSG Training Grant Application Form

UTAP

Eligible NTUC members can apply for 50% cash rebate of the unfunded fee from UTAP, capped at $250 per year. Click here to submit UTAP

Please do not pay up front. We will advise you on the eligibility and nett fee after registration

For WSQ funding, please checkout the details at WSQ - Data Analytics with Excel

Course Code: TGS-2019500284

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$228.00 (GST-exclusive)
$248.52 (GST-inclusive)

Course Date

* Required Fields

Course Information

  • Session (days): 1
  • Duration (hrs): 7.5
  • Level: Intermediate
  • Additional Note: Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.
  • Venue:

    All courses except hydroponics courses:

    12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

    The venue is disabled-friendly.


    Hydroponics courses:

    Toh Orchid Farm, 84 Sungei Tengah Singapore 698986

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts and get back to you asap.

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.


Related Courses

Check items to add to the cart or select all

Course Details

Topic 1 PivotTable and PivotChart

  • Get Started with PivotTable
  • Data Management with PivotTable
  • Format PivotTable
  • Create PivotChart

Topic 2 What-If Analysis and Optimization

  • Activate What-If Analysis and Solver
  • Scenario Analysis
  • One Variable and Two Variable Data Table
  • Goal Seek
  • Optimization Using Solver

Topic 3 Introduction to Excel Power Query

  • What is Power Query
  • Import Data
  • Clean Data
  • Transform Data

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 21-65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Hardware: Windows and Mac Laptops

SSG Training Grant

SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.

Steps to Apply Skills Future Claim

  • The staff will send you an invoice with the fee breakdown.
  • Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
  • Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
  • Upload your invoice and click ‘Submit’

Note

  • SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
  • All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
  • An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Operations Manager
  • Marketing Analyst
  • HR Metrics Specialist
  • Sales Operations Specialist
  • Report Developer
  • Project Manager
  • Management Accountant
  • Product Manager
  • Supply Chain Analyst
  • Performance Metrics Specialist
  • Market Researcher
  • Business Intelligence Coordinator

Trainers

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Liew Sing Loon: Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.

In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a ACLP certified trainer. He have a degree in Biotechnology from NUS, Advanced diploma in Pharmaceutical management from MDIS and Masters in Education from NTU. He have 8 years experience of teaching biology at O and A levels/ IB level in international schools in Singapore and overseas.

Customer Reviews (136)

might recommend Review by Course Participant/Trainee
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
Can cover more data stuff (Posted on 12/12/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 12/12/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 11/14/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 8/16/2022)
might recommend Review by Course Participant/Trainee
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
. (Posted on 8/16/2022)
The trainer is really nice and explained really well Review by Course Participant/Trainee
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
The trainer is really nice and explained really well (Posted on 8/15/2022)
Overall good Review by Course Participant/Trainee
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
Do more hands on (Posted on 8/15/2022)
might recommend Review by Course Participant/Trainee
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
Make it more interactive.Explain it more.detail about the function of each components that have introduced
Need to improve in the terms of content delivery (Posted on 8/15/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 8/15/2022)
might recommend Review by Course Participant/Trainee
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
. (Posted on 8/15/2022)
will recommend Review by Course Participant/Trainee
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
More data to try and analyse. (Posted on 6/20/2022)
will recommend Review by Course Participant/Trainee
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
Experienced some software problem when using laptop issued by the school. Laptops loan to students to be updated and more readily to be used during lessons. (Posted on 5/10/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 4/18/2022)
will recommend Review by Course Participant/Trainee
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
Giving note step by step (Posted on 4/18/2022)
everything good Review by Course Participant/Trainee
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
no comment. everything good (Posted on 2/14/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 2/14/2022)
will recommend Review by Course Participant/Trainee
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
. (Posted on 2/14/2022)
will recommend Review by Course Participant/Trainee
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
, (Posted on 2/12/2022)
We learn a lot of things that are useful to our work. Review by Course Participant/Trainee
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
We learn a lot of things that are useful to our work. (Posted on 12/13/2021)
will recommend Review by Course Participant/Trainee
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
Too many to cover in 1 day (Posted on 12/13/2021)

Items 41 to 60 of 136 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. ...
  7. 7

Write Your Own Review

You're reviewing: Advanced Excel Essential 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
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ – Data Visualisation with Tableau

WSQ – Data Visualisation with Tableau

218 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

62 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI

WSQ - Data Analytics and Visualization with Power BI

166 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
WSQ - Data Storytelling with Tableau

WSQ - Data Storytelling with Tableau

31 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ – Software Automation with Excel VBA Programming

WSQ – Software Automation with Excel VBA Programming

54 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

50 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
About Us

Tertiary Courses, founded in 2014, specializes in providing modular, skill-based courses tailored to Industry 4.0. We are WSQ Approved Training Organization (ATO), and IBF Approved ATO.. We are also Authorized Microsoft Learning Partner, Autodesk Authorized Training Center (ATC), Pearson Vue Authorized Test Center and Kryterion Authorized Testing Center. We offer a comprehensive range of training, certification prep and certification exam services. Additionally, we are a registered supplier with Singapore GeBiz, further solidifying our position as a trusted educational institution in the region.

Training Grants and Subsidies

We have various grants and subsidies for different courses. Please check the respective funding available on individual course page.

WSQ: Company and Singaporeans/PR can apply WSQ 70-90% funding depending on eligibility
SkillsFuture Enterprise Credit (SFEC) - Eligible Singapore-registered companies can tap on $10000 SFEC to cover up to 90% of out-of-pocket expense
SkillsFuture Credit: 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.
IBF-STS Companies and Singaporeans/PR can apply IBF-STS 70-90% funding depending on eligibility
UTAP: NTUC members enjoy 50% subsidy for unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP
SGTech STAR Fund: SGTECH members enjoy $500 grant per pax for SGTech STAR courses

Authorised Training Partners
1

Microsoft Learning Partner

Microsoft Learning Partner with Tertiary Infotech
2

CompTIA Authorised Delivery Partner

CompTIA Authorised Delivery Partner with Tertiary Infotech
3

AWS APN Training Partner

AWS APN Traning Partner with Tertiary Infotech
4

Autodesk Authorised Training Center

Autodesk Authorised Training Center with Tertiary Infotech
Authorized Testing Centers
1

Pearson VUE Authorised Test Center

Pearson VUE Authorised Test Center
2

Kryterion Authorized Testing Center

Kryterion Authorized Testing Center with Tertiary Courses Singapore
Approved Training Organizations
1

WSQ Approved Training Organization

WSQ Approved Training Organization for WSQ Courses
2

Institute of Banking & Finance (IBF) Approved Training Provider

Institute of Banking & Finance (IBF) Approved Training Provider
3

Singapore Chartered Accountant (SAC) Accredited Training Organisation

Singapore Chartered Accountant Accredited Training Organisation
Regional Training Centers
1

Singapore (Headquarter)

2

Malaysia Kuala Lumpur and Penang

3

Bhutan

4

Vietnam

5

Ghana Accra

6

Nigeria Lagos

Contact Us Information

Tel: +65 6100 0613

whatsapp

Whatsapp: https://wa.me/6561000613

Tertiary Courses SG GPT

Tertiary Courses SG GPT

Email: enquiry@tertiaryinfotech.com

Training Centers venue :
12 Woodlands Square, #07-85/86/87, Woods Square Tower 1, Singapore 737715 (Disabled-Friendly) .

Mailing address:
45, #06-13, Choa Chu Kang Loop, The Warren, Singapore 689679

Approved Suppliers
7

GeBiz Registered Supplier

Singapore GeBiz Registered Supplier
Information
Enquires
Training Grant and Subsidy
Our Websites
Certified Trainers

Copyright © 2023. Tertiary Infotech Pte Ltd. ROC/GST #: 201200696W. All Rights Reserved.

PayPal Master Card Visa Card PayNow