Advanced Excel provides experienced users with advanced concepts beyond those taught in introductory Excel courses.

The course begins with a review of the basic worksheet commands. Advanced commands are introduced for maximum productivity in worksheet development and modification. The use of macros commands is presented to automate spreadsheet operations. The course includes database management and related commands. Additional "=" functions are covered, as well as advanced graph development. All sessions include course exercises on prepared diskettes.

More than 70% of the course is hands on use of Excel.

• Appreciate the value of the integrated nature of Excel with exercises which utilize all the major areas;
• Use multiple windows to link worksheet formulas;
• Understand, create and use Macros to automate functions;
• Advanced printing options
• Use the Data Find and Extract commands to search the database by various conditions;
• Use sophisticated Excel financial, database statistical, and other "=" functions; and
• Use advanced graph options

Target Audience: This course is useful for professional, managerial and administrative personnel at all levels. Introductory training in Excel is required and hands-on practice is recommended.

•Customizing the Work Area

•Working the existing toolbars

•Creating a new toolbar

•Creating and using styles

•Creating templates

•Advanced Formula Construction

•Nesting functions

•The IF function

•The VLOOKUP function

•Troubleshooting

•Notes

•Error handling and the Auditing features

•Multiple File Linking

•Working with workbooks

•Linking individual cells

•Maintaining worksheet links

•Workspaces •Workbook versus linked files

•Outlining and Consolidating Information

•Outlining

•Consolidating worksheets

•Protect and Display Options

•Protecting the worksheet

•Hiding information

•View Manager

•Pivot Tables

•Creating pivot tables

•Working with pivot tables

•Viewing pivot tables at different levels

•Advanced Topics

•Analysis tools

•Importing and exporting files

•Compatability with other applications