Microsoft Excel XP - Advanced
Once you complete this course you will have achieved an advanced knowledge of the Excel program.

Table of Contents
AutoFilters
Multiple & Custom Filters
Text Boxes
Applying Colours and Lines
Fonts and Alignments
Indents
Unlocking Cells
Protecting a Sheet
Unprotecting a File
Consolidating
Pivot Tables
VLookup & HLookup Formulas
Hiding & Unhiding Cells, Rows and Columns
Forms
Criteria Settings
Styles
Numerical Formats
Validations
SubTotals
Sending via Email
Count & CountIf Formulas
Advance Filters (Extracting Data, Unique Records)
Absolute Referencing
PMT Formulas
Link Formulas
HyperLinks
Animated Clips
Web Page Preview
Goal Seek
Sqrt Formula
Macros
Creating Macros
Running and Stopping Macros
Assigning a Button to a Macro
Deleting Macros and Buttons
Array Formulas
Scenario Manager
Buttons (Macro Buttons)
Defining Names
Help
Charts with Pictures
Assignments