Microsoft Excel 2003 - Level 2
Location: Colonie
Course Outline: This course teaches intermediate-level features and
functions of Excel 2003. Students will learn how to work with large worksheets,
use 3-D formulas, customize Excel's toolbars and menus, apply special cell
formatting, sort and filter lists, create combination charts and trendlines, use
Excel's auditing features, and work with templates.
Prerequisite(s) or equivalent knowledge:
Excel 2003 - Level 1
Outline:
- Working with large worksheets
- Viewing options
- Hiding, displaying, and outlining data
- Printing large worksheets
- Using multiple worksheets and workbooks
- Using multiple worksheets
- Linking worksheets by using 3-D formulas
- Consolidating data
- Linking workbooks
- Managing workbooks
- Customizing Excel
- Using the Options dialog box
- Customizing toolbars and menus
- Advanced formatting
- Borders and shading
- Using special number formats
- Working with dates
- Working with styles
- Other advanced formatting
- List management
- Examining lists
- Sorting and filtering lists
- Advanced filtering
- Advanced charting
- Chart formatting options
- Using combination charts
- Using graphic elements
- Documenting and auditing
- Auditing features
- Comments and text boxes
- Protection
- Workgroup collaboration
- Using templates
- Built-in templates
- Creating and managing templates
| Course Fee: |
$199 |
Members: |
$189 |
|
|
|
|
|
Upcoming Class Schedules |
| # 9107 |
Tues Oct 28 |
8:30am-4:30pm |
| # 9108 |
Tues Dec 2 |
8:30am-4:30pm |
|
