Excel 2007 - Level 2

Course details

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.

Course Outline

1 - Using multiple worksheets and workbooks

• Using multiple workbooks
• Linking worksheets with 3-D formulas
• Linking workbooks
• Managing workbooks

2 - Advanced formatting

• Using special number formats
• Using functions to format text 
• Working with styles 
• Working with themes
• Other advanced formatting

3 - Outlining and subtotals

• Outlining and consolidating data
• Creating subtotals

4 - Cell and range names

• Creating and using names
• Managing names

5 - Lists and tables

• Examining lists
• Sorting and filtering lists
• Advanced filtering
• Working with tables

6 - Web and Internet features

• Saving workbooks as Web pages
• Using hyperlinks
• Distributing workbooks

7 - Advanced charting

• Chart formatting options
• Combination charts
• Graphic elements

8 - Documenting and auditing

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

9 - Templates and settings

• Application settings
• Built-in templates
• Creating and managing templates