Description
COURSE OVERVIEW:
This course explores how Conditional Formatting can be used to
automatically highlight important information and trends within your
data.
You will learn how to apply built-in formatting rules to identify values
that meet specific criteria, such as duplicates, top performers or
values above a certain threshold.
The course also covers how to create custom Conditional Formatting rules
using formulas, allowing you to build more advanced conditions based on
your own requirements.
These techniques can help make worksheets easier to interpret, improve
data visibility and draw attention to key information at a glance.
COURSE FORMAT:
The course is delivered online via Microsoft Teams and is tutor-led. It
involves explanation, demonstration and hands-on practice, working
through tasks that build on your existing skills and increase the
functionality of spreadsheets.
PREREQUISITES:
Participants should have a basic understanding of Excel and be able to
create formulas and understand relative and absolute referencing.
CONTENT
• Apply conditional formatting based on a cell value
• Use conditional formatting to highlight high or low values
• Create a graphical representation of the range of values
• Use icon sets to visually represent the range of values
• Edit conditional formatting rules to meet different criteria
• Use a formula to build a more advanced conditional formatting rule
Duration: 1.5 hrs
Cost: Free
Suitability: Staff
|
