Lookup and Reference Functions
MATCH
INDEX
Combine VLOOKUP and MATCH
Combine INDEX AND MATCH
Financial Functions
PMT
IPMT
FV
PV
NPV
Combine PV and NPV
Text Functions
LEFT, RIGHT, MID
FIND, LEN, VALUE
CONCATENATE, TEXT, TRIM
Text Joins
Combining Text Functions
Information Functions
Displaying Errors
Error trapping combining IF, Error and VLOOKUP functions
Advanced Database Features
Advanced Filter
Nested Subtotals
Further Features of Pivot Tables
Data Validation
Overview and Restrictions of Use
Validation Criteria
Input and Error Alerts
Find Validated Cells
Extend Validation Settings
Remove Validation Settings
Worksheet Protection
Locking and Hiding Cells
Protecting a Worksheet
Removing Protection
Data Analysis Tools
Goal Seek
Scenarios
Customising Excel
Custom Views
Custom Formats
Conditional Formatting
Templates
Create and delete custom templates
Create a custom template directory
Open a workbook based on a template
Styles
Create custom styles
Modify existing styles
Merge styles
Create a template with custom styles
