Overview
Learning Outcomes
- grasp the basics of the both the power query and power pivot tools
- connect to data source
- cleanse and edit the data
- reconnect broken relationships
- remodel data
- put data them into Excel worksheets for further analysis
Who Must Attend
Course Details
Methodology
LAPTOPS ARE REQUIRED.
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 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.
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
Investment
Normal fee |
Sign up 1 pax |
Pay before course starts |
MYR 2,990.00 per pax |
USD 890.00 |
Early Bird |
Sign up 1 person |
Pay 14 days before course starts |
MYR 2,600.00 per pax |
USD 760.00 |
Group Fee |
Sign up 3 pax or more |
Pay 14 days before course starts |
MYR 2,500.00 per pax |
USD 730.00 |