Learn VBA Fundamentals (Excel)
The Introductory Course for Learning Fundamentals of Excel VBA
This course is full at the moment.
Sign up for our wait list here: AlgoTrading101 Wait List
p.s. Current waiting time is about 2 months
Course Curriculum
Chapter 1 > Using Excel Magic to Improve Our Trading
Available in
days
days
after you enroll
-
PreviewExcel VBA – Why are we learning this?
-
PreviewPlaying a Trading Game with Excel VBA (2:59)
-
StartDownload Code for Excel VBA Chapter
-
PreviewSimple Demonstrations with Excel VBA (6:07)
-
StartSetting up your Excel for VBA (3:32)
-
StartWarning! Trust Settings and Setting up Developer Tabs
-
StartBefore you take this course
Chapter 2 > Referring to Sheets, Cells and Variables
Available in
days
days
after you enroll
-
StartReferencing Cells and Sheets (Part 1) (6:29)
-
StartReferencing Cells and Sheets (Part 2) (4:07)
-
StartSummary Notes - Referencing Cells and Sheets
-
StartVBA Basic Error Handling - Managing Erroneous Code
-
StartExercise on Referencing
-
StartVBA Syntax - Structure of VBA Code (2:53)
-
StartVBA Variables - Basic Building Blocks that Store/Do Stuff (6:10)
-
StartVBA Reserved Words - Words You Cannot Use
-
StartVBA Intro to Data Types - Different Types of Variables (6:15)
-
StartVBA List of Data Types
-
StartVBA Operators, Intermediate Window and Buttons (6:51)
Chapter 3 > If A happens, do B - Conditional Statements
Available in
days
days
after you enroll
-
StartVBA Conditionals - If This then That (6:41)
-
StartComparison and Logical Operators
-
StartExercise on Conditionals
-
StartWorksheet Functions (aka Excel Functions in VBA) (3:35)
-
StartList of VBA Worksheet Functions
-
StartVBA Functions - Using In-Built VBA Functions (9:22)
-
StartList of VBA Functions