Excel Programming with VBA (Self-Paced)

Self-paced online training with expert support 2 modules

In this hands-on course, you'll learn how to automate repetitive tasks in Microsoft Excel using VBA programming. You'll create macros, custom commands, and new worksheet functions that streamline your Excel workflow and help you accomplish more in less time.

$549 12 clock hours Live Support Start anytime

This course includes

  • 12 hours of project-based training from experts
  • Software Access
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion

VBA (Visual Basic for Applications) is the programming language built into Microsoft Excel. With VBA, you can take repetitive tasks in Excel and put them on autopilot.

In this hands-on class, you'll learn the fundamentals of VBA programming by working through real-world applications of macros and Excel automation. You'll learn how to automate repetitive operations, create custom commands, develop new worksheet functions, and more.

Read more

This course has a prerequisite

No prior VBA programming knowledge is required, though knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

Download Syllabus PDF

Unit 1 6 Hours

Excel VBA and Macros Level I (Self-Paced)

Learn how to build macros, run calculations, and more in this beginner VBA and Macros course. From getting familiar with macros and VBA to writing and editing your own code, this course walks you through the essential skills you'll need to automate Excel and boost your productivity.

  • Write and run basic macros to automate everyday tasks
  • Apply macros to format worksheets quickly and efficiently
  • Build interactive worksheets using VBA elements
  • Automate tasks across multiple worksheets at once
  • Run calculations using VBA to expand what your spreadsheets can do

Unit 2 6 Hours

Excel VBA and Macros Level II (Self-Paced)

Learn VBA and macros to automate tasks and expand Excel's capabilities. This course walks you through the VBA Editor, writing and editing code, working with objects, logic statements, functions, looping, interactive code, and error handling.

  • Write and edit VBA code in the VBA Editor and invoke macros to automate repetitive tasks
  • Navigate workbooks using offsets, named ranges, and variables, while controlling variable lifespan and scope
  • Analyze data with looping structures paired with If and Case statements
  • Build user interface structures that capture multiple variable inputs interactively
  • Create automated, event driven processes and handle unexpected errors and events gracefully

Related Courses: Compare to Excel Programming with VBA (Self-Paced)

These related courses share skills and topics with Excel Programming with VBA (Self-Paced). Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • Excel Bootcamp Online (Self-Paced)
    18 hours $549

    Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

  • Excel Level III: Advanced Course Online (Self-Paced)
    6 hours $249

    Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.

Yelp Facebook LinkedIn YouTube Twitter Instagram