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!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024