MS Excel Advanced

Course Description	This one-day course is designed to provide students with the skills to use Excel 2002's advanced features to customize workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects.
Student Objectives	The course provides students with the skills and knowledge to perform conditional formatting, add data validation criteria, customize menus and toolbars, enable worksheet protection, and modify embedded charts and chart items.
Prerequisites	The prospective trainee should have a firm understanding of intermediate Excel 2002 operations.
Length	1 Day
Recommended Class Size	12
Delivery	Instructor-led, group, structured hands-on activity

Customizing Your Workbook
Applying Conditional Formatting
Adding Data Validation Criteria
Customizing Menus
Customizing Toolbars
Creating a Macro
Editing a Macro
Grouping and Outlining Structured Data

Working with Multiple Data Sources
Creating a Workspace
Consolidating Data
Linking Cells in Different Workbooks
Editing Links
Exporting Excel Data as XML
Importing XML Data in Excel
Create a Web Query

Collaborating with Others Using Workbooks
Protecting Your Worksheets
Protecting Your Workbook
Sharing Your Workbook
Setting Revision Tracking
Merging Workbooks
Tracking Changes

Enhancing Your Worksheet Using Charts
Charting Non-adjacent Data
Modifying Chart Items
Creating a Trend Line

Using Graphic Objects to Enhance Your Worksheet
Creating Graphic Objects
Resizing, Moving, and Copying Graphic Objects
Changing the Order of Graphic Objects
Grouping Graphic Objects
Formatting Graphic Objects
Inserting Clip Art
Modifying Clip Art

Scientific Systems and Software International Corporation
10480 Little Patuxent Parkway, Suite 600 - Columbia, Maryland 21044
410-715-5700 - FAX 410-715-6943