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

Excel 365 Level 2 Presenting Information

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 Skills / ESCC Staff / Early Years and Childcare / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
Subject
ICT Skills / Personal Development
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 are familiar with basic Excel techniques, such as entering data, writing simple formulas and applying basic formatting. You now want to find different ways of presenting your data, so it is effective and eye-catching.
This course includes topics from the Excel Presenting Information 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 apply conditional formatting to data, making cells change colour depending on their values.


You will understand Excel theme colours and know how to add and format icons on a worksheet.


You will be able to create a chart and apply formatting to it in order to present your information effectively.

Learning outcomes

Theme colours



  • What is a theme colour?

  • Change the theme colours

  • Understand the effect of changing theme colours


Icons



  • Search for an icon

  • Insert an icon on a worksheet

  • Format an icon


Apply conditional formatting



  • Understand the different types of conditional formatting

  • Apply conditional formatting to cells

  • Edit and remove conditional formatting


Excel Charts



  • Create a chart

  • Move, print and delete a chart

  • Add and remove chart elements

  • Format different elements of a 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
Wednesday 8 July 2020
End Date
Wednesday 8 July 2020
Closing Date
Tuesday 7 July 2020
Times
10:00 - 11:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1