MS Excel 2007 Intermediate

Course Contents

Range Names

• Concept and Purpose
• Naming individual or range cells's
• Deleting and amending named ranges
• Using named cells/ranges in formulae

Conditional Functions & Formats and Date Calculations

• Benefits and purpose
• If Statements , Nested If
• And, Or, Not
• Combining If, And, Or, Not
• Sumif , Countif
• Conditional Formatting
• Entering Dates and Times
• Different date/time formats
• How dates are stored
• Calculating working days
• Using the DAY(),MONTH(),YEAR() functions
• Time calculations

Formulae Auditing

• Formula Auditing Tools
• Revealing Formulae
• Tracing Precedents/Dependents
• Goto Special

Worksheet Management & Linking

• Linking sheets in the same file
• Linking different Excel files
• Using Edit, Links
• Viewing different files at once
• Saving a workspace
• Viewing different sheets at once
• Window Split
• Data consolidation

Basic List Management

• Sorting Data
• Adding Subtotals
• AutoFilter
• Freeze Panes
• Group and Outline
• Data Form

Excel Charts / Graphs

• Using the Chart Wizard
• Editing and Formatting charts
• Saving custom chart types
• Setting a default chart type

**All the Excel 2007 intermediate course content above can be tailored by adding more basic or advanced functionality**