Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn VBA Fundamentals (Excel)
Chapter 1 > Using Excel Magic to Improve Our Trading
Excel VBA – Why are we learning this?
Playing a Trading Game with Excel VBA (2:59)
Download Code for Excel VBA Chapter
Simple Demonstrations with Excel VBA (6:07)
Setting up your Excel for VBA (3:32)
Warning! Trust Settings and Setting up Developer Tabs
Before you take this course
Chapter 2 > Referring to Sheets, Cells and Variables
Referencing Cells and Sheets (Part 1) (6:29)
Referencing Cells and Sheets (Part 2) (4:07)
Summary Notes - Referencing Cells and Sheets
VBA Basic Error Handling - Managing Erroneous Code
Exercise on Referencing
VBA Syntax - Structure of VBA Code (2:53)
VBA Variables - Basic Building Blocks that Store/Do Stuff (6:10)
VBA Reserved Words - Words You Cannot Use
VBA Intro to Data Types - Different Types of Variables (6:15)
VBA List of Data Types
VBA Operators, Intermediate Window and Buttons (6:51)
Chapter 3 > If A happens, do B - Conditional Statements
VBA Conditionals - If This then That (6:41)
Comparison and Logical Operators
Exercise on Conditionals
Worksheet Functions (aka Excel Functions in VBA) (3:35)
List of VBA Worksheet Functions
VBA Functions - Using In-Built VBA Functions (9:22)
List of VBA Functions
Chapter 4 > Do Something Many Times - Loops
For Loops - Do Something Many Times (7:46)
Do While Loops - Do Something Many Times (in another way) (4:36)
Multi-step Loops - Jumps of more than 1 (2:28)
Exercise on Loops (Part 1)
Nested Loops (Loops within loops) and Indentations (5:20)
Exercise on Loops (Part 2)
Other Types of Loops
Breaking out of Loops
Infinite Loops - Loops that go on forever
Chapter 5 > Mini Project - Help the Finance Guy
VBA Self-Learning - Be a problem solver
VBA Mini Project - Help the Finance Guy
Playing a Trading Game with Excel VBA
Complete and Continue