Back to Search Results

Training Course Summary:

On this one day course, students will customize their workbooks, work with multiple data sources, collaborate with other users, enhance their spreadsheets using charts and graphic objects.

Pre-Requisites:

Windows 2000: Introduction
Excel 2002: Level 1
Excel 2002: Level 2

Training Course Overview/Content:

Apply conditional formatting, add data validation criteria, customize menus and toolbars, create, edit, and run macros. The student will also view data using the outline.
Create a workspace, consolidate data, and view the consolidated data and link cells.
Protect their worksheet, protect their workbook, add and remove file passwords, share their workbooks, Set revision tracking, merge workbooks, and track changes.
Chart non-adjacent data, modify embedded charts, and modify chart items, and add a trend line to their chart.
Create, change the order of, group, move and copy, and format graphic objects. They will also insert and modify clipart.