...
Contact us

Microsoft Excel Training in Malaysia (HRDF Claimable)

1-2 days ( customisable)

Training Overview

The Microsoft Excel Training – One Day Program is an HRDF claimable corporate training in Malaysia designed to build on your existing Excel knowledge and take your skills to the next level.

Participants will gain proficiency in intermediate and advanced Excel techniques, including data manipulation, formulas and functions, advanced formatting, PivotTables, charts, and analysis tools. This practical, hands-on training equips professionals to analyze, present, and manage data efficiently, enhancing productivity and decision-making.

Through interactive exercises, live demonstrations, and group discussions, participants will be able to apply learned skills immediately in their workplace. This training is suitable for business professionals, analysts, finance and operations staff, and anyone working with data who wants to improve their Excel competency.

✔ HRD Corp / HRDF claimable
✔ Hands-on, practical exercises
✔ Beginner-to-advanced Excel skills covered

Training Objectives

At the end of this corporate training program, participants will be able to:

  1. Apply data manipulation techniques efficiently (sorting, filtering, conditional formatting)
  2. Demonstrate proficiency in using intermediate and advanced formulas and functions (SUMIF, IF, VLOOKUP, XLOOKUP, logical functions)
  3. Create professional reports, dashboards, and charts
  4. Use PivotTables, PivotCharts, slicers, and timelines for data analysis
  5. Perform scenario-based What-If Analysis (Goal Seek, Scenario Manager)
  6. Automate repetitive tasks using templates, macros, and workbook features

HRDF Claimable Training

This program is HRD Corp (HRDF) claimable, subject to HRD Corp’s terms and approval. Upscale Sdn Bhd is a registered HRDF training provider in Malaysia and supports clients throughout the HRDF claim submission process.

Why Attend This Corporate Training Program

By attending this HRDF claimable Excel training, participants will be able to:

  • Efficiently manipulate and analyze data
  • Apply formulas, functions, and advanced Excel tools for decision-making
  • Create professional, visually appealing reports and dashboards
  • Use PivotTables, charts, and What-If Analysis to explore and present insights
  • Automate repetitive tasks using templates and Macros

This program is ideal for organizations seeking practical, results-driven Excel skills training in Malaysia.

Target Audience

This Microsoft Excel Training program is suitable for:

  • Professionals responsible for creating, analyzing, and reporting data
  • Business analysts, finance staff, and operations personnel
  • Managers and team leaders seeking to improve Excel productivity
  • Students or individuals wanting to expand Excel proficiency

Prerequisites: Basic understanding of Windows and proficiency with keyboard/mouse usage.

Course Outline

Session 1: Introduction to Excel
  • Excel interface overview, Ribbon, tabs, menus
  • Launching Excel, opening workbooks, creating new workbooks
  • Understanding workbook, worksheet, cell, rows, columns
  • Quick Access Toolbar, Status Bar, and Excel Help
  • Entering text, numbers, dates, and constants
  • Formatting cells (font, alignment, borders, fill color)
  • Using styles, themes, Auto Fill, Undo/Redo
  • Managing worksheets: Insert, Rename, Delete
  • Saving, closing, and accessing workbooks
  • Arithmetic operations (+, -, *, /)
  • Functions: SUM, AVERAGE, COUNT, AutoSum
  • Copying and auto-filling formulas
  • Statistical functions and error checking
  • Sorting and filtering data, AutoFilter and advanced filter
  • Find and Replace
  • Conditional formatting based on cell values
  • Creating bar, line, and pie charts
  • Formatting charts (titles, labels, legends, templates)
  • Adding data labels and annotations
  • Data Tables for What-If Analysis
  • PivotTables and PivotCharts
  • Slicers for interactive filtering
  • Excel’s built-in analysis tools: Goal Seek, Solver
  • Using and creating templates
  • Paste Special operations: add, subtract, multiply, divide, values, transpose
  • Creating, filtering, sorting, grouping, renaming data
  • One- and two-input data tables
  • COUNT, COUNTA, COUNTIF, COUNTBLANK
  • FV, PV, NPV, RATE, PMT
  • VLOOKUP, HLOOKUP, XLOOKUP
  • DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
  • Scenario Manager, Scenario summary reports
  • Recording and assigning Macros to buttons
  • Managing and deleting Macros
  • Enabling/disabling track changes
  • Sharing, comparing, and merging worksheets

Training Duration & Delivery Mode

  • Duration: 1 Day (9:00 am – 5:00 pm)

Why Choose Upscale Sdn Bhd

  • HRDF registered training provider
  • Experienced Excel and corporate trainers
  • Practical, hands-on learning approach
  • Customised in-house training solutions
  • Trusted by organisations across Malaysia

Other Security-Related Training Programs

Upscale Sdn Bhd also provides advanced and specialised security training, including:
  • Industrial Cybersecurity Awareness for Managers
  • Hacking & Security Vulnerability Management
  • Network Security & Penetration Testing
  • Advanced Web Hacking & Defences
  • Mobile Hacking and Security
  • Secure Coding
  • MySQL & Apache Tomcat Hardening
  • Hack-away Workshops
  • Advanced Persistent Threats (APT)

Enquiry & Customisation

For customised Excel training, in-house sessions, or HRDF claimable programs, please contact Upscale Sdn Bhd.
Get in Touch
Contact us

Connect with us

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.