Training Calendar

Intermediate Excel

Instructor: Computer Trainings of America
Fee: $233.10

Date: Time: Code: Location:  
May 13, 2019 9:00am - 4:00pm PD007.190513CTAIME Palmer, MA REGISTER NOW
Jun 12, 2019 9:00am - 4:00pm PD007.190612CTAIME Palmer, MA REGISTER NOW
Jun 21, 2019 9:00am - 4:00pm PD007.190621CTAIME Palmer, MA REGISTER NOW
Jul 10, 2019 9:00am - 4:00pm PD007.190710CTAIME Palmer, MA REGISTER NOW
Jul 19, 2019 9:00am - 4:00pm PD007.190719CTAIME Palmer, MA REGISTER NOW


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