Who Must Attend
2 days syllabus
Module 1. Formula references
Absolute & relative references
References when copying formulas in an array
Module 2. Array formulas
New developments in array formulas
How to apply legacy CSE formulas
How to apply new platform array formulas
Module 3. Logical functions
IFS function (Microsoft 365, Excel 2021, Excel 2019 only)
Module 4. Lookup functions
Match types-looking up an exact match and looking up a range
INDEX, MATCH Functions- basic & array formulas
Module 5. SUM & COUNT functions
SUMIF, SUMIFS, COUNTIF, COUNTIFS Functions
DSUM & DCOUNT
Module 6. An introduction to Table
Function of the Table
Creating the Table
Module 7. The Pivot Table
Creating the Pivot Table from a flat file
Populating the Pivot Table, formatting values & other Pivot Table options & settings
Slicers & Timelines
Module 8. The OLAP Pivot Table
What is OLAP?
Introduction to the OLAP Pivot Table
Tables and Data Models
OLAP Pivot Table formulas
Module 9. Form Controls & Drop-down boxes
Introduction to Form Controls- ScrollBar, Combobox, Data Validation List
Creating Form Controls and using them in data analysis
Creating drop-down boxes using the Data Validation List
Module 10. Extracting & combining data with Power Query
Extracting data of various file types and source
Transforming extracted data
Merging and appending data
Combining worksheets from a folder
Module 11. Excel charts
Introducing new graphs and charts in Excel
The primary & secondary axis
Custom chart templates
Module 12. Conditional Formatting
What is Conditional Formatting?
Conditional Formatting Rules, Data Bars, ColorScales and Icon Sets
Creating and managing formatting rules
Advance formatting using formula
The course is instructional, step-by step in approach. Participants are also put through exercises on interesting datasets to apply their understanding & learning.
1. Required software (either one): Excel 2016 Professional Plus, Excel 2019, Excel 2021, Microsoft 365.
2. Ensure Power Query and Power Pivot is working in your installed versions of your Excel.
Power Pivot info: https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b
Power Query info: https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
Tutorial video: https://youtu.be/8tWi4nSUyWA
3. If you have two computer monitors, please use them.
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer
Vincent has held financial, continuous improvement and I.T. positions in the banking, shared services and hospitality industry. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist and HRD Corp accredited trainer. His previous roles include being an internal change consultant of a global team, a financial shared-services local head and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA and process improvement.
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.
We have a faculty of equally talented specialists who can cater to your organization's specific needs in the event of substitution.
For training and advisory services, feel free to contact us at email@example.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123
“I felt that I lacked the necessary skills to utilize Excel efficiently. During the course, I learned a lot of different excel functions that could help me in at work. After the 2 days training, I feel like an Excel master.The trainer was very engaging. He answered all my questions and explained them very well.”- Ahmad Safuan, Science officer, ISC ROAP.
“I didn’t have too much knowledge about Excel and its functions. By showing up in the 2 days Microsoft Excel course, I feel gained knowledge & discover many things in this application. The trainer was good at explaining.”- Zarmila Salmi, Admin & Finance officer, ISTIC-UNESCO.
|Sign up 1 pax|
|Pay before course starts|
|MYR 2,290.00 per pax|
|Sign up 1 person|
|Pay 14 days before course starts|
|MYR 1,690.00 per pax|
|Sign up 3 pax or more|
|Pay 14 days before course starts|
|MYR 1,490.00 per pax|
Upon successful completion of this program, you will receive an E-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. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.
Contact us: ITRAININGEXPERT GLOBAL PLT
Tel:+603 8074 9056 | +603 8082 3707
Mobile: +6012 6869 628 | +6018 2175 123