All Events

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.

Details
Location CFA Society Toronto, Aberdeen Room 120 Adelaide St. W., Suite 701
Date Mar 25, 2014
Time 8:30 AM - 5:00 PM
Fees Summary
Cost FREE
Registration Closed

Please contact us for questions about this event.

Your web browser is outdated. For the best possible site experience, we encourage you to switch your browser to Microsoft Edge, Google Chrome or Firefox.