Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
VBA Macros 101 Class Bootcamp for Begineers Analytics Course
Rating: 4.2 out of 5(16 ratings)
1,319 students

VBA Macros 101 Class Bootcamp for Begineers Analytics Course

VBA Macros 101 Class Bootcamp for Begineers Analytics Course Analytics Investment Financial Analysis in Excel VBA Macros
Created byShivgan Joshi
Last updated 12/2024
English

What you'll learn

  • Use Excel and VBA in a more efficiency way

Course content

8 sections • 24 lectures • 47m total length

  • Intro to Project and the Course4:10

    Master Excel VBA basics in a boot camp: data cleaning, including forward and backward fill, missing value handling, and building functions and subroutines; explore regression, Monte Carlo, and pivot tables.

  • Introduction to VBA Language, Variable Assignment, Msgbox2:16
  • Intro to Sub - Hello world3:49

    Learn to create a hello world subroutine in VBA, display a message box, concatenate strings, and print from ranges or cells while distinguishing subroutines from functions.

Requirements

  • Basic knowledge of Excel
  • No programming experience is needed. This course introduces loops, if else and error handling from ground 0

Description

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

Who this course is for:

  • Anyone who wants to use VBA and Advanced Excel features
  • Want to break in Wall Street in NYC New York or IB with enhanced project and portfolio

Report abuse