Microsoft Excel Macros Made Easy:  Working with Interactive & Multiple Worksheets

Length: 1 day
Software Version:  2007/2010
Prerequisites: Intermediate to advanced knowledge of MS Excel required.  No programming experience necessary

Target Student:  Simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.

Course Objectives

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

• create, edit, and debug a macro.

• format worksheets using macros.

• create an interactive worksheet.

• work with multiple worksheets.

• perform calculations.

Course Content

Lesson 1: Developing Macros

Create a Macro with the Macro Recorder

Edit a Macro

Debug a Macro

Customize the Quick Access Toolbar and Hotkeys

Work with Macro Security

Lesson 2: Formatting Worksheets Using Macros

Insert Text

Format Text

Sort Data

Duplicate Data

Generate a Report

Lesson 3: Creating an Interactive Worksheet

Determine the 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

BACK