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
No targets found
target audience
Course Types
Course
Course categories
ESCC Directly Provided Services / ICT & Digital Skills / ESCC Staff
Subject
No categories found
Course description

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.


Pre-requisites


The course assumes that delegates are familiar with:
• entering data and simple formulas in Excel
This online course has example worksheets you can practice with after the session.


There is also a 3 hour, classroom-based version of this course, which has more opportunity to practice techniques during the training.


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.
Ideally you will also have a PC or laptop with Office 365 installed, as chart tools are displayed differently in earlier versions of Excel.

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

This training will be delivered through Microsoft Teams.

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