JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
Advanced Excel Essential Training

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)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time *

Sponsorship

Self-Sponsored
Employer-Sponsored

No. of Participants

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

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.

Course Cancellation/Reschedule Policy

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom

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:

Excel

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.