Delegates will acquire the necessary skills to become productive in Excel.

All our training courses can be designed to suit your specific needs.

Objectives: This course provides an Intermediate level of training.

Who should Attend:

Existing users or delegates who have attended the introduction course.

Course Outline

• More advanced formulas and functions
• VLOOKUP and HLOOKUP functions
• Validation and Conditional formatting
• Sorting and filtering lists
• Subtotals and auto outlining
• Data Consolidation
• Charts
• Working with multiple worksheets and workbooks
• Absolute and relative reference
• Using range names
• Inserting comments