Excel Visual Basic (VBA) for Finance – Wall Street Prep 2022 | CFA Society New York | 13 September 2022 | Virtual Event

This boot camp is an intensive instructor-led training program where trainees learn the secrets of Automation and Efficiency in Excel VBA using an intuitive, step-by-step approach. Participants will write subroutines and user-defined functions in VBA in a fun and energetic setting. We will build templates that can quickly turn large obscure data files into clean, elegant reports. We will learn iteration methods to dramatically increase productivity. Participants will also create user interfaces and build data entry forms to interact with Excel users. No prior programming knowledge is needed.

What You’ll Learn:
• Start Writing VBA From ScratchGet up to speed with the VBA environment and dive right into some real-world exercises that will teach you how to write your own code including macros, functions and subroutines.

• Immediately Use VBA on the JobWe’ll show you how you can start using macros in a finance setting by running through real-world exercises such as calculating asset returns and building a payback-period calculator.

• No Coding Experience NeededDesigned for complete newbies and/or those looking for a refresher. No prior programming knowledge is needed

Who is this boot camp for:
This boot camp is designed for anyone who wants to learn VBA and add Excel automation to their skill set. Given Wall Street Prep’s client base, attendees tend to come from the following backgrounds:

• Financial planning and analysis and treasury
• Corporate finance and business development
• Credit analysts
• Quantitative finance and trading
• Sell-side / buy side analysts