Microsoft Excel 2007 - Level 2
Location: Colonie
Overview: This course builds on the skills and concepts taught in
Excel 2007 - Level 1. Students will learn how to use multiple worksheets and
workbooks efficiently, and they will start working with more advanced formatting
options including styles, themes, backgrounds, and watermarks. They will also
learn how to create outlines and subtotals, how to create and apply cell names,
and how to work with lists and tables. Students will save workbooks as Web
pages, insert and edit hyperlinks, and save a workbook as a PDF file. This
course also covers advanced charting techniques, worksheet auditing and
protection, file sharing and merging, and workbook templates.
Prerequisite(s) or equivalent knowledge: Excel
2007 - Level 1
Course Outline:
- Using multiple worksheets and workbooks
- Using multiple workbooks
- Linking worksheets with 3-D formulas
- Linking workbooks
- Managing workbooks
- Unit 2: Advanced formatting
- Using special number formats
- Using functions to format text
- Working with styles
- Working with themes
- Other advanced formatting
- Unit 3: Outlining and subtotals
- Outlining and consolidating data
- Creating subtotals
- Unit 4: Cell and range names
- Creating and using names
- Managing names
- Unit 5: Lists and tables
- Examining lists
- Sorting and filtering lists
- Advanced filtering
- Working with tables
- Unit 6: Web and Internet features
- Saving workbooks as Web pages
- Using hyperlinks
- Distributing workbooks
- Unit 7: Advanced charting
- Chart formatting options
- Combination charts
- Graphic elements
- Unit 8: Documenting and auditing
- Auditing features
- Comments in cells and workbooks
- Protection
- Workgroup collaboration
- Unit 9: Templates and settings
- Application settings
- Built-in templates
- Creating and managing templates
| Course Fee |
$199 |
Members |
$189 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 9500 |
Fri Oct 10 |
8:30am-4:30pm |
|
