Microsoft Excel : Data Analysis & Automated Reporting

23-24 Feb, 2026, Concorde Hotel Kuala Lumpur

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Kelvin Ng
Microsoft Office 2016 Master Specialist
Microsoft Certified Trainer

Kelvin Ng Choo Kent is a highly experienced digital arts instructor and master trainer with more than 17 years of experience in the office automation consultation, graphic design, animation and print production arena. He is a graduate of Malaysian Institute of Art (MIA) And holds the distinction of being certified as Adobe Certified Expert (ACE), Microsoft Office 2016 Master Specialist MCP & MCT, Certified practitioner of Neuro-Semantics, Certified practitioner of Neuro-Linguistic programming & Certified practitioner of Hypnosis & Time-Lines.

Microsoft Certification

  • MICROSOFT CERTIFIED TRAINER (MCT) SINCE 2012
  • MICROSOFT OFFICE 2016 MASTER SPECIALIST (MOS)
  • MICROSOFT OFFICE EXCEL 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE WORD 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE POWERPOINT 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE ACCESS 2016 SPECIALIST (MOS)

Professional Qualifications

  • PSMB APPROVED TRAINER
  • CERTIFIED ETHICAL HACKER (CEH)
  • ADOBE CERTIFIED EXPERT (ACE)
  • CERTIFIED PRACTITIONER OF NEURO-SEMANTICS
  • CERTIFIED PRACTITIONER OF NEURO-LINGUISTIC PROGRAMMING
  • CERTIFIED PRACTITIONER OF HYPNOSIS & TIME- LINES


AREA OF EXPERTISE
Office Tools
Microsoft Office Suite (2003, 2007, 2010, 2013, 2016), Adobe Acrobat, Microsoft Visio


Soft Skill
Effective Presentation, Train The Trainer, Microsoft Office Business Application Coaching, Effective Communication


Graphic Design
Adobe Photoshop, Adobe Illustrator, Adobe Indesign, Quarkxpress, Adobe Pagemaker, Corel Draw, Corel Photo Paint

His Clientele


Venue Details

Concorde Hotel Kuala Lumpur
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,
Phone : 03 2144 2200

https://kualalumpur.concorde hotelsresorts.com/

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

Day 1: Automating HR Data Analysis & Reporting
Session 1: Excel Essentials for HR
Session 2: Automating HR Reports with Power Query
Session 3: PivotTables for HR Reports
Session 4: HR Dashboards

Day 2: Practical Excel Features, HR Functions & Automation
Session 5: Practical Excel Features for HR
Session 6: HR Formulas & Functions
Session 7: HR Mail Merge for Employee Letters & Notices
Session 8: Final Assignment – Design an HR Report

COURSE OVERVIEW
This course is designed to enhance the efficiency of HR professionals in handling HR data, automating reporting processes, and improving decision-making using Microsoft Excel. By the end of the course, participants will gain hands-on experience in data analysis, Power Query, PivotTables, and Mail Merge to automation techniques and optimize HR reporting workflows.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Structuring and cleaning HR data for analysis and reporting.
  2. Utilizing Power Query to automate HR data processing and report generation.
  3. Building PivotTables to analyze employee data, attrition, salary trends, and HR metrics.
  4. Designing interactive HR dashboards for quick decision-making.
  5. Using essential Excel formulas for HR calculations, lookups, and text management.
  6. Implementing Mail Merge to automate HR communication (letters, salary slips, notices).
  7. Applying best practices to create automated HR reports, saving time and effort.
WHO SHOULD ATTEND
  • HR Professionals who work with employee data and reporting
  • Managers, Executives, and Administrators who need data-driven insights for decision-making
  • Professionals handling Payroll, Attendance, Recruitment, and Workforce Planning
  • Anyone who wants to improve Excel skills for data analysis and automation in HR and Business
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 such as HR, Admin, Production, Sales etc.
DAY 1
 

Day 1: Automating HR Data Analysis & Reporting

9:00

Session 1: Excel Essentials for HR

  • Structuring Data Type (Text, Number, Date and Format)
  • Data Cleaning & Preparation Techniques (Remove Duplicates, Text to Columns)
  • Formatting HR Reports (Conditional Formatting, Custom Number Formats)
10.30

Session 2: Automating HR Reports with Power Query

  • Introduction to Power Query for Data Transformation
  • Cleaning & Consolidating Multiple HR Data Sources
  • Automating Monthly HR Reports
1:00 Lunch
2:00

Session 3: PivotTables for HR Reports

  • Creating PivotTables from HR Data
  • Summarizing Employee Data (Headcount, Attrition, Salary Reports)
  • Grouping & Filtering (Department, Age Group, Years of Service)
  • PivotTable Formula: Calculated Fields
  • Pivot Charts for Dynamic Visualization
3:45

Session 4: HR Dashboards

  • Designing an Interactive HR Dashboard
  • Slicers & Timelines for Quick Analysis
  • Creating Dynamic HR Reports with Charts
5:00 End of Day 1
DAY 2
 

Day 2: Practical Excel Features, HR Functions & Automation

9:00

Session 5: Practical Excel Features for HR

  • Copy-Paste Special (Operations, Values, Formats, Transpose)
  • Go-To Special (Select Blanks, Constants, visible Cells only)
  • Worksheet Navigation & Shortcuts (Quick Selection, Sheet Management)
10.30

Session 6: HR Formulas & Functions

  • IF, COUNTIF, SUMIF, AVERAGEIF for HR Metrics
  • VLOOKUP, XLOOKUP, INDEX-MATCH for Employee Database Lookups
  • TEXT Functions (LEFT, MID, RIGHT, CONCATENATE) for Handling Names & IDs
1:00 Lunch
2:00

Session 7: HR Mail Merge for Employee Letters & Notices

  • Creating a HR Employee Database in Excel
  • Using Word Mail Merge to Generate Offer Letters, Salary Slips, & Appraisals
  • Automating Bulk Emailing with Mail Merge
3:30

Session 8: Final Assignment – Design an HR Report

  • Participants will apply what they’ve
    learned to create:
    o A simplified HR dashboard
    o An automated PivotTable report
    o A basic Mail Merge letter
  • Review, feedback & best practices discussion
5:00 End of Course