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.
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.
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.
What is a theme colour?
Change the theme colours
Understand the effect of changing theme colours
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
Create a chart
Move, print and delete a chart
Add and remove chart elements
Format different elements of a chart
The provider for this session is an external trainer. Once your place has been confirmed look out for invitation to join the session from firstname.lastname@example.org
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.
For security reasons your session is about to expire. You will be automatically signed out in
To continue your session, select Stay Signed In.