This course is designed for persons desiring to customize workbooks, work with multiple data sources, collaborate with others using shared workbooks, and enhance worksheets using charts and graphic objects.

Upon successful completion of this course, users will be able to:

• Customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data.
• Work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query.
• Collaborate with other Excel users by protecting your workbook, sharing your workbook, setting revision tracking, merging multiple copies of the same workbook, and tracking changes.
• Chart non-adjacent data, modify chart items, and create a trendline.
• Use multiple graphic objects to enhance your worksheet.

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

• Windows 2000 Introduction
• Excel 2002 Beginning
• Excel 2002 Intermediate

Minimum 8
Maximum 12