This Excel Macro Course assumes no previous knowledge of Macros. This basic VBA class, that will help you apply skills to build quantitative models in excel.

Step by step this course explains how to start building sophisticated financial models capital investment and financing decisions.
What this course is about:

Step by step this course explains how to start building sophisticated financial models capital investment and financing decisions. We start with Excel essentials and then move to Excel VBA (Visual Basic for Applications)programming. This Excel Macro Course assumes no previous knowledge of Macros. This basic VBA class, that will help you apply skills to build quantitative models in excel.

Four projects for the course: Multiple Linear Regression Logistic Regression Monte Carlo Simulation (AR1) Scraping data from Yahoo Finance We will cover: Macros / VBA What are Macros? What is VBA? How to record macros How to run macros VBA Editor Modules Procedures Project Explorer Toolbars / Options Creating / Editing Code Create Procedures Subs Comments Invoking Macros Hot Keys Quick Access Toolbar Call Command Compiling Code Stepping through code Reset Run Variables Declarations Option Explicit Data Types Working with The Object Model Ranges: Rows, Columns, Cells Naming conventions Navigation / Selection Techniques Offsets Range Names Logic Statements IF Statements Looping Statements Error Handlers, Preventing fatal errors and crashes

Who this program is for:

Investment banking analysts and associates, Private equity, asset management and hedge fund associates, Corporate finance and business development professionals, MBA students and business undergraduates, Anyone seeking to improve their Excel skills.

You will learn:
  1. Programming Control Structures
  2. How to use Variables and Arrays
  3. How to Write Programs With the Visual Basic Editor
  4. Decision Control: If/Then/Else and Select Case
  5. Introduction to VBA and Recording Macros
  6. Create User Defined Functions and Workbook Events
  7. How to Call Excel Functions and Write New Functions
Prerequisites & Preparation:
  1. A laptop with installed Excel.

Start Dates

Sep 29, 10 a.m.

$349

Total 7.5 Hrs
Course schedule:
Sept. 29, 2018, 10 a.m.

Oct 13, 10 a.m.

$349

Total 7.5 Hrs
Course schedule:
Oct. 13, 2018, 10 a.m.