Requisite: Excel 2007-Level 1 or equivalent experience

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
• start working with more advanced formatting options including styles, themes, backgrounds, and watermarks
• learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables
• 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.

Fee:

$150

W10G2

Unit 1: Using multiple worksheets and workbooks
Topic A: Using multiple workbooks
Topic B: Linking worksheets with 3-D formulas
Topic C: Linking workbooks
Topic D: Managing workbooks

Unit 2: Advanced formatting
Topic A: Using special number formats
Topic B: Using functions to format text
Topic C: Working with styles
Topic D: Working with themes
Topic E: Other advanced formatting

Unit 3: Outlining and subtotals
Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Unit 4: Cell and range names
Topic A: Creating and using names
Topic B: Managing names

Unit 5: Lists and tables
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering
Topic D: Working with tables

Unit 6: Web and Internet features
Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks
Topic C: Distributing workbooks

Unit 7: Advanced charting
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphic elements

Unit 8: Documenting and auditing
Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Unit 9: Templates and settings
Topic A: Application settings
Topic B: Built-in templates
Topic C: Creating and managing templates