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: Analysing Data

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
Course description

This course is for you if you use Excel to store tables of data and want to extract information and produce reports from that data.


 

Training objectives


This course is suitable if you are familiar with basic operations in Microsoft Windows, such as opening and saving files, entering and editing data in Microsoft Excel.

Learning outcomes

At the end of the course, you will be able to:



  • store data effectively

  • create a subtotals report and know the advantages of turning your data into an Excel table

  • create a Pivot Table

  • use Slicers to filter the data and use different functions to analyse the data

  • present the results in different ways and create a Pivot Chart


      

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
Tuesday 19 November 2019
End Date
Tuesday 19 November 2019
Closing Date
Monday 18 November 2019
Times
09:30 - 12:30
Maximum Places
11 
Cost
Login to view cost
Number of Sessions
1