Data filters: AutoFilter and advanced filters
Sorting, Customize sorting
Subtotals

Cell level validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell

Using data tables for data analysis
Mastering PivotTables
Using external data sources
Multiple consolidation ranges
Customizing PivotTable layout
PivotTable advanced options
Pivot Charts

Working with external data (Requires Microsoft Query)
Querying external databases
Saving, editing and reusing external data queries
Web queries
Importing text files in Excel
Refreshing data

Using data forms for managing tabular data
Specifying criteria for a form
Searching with a form

Workbook sharing
Tracking changes
Merging workbooks
Workbook and sheet protection

Online collaboration (requires Microsoft NetMeeting and Microsoft Outlook)
Scheduling meetings and web discussions

Goal Seek
Scenario Manager
Creating and editing scenarios
Merging scenarios

Auditing
Tracing precedents and dependents
Tracing errors

Managing add-ins
Customizing toolbars and menus

Customizing views
Customizing calculations and iterations
Settings 
Creating custom lists

Conditional formatting of cells
Creating, managing and merging styles for cell formatting

Working with functions (based on your requirements)
Financial functions
Date and time functions
Statistical functions
Lookup and reference functions
Database functions
Text manipulation functions
Logical functions
Worksheet and cell information functions

MS Excel - Macros topics
Recording and running macros
Types of references in macros
Assigning a macro to a toolbar or menu

User-defined functions
Adding descriptions to user-defined functions

Control-flow statements
IF...ELSE
SELECT...CASE
FOR...NEXT

Macro actions for cells and ranges
Objects, properties and methods
Processing individual cells in a range

Macro actions for worksheets
Macro actions for files
Macro actions for charts

Managing dialog boxes

Manipulating menus in Excel macros
Creating automatic procedures