Excel Programming with VBA
IDCVBA

Hands-on Training from Experts Live Online

Explore how to automate tasks in Excel using VBA to streamline workflows and increase efficiency. You'll write macros, use loops and logic statements, and build custom functions to enhance spreadsheet functionality. This hands-on class is ideal for those with prior Excel experience looking to deepen their technical skills.

This course includes

  • 12 hours of live, project-based training from experts
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

VBA (Visual Basic for Applications) is the programming language built into Microsoft Excel. With VBA, you can automate repetitive tasks and streamline your workflow.

In this hands-on course, you’ll learn the basics of VBA programming through real-world applications of macros and Excel automation. You’ll discover how to automate routine processes, create custom commands, build new worksheet functions, and more.

Read more

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
  • Write and run basic macros to automate tasks
  • Use macros to format worksheets efficiently
  • Build interactive worksheets using VBA elements
  • Automate tasks across multiple worksheets
  • Perform calculations using VBA to enhance spreadsheet functionality

Unit 2 6 Hours

Excel VBA and Macros Level II
  • Navigate a workbook using offsets, named ranges, and variables
  • Analyze data using looping structures in combination with If and Case statements
  • Create user interface structures to capture multiple variable inputs
  • Control the lifespan and scope of variables
  • Create automated event-driven processes
  • Create automation to handle unexpected errors and events

Schedule & Enrollment: Excel Programming with VBA

  • 12 Hours
  • Price before discounts: $690 Full tuition: $549
  • Live Online
  • Expert instructors
  • Small classes

Show more
A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

Related Courses: Compare to Excel Programming with VBA

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

  • Excel Bootcamp
    18 hours $549

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

  • Excel Level III: Advanced
    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.

  • Excel Level II: Intermediate
    6 hours $249

    Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.