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

Introduction

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.

Program Outlines

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.

Register Here - Copy.png
PDF Brochure Icon.jpg

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.

Methology

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

Course Fees

Normal Fee ~ RM 742/ person

Group Discount ~ RM 636 / person (for 3 or more participants)

(Price incl. 6% Service Tax)

Copyright © 2020 Scientia Training Sdn Bhd