Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentEmailCloak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentLoadModule() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentPagebreak() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentNavigation() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

Warning: Parameter 2 to plgContentVote() expected to be a reference, value given in /home/ashbeeco/public_html/libraries/joomla/event/dispatcher.php on line 136

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