VBA Macros 101 Class Bootcamp for Begineers Analytics Course

VBA Macros 101 Class Bootcamp for Begineers Analytics Course

This course is build up using experience and suggestions taken after tutoring and delivering classes in several New York, New York bootcamps and courses. Thanks to all the suggestion given my NYC, New York learners to enhance this course.

Course starts with excel, then move to loops, then 2d loops, then error handling, file imports, then multiple regression and simple monte carlo, then scraping.

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