Excel 2007 advanced online training Hyderabad India

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index
IsText, IsValue, IsDate , IsErr, Is Error, IsNa
Advanced Filters
Using List Features
Dynamic Lists (Tables)
Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart
Advanced Filters
Using List Features
Dynamic Lists (Tables)
Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Purpose of Macros
Recording macros
Where to save macros
Absolute and relative record
Running macros:
Custom buttons, menu items, keyboard shortcuts