Advanced Excel Class

DESCRIPTION

This workshop is intended for Excel users who want to learn to use the program more efficiently, have it automate tasks for them and work with functions and data analysis tools. Class discussion and exercises cover --
Using named ranges for workbook navigation and formula development,
How to define and apply format style sheets,
Linking cells in separate Excel workbooks,
Recording and modifying macros,
How to decide what steps to include in a macro,
Relative and absolute cell references, when to use each in a macro,
Creating new and customizing existing toolbars,
Use of Excel's data analysis features, including pivot tables.

6 hours, $260 (available for Windows and Macintosh)
Purchase with Excel for discounted package price of $430.

PREREQUISITES

Knowledge of fundamental Excel operations, including entry of data and formulas, autofill, relative and absolute cell references, worksheet formatting, autosum and IF function, sorting and charting.

RELATED CLASS

Excel

LOCATION

Public sessions are offered monthly in Boston, Massachusetts (see directions). Private sessions can be scheduled either at our location or yours.

REGISTRATION

Check our current schedule to see when this class is next offered.
To register, call (866) 720-7171 (toll-free), or Register On-Line.

MAILING LIST and FURTHER INFORMATION

To receive our monthly schedule, join our mailing list.

For further information, please contact us at --
. . Phone: (866) 720-7171 (toll-free)
. . E-mail: info@computerimages.com.

Class Schedule · Excel Technical Support · Excel Tips