- Conditional Formatting
- Manage Rules
- Data Bars
- Colour Scales
- Icon Sets
- Find Duplicates
- Shade Alternate Rows
- Compare Two Lists
- Conflicting Rules
- Heat Map
DATA ANALYSIS - CONDITIONAL FORMATTING
There are many quick and handy tools to visualise data in Excel. Some tools can be applied in just a few clicks.
This session covers how to use colour scales to visualise data.
After completing this session, you will be able to set up colour scales to automatically fill different cells with different colours depending on their values.
Learning objectives
Set up colour scales for a range of numeric values
Adjust the number of colours used in the colour scale
Remove the colour scale using the Conditional Formatting Rule Manager
This session covers how to use colour scales to visualise data.
After completing this session, you will be able to set up colour scales to automatically fill different cells with different colours depending on their values.
Learning objectives
Set up colour scales for a range of numeric values
Adjust the number of colours used in the colour scale
Remove the colour scale using the Conditional Formatting Rule Manager
- Course provided by : Skills Hub
- Social Media :
