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
Microsoft Office
Subject
ICT Skills / Microsoft Office
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