INTERMEDIATE COURSE OUTLINE

One day

Keyboard familiarity.  Must have attended Excel Introduction course or have a proficient working knowledge at that level. 

At the end of this course delegates will be able to use and  apply intermediate features of Excel 2003.

Page Set-up

• Changing default settings
• Headers and footers
• Setting Print ranges

 Use Fill & Create a Series

• Drag to Fill a Range of Cells
• Increment a Series of Numbers & Dates
• Create a Series based on a Single Value

 Work with Named Ranges

• Create and Apply Range Names
• Insert a Name into a Formula

Create and Edit Templates

• Create, Save and Open a Template

 View a Worksheet

• Open, Arrange & Close Workbook Windows
• Split & Remove Splits, Freeze/Unfreeze Titles
• Hide/Unhide Rows & Columns

 Work with Multiple Worksheets

• Arrange Worksheets on the Screen Simultaneously
• Organise Multiple Files in a Workbook
• Group and Format Multiple Worksheets
• Print Multiple Reports from a Single Worksheet

 Establish Links between Worksheets

• When to Link and work with Data Links
• Establish DDE and OLE Links
• Add Files to an Existing Workbook

Create Basic Conditional IF Functions

• Use the IF() Function
• Use the IF() Function Combined with AND()
• Use the IF() Function Combined with OR()

Change Default Options & Settings

• View, Calculation, Edit, Transition, General, Custom List, Chart, Colour, Module General, Module Format
• Customise Toolbars

Toolbars

• Altering Existing Toolbars
• Creating New Toolbars