Skip Ribbon Commands
Skip to main content

ExcelVBA2010 - Microsoft Excel 2010: VBA Basics


Duration: 1 Day




Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​This course is intended for advanced Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). This is a great course for the advanced user of Excel and for helpdesk or support staff working in an intensive Excel environment.

Course Objectives

You will automate your job tasks in Excel 2010 using VBA.

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

  • develop a macro.
  • format worksheets using macros.
  • create an interactive worksheet.
  • work with multiple worksheets.
  • perform calculations.

Course Audience

​Anyone interested in learning higher-level techniques to optimize productivity using Excel 2010.

Course Outline

Developing Macros

  • Create a Macro Using the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and
  • Hotkeys
  • Set Macro Security
Formatting Worksheets Using Macros
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report
Creating an Interactive Worksheet
  • Determine the Dialog Box Type
  • Capture User Input
Working with Multiple Worksheets
  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets
Performing Calculations
  • Create User-Defined Functions
  • Automate SUM Functions

Course Prerequisites

​Proficient knowledge of Excel 2010. Knowledge of PivotTables helpful but not required.

Course Schedule
This course is not scheduled yet.