In light of continuing Government advice regarding the spread of coronavirus (Covid-19) and social distancing, the majority of our face to face courses remain cancelled. Alternatively, we are pleased to offer an increasing range of online and virtual courses. Please see individual courses for details.

View Details

Excel 365 Level 3 Tables and Pivot Tables

Venue
Remote Corporate Training, Not a geographical location
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
All users
target audience
Course Types
Course
Course categories
ESCC Assessment & Care Management / ESCC Directly Provided Services / ICT Skills / ESCC Staff / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
Subject
ICT Skills
Course description

Please note - this is a "remote" session, and if applying, you should note the additional information in "full details" regarding joining the session.


Is this course for you?


You work with tables of data which you need to summarise and analyse.
This course includes topics from the Excel Analysing Data course.


Pre-requisites


The course assumes that delegates are familiar with: entering data and simple formulas in Excel.
To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.


 

Training objectives

At the end of the course, you will be able to create an Excel Table, change its formatting and perform simple analysis using the Totals row. You will know how to create Pivot Tables, change the analysis the Pivot Table performs and present the data in a Pivot Chart

Learning outcomes

Excel Tables



  • Create an Excel Table

  • Add a calculated column

  • Analyse data with the Totals row


Analysing data with Pivot Tables



  • Create a Pivot Table

  • Re-pivot the table, using different fields

  • Drill down to see underlying data

  • Refresh a Pivot Table


Changing Pivot Table design and formatting



  • Change Pivot Table layout

  • Summarise data in different ways

  • Understand how table filters work

  • Use a Slicer to filter data

  • Present results as percentages

  • Analyse data by time period

  • Present data with a Pivot Chart

Additional Information

The provider for this session is an external trainer. Once your place has been confirmed look out for invitation to join the session from pmseaman@gmail.com

Accept the invitation (and be sure to check your spam folder as well in case it has slipped into that) and the session will automatically drop into your Outlook calendar. You'll get a reminder about 15 minutes beforehand to join the meeting,

Delegates' email addresses as registered on the portal will be provided to the trainer for the purpose of conducting this training only.

Delegates should ensure that their work (not personal) email addresses are recorded - check and update as necessary through 'My Profile and Bookings/Change Contact Details'.

It is expected that this training will be delivered through Microsoft Teams.

Enquiries
Start Date
Tuesday 22 September 2020
End Date
Tuesday 22 September 2020
Closing Date
Monday 21 September 2020
Times
10:00 - 11:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1