Microsoft Excel Making Microsoft Excel work hard for your business

19-20 Dec, 2022, Remote Online Training - Public

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

Remote Online Training - Public

Contact us

Juliany,
M - 012 2281 247
juliany@ipa.com.my

Phoebe,
M - 019 363 7822
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
June,
M - 012 941 8251
June@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: The Excel Reference SECRETS
  • Module 2: The Special tools in Excel
  • Module 3: Making Data Easy to Understand
  • Module 4: The Amazing Formula Secrets
  • Module 5: Getting to know what is “Get and Transform”
  • Module 6: Generating Quick but a Complex Report
  • Module 7: Visual Data Presentation using Excel Chart
  • Module 8: Secure your Excel files
COURSE OBJECTIVE
This course is specifically designed to help you work on your reports like a HERO. In this course, the participants will be given the simplest solution to solve sophisticated task within a short span of time. Mastery comes with lots of practice. There will be exercises and examples that will ignite your creativity using the Formulas and Features in Excel. Ultimately, with practice to turn the knowledge into learning, you will be a master in Microsoft Excel in no time
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Using all the different type of Cell References Effectively & Accurately.
  2. Applying the Go to Special and Paste Special to solve complicated Task Quickly.
  3. Changing & Applying the Number Formatting Dynamically.
  4. Being able to fully understand the secrets of VLOOKUP and use it like a Pro.
  5. Using PowerQuery to Clean Up and Collect Data from Multiple Source.
  6. Designing Mini Dashboard using Pivot Table.
  7. Presenting Data Visually.
  8. Applying Worksheet and Workbook Level Protection
WHO SHOULD ATTEND
Executives, Managers, Business Owners, General Public, Individual pursuing Self Improvement
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

Module 1: The Excel Reference SECRETS

  • Cell Reference and Name Range
  • Applying Names in Formulas
  • Dynamic References
  • Structured Reference
  • 3D Reference


10.45

Module 2: The Special Tools in Excel

  • Selection: Go to Special | Blank | Visible
  • Copy & Paste: Paste Special | Transpose | Operation
  • Camera Tool: Smile – One Two Three – Snap
  • Data Entry Form (Non-Coding Form) 

 

1:00 Lunch
2:00

Module 3: Making Data Easy to Understand

  • Explore the Number Formatting
  • Deep Dive into Date Formatting
  • Making Number Value Appear Dynamic
  • Apply symbols in Number Formatting
  • Insert Picture evidence in the Excel Comment/ note

 

3:45

Module 4: The Amazing Formula Secrets

  • Introducing VLOOKUP and its Accomplice
  • Why not XLOOKUP?
  • Index and Match Function is a perfect couple
  • Search Part of the Value with a HELPER column

 

5:00 End of Course
DAY 2
9:00

Module 5: Getting to know what is “Get and Transform”

  • Cleaning up messy Data
  • Collect data from multiple source
  • Merge data from 2 sets of data


10.45

Module 6: Generating Quick but a Complex Report

  • Transform a Data List (database) into an easy-to- understand Report
  • Making Right Click your Buddy in Pivot Table
  • Analyze the data by Grouping data
  • Write a Calculated Field in Pivot Table (Formula)
  • Present the Report Visually with Chart

 

1:00 Lunch
2:00

Module 7: Visual Data Presentation using Excel Chart 

  • Manipulate data to display your chart Correctly
  • Add Visual Information to make Chart easy to read
  • Apply Cosmetic Change on the Chart to WOW the Audience

 

3:45

Module 8: Secure your Excel file

  • Sheet Protection: No Editing Capability
  • Partial Sheet Protection:” Protect Locked and hidden Cells
  • File Protection: Only allow access with Password

 

5:00 End of Course