Excel - Intermediate

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