Excel 2007 Advanced Course Contents

Hover over the content header to see more details

Click to view Course Contents as PDF file

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

Excel 2007 Courses

Wed Sep 08
Excel 2007 Introduction Course
Thu Sep 09
Excel 2007 VBA Introduction
Tue Sep 14
Excel 2007 Intermediate Course
Tue Sep 21
Excel 2007 Advanced Course
Wed Sep 29
Excel 2007 VBA Intermediate
Thu Oct 07
Excel 2007 Introduction Course
Tue Oct 12
Excel 2007 VBA Introduction
Wed Oct 13
Excel 2007 Intermediate Course
Wed Oct 20
Excel 2007 VBA Intermediate
Thu Oct 21
Excel 2007 Advanced Course