Training Calendar

Intermediate Excel

Instructor: Computer Trainings of America
Fee: $233.10

Intermediate Excel will cover the following:

Using multiple worksheets and workbooks:

Using multiple workbooks

Linking worksheets with 3-D formulas

Linking/managing workbooks

Advanced formatting:

Using special number formats

Using functions to format text

Working with styles and themes

Outlining and subtotals:

Outlining and consolidating data

Creating subtotals

Cell and range names:

Creating/ using/ managing names


Sorting and filtering data

Advanced filtering

Working with tables

Web and Sharing features:

Saving workbooks as Web pages

Using hyperlinks

Sharing workbooks

Advanced charting:

Chart formatting options

Combination charts

Graphic elements

Documenting and auditing:

Auditing features

Comments in cells and workbooks


Workgroup collaboration

Templates and settings:

Application settings

Built-in templates

Creating and managing templates

PivotTables and PivotCharts:
Working with PivotTables

Rearranging PivotTables

Formatting PivotTables

Using PivotCharts