Microsoft Excel 2002 Level 3
Customizing your Workbook
Apply Conditional Formatting
Add Data Validation Criteria
Customize Menus
Customize Toolbars
Create a Macro
Edit a Macro
Group and Outline Structured Data
Working with Multiple Data Sources
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Export Excel Data as XML
Import XML Data into Excel
Create a Web Query
Collaborating with Others Using Workbooks
Protect your Worksheets
Protect Your Workbook
Share Your Workbook
Set Revision Tracking
Merge Workbooks
Track Changes
Enhancing Your Worksheet Using Charts
Chart Non-adjacent Data
Modify Chart Items
Create a Trendline
Using Graphic Objects to Enhance your Worksheets
Create Graphic Objects
Resize, Move, and Copy Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Format Graphic Objects
Insert Clip Art
Modify Clip Art
Class Information
Duration: 1 day
Prerequisite: Microsoft Excel 2002 Level 2 or equivalent experience.
Course Materials: Course manual (084202S3)
Description: Students will customize their workbook, work with multiple data sources, and collaborate with others using shared workbooks. They will also enhance their worksheets using charts and graphic objects.
Student Comments
Susan is an exceptional instructor. I learned a lot, and now it is up to me to practice and utilize learning applications.
—Excel, Level 3
Very informative and useful for work related issues.
—Excel, Level 3
Great! Well worth it!
—Excel, Level 2