Excel - Intermediate

In-House & Bespoke Training Programmes offer the ideal forum to learn new skills by targeting training to the specific needs of a group of employees. We can design content to meet your development and training requirements. Also, and very importantly, the cost per person is often less than booking the same people on an open course session if you have 8+ delegates. This is a very cost-effective way to take advantage of, and benefit from, our powerful training opportunities.

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