|Title||Financial Modeling with Microsoft Excel VBA|
|Objective||VBA (Visual Basic® for Applications) is the built-in macro programming language in Microsoft Office applications. It can be used to overcome the limitations of Excel and automate spreadsheet procedures.
Upon completion of this course, participants would have learned the fundamentals of Excel VBA and how to apply it to build simple yet commonly used spreadsheet models for financial data analysis.
|Assessment||In-class performance and exercises|
|Target audience||High-level users who need expert skills in using Excel to build simple financial models.|
|Prerequisite||Students must have:
|Instructor||Microsoft Certified Trainer, specialized in teaching Office applications and VBA, presently a full time trainer for a computer company in Hong Kong|
|Handout language||Handouts in English|
|Duration||28 hours in 8 sessions|
|Schedule||10:00-13:00, 14:00-18:00, from Feb 23, 2019 to Mar 16, 2019 every Saturday.|
|Venue||CPTTM Head Office (Rua de Xangai 175, Edf. ACM 7 Andar, Macau)|
|Certificate||Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).|
|PDAC code||Approved Course under the SAR Government "Continuing Education Development Program", Code: 1807321321-0|