Mr. Kent Lau Chee Yong has over 10 years of training experience for Malaysian’ corporate and MNC focusing on improving productivity using Excel. He is not only capable of conducting training effectively but also developing Excel-based tool for corporate using Excel Macro/VBA.
Just by writing a few lines of VBA code, he helped an audit executive to reduce his work from 3 days to few minutes. In another case, he wrote VBA codes to help a business analyst to reduce her monthly reporting task from half day to few minutes.
He has helped many Executives reducing their time spent to analyze and produce reports.
He has over 300 corporate clients such as LB Aluminium Berhad, SGS Malaysia Sdn Bhd, Tunku Abdul Rahman University College, Shell Malaysia, SapuraKencana Petroleum Berhad and etc.
Whenever he discover a new application of Excel, new combinations of Excel function to achieve an amazing time-saving result, a new way to solve a reporting problem, he will document it and share as a case studies with his participants.
By the end of his course, his participants will be able to experience a significant increase in their capability to use Excel to create report such as by merging from different worksheet, various workbooks. He enjoys seeing participants becoming the star of their companies.
Over 3000 of his participants have experienced the power of Excel like never before. Are you the next?
Sample of works:
http://www.ugrowit.net/excel-dynamic-chart-and-dashboard-kent-lau-chee-yong/
http://www.ugrowit.net/extracting-date-of-birth-dob-from-malaysia-identity-card-ic-number/
https://www.youtube.com/watch?v=F_NohX4gz3A
https://www.youtube.com/watch?v=u2MbDmxctuQ&t=93s
https://www.youtube.com/watch?v=fZHttdO5cPk
Vistana Kuala Lumpur
9 Jalan Lumut Off Jalan Ipoh,
50400 Kuala Lumpur,
Phone : 03 4042 8000
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 |
|
OVERVIEW |
We can help you understand Excel function easier and guide you how and when to apply them.
For the past 10 years, we have trained Directors, General Manager, Sales Managers, Area Sales Manager, HR Manager, Marketing Manager, Digital Marketing Manager, Production Manager, QA Manager, Finance Manager, executives, supervisors to use Microsoft Excel to solve their real business problems for a wide range of functions such as sales and marketing, administration, purchasing, Human Resource (HR), warehouse, R & D etc.
For example, using two specific Excel’s tools we can help a digital marketing consultant to highlight duplicate entries of Leads and remove it within less than 1 minute. Besides, using Excel Advanced functions you will know what item is going to expire. Lots of useful and practical example is given to help you understand Excel useful advanced function and formula fast. |
OBJECTIVES |
This course is best for Excel users who want to get more out of Microsoft Excel in their day-to-day work. Working with data faster and efficiently. Learning Excel by doing practical, industry-driven exercises, and applying over 20 Excel shortcut on the spot. The Q&A Session will give you the opportunity to ask your own Excel questions on the spot.
|
WHO SHOULD ATTEND |
Participants should understand the basics of Windows. They should already have basic experience working with Microsoft Excel such as using SUM, viewing multiple sheets. |
METHODOLOGY |
|
WHAT YOUR COLLEAGUES ARE SAYING ABOUT THE COURSE…. |
|
DAY 1 | ||||||||||||||||||||||||||||
|
DAY 2 | ||||||||||||||||||||||||||
|