The Microsoft Excel Data Analysis Class is a one full day hands-on training where PSMB certified trainer Kent Lau will be teaching you why and how to use Excel Advanced function such as VLOOKUP, MATCH, IF together with industrial case study related to finance, manufacturing, banking industry.
Our trainer has trained various manufacturers, oil and gas and finance institutes over the past 10 years.
The following is what you can expect to learn (and more):
MICROSOFT EXCEL DATA ANALYSIS COURSE OUTLINE
You will learn the following and practice on the spot:
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.
Topic 2: Advanced functions and formulas
Date and time functions
Topic 3: Presenting Data Using Charts
Create a Chart
Topic 4: Analyzing Data Using PivotTables, Pivot Charts and Slicer
Create a PivotTable Report
Analyze Data Using Pivot Charts
Filtering Data Using Slicers
Topic 5: Protecting your data
Protect your worksheet
Unprotect your worksheet
WHY LEARN WITH CREATIVEWISE SDN BHD?
Small class size. Only 6 pax.
PSMB Approved Training Provider. We deliver only the excellent Excel training you want.
Highly creative and experienced. We are the expert in applying various Excel functions and feature. We have trained more than 200 corporate clients including batches of finance staffs for Bank Negara Malaysia, TESCO, Maybank and etc.
Ongoing learning. You can further deepen your Excel skill and understand by purchase videos tutorial after the training session. It’s great and excellent tool for you to revise what you learnt and help you enhance your skill to next level, all this - on your own pace.**
Carefully designed course material and exercise. Easy to understand and practical example for various job functions.
Excel Peak Performance Coaching. We are committed 100% to your success in applying Excel to master level within 3 - 5 months or less through one to one coaching.**
** optional solutions.
Is my registration/ticket transferrable?
Do I have to bring my printed ticket to the event?
No, just show us your ticket on your mobile phone will do. Let us go green.
What is the refund policy?
The name on the registration/ticket doesn't match the attendee. Is that okay?
It is OK.As long as you can explain logically.
Will a certificate be given?
Yes, Certificate will be issued upon completion of the program, you will receive right after the training.
For practical Excel tips, please visit us here:
Please sign up today. Limited seats (12 seats only)