Microsoft Excel 2007 Intermediate

Course Overview

Using multiple worksheets and workbooks

• Using multiple workbooks
• Linking worksheets with 3D formaulas
• Linking Workbooks
• Managing 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
• 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 cells and workbooks
• Protection
• Workgroup collaboration

Templates and settings

• Application settings
• Built-in templates
• Creating and managing templates

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.