Basic Microsoft Excel Microsoft Office Mastery Series

20 Aug, 2025, 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
  • Getting Started with Excel
  • Excel Selection Techniques
  • Manipulating Rows and Columns within Excel
  • Manipulating Cells and Cell Content within Excel
  • Number Formatting within Excel
  • Alignment Formatting within Excel
  • Excel Worksheets
  • Freezing Row and Column Titles
  • Excel Formulas
  • Excel Functions
INTRODUCTION
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 basic level, it provides strong understanding what is Data Type and proper formatting to present the data effectively.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Describing Excel Data thoroughly to prevent common mistake in Excel Reports!
  2. Selecting and modifying cells, columns, and rows confidently.
  3. Managing multiple worksheets with ease.
  4. Understanding the used of Cell Reference techniques.
  5. Writing some basic formula and functions.
WHO SHOULD ATTEND
  • Administrative Assistant
  • Data Entry Clerk
  • Accounts Assistant
  • Marketing Assistant
  • Sales Support Specialist
  • Inventory Clerk
  • HR Assistant
  • Project Coordinator
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 CONTENT
9:00

Getting Started with Excel

  • Cell Referencing System
  • Entering Numbers and Text
  • Default Text and Number Alignment
  • Summing a Column of Numbers
  • Entering a Date

 

Excel Selection Techniques

  • Selecting a Cell
  • Selecting the Entire Worksheet
  • Selecting a Row & a Column
 

Manipulating Rows and Columns within Excel

  • Inserting Rows into a Worksheet
  • Inserting Columns into a Worksheet
  • Automatically Resizing the Column Width to Fit Contents
 

Manipulating Cells and Cell Content within Excel

  • Editing Cell Content
  • Undo and Redo
  • AutoFill
  • Searching and Replacing Data
10.45

Number Formatting within Excel

  • Number Formatting
  • Decimal Point Display
  • Applying and Removing Comma Style Formatting (To Indicate Thousands)
  • Currency Symbol
  • Date Styles
  • Percentages
12.00

Alignment Formatting within Excel

  • Centring a Title over a Cell Range
  • Cell Orientation
  • Text Wrapping within a Cell
  • Aligning Cell Contents Vertically
  • Format Painter
1:00 Lunch
2:00

Excel Worksheets

  • Switching between Worksheets
  • Renaming a Worksheet
  • Copying or Moving Worksheets between Workbooks
 

Freezing Row and Column Titles

  • Freezing Row and Column Titles
3:45

Excel Formulas

  • Creating Formulas
  • The Easy Way to Create Formulas
  • Copying Formulas
  • Operators
  • Using Operators in Formulas
  • Formula Error Messages
  • Relative Cell Referencing within Formulas
  • Absolute Cell Referencing within Formulas
 

Excel Functions

  • What Are Functions?
  • Common Functions
  • Sum Function
  • Average Function
  • Max Function
  • Min Function
  • Count Function
  • The Counta Function
  • The CountBlank Function
5:00 End of Course