San Francisco, California
London, United Kingdom
The Microsoft Excel Advance Training is a 2-days hands-on training where PSMB certified trainer will be teaching you how to use Excel advanced feature such as Advanced Pivot Table, Pivot Chart, Goal Seek, Data Table, Advanced Excel built-in function such as NETWORDAYS, MATCH, INDEX, Nested IF, SUMIF, COUNTIF, SUMIFS, COUNTIFS, recording a macro/Visual Basic for Application (VBA) and case study related to various industries within Malaysia.
RM 680 for 1 day inclusive refreshment.
Module 1: Advanced Pivot Table & PivotChart
Using Pivot Table to summarize data faster.
Learn how to group dates to find out summarize data on a quarterly or yearly basis.
How to project Sale forecast with single variable Data Table.
You will also learn to create a Cost Benefit Analysis with two variables Data Table and create a Discounting Table
Learn the concept of Goal Seek easily.
Module 2: VLOOKUP vs INDEX
Learn how to look up the unit price based on product Id.
Learn how to look up certain month’s expense based on an account number.
Example: Find Net Salary Based on Employee ID
Module 3: Named Cell/Range
The purpose of using named cell
How to name a cell or a range
Deleting and amending named ranges
Using named cells/ranges in formula
Module 4: Advance functions
Using the IF function
And, Or, Not
Combining If, And, Or, Not
Date related function
Using the TODAY(),EOMONTH(), DAY(),MONTH(),YEAR() functions
Calculating working days
COUNTIF & COUNTIFS
Find out late payment in a membership list. You will also learn how to get the item(s) is going to expire in two weeks times.
Example: Payroll Analysis
SUMIF and SUMIFS
Learn to quickly find out the total of hours spent on each project
MODULE 5: Condition Formatting
You will learn to highlight those members that are late payment automatically.
Create a useful inventory/Order Tracking system that monitors stock level.
Learn to create a drop-down list to help a user select a value easier.
How to configure a drop-down list better.
MODULE 6: Super Pivot Table
Understand your company growth using Excel’s latest Big Data technology
Big Data is the key asset for your company.
Example: Analyze Sales Based on Price Range
MODULE 7: Troubleshoot Error With Formulas
Exploring Formula Auditing
Learn to trace formula
Find out the precedent cells and dependent cells.
Check error using Watch window.
MODULE 8: Introduction to macro/VBA
You will learn to create a simple Step-by-Step macro in less than 5 minutes, and then you will be guided to understand what happen when you use a macro.
WHY LEARN WITH CREATIVEWISE SDN BHD?
-Small class size. Only 4 pax, Before you decide, just ask other training providers, how many students per class?
-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 learned 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.**
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, E-certificate will be issued upon completion of the program, you will receive it 1 day after the training.
For practical Excel tips, please visit us here:
Please sign up today. Limited seats (4 seats only for each batch)
Other dates available for learning with us fast:
- 11 - 12 Aug
- 18 - 19 Oct
- 8 - 9 Nov
- 5 -6 Dec
When & Where
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