Excel 365: level 3 Tables and Pivot Tables - bespoke for Orbis

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
ICT & Digital Skills
Subject
ICT & Digital Skills / Personal Development
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

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 drop into your Outlook calendar. You will get an automatic reminder to JOIN MICROSOFT TEAMS MEETING (about) 15 minutes before the scheduled start.

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'.

This training will be delivered through Microsoft Teams.

 

Enquiries
Start Date
Friday 25 June 2021
End Date
Friday 25 June 2021
Closing Date
Thursday 24 June 2021
Times
10:00 - 11:30
Maximum Places
11 
Cost
Login to view cost
Number of Sessions
1