Microsoft Excel Advanced Microsoft Office Mastery Series

25-26 Sep, 2023, Melia 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

Melia Kuala Lumpur
16 Jalan Imbi,
Phone : 0 3 2785 2828

https://www.melia.com/en /hotels/malaysia/kuala-lumpur /melia-kuala-lumpur

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
  • Sorting, Subtotal & Filtering
  • Explore Reporting using PivotTable and PivotChart
  • Working with External Data
  • Linking Data for Worksheet, Workbook & Application
  • Report Checking Features
  • Presenting Data using Chart
  • Work with What-If-Analysis
  • Protecting and Securing your Worksheet & Workbook
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.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Describing Excel Data thoroughly to prevent common mistake in Excel Reports.
  2. Managing & Analyzing Database/Excel List effectively.
  3. Being able to connect data from another source/file.
  4. Knowing the introduction to Macro Recording in order 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 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
9:00

Sorting and Filtering Data

  • Sorting Data by Multiple Columns at the Same Time
  • Applying a Pre-Installed Custom Sort
  • Creating a Customized List and Performing a Custom Sort
  • Sub-Totalling
  • Removing Subtotals
  • Using AutoFilter
  • Using AutoFilter to Perform Multiple Queries
  • Removing All AutoFilters from a Worksheet
  • Advanced Filter Criteria
10.45

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
 

Importing Text Files

  • What Is a Delimited Text File?
  • Importing a Delimited Text File
1:00 Lunch
2:00

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
3:45

Hyperlinks

  • Inserting a Hyperlink
  • Editing a Hyperlink
  • Removing a Hyperlink
 

Tracking and Reviewing Changes

  • Enabling or disabling the ‘Track Changes’ Feature
  • Sharing, Comparing and Merging Worksheets
5:00 End of Day 1
DAY 2
9:00

Validating

  • Data Validation - Whole Number
  • Data Validation - List
  • Data Validation - Text Length
  • Customising a Validation Input Message and Error Alert
  • Removing Data Validation
10.45

Auditing

  • Tracing Precedent Cells
  • Tracing Dependent Cells
  • Cells with Missing Dependents
  • Showing All Formulas in a Worksheet
 

Charts

  • Creating a Combined Line and Column Chart
  • Adding a Secondary Axis to a Chart
  • Changing the Chart Type for a Data Series
  • Moving and Formatting Chart Data Labels
  • Modifying Chart Axis Scales
  • \ Inserting Images into Chart Columns
1:00 Lunch
2:00

Input Tables

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

Scenarios

  • Scenario Manager
 

Macros

  • Macro to Change the Page Set-Up
  • Macro to Apply a Custom Number Format
  • Macro to Format a Cell Range
  • Deleting Macros
3:45

Passwords & Security Issues

  • Adding ‘Open’ Password Protection to a Workbook
  • Removing an ‘Open’ Password from a Workbook
  • Password Protecting Cells and Worksheets
5:00 End of Course