In the previous segments, you explored how statistical functions in Excel are instrumental in analysing and interpreting data to provide insights into its distribution, characteristics, and variability. You also learnt how logical functions play a crucial role in organising, categorising, and preparing data for deeper analysis. Together, these functions form a comprehensive toolkit for effectively understanding and interpreting the nuances of the dataset. This segment will look at another important feature in Excel called Conditional Formatting, which allows you to format your data based on different criteria. Changing the appearance of cells can also visually highlight interesting data points for analysis.
Let’s learn more about conditional formatting through the video.
As shown in the video, conditional formatting gives a broad sense of how data is distributed without going into formulas. It can also help in identifying the presence of outliers quickly.
The cleaning steps used for this demonstration are as follows:
- Remove the entities with a blank logistics provider ID.
- Remove the entities with a blank actual delivery date corresponding to the cancelled orders. Hence, remove all the cancelled orders as well.
- Remove the entities with a blank transit storage cost. Due to the presence of outliers (value 9999) from the conditional formatting of the transit storage cost, these entities are dropped as well.
Before we move ahead, let us test our understanding of this segment.
With this, we have come to the end of the session. Let’s revise all the topics discussed in the Session Summary.