Overview
Learning Outcomes
Upon completion of this course, participants would grasp the fundamentals of VBA coding and able to create VBA applications.
Who Must Attend
This course is for advanced users of MS-Excel who seek programming skills in VBA. Participants should have the desire to learn code and possess an inception-to-completion mindset.
Course Details
Methodology
Participants will be taught basics of code before the deep-dive into Excel programming such as manipulating objects and other facets of Excel. This includes mastering forms, controls, trapping errors, working code through data and coming out with useful practical applications. Participants will be assigned mini-projects to complete during training to test their skills in applying knowledge taught.
Course Leader
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 Office Specialist and a PSMB-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.
Vincent’s experience in the continuous improvement sphere of the financial industry includes projects in process automation & robotics, productivity management, end-to-end reviews and streamlining. He also trained yellow belts and green belts in DMAIC (the acronym for Define, Measure, Analyse, Improve & Control; a problem-solving methodology in Six Sigma) for other various companies. Vincent codes in VBA and has developed complex bespoke Excel applications in the companies he worked for.
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 also assist companies in automating Excel tasks, end-to-end process reviews, developing process target operating models and other areas of process continuous improvement.
Testimonies
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 580.00 |
| Group Fee |
| Sign up 3 pax or more |
| Pay 14 day(s) before course starts |
| MYR 1,790.00 |
| USD 520.00 |
(Fee inclusive of Buffet Lunch, Refreshment, Welcome Pack, Training Materials & Certificate of Achievement. Fee is NOT INCLUSIVE TO 6% SST.)
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 banks.
