Visual Basic For Applications (VBA) Excel

Visual Basic For Applications (VBA) – Excel, available at $19.99, has an average rating of 4.55, with 35 lectures, based on 43 reviews, and has 174 subscribers.

You will learn about 42. Possibly more. This course is ideal for individuals who are Anyone wanting to learn VBA. It is particularly useful for Anyone wanting to learn VBA.

Enroll now: Visual Basic For Applications (VBA) – Excel

Summary

Title: Visual Basic For Applications (VBA) – Excel

Price: $19.99

Average Rating: 4.55

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

42. Possibly more.

Who Should Attend

Anyone wanting to learn VBA.

Target Audiences

Anyone wanting to learn VBA.

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.?

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Inputting and Outputting to Excel

Lecture 3: Data Types

Lecture 4: Object Hierarchy

Lecture 5: Simplification and Offset

Lecture 6: Variations – That All Work

Chapter 2: Second Steps

Lecture 1: More on Data Types

Lecture 2: Arrays and User Defined Type Intro

Lecture 3: Using VBA and Excel Functions in Code

Chapter 3: If and Select/Case Statements

Lecture 1: If

Lecture 2: Select Case

Chapter 4: While Loops. For Loops, and For Each Loops

Lecture 1: While Examples

Lecture 2: While Examples 2 (Primes and Collatz)

Lecture 3: While Examples 3 (Backwards Numbers, Bonds Price)

Lecture 4: For Loops

Lecture 5: For Each Loops

Chapter 5: Functions, Passing and Arrays

Lecture 1: Functions Intro

Lecture 2: Functions Practice

Lecture 3: Function Examples #1

Lecture 4: Function Examples #2

Lecture 5: ByVal and ByRef Examples

Lecture 6: Multiple Passes and Passing Arrays – Bubble Sort

Lecture 7: Arrays Reading and Writing Quickly

Lecture 8: Array Methods and More Sorting Examples

Chapter 6: User Forms

Lecture 1: Introduction to User Forms

Lecture 2: User Form Initial Example

Lecture 3: Spin Button and Text Box

Lecture 4: List Box Read and Write

Chapter 7: Buttons / Financial Examples

Lecture 1: Bond Example

Lecture 2: Monte Carlo Option Pricing with Data Tables and VBA

Lecture 3: Swaps and FRAs in VBA with Choices

Lecture 4: Spin buttons in Excel / linking output – Bond discounting example with rotation

Chapter 8: Student Questions

Lecture 1: Counter for List of Information

Lecture 2: Use highlighted values to find statistics

Lecture 3: Summing Across Worksheets with Blank Cells In Between

Instructors

Matthew Fried
Prof.

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 6 votes

4 stars: 14 votes

5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!