You have a large amount of data in Excel and you want to see trends or outliers in that data.
Solution
You can use Conditional Formatting in Excel to colours cells based on the data withing the cells. This helps to highlight trends and other things occurring in the data.
Steps
Watch this video from Pip on how to use Conditional Formatting