Following government advice, ESCC have made the decision to postpone or cancel some face to face training.
This decision has been made in light of the national concerns about the spread of the coronavirus (COVID - 19). Please see individual courses for more information.

View Details

Microsoft Excel 2010: Advanced Calculations

East Sussex Training & Development Centre (St Mary's House), St Mary's House, St Leonard's Road
Admin Contact
Corporate Training Mail Box (
Target Audience
No targets found
target audience
Course Types
Course categories
ICT Skills / ESCC Staff / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
No categories found
Course description

This course is for you if you can perform calculations in Excel using formulas and simple functions and now want to use some of Excel’s more advanced calculation features.

Training objectives

This course is suitable if you are familiar with basic operations in Microsoft Windows and Excel calculation techniques covered in the Level 2 course Performing Calculations.

Learning outcomes
At the end of the course, you will be able to  

  • use some of Excel’s more advanced functions, such as IF and VLOOKUP

  • knowhow to construct 3D formulas taking data from multiple sheets and how to consolidate data, producing summary reports from data in multiple workbooks

  • analyse worksheet structure using Excel’s Formula Auditing tools

Additional Information

Please note:

Parking around St. Mary's House is scarce due to limited parking.

Corporate Training offer a selection of teas/coffees, hot chocolate and biscuits.

A handout covering the main course topics will be provided.

If you are in Adult Social Care and require funding for this course please contact


Start Date
Thursday 4 February 2021
End Date
Thursday 4 February 2021
Closing Date
Wednesday 3 February 2021
13:30 - 16:30
Maximum Places
Login to view cost
Number of Sessions