Excel Training - Intermediate v2007/2010

By the end of the day you will know how to:

Use multiple workbooks
Use advanced formatting
Outline and subtotal
Create and use names
Use filters and lists
Work with tables
Work with the web
Use advanced charting
Use group features such as auditing
Create and manage document templates

-Proposed Course Outline:

Microsoft Excel course content:

Using multiple excel worksheets and workbooks

Using multiple excel workbooks
Linking worksheets with 3-D formulas
Linking excel workbooks
Managing excel workbooks

Advanced formatting

Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting

Outlining and subtotals

Outlining and consolidating data
Creating subtotals

Cell and range names

Creating and using names
Managing names

Lists and tables

Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables

Web and Internet features

Saving workbooks as Web pages
Using hyperlinks
Distributing workbooks

Advanced charting

Chart formatting options
Combination charts
Graphic elements

Documenting and auditing

Auditing features
Comments in excel cells and workbooks
Workgroup collaboration

Templates and settings

Application settings
Built-in templates
Creating and managing excel templates

No pre course work is required for this excel training course, however delegates must be proficient in excel or have attended the new users course.

This course is delivered over 1 day.

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office.

Public Courses - 225.00 per delegate

In-house Courses - 625.00 per day*

Guide Price: 625 per day

Delivery: In house
Category: Intermediate Microsoft Excel »

Search for intermediate microsoft excel courses in