Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Cleaning
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Excel VBA

Ultimate Beginners Excel VBA Finance Course for Banking

Proven core methodology to master VBA and become competitive on the banking job market.
Rating: 2.7 out of 52.7 (214 ratings)
8,264 students
Created by VBA Finance
Last updated 11/2016
English
English [Auto]
30-Day Money-Back Guarantee

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

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

Course content

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

  • Preview03:09
  • Preview05:13
  • Preview03:26
  • Preview04:01
  • Preview02:39

  • 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

  • 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

  • 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

  • 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

Instructor

VBA Finance
Trainer
VBA Finance
  • 3.3 Instructor Rating
  • 310 Reviews
  • 9,789 Students
  • 2 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.