Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!
What you’ll learn
Automate and Customize data entry forms
Choose the right Loop for each task
Master the CELLS and RANGE objects in multiple scenarios
Create multiple Variable styles to match your need
Customize your VBA Editor and Understand all the Toolbars and options
Debug and Troubleshoot code like a boss!
Record, Modify or Write Macros from scratch
Make Custom Formulas/Functions on the fly
Breeze through IF THEN statements and conquer all the Logical Operators
Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES!
Generate Basic Reports that can be printed
Add filters to report menus to narrow the records
Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. . .
Trigger code from a number of different methods – from Clicking on a cell – to De-Selecting a worksheet.
Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc. . .
Manipulate Userforms for data entry, report generation, editing tables/databases – ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE.
Streamline your work and the work of others.
Put Excel ON AUTOPILOT. . .
Trigger Macros using Worksheet and UserForm Controls (Buttons, Shapes, DropDowns, ListBoxes, Click Actions, Loads of Fun Controls)
Change Cell Properties using code – Cell Color, Font Properties (Bold, Italic, Underline, etc), Borders and more!
Master Bning to Advanced Math with Variables and Learn Proper Use, Declaration and Scope
Learn String Functions, Concatenation and How to Control Case-Sensitivity with VBA Functions
Create Your Own Functions to be used In VBA or in a Cell!
Uncover Advanced Search Functions Only Available in VBA
Fun with Date and Math to Calculate Duration, Length and Intervals
PROJECTS: Create Full Games, Learn From Coding Exercises and Enjoy Mid-Lecture Challenges!
Discover and Master the VBE (Visual Basic Editor) and All the Mysterious Buttons and Features Within!
Deal With Errors and Learn How To Prevent Them
