Excel 2007 Intermediate

Overview

This course will introduce new and existing users of Microsoft Excel to the basic but fundamental features of Spreadsheets and their use. Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format.

Objectives

The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its  facilities. The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves.

Who Should Attend

• New, recent or intended users of Excel who want to gain a good overview of the product in a short space of time
• Existing users of Excel who feel that they are not making best use of its facilities
• Users who are converting from another Spreadsheet package to Excel or upgrading

Content:

• Using multiple worksheets and workbooks
• Using multiple workbooks
• Linking worksheets with 3-D formulas
• 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 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

Prerequisites

• A working knowledge of PCs and a mouse is assumed.
• It is also recommended that proposed delegates have attended a Windows 2000 or Windows 2002 course or have obtained comparable knowledge from the workplace.