Overview
Learning Outcomes
This 2-day program covers functions & formulas important to regular users of Excel who process and operate a medium-to-high volume of data in various complexities at the office. This course aims to bring your expertise in Excel to the advance level so that your turn-around-time in Excel spreadsheets are reduced.
Who Must Attend
- HR managers, project managers, revenue managers, finance managers and administrative personnel who already have a BASIC to INTERMEDIATE understanding of Excel 2016 and are looking to expand it further.
Course Details
Methodology
The course is instructional, step-by step in approach. Participants are also put through exercises on interesting datasets to apply their understanding & learning.
LAPTOPS REQUIRED -"if you have two computer monitors, please use them."
SETUP REQUIREMENTS
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
3. Power Query info: https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
4. Tutorial video: https://youtu.be/8tWi4nSUyWA
Course Leader
VINCENT CHIN
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 industries. 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 require his expertise.
One of his highest achievements in the role of Financial Controller for several multinational conglomerates 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, and 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 mimics closely the solutions that are needed in his participants’ organizations.
OR
Other professional trainers in this field.
To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707 or info@itrainingexpert.com
Testimonies
"The trainer was very clear in this explanation on how to use the excel functions to enhance my work. Great job. Thanks" Farhan, Rail Transit.
“I have learned a lot of knowledge from this course, Excel based (Intermediate level). Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd
“Thanks to my trainer. I learned to apply Microsoft Excel in my future work. He is good and expressive. He is able answer all my questions immediately. I hope to join for Microsoft Excel – Advanced Level.”– Accounts, Hiraki Timur Sdn Bhd.
“During the course, I learned to simplify my work using Excel. After the course, I am so excited and can’t wait to apply the knowledge that I learned from this course. My Excel training is an excellent and knowledgeable trainer. I hope to join Microsoft Excel – Advanced Level conducted by him.”– Accounts, Hiraki Timur Sdn Bhd.
“Before attending the course, I felt ready to learn & improve my Excel skills. In the program I learned many methods to work on data in Excel. After the course, I feel I have improved some excel skills. The trainer went above & beyond and share a lot. His training is also easy to understand & very clear.” – Intan Diana, Science officer, ISTIC-UNESCO.
“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.
“Before attending the course, I thought enough about Excel. On these 2 days course, I learned picked up many different Excel functions. I gained knowledge a lot from the training. The trainer well engaged and knowledgeable.’- Farah Atiqah, 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.
Investment
Normal fee |
Sign up 1 pax |
Pay before course starts |
MYR 2,590.00 per pax |
USD 760.00 |
Early Bird |
Sign up 1 person |
Pay 14 days before course starts |
MYR 1,990.00 per pax |
USD 580.00 |
Group Fee |
Sign up 3 pax or more |
Pay 14 days before course starts |
MYR 1,890.00 per pax |
USD 550.00 |