Excel VBA Finance and Invest One Day Bootcamp

sam. 13 octobre à 16:00

Fuseau horaire : Paris (GMT+02:00)

Practical Programming
New York
États-Unis
New York

One Day Bootcamp from 10.00am - 5.30pm, Total In-Class, 7.5hrs, the price is $349 RSVP at https://programwithus.com/learn-Excel-VBA-Finance-and-Investment-One-Day-Bootcamp/?utm_source=meetupPro&utm_medium=meetup&utm_campaign=meetupPro&utm_content=meetupPro 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

Do Loops

Error Handlers, Preventing fatal errors and crashes You will learn: Programming Control Structures

How to use Variables and Arrays

How to Write Programs With the Visual Basic Editor

Decision Control: If/Then/Else and Select Case

Flow Control: For/Next, Do While, For Each

Macros vs Excel Formulas: Strengths and Weaknesses: When to avoid VBA and do it in excel?

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

Use the models in the class at your workplace

How to Call Excel Functions and Write New Functions

How to Call Excel Dialogs

How to Debug and Fix Macros, How to Handle Errors Prerequisites:

A laptop with installed Excel. Who should attend:

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.

Source: https://www.meetup.com/fr-FR/Practical-Introduction-to-Python-Programming/events/254665691/


Practical Programming
New York
États-Unis

Technologie
Nous avons temporairement désactivé la possibilité de naviguer vers les tags.