This advanced spreadsheet course will learn to use advanced features of Microsoft Excel such as using multiple worksheets and workbooks, create advanced charts, template, documenting and auditing, advance formatting, and work with large worksheets.

Course Outline

Working with large worksheets

Viewing options

Hiding, displaying, and outlining data

Printing large worksheets

Using multiple worksheets and workbooks

Using multiple worksheets

Linking worksheets by using 3-D formulas

Consolidating data

Linking workbooks

Managing workbooks

Customizing Excel

Using the Options dialog box

Customizing toolbars and menus

Advanced formatting

Borders and shading

Using special number formats

Working with dates

Working with styles

Other advanced formatting

List management

Examining lists

Sorting and filtering lists

Advanced filtering

Advanced charting

Chart formatting options

Using combination charts

Using graphic elements

Documenting and auditing

Auditing features

Comments and text boxes

Protection

Workgroup collaboration

Using templates

Built-in templates

Creating and managing templates