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.
understand the following:
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
those who are familiar with basic Excel techniques, such as entering data, writing simple formulas and applying basic formatting. Delegates now want to find different ways of presenting data so it is effective and eye-catching.
The course assumes that delegates are familiar with entering data and simple formulas in Excel.
Get notified when this
course is on next.
