• Home
  • 5 Days Excel Specialization

5 Days Excel Specialization

Course Information

  • Sessions 5 days
  • Duration 37.5 hrs
  • Level Beginner
  • Assessment NA

Venue

Kuala Lumpur: G-3A-02, Suite Pejabat Korporat, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200 Kuala Lumpur, Malaysia
Penang: Jalan Sungai Dua, 11700 Penang, Malaysia.

Download Course Brochure

Certification

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

5 Days Excel Specialization

Course Code: C1288
  • HRDF

10 Review(s) | Add Your Review

What's This Course About

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.

WSQ Funding

Full Fee 5,500.00 Before GST
GST 495.00 9% of fee
Baseline Nett 3,245.00 SG/PR age 21+ · 50% funded
MCES / SME Nett 2,145.00 SG age 40+ · 70% funded

Course Fee

MYR5,500.00

Course Date

Course Time

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.

Disclaimer: The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

  • We may provide consultation related to the subject matter after the course.
  • Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you as soon as possible.

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. The minimum class size to start a class is 3 Pax.

Course Details

Course Details

What You'll Learn

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

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

Trainers

Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.

Review

Customer Reviews (10)

Exceeded my expectations 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
Excellent delivery and good balance between theory and practice. Learned a lot in a short time. (Posted on 13/02/2025)
Very useful course 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
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 26/12/2024)
Great learning experience 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 training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 10/10/2024)
Great practical training 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 an expert in the subject and shared many practical insights from real projects. (Posted on 22/06/2024)
Fantastic experience 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 course materials were detailed and easy to reference afterwards. Great value for money. (Posted on 24/03/2024)

Items 6 to 10 of 10 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: 5 Days Excel Specialization

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