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,
How to make date and time calculations in Excel,
How to use functions in Excel and the specific application of commonly used functions,
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 class 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, Excel 2007

LOCATION

Public classes are offered monthly at 15 Court Square, Boston, Massachusetts (see directions). Private training 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 --
. . Phone: (866) 720-7171 (toll-free)
. . E-mail: info@computerimages.com.

Class Schedule · Excel Technical Support · Excel Tips