Ultimate Beginners Excel VBA Finance Course for Banking
4.0 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,779 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate Beginners Excel VBA Finance Course for Banking to your Wishlist.

Add to Wishlist

Ultimate Beginners Excel VBA Finance Course for Banking

Proven core methodology to master VBA and become competitive on the banking job market.
4.0 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,779 students enrolled
Created by VBA Finance
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $195 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Develop the most useful macros in Banking
  • Master techniques used by the top banking professionals
  • Outpace your peers by maximizing your productivity and time
  • Debug VBA code
  • Create functions and subs
  • Automate graphs generation
  • Understand how to do object oriented programming
View Curriculum
Requirements
  • You have should have Excel installed on your computer.
Description

This course will provide you with essentials about Visual Basic Applications (VBA) Excel for Finance. VBA is the programming language of Excel and is a fast programming language. When correctly mastered, it can automate almost every task that is required in Banking and Investment Banking.

By taking this class, you will see that getting a job in investment banking is not just a matter of luck, but of technique and forward thinking.

This course is best suited for university students who are studying business, finance, accounting, economics or any other finance related programmes.

This course is also for anyone who is interested in knowing more about the Banking and Finance world, and to know about necessary skills to acquire to get into these sectors.

No prior technical knowledge is required. The course covers:

Fundumentals of VBA :

  • Functions, Sub, Variables, Loops, Conditions.

Real life applications that are used in Banks today

  • Build pricers for options and bond
  • Create Userforms and top-notch charts
  • Link your VBA application to a database
  • Understand the concept of Object Oriented Programming


Why should you take this course?

You are a finance student. You are really struggling in finding a good and challenging position in Banking. You would like to start your career with a great asset on your resume and you are motivated to reach that goal.

You are a banker facing issues with repetitive tasks to run on a daily basis and you want to learn how you could automate all of those tasks in a single process.

You are already a banking employee, but you are working in a department that does not fit your ambitions, and you would like to join a more challenging department such as front-office, and work in the exciting environment of the trading room. In order to do that you need to prove that you can bring value to the team.

With this course, you get everything you need to be able to quickly design performant VBA applications.

Who is the target audience?
  • Student who wants to enter the Investment Banking sector with a real asset.
  • Individuals who wants to exponentially increase their productivity at work.
  • Bankers who wants to increase their value to their current or potential employer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:55:03
+
The Black & Scholes Model with VBA
4 Lectures 13:27
The Black & Scholes Formula
03:13

B&S
3 questions

The Pricing Function
02:34

Pricing Function
3 questions

D1 and D2
03:08

D1 and D2
3 questions

Greeks
04:32

Greeks
2 questions
+
Build a Complete Bond Pricer in VBA
6 Lectures 31:45
Intro to Bonds Instrument
02:48

Intro to Bonds Instrument
3 questions

The Userform on VBA
08:06

The Userform on VBA
3 questions

Manage Data Storage
04:01

Manage Data Storage
3 questions

Introduction to Oriented Object Programmation for VBA
05:10

Introduction to OOP
3 questions

Implement the Bond Formula
06:54

The Bond Formula
3 questions

The Userform in Excel
04:46

Userform on Excel
3 questions
+
Learn How to Manipulate Large Quantities of Financial Data
3 Lectures 23:59
Prepare And Format Your Data
04:02

Data Format
2 questions

Import Your Data From Internet in Excel with VBA
12:00

Data Import
3 questions

Automate Graphs Generation
07:57

Graphs Generation
3 questions
+
Learn to Link Your Excel Data to a Database
5 Lectures 27:24
Database and Tools
03:14

Setting up the database
02:47

Building the Excel Application
02:59

Application Design with VBA
06:32

Connect the Function
11:52
About the Instructor
VBA Finance
3.8 Average rating
125 Reviews
9,042 Students
2 Courses
Trainer

VBA Finance is a team of profesionnals decicated to helping and instructing people who want to join the Banking Industry

. VBA is the programming language in Microsoft office and is a versatile tool that can be used to automate simple to complex tasks.

It is one of the most used programming language in banks, especially for front-office positions.