Excel VBA Advanced Tutorial

Dive into advanced Excel VBA techniques in this comprehensive tutorial designed for Business Analysts, Data Scientists, and Excel power users. Learn to automate repetitive processes and create custom tools using Visual Basic for Applications (VBA). Master foundational concepts such as building macros from scratch, starting with simple recorded macros and progressing to complex functions using Loop, If Then, and other advanced VBA concepts. Explore Worksheets Methods, DateSerial and Format functions, and create a Sheet Template Generator. Discover how to manipulate worksheets with Move, PrintOut, and PrintPreview methods. Engage in hands-on practice sessions and learn to develop custom functions to extend Excel's capabilities. With exercise files provided, follow along and apply your new skills immediately. By the end of this 1 hour and 15 minutes tutorial, you'll be equipped to write your own rulebook on what's possible in Excel using VBA.

Start
Worksheets Methods

DateSerial and Format

Sheet Template Generator

Move

PrintOut and PrintPreview

Practice Part 1

Practice Part 2

Practice Part 3

Practice Part 4

Practice Part 5

Practice Part 6

Custom Functions Part 1

Custom Functions Part 2

Custom Functions Part 3

Wrapping Up