EXCEL TRAINING | INTERMEDIATE & ADVANCED LEVEL(2 DAYS)
By Mr. Kent Lau Chee Yong - 20 & 21 February 2019, 9:00 am to 5:00 pm
Kuala Lumpur
(100% Claimable From HRDF/PSMB)
INTRODUCTION

The Microsoft Excel Data Analysis Class is a 2- 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.

COURSE OBJECTIVES:
At the end of this training, you will be able to:
  • Analyze data faster and easier than you think
  • Understand VLOOKUP function completely
  • Understand how to use IF function to perform data analysis.
  • How to combine multiple function together to perform data analysis
  • Idea that can help you improve your performance in creating monthly report.
  • How to protect the report you created.
  • How to highlight item that meet certain requirement
  • How to use Pivot Table, Pivot Chart, Slicer
  • How to use Named Cell, Named Range in complex Excel formula
  • How to use INDEX, HLOOKUP, MATCH
  • How to create a dropdown list
  • How to access PowerQuery
  • You will begin to see the usefulness of Excel like never before.

Who is suitable:

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.

Effective Training methods:

Partner sharing. Learn to share, Post Test, Pre Test, Group sharing,Class sharing, Our unique revision technique

Duration

14 Hours, 2 Days.

Course Outlines :-
  1. 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.
  2. 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
  3. 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.
  4. TOPIC 4: HYPERLINK
    • Create a Table of Content with Hyperlink
    • Hyperlink with a picture, shape
  5. TOPIC5: DATA PROTECTION
    • Protecting the Report you have analysed/li>
    • Protect the Worksheet
    • Protecting the Workbook structure
    • Protect the Workbook with a password
  6. 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.
  7. TOPIC 7: ADVANCED PIVOT TABLE
    • Learn to summarize data on quarterly or yearly basis or even weekly using Pivot Table
    • Creating PivotChart
    • Using Slicer
    • Changing PivotChart type and Chart element
    • Using GetPivotData together with Slicer
  8. TOPIC 8: NAMED CELL/RANGE TECHNIQUE
    • How to name a cell or a range fast
    • Deleting and amending named ranges
    • Using named cells/ranges in formula
  9. TOPIC 9: ADVANCE FUNCTIONS
    • Quick revisit: Using the IF function
    • Nested IF
    • And, Or
    • Combining If, And, Or, Not
    • Using INDEX
    • Learn how to look up the unit price based on product Id in any direction.
    • Learn how to look up certain month’s expense based on an account number in any direction.
    • Find Out Late Payment In A Membership List.
    • How to highlight the item(s) is going to expire.
    • Understand COUNTIF and SUMIF easily.
    • Learn to quickly find out the total of hours spend on each project
  10. TOPIC 10: HIGHLIGHTING ITEMS THAT MEET A CONDITION AUTOMATICALLY
    • You will learn to highlight those members that are late payment automatically.
    • Highlighting items that meet multiple conditions automatically
  11. TOPIC 11: DATA VALIDATION
    • Learn to create a dropdown list to help user select a value easier.
    • How to configure a dropdown list better.
Your Trainer

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.

Course Fee
(Course fee is inclusive of 2 tea breaks, lunch, course material,Certificate of Attendance)
Early Bird for training in KL : ( Book Before 6 February 2019 )
1 person or more ~ RM 1180 / person
Standard
1 person ~ RM 1280 / person
2 persons or more ~ RM 1180 / person
(Course fee is inclusive of 2 tea breaks, lunch, course material, Certificate of Attendance)
Terms & Conditions:
1. Registration & Fees Policy
Registration is confirmed once registration form is received via fax/email/mail. All Payments/Undertaking Letters/Local Order (LO)/Letter of Approval must be made available and presented prior to the course.
2. Cancellation Policy
Any cancellation must be received in writing within 7 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.
3. Disclaimer & Program Changes Policy
Scientia Training Sdn Bhd reserves the right to amend or cancel the event due to circumstances beyond its control. We reserved the right to modify the advertised topics or course timing whenever necessary.
Registration:
1. Fax 03-6207 6727
       OR
3. Payment shall be made payable to SCIENTIA TRAINING SDN BHD
Contact Us:
Scientia Training Sdn. Bhd. (1001247-U)
GST: 001871699968
Tel: 03 7732 0477     Fax: 03-6207 6727     
Info    019 335 1111     info@scientia.com.my
Sara    019 335 1111     sara@scientia.com.my
Nonie    019 327 1111     nonie@scientia.com.my
Max    012 375 2003     max@scientia.com.my
For Customised In-House Training:
Ronny     012 223 6666     ronny@scientia.com.my
Office Hour: Monday ~ Friday 9.00 am~6.00 pm
Click here to request for a Brochure
Copyright (c) 2015 by Scientia Training Sdn Bhd