Microsoft Excel 2003 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Excel 2003 Level 1 or equivalent experience. |
| Course Materials: | Course manual (084261S3) |
| 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: | In this class, students will use Microsoft® Excel 2003 to create and apply templates, create and modify charts, work with graphics, calculate with advanced formulas, and sort and filter data. |
Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools
Creating and Modifying Charts
Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram
Working with Graphic Objects
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup and Reference Functions
Calculate with Logical Functions
Sorting and Filtering Data
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet
Using Excel with the Web
Export Excel DataPublish a Worksheet to the Web
Import Data from the Web
Create a Web Query