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

Venue
East Sussex Training & Development Centre (St Mary's House), St Mary's House, St Leonard's Road
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
All users
target audience
Course Types
Course
Course categories
ICT Skills
Subject
ICT Skills / Personal Development
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 sara.lewis@eastsussex.gov.uk

 

Enquiries
Start Date
Friday 3 July 2020
End Date
Friday 3 July 2020
Closing Date
Thursday 2 July 2020
Times
13:30 - 16:30
Maximum Places
11 
Cost
Login to view cost
Number of Sessions
1