Overview
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.
Learning Outcomes
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.
Who Must Attend
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
skills such as VLOOKUP
- Some advanced techniques such as PIVOTABLE is also covered
Course Details
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
Methodology
This program is conducted with practical exercises and interactive discussions.
Course Leader
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.com
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.com
Testimonies
“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
Investment
| Normal Fee |
| Sign up 1 pax |
| Pay before course starts |
| MYR 2,590.00 |
| USD 760.00 |
| Early Bird |
| Sign up 1 pax |
| Pay 14 day(s) before course starts |
| MYR 1,990.00 |
| USD 600.00 |
| Group Fee |
| Sign up 3 pax or more |
| Pay 14 day(s) before course starts |
| MYR 1,790.00 |
| USD 540.00 |
(Fee inclusive of Buffet Lunch, Refreshment, Welcome Pack, Training Materials & Certificate of Achievement)
Certificate
Upon successful completion of this program, you will receive a Certificate of Achievement.
Certificates are distributed on the final day of the program.
Payment mode:
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
