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
|
