Microsoft Excel 2002 Advanced
| Duration: | 1 day |
| Prerequisite: | Microsoft Excel 2002 Level 2 or equivalent experience. |
| Course Materials: | Course manual ((084202S3)) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| 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. |
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