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.

Introduction to VBA and Recording Macros
Writing VBA Code - Introduction to Variables, Decision and Looping Controls
Graceful Error Handling using ON ERROR
Create User Defined Functions and Workbook Events
Object Variables, Array Variables, Indefinite Loops
Use the models in the class at your workplace

Things that you will learn are:
How to Debug and Fix Macros, How to Handle Errors
How to use Variables and Arrays
How to Write Programs With the Visual Basic Editor
Programming Control Structures
Decision Control: If/Then/Else and Select Case
Flow Control: For/Next, Do While, For Each
How to Call Excel Functions and Write New Functions
How to Call Excel Dialogs

Upon successful completion of this course, students will be able to:
Run Multiple Regression, Logistic Regression and Monte Carlo Simulation in Excel.
Develop a macro
Format worksheets using macros
Create an interactive worksheet
Work with multiple worksheets
Import from difference files

Topics covered in the class:
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
reating & Naming Objects
Naming conventions
Navigation / Selection Techniques
Offsets
Range Names
Logic Statements
IF Statements
Looping Statements
Do Loops
Error Handlers
Preventing fatal errors and crashes

#Instructor:
Shivgan Joshi
info@bainyc.com
929 356 5046
https://github.com/shivgan3
https://www.linkedin.com/in/shivganjoshi/
https://notebooks.azure.com/shivgan3/libraries

Other courses:

http://www.qcfinance.in/learn-elementary-excel-vba-course/