Excel for Administrative Professionals: Digital Productivity Tools

18-19 May, 2026, Concorde Hotel Kuala Lumpur

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 24 years working experience as a trainer in the field of Information Technology. He is a Microsoft Certified Power Bl Data Analyst & Microsoft Certified  Office 365 Specialist & also obtained ITIL Certification. He is PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

 

  1. Conducting trainings in Power Query, Power Pivot, Power Bl, Microsoft Excel, Word & Power Point all from Beginner to Expert level
  2. He also does consultancy & project solutions in Data Management & complex reports by using the Power products from Microsoft
  3. He also conducted training in other Bl platform: Crystal Report

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia.
As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.

 

He has trained in Provater Sectors, Insurance led companies, MNCs, Government Ministries & Government agencies, among them are :

 

  • Thermos (M) Sdn Bhd
  • Prime Minister Office (PMO)
  • IKBN
  • JKR
  • PNS
  • Bank Negara Malaysia
  • Tenaga Nasional Bhd
  • MAHSA University
  • Ranhill
  • Alam Flora
  • REAL Education
  • Sime Tyres
  • Tawau Polytechnic
  • Dasmesh International School

Venue Details

Concorde Hotel Kuala Lumpur
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,

https://kualalumpur.concorde hotelsresorts.com/



Phone : 03 2144 2200

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Getting Started with Excel
  • Module 2: Structuring Data
  • Module 3: Sorting & Filtering
  • Module 4: Essential Formulas
  • Module 5: Data Cleaning
  • Module 6: Conditional Formatting
  • Module 7: PivotTables
  • Module 8: Charts
  • Module 9: Protection
OBJECTIVES
This course equips Administrative Professionals with Practical Microsoft Excel skills to manage data efficiently, automate routine tasks, and improve productivity.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Organizing and Cleaning Data Efficiently.
  2. Using Essential Excel Formulas.
  3. Applying Sorting, Filtering, and Validation.
  4. Creating Reports Using Tables and Charts.
  5. Automating Repetitive Tasks.
WHO SHOULD ATTEND
  • Administrative Staff
  • Personal Assistants
  • Clerical Officers
  • HR
  • Finance
  • Office Executives
METHODOLOGY
  • Guided Learning, Group-Paced, Hands-On Classroom Training with Real Life Examples for
    Business Applications.
  • Challenging Exercises are Set Based on Practical Applications for Typical
    Organizational Functions

DAY 1
9:00

MODULE 1: GETTING STARTED WITH EXCEL

  • Interface Overview
  • Shortcuts
  • Formatting Basics

10.45

MODULE 2: STRUCTURING DATA

  • Tables
  • Naming
  • Remove Duplicates
12.00

MODULE 3: SORTING & FILTERING

  • Advanced Sort and Filter
  • Data Validation
1:00 Lunch
2:00

MODULE 4: ESSENTIAL FORMULAS

  • COUNTIF / SUMIF
  • TEXT Functions
  • VLOOKUP
  • Date Functions
    - WORKDAYS
    - NETWORDAYS
    - EOMONTH
    - EDATE
    - DATEDIF
3:45

MODULE 5: DATA CLEANING

  • TRIM
  • Flash Fill
5:00 End of Day 1
DAY 2
9:00

MODULE 6: CONDITIONAL FORMATTING

  • Highlight Data
  • Using Conditional Formatting in Reports

10.45

MODULE 7: PIVOTTABLES

  • Create Reports
  • Slicers
  • Dynamic Pivot Table
  • Inserting Formulas
  • Creating Dashboard
12.00

MODULE 8: CHARTS

  • Line
  • Pie
  • Combo Chart
  • Bar Chart
  • Area Chat
  • Budget vs Actual Comparison
1:00 Lunch
2:00

MODULE 9: PROTECTION

  • Protect Sheet
  • Protect Workbook
  • Applying Password for File
  • Protecting Formulas
  • Hiding Formulas
5:00 End of Course