Microsoft Excel VBA 2010 Level 1

Overview

Course Objective: You will automate your job tasks in Microsoft Office Excel 2010.

Course Objective:

You will apply automation to job tasks in Microsoft Office Excel 2010.

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

The Career Center Course Curriculum for Microsoft Excel 2010 VBA:

Lesson 1: Developing Macros

• Topic 1A: Create a Macro with the Macro Recorder
• Topic 1B: Edit a Macro
• Topic 1C: Debug a Macro
• Topic 1D: Customize the Quick Access Toolbar and Hotkeys
• Topic 1E: Work with Macro Security

Lesson 2: Formatting Worksheets Using Macros

• Topic 2A: Insert Text
• Topic 2B: Format Text
• Topic 2C: Sort Data
• Topic 2D: Duplicate Data
• Topic 2E: Generate a Report

Lesson 3: Creating an Interactive Worksheet

• Topic 3A: Determine the Dialog Box Type
• Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

• Topic 4A: Insert, Copy, and Delete Worksheets
• Topic 4B: Rename Worksheets
• Topic 4C: Modify the Order of Worksheets
• Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

• Topic 5A: Create User-Defined Functions
• Topic 5B: Automate SUM Functions