Location | CFA Society Toronto, Aberdeen Room 120 Adelaide St. W., Suite 701 |
---|---|
Date | Mar 25, 2014 |
Time | 8:30 AM - 5:00 PM |
The VBA Fundamentals for Financial Professionals course broadens and deepens the skills and knowledge the participants have already gained by using Excel for analysis and modeling. The course uses a modular approach for introducing the basic concepts of code and interface controls.
VBA Introduction – what you need to know in order to start using VBA • How to use the Visual Basic Editor • Use Code Window and customize the working environment • Excel Macro recorder - as an example on how code is created • An overview of objects, collections, properties, and methods • A case study VBA Programing Fundamentals (Writing Code) • VBA Language Elements - Overview • Elements and structure of code • Variables, Data Types, Constants • Arithmetical and Logical Operators • Controlling Code Execution • If-Then – code; uses and examples • Loops – code; uses and examples Building User Interfaces • Message Boxes • Buttons • Combo Box
To receive CFA member pricing please contact Dawn Wong dawn.wong@cfatoronto.ca or 416-366-5755 x226
The information, analysis and opinions expressed in the webinars, podcasts and/or congress presentations are solely those of the presenter/author, are not reviewed by the Institute as to content or accuracy, and are not endorsed by CBV Institute or any of its Members.
Location | CFA Society Toronto, Aberdeen Room 120 Adelaide St. W., Suite 701 |
---|---|
Date | Mar 25, 2014 |
Time | 8:30 AM - 5:00 PM |
Cost | FREE |
---|
Please contact us for questions about this event.