Excel 2013 - Level 2

Course details

How to work with large worksheets and advanced formatting techniques. How to create outlines and subtotals. Sort and filter data. Create and format tables. Audit worksheets for errors, protect work-sheets, share and merge and track changes in a workbook.

Course Outline

1 - Managing workbooks and worksheets

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
• Linking worksheets with 3-D formulas
• Using multiple workbooks
• Linking workbooks

2 - Advanced formatting

• Using special number formats
• 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 - Data structure and tables

• Sorting and filtering data
• Working with tables

6 - Web and sharing features

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

7 - Documenting and auditing

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

8 - Application settings and templates

• Application settings
• Working with templates

Target Audience: This course is for students to gain a farther understanding of Excel 2013.