Microsoft Excel 2003, Advanced -

This course is designed for persons who want to gain advanced skills necessary to utilize the specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. Topics include creating macros, collaborating with others, auditing and analyzing worksheet data, incorporating multiple data sources, and importing and exporting data.

Upon successful completion of this course, students will be able to: • Formulas and functions: Financial, Logical, Text, • Statistical formulas; Summary options, • Absolute Referencing and how to Link worksheets & work books. • Creating and maintaining Databases (Pivot tables, Concatenation). • Applying Formatting Options. • Creating, revising, and formatting Charts to illustrate your spreadsheets • Creating Macros, Templates; Inserting Comments; Auditing formulas and identifying errors

ZMSA

1131