Excel - VBA Bootcamp

This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA).

Excel - VBA Bootcamp

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively.


Course Details

Course Outline

1 - Introduction to Macros
  • Recording Macros
  • Absolute and Relative
  • How to Run a Macro
  • 2 - Basics of Code Writing
  • The VBA Environment (the “VBE” window)
  • Essential Tips, Tricks, Shortcuts
  • Understanding VBA and Best Practice
  • 3 - Crucial VBA Objects and Structures
  • Variables and Data Types
  • Conditionals (If, Select Case)
  • Loops (For, Do)
  • 4 - Interaction
  • Interact with Data, Sheets, the Excel Application
  • Interact with User (Message Box, Input Box)
  • 5 - Errors
  • Run
  • Editing
  • Debuging
  • Handeling Errors
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.

    Excel - VBA Bootcamp

    Course Length : 1 Day

    1. Choose a Date | 2. Click Enroll Now [G2R=Guaranteed to Run]

    Need Help Picking the Right Course? Give us a call! 01 8898700