In this video we introduce an important tool of excel named as conditional formatting which is a very great tool for data analyzing and showing the data in meaningful way. By using this tool, we are able to set different colors or icons for different range of values or based on some predefined conditions, we can change colors or icon of specific cells.
In this video talk about the filter option of Excel and how we can use it efficiently for filtering numeric or text data in Excel. We convert the data area into table for convention filtering, but you should note that if you don’t convert range to table all concepts will be same.
In this video we talk how we can filter data in Excel. Specially, in Excel tables by using slicers options. Slicers are useful tool in excel that enable you filtering data by just clicking at current values in an box. Which can be very helpful when you have lots of data and want to filter them easily