Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

04 Excel VBA Tools & Advanced Conditional Logic

Current Status

Not Enrolled

Price

$20.00

Get Started

Course Content

Essential Tools & Advanced Conditional Logic
Intro to Essential Tools and ACL (Plus Download Kit)
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 Assignment
Random Password Generator Solution Video
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 Project Breakdown
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
User Defined Functions 101
User Defined Functions - Optional Parameters
Volatile vs Non-Volatile Functions
Essential Tools and ACL Quiz 1 Quiz
BONUS Section - VBA Functions
InStr Function - Search for Text Within Other Text
The EVALUATE Function - Mac-Daddy of all functions
Sum Function in Excel VBA - EASY!
Count Function in VBA

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram