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

Sessions 1 day
Duration 7.5 hrs
Level Intermediate
Assessment NA

Venue

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.

Download Course Brochure

Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

Advanced Excel Essential Training

Course Code: C34

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.

No funding is available for this course.

Course Fee

$350.00 (GST-exclusive)

$381.50 (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

Additional Message

* Required Fields

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

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.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
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

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

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

Dwight Nuwan Fonseka

Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.