Learn From The Best
Mr. Kent Lau Chee Yong is capable to transform Excel training session interestingly and engaging all participants in the learning process using his unique SpeedExcel system. A PSMB Certified trainer with over 10 years of corporate training experience. He has served Bank Negara Malaysia, TMF Group, TESCO Malaysia, Maybank ECC, LB Aluminium Berhad, Panasonic Electronic Devices Malaysia Sdn Bhd, SGS Malaysia Sdn Bhd, ELTETE Malaysia Sdn Bhd, MERGE Energy Berhad, Puratos Malaysia, TAR University College, Nitritex Malaysia Sdn Bhd, Telepaper (M) Sdn Bhd, Pamir Development Sdn Bhd, Johor, AA Mewah Sdn Bhd, Levi Malaysia, LION Group and etc. Numerous organization has benefited from his practical approach to empower employee to master Excel skill in the shortest of time.
He provided corporate training for Puratos Malaysia Sdn Bhd, TAR College, Polytechnic Kulim, UTHM, Telepaper (M) Sdn Bhd,LB Aluminium Berhad, Nokia Siemen Netowork, AVNET, Thai Express, Dentsu Utama Sdn Bhd, ERIKS Sdn Bhd and etc.
Excel Training- Intermediate Level
24 September 2020
The Microsoft Excel Data Analysis Class is a 1-day hands-on practical training where our Expert Reporting Expert will be teaching you some of the most powerful Excel Advanced function that will improve your productivity, your ability immediately with industrial case study related to finance, HR, Sales, manufacturing, retail.
With over 10 years’ experience in training and consulting, Kent Lau has excellent industrial case study related to HR, Finance, Account, Manufacturing, Operation and etc.
Kent Lau has consulted over 200 corporate to learn Excel fast and improve their skill of Excel, and in turn, improve my students' productivity.
TOPIC 1: RELATIVE VS ABSOLUTE CELL REFERENCE
We design easy to understand exercise to help explain what cell address, cell reference, relative reference and absolute cell reference is.
Exercise to help participant to understand fully understand this key concept.
TOPIC 2: ADVANCED FUNCTIONS AND FORMULAS
Logical functions – TRUE, FALSE
Conditional functions – IF, AND, OR
Text functions – MID, LEFT, RIGHT, UPPER, LOWER, PROPER
Date and time functions – DATE, MONTH, YEAR
VLOOKUP - Type 1 & Type 2
TOPIC 3: PIVOT TABLE
What is Pivot Table
How to use Pivot Table
The Pivot Table structure
Using Pivot Table creatively
Extracting key business information from primary data source.
TOPIC 4: HYPERLINK
Create a Table of Content with Hyperlink
Hyperlink with a picture, shape
TOPIC5: DATA PROTECTION
Protecting the Report you have analysed
Protect the Worksheet
Protecting the Workbook structure
Protect the Workbook with a password
TOPIC 6: QUESTION AND ANSWER (Q & A) SESSION
We help you speed up your existing work on the spot, so you look awesome after 2 days training with us.
Who Should Attend
Senior Level, administrative staff including senior Sales & marketing executive, Finance staff, Senior Account Executive, Personal Assistant, senior IT staff, purchase executive, operation staff, retail staff who job description require them to not only enter data but to analyze data into Excel. Those who play a supportive role in decision making process will find this course useful.
Partner sharing. Learn to share, Post Test, Pre Test, Group sharing,Class sharing, Our unique revision technique
After Attending, You Will Return To Your Job
Normal Fee ~ RM 742/ person
Group Discount ~ RM 636 / person (for 3 or more participants)
(Price incl. 6% Service Tax)