Excel 2010 - Level 2

Course details

Students will learn how to use multiple worksheets and workbooks efficiently, start working with more advanced formatting options including styles, themes, and backgrounds, learn how to create outlines and subtotals, work with tables and add hyperlinks.

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 - Tables

• Sorting and filtering data
• Advanced filtering
• Working with tables

6 - Web and sharing features

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

7 - Advanced charting

• Chart formatting options
• Combination charts
• Graphical elements

8 - Documenting and auditing

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

9 - Templates and settings

• Changing application settings
• Using built-in templates
• Creating and managing templates

10 - PivotTables and PivotCharts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• Using PivotCharts

Target Audience: This course is intended for students who have some experience using Microsoft Excel. Students will get the most out of this course if their goal is to become proficient in such tasks as consolidating data, using advanced chart formatting options, sorting and filtering data, using special formatting options, using templates, using error tracing features, protecting worksheets, and linking worksheets and workbooks.