Microsoft Excel 2003/07 - Advanced

Advanced Functions

• Further Lookup and Reference Functions:
• MATCH, INDEX, Combine VLOOKUP and MATCH, Combine INDEX and MATCH
• IS Functions
• Error Trapping combining IF, Error and VLOOKUP Functions
• Financial Functions - PMT, IPMT, FV, PV, NPV
• Text Functions - LEFT, RIGHT, MID, FIND, LEN, VALUE, CONCATENATE, TEXT, TRIM
• Combining Text functions

Customising Excel

• Customising the toolbar
• Custom formatting
• Conditional formatting
• Custom Views

Data Validation

• Overview and Restrictions of use
• Apply Data Validation Settings
• Input and Error Alerts
• Extending Validation Settings
• Removing Validation Settings

Advanced Database Features

• Advanced Filter
• Nested Subtotals
• Advanced Pivot Tables

Introduction to Macros

• Recording Macros
• Range names and Macros
• Assigning Macros to buttons on
• Spreadsheets and toolbars
• Editing Macro Buttons