Do you have some co-workers who are always ahead with their data analysis while you’re still struggling? The answer is simple. They are simply more efficient at using the Excel functions and formulas. And you too can achieve that in a short time.
Want to save more time and to be more productive at work?
Want to be more efficient instead of desk-bound working on excel spreadsheets and complicated formulas?
You’ve come to the right course that is most sought-after. Learn how successful business professionals and managers are using the top 10 Microsoft Excel function with maximal efficiency.
Through this 2 day intensive workshop, you will master essential Excel functions and formula that are most used in workplace. Not only will you use the functions correctly, you will learn when not to use them, avoid common mistakes and reduce non-value adding time in MS-Excel and quickly create fast reports in MS-Excel.
Participants who seek a power-overview on essential MS-Excel functions and learn how to apply them effectively at their workplace.
- Anyone who is interested in increasing his or her productivity and skills in Excel.
- Anyone who wants to be a better Excel user.
- This course covers some introductory functions such as LARGE and SMALL, but also some intermediate
skills such as VLOOKUP.
- Some advanced techniques such as PIVOTABLE is also covered.
Day 1: 9.00am - 5.00pm Module 1: Look up Functions-focus on VLOOKUP
- VLOOKUP Function
- IF Function
- Match types-looking up an exact match and looking up a range
- INDEX, MATCH Functions
Module 2: Summing Functions
- SUMIF and SUMIFS Functions
- How these Functions work and their limitations
- Customizing the Status Bar & using Auto Calculate
Module 3: Counting Functions
- COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS Functions
Module 4: TEXT Functions
- LEFT, RIGHT, MID, TEXT Functions
Module 5: Grouping and Outlining
- Manual Grouping, Auto Outlining
- SUBTOTAL, AGGREGATE Functions
Module 6: Database and Autofilters
- What is an Excel Database?
- Creating a Table Manipulating Tables
- What is AutoFilter?
Module 7: Excel Database Functions
- DSUM Function
- DSUM vs SUMIF/ SUMIFS
Module 8: Conditional Formatting
- What is Conditional Formatting?
- Conditional Formatting Rules, Data Bars, ColorScales and Icon Sets
- Creating and Managing Rules
- Sparklines(Excel 2010 and above only).
- Advance Formatting
Day 2: 9.00am - 5.00pm Module 9: Pivot Table
- Pivot Table basics
- Building Effective Pivot Tables
- Using Pivot Table Filters
- Sorting, Formatting Pivot Tables
- Calculations and Inserting Formulas
- Pivot Table charts
- Creating Pivot Table from external sources
- Grouping Function in Pivot Tables
Module 10: How to use PowerPivot
- Downloading huge datasets
- Flattening the PivotTable
- Relational Database basics
- Managing and Creating Relationships in PowerPivot
This program is conducted with practical exercises and interactive discussions.
VINCENT CHIN
Chartered Accountant, ACCA (UK)
Sig Sigma Black Belt (ASQ)
Vincent, HRDF-certified trainer specializing in Financial Modelling, Lean Six Sigma and Excel Advanced trainer; and a continuous improvement training consultant. He is a trained Chartered Accountant (Association of Chartered Certified Accountants) and a Six Sigma Black Belt (ASQ) professional.
Vincent brings to you his 20 years’ of work and training experience in multiple industries where he was in charge of financial and business reengineering functions. He also develops complex VBA applications regularly in process improvement projects which requires his expertise.
One of his highest achievements in the role of a Financial Controller for several multinational conglomerates, he was being able to turn a loss making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank.
Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, HSBC.
Vincent adapts a highly practical approach in his training and relates topics he conducts to real life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimic closely the solutions that are needed in his participants’ organizations.
To contact Vincent for any speaking, training and consultancy engagements, please contact us at +603 8074 9056 | Mobile +6012 6869 628 | +6018 2735 123 or email:
info@iTrainingExpert.comOr
We have a faculty of specialist and can cater to your organisation's different levels and specific needs.
For training and advisory services, feel free to contact us at
info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123.
“Vincent is an excellent trainer with excellent knowledge in the subject subject.” - Badrun Berahim, Westin Langkawi.
“Before this I never understood what Six Sigma was. Vincent crystalised it and clarified it for me so well.” - Betty Yu, HSBC.
“I’ve many times been told that PivotTable is the most useful function which help me great at work. This is a great course! ” - David Chiang, Telecommunication.
| Normal Fee |
Early Bird |
Group Fee |
| Sign up 1 pax |
Sign up 1 pax |
Sign up 3 pax or more |
| Pay 1 day(s) before course starts |
Pay 14 day(s) before course starts |
Pay 14 day(s) before course starts |
| MYR 3490 per pax |
MYR 2890 per pax |
MYR 2790 per pax |
| USD 1030 per pax |
USD 850 per pax |
USD 820 per pax |
(Fee inclusive of Training Materials & Certificate of Achievement)
Upon successful completion of this program, you will receive a Certificate of Achievement.
1. ONLINE PAYMENT by Credit card: You can opt to register and pay online with our latest payment integration system through our website.
2. BANK IN CHEQUE
Bank in and then scan the Bank-in slip and email to us before the course commence to confirm your seat.
Courier your cheque payment to our Finance HQ.
* Note that we DO NOT take any payments during the event.
3. BANK IN CASH:You can also pay by cash through bank-in our company bank account
4. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international
