Home
5 Days Excel Specialization

Sessions 5 days
Duration 37.5 hrs
Level Beginner
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.

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.

5 Days Excel Specialization

Course Code: C1288

14 Review(s) | Add Your Review

Embark on a transformative journey with our 5 Days Excel Specialization course, meticulously designed for individuals aiming to elevate their data management and analysis skills. This intensive course offers a comprehensive curriculum, covering advanced Excel functionalities vital for today's fast-paced business environment. Participants will gain proficiency in complex data analysis, visualization techniques, and automation processes, enabling them to manipulate large datasets efficiently and effectively.

Dive deep into the realms of Excel with a focus on practical, real-world applications. Learn to leverage pivot tables for insightful data summaries, utilize advanced functions for intricate data manipulation, and explore macro programming for task automation. Our expert instructors, equipped with industry-relevant knowledge, guide you through interactive sessions and hands-on projects. This course is a stepping stone for professionals aspiring to become adept at using Excel as a powerful tool for decision-making and productivity enhancement. Join us and transform your data skills in just five days.

No funding is available for this course

Course Fee

$1,500.00 (GST-exclusive)

$1,635.00 (GST-inclusive)

Training Mode *

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

Course Date * Course Date

Course Time * Course Time

9:30am - 5:30pm

No. of Participants

Sponsorship

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate *

Additional Emails for Notification

* 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

Day 1

Topic 1: Basic Excel Training

Topic 1.1 Getting Started with Excel

Explore Excel user interface
Manage Worksheets
Manage Rows and Columns
Manage Data

Topic 1,2 Basic Data Analysis using Excel

Overview of Formulas and Functions
Use IF functions to analyse data
Use Lookup and Reference functions to extract data
Aggregate functions - COUNTIF, AVERAGEIF, SUMIF

Topic 1.3 Basic Data Visualisation using Excel

Create chart
Basic chart types
Format chart elements
Other chart types - Treemap, Sunburst, Histogram, Pareto, Box plot, and Waterfall charts

Day 2

Topic 2: Advanced Excel Essential Training

Topic 2.1 PivotTable and PivotChart

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

Topic 2.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 2,3 Introduction to Excel Power Query

What is Power Query
Import Data
Clean Data
Transform Data

Day 3

Topic 3: Statistical Data Analysis Training with Excel

Topic 3.1 Basic Statistics

Why Statistics Matter
Types of Data
Descriptive Statistics
Probability and Conditional Probability
Probability Distributions
Install Excel Data Analysis ToolPak

Topic 3.2 Sampling and Hypothesis Testing

Sampling
Central Limit Theorem
Sampling Distribution and Standard Errors of Sample Mean
Confidence Interval
Z and T Statistics
Overview of Hypothesis Testing
Types of Hypothesis Testing
Type 1 and Type 2 Errors
Analysis of Variance (ANOVA)

Topic 3.3 Regression and Correlation Analysis

Regression Modeling
Residues and Mean Square Error
Covariance and Correlation Analysis

Day 4 Topic 4: Creating an Interactive Excel Dashboards for Business Analytics

Topic 4.1 Data Visualization and Display using Excel Pivot Tables and Charts

Data analysis using Excel pivot tables and charts
Organize and visualize data to show trends and correlation

Topic 4.2: Create Basic Excel Dashboard and Scorecards

Sketch your dashboard layout
Link to Excel pivot tables
Incorporate appropriate dashboard elements such as gauge chart, KPI

Topic 4.3 Create Interactive Excel Dashboard

Form control, value-based formatting and dynamic series selection
Animating changes over time
Limitations of data and Interpretation of findings

Day 5 Topic 5: Visual Basic Application (VBA) for Excel Training

Topic 5.1 Get Started on VBA

What is VBA
Access VBA from Excel
Write Your First VBA Code
Message and Input Box
Macro Record

Topic 5.2 VBA Programming

Variables and Constants
Data Types and Array
Operators
Decision
Loops

Topic 5.3 Function and Sub Procedure

Worksheet Functions
Create Charts
Sub Procedure

Topic 4.4 Managing Excel Objects

Work with Excel Objects
Error Handling
Debugging

Topic 4.5 Events and User Forms

Events
User Forms

Course Info

Prerequisite

The learner must meet the minimum requirement below :

Read, write, speak and understand English

Target Audience

NSF
Full Time Students
Data Analysts

Software Requirement

This course will use Google Colab for training. Please ensure you have a Google account.

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

Jim Gan Chiu Liang: Jim Gan Chiu Liang is a ACTA certified trainer. Jim Gan Chiu Liang obtained his Master of Technology (M.Tech Knowledge Engineering) from National University of Singapore (NUS) Institute of System Science. He is currently working as adjunct trainer at PACE (Professional Adult Continuing Education) Academy, Singapore Polytechnic. His past experience included being a chief instructor for Kumon Education.

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.