Microsoft Excel EXPert (2003/2007)

Course Content

Part 1

Nesting Functions

• Combing Several functions of the same kind for example IF, IFAND and OR function.
• Combing Different Functions Together

Offset and Choose

• Selecting an Array of Cells offset by a Number of Columns and Rows

Dynamic Lookup

• Changing the Lookup Table according to the Criteria Required.

Part 2

Consolidation Methods

• Using Formulas
• Using Consolidation
• Advanced Features of Pivot table

Text Functions

• Using Text Functions When Importing Data from Another Application
• Concatenation Methods used for Combining Text Entries into One

Macros

• Macros Assigned to Tool Buttons
• Writing a Simple Macro
• Introduction to Visual Basic Editor