You have no items in your shopping cart.
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.
Customer Reviews (14)
- will recommend Review by Course Participant/Trainee
-
. (Posted on 4/15/2024)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - might recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - might recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - might recommend Review by Course Participant/Trainee
-
. (Posted on 2/21/2024)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 - Trainer is friendly and helpful! Review by Course Participant/Trainee
-
Trainer is friendly and helpful! (Posted on 2/21/2024)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 - might recommend Review by Course Participant/Trainee
-
All is good. (Posted on 2/21/2024)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 - might recommend Review by Course Participant/Trainee
-
Course material should send before the course. Issuing of laptop due to restriction on my work laptop (Posted on 2/21/2024)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 - will recommend Review by Course Participant/Trainee
-
Fun learning with sporting teacher. (Posted on 1/12/2024)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 - All Good Review by Course Participant/Trainee
-
Provide excess card for building from training center (Posted on 1/12/2024)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 10/31/2023)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
Write Your Own Review
You May Be Interested In These Courses
WSQ - Statistical Data Analysis with Excel for Beginners
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
WSQ – Software Automation with Excel VBA Programming
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
