excel.jpg (1173 bytes)
Excel for Power Users

Macros

The objective of this advanced course is to provide maximum student productivity on Excel, using more advanced commands for worksheet development and modification. Excel macros can be a tremendous time and effort saver. Macros also enable the user to create customized applications which may even look quite different from a spreadsheet, with dialogs and custom menus. More than 70% of the course is hands-on use of Excel.

Prerequisites: Advanced Excel

Learning Objectives: After completing this course, a participant will be able to:

* Plan and design macros

* Name and invoke macros

* Test and "debug" macros

* Assemble macro libraries

* Connect and loop macros

* Create decision-making macros

* Formulate "user-friendly" menu-driven macros including

- Dialog boxes

- Menu Bars

- Check Boxes

- Scrolling Lists

* Apply these functions to all applications including:

- Data entry

- "What if" and financial ledgers

- Database management

- Graphs

Target Audience: This course is useful for professional, managerial and administrative personnel. Familiarity with the basics of Excel is required.

 

Excel Macros Topics Included

 

Planning macros

Creating

Documenting

Recording

Debugging Techniques

Command Macros

Function Macros

Using Arguments

Absolute and Recording

Macro Sheets - Organizing, Documenting, Formatting

Dialog Box Functions

INPUT

ALERT

MESSAGE

WAIT

IF

Value-returning functions

Auto-executing macros

Customized menus and dialog boxes

Menu Bars

Menus and Commands

Graying Choices

Item Column

Text Columns

Custom Help

Protecting and Hiding macros

Speeding up macros