Course Summary

This one-day course is for the reasonably experienced user of Excel who wishes to develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques.  A proficiency in setting up basic spreadsheets is assumed, as is familiarity with the Windows environment.

What you will learn

Formatting worksheets
Relative and absolute cell references in formulae
Building functions using the Insert Function feature
Using IF, SUMIF, COUNTIF and other logical functions
Statistical functions
Financial functions
Using multiple worksheets
Linking workbooks
Database management and facilities
Pivot Tables
Creating and formatting charts
Useful shortcuts

Workshop Timetable

9.15am Welcome and coffee
9.30am Session start
 Delegate introductions and explanation of day
 Excel formatting exercise with useful shortcuts.
 Pivot tables

11.00am Break

11.15am Developing multipage spreadsheets using sheet
grouping and linking techniques.
 Relative and absolute cell references in Excel
 Basic statistical and financial functions –
AVERAGE, COUNT, MAX, MIN, SUBTOTAL

12.30pm Lunch

1.15pm Using the IF, SUMIF and COUNTIF functions

3.00pm Break

3.15pm Database management in Excel – Auto filtering,
sorting and the use of subtotals.
 Excel charting
4.30pm Close