Excel for Finance Users
These sessions are specifically for finance users who use Excel as part of their role. Staff wishing to attend must have either attended the training sessions provide by IT Services or have a sound working knowledge of Excel.
Please note that Excel 2007 will not be used in these sessions.
Contents
| Excel 1 - Lookups, Text and Formatting |
|
This event is appropriate for Staff needing to use Excel for advanced Financial calculations or gain an understanding of complex spreadsheets
Content Summary:
- Lookups
- Error trapping
- Combining fields
- Extracting Text
- Finding Text
- Formatting Cells
- Cleaning Data
- If Statements
- Using And/Or in If statements
|
Facilitated by |
Aimed at |
Roger Travis |
All Staff |
Date |
Time |
Tuesday 18 October 2011 |
14:00 - 16:00 |
|
|
 |
| Excel 2 - Functions and Pivot Tables |
|
This event is appropriate for Staff needing to use Excel for advanced Financial calculations or gain an understanding of complex spreadsheets
Content Summary:
- Working with Dates
- Sumif / countif
- Sub Totals
- Pivot Tables
|
Facilitated by |
Aimed at |
Roger Travis |
All Staff |
Date |
Time |
Tuesday 15 November 2011 |
14.00 - 16.00 |
| |
|
| Excel 3 - Easyextractor |
|
This event is appropriate for Staff needing to use Excel for advanced Financial calculations or gain an understanding of complex spreadsheets
Content Summary:
Analysing data using IF statements and Pivot tables |
Facilitated by |
Aimed at |
Roger Travis |
All Staff |
Date |
Time |
Tuesday 13 December 2011 |
14.00 - 16.00 |
| |
|
You may also be interested in checking out the following website for more information:
Financial and Commercial Services Website
|
