Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Ultimate Beginners Excel VBA Finance Course for Banking
Rating: 3.2 out of 5(233 ratings)
8,386 students

Ultimate Beginners Excel VBA Finance Course for Banking

Proven core methodology to master VBA and become competitive on the banking job market.
Created byVBA Finance
Last updated 11/2016
English

What you'll 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

Course content

5 sections • 23 lectures • 1h 55m total length

  • Introduction - First Steps in Excel VBA3:09
  • Understand The Difference Between a Function And a Sub5:13
  • The Variables3:26

    Learn how variables store data in VBA, including function inputs value1 and value2. Understand swapping values with a pivot: declare pivot, assign, and verify with debug.print.

  • The Conditions4:01
  • How Learning VBA for Excel Will Give You a Real Edge in Investment Banking2:39

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 this course is for:

  • 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

Report abuse