ICT Training
Excel XP Advanced
OBJECTIVES:
On completion of the course participants will be proficient in the use of more complex functions of Excel.
AUDIENCE:
Anyone needing to use more complex functions.
DURATION:
1 Day
PRE-REQUISITES:
It is essential delegates are proficient in setting up spreadsheets in Excel and able to perform simple calculations and use functions such as SUM, AVERAGE, MIN, MAX.
| Naming Ranges | Nesting Functions (using several functions in one formula) |
| Adding Comments | Lookup Functions |
| Date/Time Functions | Pivot Tables |
| Financial Functions | Auditing Toolbar |
| Logical Functions | Creating simple Macros |
| Text Functions | Datatables, Scenarios and Goalseek |
