Microsoft Excel 2000 XP 2003: Advanced - Formulae and Functions

Course Overview

Designed for existing users of Excel.

Delegates that attend a Microsoft training course are twice as motivated than those that don't?

Related Courses

• Microsoft Excel 2002 (XP): Advanced (1 day)
• Microsoft Excel 2002 (XP): Introduction for Beginners (1 day)
• Microsoft Excel 2002 (XP): Intermediate (2 day)
• Microsoft Excel 2002: Intermediate
• Microsoft Excel 2000: Visual Basic for Applications (VBA)
• Microsoft Excel 2000: Introduction for Beginners (1 day)
• Microsoft Excel 2000: Advanced (2 day)
• Microsoft Excel 2000: Intermediate
• Microsoft Excel 2003: Advanced (2 day)
• Microsoft Excel 2003: Visual Basic for Applications (VBA)

Audience

It is assumed that the participant will have either attended an Excel Intermediate course or has equivalent knowledge.

Skills Gained

By the end of this course you will be proficient in the use of advanced formulae and functions, you will have gained an understanding of Formula referencing and be able to create multi function calculations.

Course Outline

Formulae

• Refresh on Formulae
• Absolute referencing
• Mixed referencing

Named Ranges

• Add & delete a named range
• Use named ranges in a formula
• Natural Language

Set Display Options

• Customise Toolbars
• Options

Advanced Autofill

• Fill Weekdays
• Fill Values Only
• Growth Trend

Format Worksheets

• Apply accounting, currency & scientific formats
• Create custom number formats
• Conditional formatting

Multiple Workbooks

• Link workbooks
• Use multiple workbooks
• Save a workspace
• Consolidate information

Forecasting

• Goal Seek
• Scenario Manager

Advanced Functions

• String functions
• Logical functions
• Random numbers and rounding
• Nesting If's
• Handling errors
• HLookups
• VLookups

Auditing a Worksheet

• Check and review data
• Finding cells that refer to a specific formula
• Finding formulas that refer to a specific cell
• Finding errors