| |
|
| |
Excel 2002 - Level 3 Training Class
Course ID: 5965
|
|
| |
|
|
| |
|
|
| |
Excel 2002 - Level 3 Training Seminar
Overview:
In this course you will customize workbooks, work with multiple data sources, collaborate with other users, enhance spreadsheets using charts and graphic objects.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Customizing Your Workbook
Apply Conditional Formatting
Add Data Validation Criteria
Customize Menus
Customize Toolbars
Create a Macro
Editi a Macros
Group and Outline Structured Data
|
|
Lesson 2: Working with Multiple Data Sources
Creating a Workspace
Consolidate Data
Link Cells in Different Workbooks
Editi Links
Export Excel Data as XML
Import XML Data into Excel
Create a Web Query
|
Lesson 3: Collaborating with Others using Workbooks
Protect Your Worksheets
Protect Your Workbook
ShareYour Workbook
Set Revision Tracking
Merge Workbooks
Track Changes
|
Lesson 4: Enhancing Your Worksheet using Charts
Chart Non-adjacent Data
Modify Chart Items
Create a Trend Line
|
Lesson 5: Using Graphic Objects to Enhance Your Worksheet
Create Graphic Objects
Resize, Moving and Copying Graphic Objects
Change the Order of Graphic Objects.
Group Graphic Objects
Format Graphic Objects
Insert Clip Art
Modify Clip Art
|
|
|
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Excel 2002 - Level 1
Excel 2002 - Level 2
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Excel 2002 - Level 3 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5965
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|