Visual Basic For Applications (VBA) - Excel
4.9 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
54 students enrolled

Visual Basic For Applications (VBA) - Excel

Being the best of the best of the best at Spreadsheet Programming and Analysis
Highest Rated
4.9 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
54 students enrolled
Created by Matthew Fried
Last updated 6/2020
English
English [Auto]
Price: $19.99
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 33 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 42. Possibly more.
Course content
Expand all 34 lectures 04:28:52
+ While Loops. For Loops, and For Each Loops
5 lectures 26:11
While Examples
03:38
While Examples 2 (Primes and Collatz)
02:55
While Examples 3 (Backwards Numbers, Bonds Price)
09:30
For Loops
05:16
For Each Loops
04:52
+ Functions, Passing and Arrays
8 lectures 01:35:41
Functions Intro
07:58
Functions Practice
10:41
Function Examples #1
29:29
Function Examples #2
18:51
ByVal and ByRef Examples
02:59
Multiple Passes and Passing Arrays - Bubble Sort
06:17
Arrays Reading and Writing Quickly
05:49
Array Methods and More Sorting Examples
13:37
+ User Forms
4 lectures 16:17
Introduction to User Forms
04:13
User Form Initial Example
06:31
Spin Button and Text Box
02:36
List Box Read and Write
02:57
+ Buttons / Financial Examples
4 lectures 48:05
Bond Example
10:44
Monte Carlo Option Pricing with Data Tables and VBA
10:36
Swaps and FRAs in VBA with Choices
12:33
Spin buttons in Excel / linking output - Bond discounting example with rotation
14:12
+ Student Questions
3 lectures 16:00
Counter for List of Information
07:58
Use highlighted values to find statistics
04:40
Summing Across Worksheets with Blank Cells In Between
03:22
Requirements
  • No background is required.
Description

A complete and total immersion in VBA. Learning to program and interact with Excel. A fun learning experience that balances practical tools of data and financial analysis with professional attribution.  We will cover absolute basics through the management of different objects and variants thereof. This course assumes no prior knowledge. It includes many lessons of real-world problems.  The course will cover the exciting world of Subs, Functions and Forms. 

Who this course is for:
  • Anyone wanting to learn VBA.