The Microsoft Excel Data Analysis Class is a one full day hands-on training where PSMB certified, VTO 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 12 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)
Save This Event
When & Where
3-2, Jalan Puteri 5/20
3-2, Jalan Puteri 5/20
Creativewise Sdn Bhd
Creativewise Sdn Bhd (formerly UGROW IT Solutions)
- 15 yrs experience in IT industry
- 8 yrs corporate training experiences
We provide all level of Microsoft Excel training for senior management and executive. We has successfully trained LB Aluminium Berhad, Nokia Siemen Network, ThaiExpress Sdn Bhd, SGS Malaysia Sdn Bhd, DataStream Solution (Brunei) Sdn Bhd, 3ntity Berhad, SGS Labuan (Group of Oil & Gas Chemists), AVNET Malaysia Sdn Bhd, SOMFY Sdn Bhd, KTC , New Horizons Malaysia, Nota Asia, Tunku Abdul Rahman College, Kawan Food Berhad, Merge Energy Berhad, PUMA, Syngenta, Ntritex Sdn Bhd and etc
"Kent has helped my staff to reduce data analysis time in calculating staff overtime." ~ LB Aluminium Berhad