Excel 2003 - Level 2
Location: Latham
Work with large worksheets, link and consolidate data, customize the
Excel environment, enhance charts, use advanced formatting features,
create and manage lists, document and audit workbooks, create templates.
Recommended Preparation:
Excel 2003 - Level 1 or equivalent knowledge.
Lesson 1: Working with large worksheets
- Viewing options
- Zooming in and out on a large
Worksheet
- Hiding/displaying data
- Printing large worksheets
Lesson 2: Multiple worksheets and workbooks
- Linking worksheets using 3-D formulas
- Consolidating data
- Linking workbooks
Lesson 3: Customizing Excel
- Changing options
- Customizing toolbars and menus
Lesson 4: Advanced charting
- Formatting chart options
- Creating combination charts
- Adding graphic elements
|
|
Lesson 5: Advanced formatting
- Borders and shading
- Special number formats
- Dates
- Styles
- Other advanced formatting
Lesson 6: List management
- Creating lists
- Sorting and filtering lists
- Advanced filtering
Lesson 7: Documenting and auditing
- Comments and text boxes
- Auditing features
- Protection
Lesson 8: Using templates
- Built-in templates
- Creating and managing templates
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3105 |
Thur Sept 16 |
8:30am-4:30pm |
|
