The Range Object
  • Course Intro and Download Kit
  • Get the Developer Ribbon (PC and Mac)
  • What Is The Range Object and Your First Macro From Scratch
  • Adding Secondary or Subsequent Commands
  • Debugging in Excel VBA and Stepping Through Code
  • Three Easy Ways To Test Or Store A Value
  • How and When To Record a Macro (Plus Clean Up Tips)
  • Three Main Data Type Notations For Entering Into Cells
  • Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)
  • Exercise 01 - Objectives Overview
  • Exercise 01 - Solution
  • Affecting Multiple Cells With One Range Command
  • Using a Named Range with the Range Object
  • Tips and Best Practices For Better Development Skills
  • Range Object Quiz
Range Properties
  • VALUE, TEXT and FORMULA Properties - Reading and Writing Functions To a Cell
  • Row and Column Properties
  • SELECT Method
  • COUNT Property
  • Exercise 02a - Objectives Overview
  • Exercise 02a - Solution
  • ADDRESS Property
  • NUMBERFORMAT Property
  • FONT Collection - BOLD, ITALIC, UNDERLINE Properties
  • Exercise 02b - Objectives Overview
  • Exercise 02b - Solution
  • Add Color To Cells, Inside and Out (4 Ways)
  • Properties Quiz
The Cells Object
  • Intro To The Cells Object
  • Using The Cells Object and Practical Applications
  • Using Column Letters instead of Numbers
  • Using Cells Positionally within a Range
  • Affecting ALL Cells in a Worksheet
  • Exercise 03 - Objectives Overview
  • Exercise 03 - Solution
  • Using Range Object With Cells Object (To Affect Multiple Cells)
  • Cells Quiz
Variables
  • Intro to Variables
  • Math With Variables
  • Variable Declaration and Different Variable Types
  • Variable Type Demonstration
  • String Manipulation - Concatenation Examples
  • String Manipulation - Len, Left, Right Functions
  • String Manipulation - Mid Function (2 Methods)
  • String Manipulation - Replace Function
  • String Manipulation - Format Function
  • String Manipulation - InStr Function and Practice Projects
  • Date and Time Functions and Fun DateTime Math Tricks
  • CDate and DateDiff Functions
  • Exercise 04 - Objectives Overview
  • Exercise 04 - Solution
  • Scope and Heirarchy of Variables and Procedures
  • VARIABLE SCOPES - Public, Private and other Variables
  • Procedural Scopes - Public Versus Private Subs, Option Private Module
  • Using Constants
  • Passing Values to Another Procedure - ByRef vs ByVal
  • Variables Quiz
Toolbars and Menus
  • File Menu Walkthrough
  • Edit Menu Walkthrough
  • View Menu Walkthrough Pt 1
  • View Menu Pt 2 - Watch Window, Locals Window and Immediate Window
  • Insert, Format and Debug Menu Walkthrough
  • Run and Tools Menu Walkthrough
  • Toolbars Quiz
Super Important Tools and Excel Logic
  • Three Ways To Access Other Sheets - Sheet Name, Index and CodeName
  • Get the Last Row of Your Data Set
  • Get the Last (Rightmost) Column of Your Data Set
  • Get the Next Row in Your Data Set - Data Entry Basics
  • Recording a Macro 101
  • Dynamically Sorting The Employee Data
  • Absolute vs Relative References and OFFSET() Function
  • R1C1 Notation and How To Use In Formulas
  • Using Worksheet Functions in the VBE
  • Random Password Generator - Objectives Overview
  • Random Password Generator - Solution
  • Using With and End With
  • If Then Statement
  • Using Is Not Equal To And The NOT Operator
  • AND, OR and NOT Operators
  • Exercise 06a - Objectives Overview
  • Exercise 06a - Solution
  • Using ELSE and ELSEIF Commands
  • Rock, Paper, Scissors Game - Objectives Overview
  • Rock, Paper, Scissors Game - Solution
  • The LIKE Operator
  • Compare Strings With Case Insensitivity Using UCase and LCase
  • Comparitive Operators With Text and Numbers (IsNumeric Function)
  • Two Ways to Use If Then Statements in a One-Liner of Code
  • Using GOTO and Labels, Common Uses, Error Routing
  • Select Case as Alternative to IF THEN Statements
  • Advanced MessageBox Features
  • User Interaction - Message Box with Yes, No Buttons
  • Exercise 06b - Objectives Overview
  • Exercise 06b - Solution