Excel Introduction to VBA

Learning Method: Instructor-led Classroom Learning Duration: 2.00 Days


*Click here to view upcoming Excel Intro to VBA classes


Overview:

Students who want an introduction to programming in Visual Basic should sign up for this course!  The class is for anyone who wants to use macros and Visual Basic® to automate repetitive tasks in complex spreadsheets.


Course Objective:

Students will use VBA to create macros for automating repetitive tasks in Excel.


Who Should Take This Class:

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.


Prerequisites:

To ensure students’ success, we recommend they first take the Excel: Levels 1,2 and 3 or have equivalent knowledge.


Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.


Performance-Based Objectives:

Upon successful completion of this course, students will be able to:

  • Develop macros.
  • Format worksheets.
  • Create an interactive worksheet.
  • Work with multiple worksheets.
  • Perform calculations.

Course Outline

Lesson 1: Developing Macros

  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize Toolbars, Menus, and Hotkeys

Lesson 2: Formatting Worksheets

  • Sort Data
  • Insert Rows and Columns
  • Insert Text
  • Format Text
  • Duplicate Data
  • Generate a Report

Lesson 3: Creating an Interactive Worksheet

  • Determine Dialog Box Type
  • Capture User Input

Lesson 4: Working with Multiple Worksheets

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Lesson 5: Performing Calculations

  • Create User-defined Functions
  • Automate SUM Functions
Site Loader