In-house: | Face to Face:

Microsoft Excel Advanced

27 Jan, 2027, Concorde Hotel Kuala Lumpur

IPA Training is Registered with

Learn from the Best

Kelvin Ng

25 years teaching experience

 

Kelvin Ng is a dynamic, fun-loving corporate trainer who brings a touch of magic to every session. With over 25 years of experience, his training is nothing short of a WOW experience. Kelvin is passionate about helping people unlock the full potential of Microsoft Office applications, teaching them the right techniques to boost workplace productivity and efficiency.

 

As a Microsoft Office Automation Consultant, Kelvin specializes in creating customized Office Templates that streamline workflows and optimize business processes. His extensive expertise spans across classroom training, virtual learning, office automation, and graphic design, making him the go-to expert for anyone looking to elevate their skills.

 

Certified as a Microsoft Office 2019/O365 Expert & Associate, Microsoft Office 2016 Master Specialist, and Microsoft Certified Trainer, Kelvin also holds Adobe Certified Expert (ACE), Certified Virtual LearnCaster Facilitator, GTF Certified Online Trainer, and eSpeaker Certified Virtual Presenter distinctions. He’s worked with top companies around the globe, including INTEL Penang, Jabil, Baiduri Bank Brunei, Maybank, Petronas, Huawei, Standard Chartered, and many more across Malaysia, Brunei, Singapore, New Zealand, Papua New Guinea, India, and the USA.

 

Kelvin’s fun, engaging, and easy-to-learn modules have helped clients boost their productivity by at least 35%. Whether it’s creating clearer reports, communicating complex data for critical decision-making, or designing impactful presentations, Kelvin’s approach makes mastering Microsoft Office feel like a breeze. With the right support and a little practice, you’ll soon be the Microsoft Office Hero in your workplace!

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

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • Sorting and Filtering Data | Reporting with PivotTable
  • Linking data | Report Checking Features
  • Advance Charting | What-If-Analysis
  • Macro Recording| Security Settings
COURSE OVERVIEW

Microsoft Excel is a software for storing numerical data and analyzing them. It is one of the most flexible and commonly used applications in Office. Whatever career path you choose, you will probably have to use Excel to achieve your professional goals, some of which may happen every day. For one way or the other, we all work with numbers. When we want to record, analysis and save such numeric data, Microsoft Excel comes in handy. At this Advanced level, it provides an overview of the Excel database management and basic analysis features used for preparing reports and analytics for our managers.

COURSE LEARNING OUTCOMES (CLO)
  1. Comprehend Excel Data thoroughly and Preventing common mistake in Excel Reports.
  2. Reproduce,Managing and Analyzing Database or Excel List effectively.
  3. Being able to connect data from another source/ file.
  4. Perform Macro Recording to automate repetitive task.
  5. Managing worksheet & file Protection.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom 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.
COURSE OUTLINE
9:00

Sorting and Filtering Data

  • Sorting Data by Multiple Columns at the Same Time
  • Using AutoFilter
  • Sub-Totalling
  • Removing Subtotals
 

Pivot Tables

  • Creating and Using a Pivot Table
  • Filtering and Sorting Data within a Pivot Table
  • Automatically Grouping Data in a Pivot Table and Renaming Groups
  • Manually Grouping Data in a Pivot Table and Renaming Groups
10.45

Linking & Embedding

  • What Is Embedding and Linking?
  • Linking Data within a Worksheet
  • Linking Cells between Worksheets within a Workbook
  • Linking Data between Workbooks
  • Linking Data from Excel to a Word Document
  • Linking an Excel Chart to a Word Document
  • Updating, Locking and Breaking Links
 

Validating

  • Data Validation - Whole Number
  • Data Validation - Decimal Number
  • Data Validation – List
  • Removing Data Validation
 

Auditing

  • Tracing Precedent Cells
  • Tracing Dependent Cells
1.00 Lunch
2:00

Charts

  • Creating a Combined Line and Column Chart
  • Adding a Secondary Axis to a Chart
  • Changing the Chart Type for a Particular Data Series
  • Re-Positioning Chart Title and Legend
  • Modifying Chart Axis Scales
  • Formatting an Axis to Display Using Commas
 

Input Tables

  • One-Input Data Tables
  • Two-Input Data Tables
 

Scenario

  • Scenario Manager
3.45

Macros

  • Record macro
  • Assigning a Macro to a Button
  • Deleting Macros
 

Passwords & Security Issues

  • Adding ‘Open’ Password Protection to a Workbook
  • Adding ‘Modify’ Password Protection to a Workbook
  • Password Protecting Cells and Worksheets
5.00 End of Course