Excel 2007 - Level 2
Location: Latham
Use multiple worksheets, advanced formatting, outlining and subtotals.
Create cell names and use lists features. Enhance charts, document and
audit worksheets. and standardize data entry with templates.
Recommended Preparation:
Excel 2007 - Level 1 or equivalent knowledge
Lesson 1: Using multiple worksheets and workbooks
- Linking worksheets by using 3-D formulas
- Linking workbooks
- Managing workbooks
Lesson 2: Advanced formatting
- Borders and shading
- Using special number formats
- Working with dates
- Working with styles
- Other advanced formatting
Lesson 3: Outlining and subtotals
- Outlining and consolidating data
- Creating subtotals
Lesson 4: Cell names
- Creating and using names
- Using names in multiple worksheets
Lesson 5: Lists and tables
- Examining lists
- Sorting and filtering lists
- Advanced filtering
- Working with tables
|
|
Lesson 6: Advanced charting
- Chart formatting options
- Combination charts
- Graphic elements
Lesson 7: Documenting and auditing
- Auditing features
- Comments in cells and workbooks
- Protection
- Workgroup collaboration
Lesson 8: Templates and settings
- Application settings
- Built-in templates
- Creating and managing templates
Optional Topic: Web features
- Saving workbooks as Web pages
- Using hyperlinks
- Sending workbooks via e-mail
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3216 |
Thur Oct 21 |
8:30am-4:30pm |
|
