Excel Macros

This course teaches participants how to create custom toolbars & menus, as well as, templates in Excel.

Overview

Students will gain competency in customizing the Excel interface, using templates, using custom chart types, using workbook collaboration features, using workbook integration and XML features, creating and editing macros, controlling macro assignments and functionality, and troubleshooting macros.

Guided, step-by-step labs will provide opportunities to practice new skills.

Audience

This course assumes a basic knowledge of the Excel.

Length

8 hours

Outline

Topics covered in this course include:

Customizing the Excel Interface

Using Templates and Custom Chart Types

Using Advanced Integration and XML Features

Creating Macros

Editing Macros

Controlling Macro Assignments

Troubleshooting Macros