Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 

0611 Filter - Color Filter and Text Filter

1 minutes
Share the link to this page
Copied
  Completed
You need to purchase the class to view this lesson.
One-time Purchase
$99.99
List Price:  $139.99
You save:  $40
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
A$145.90
List Price:  A$204.27
You save:  A$58.36
৳8,489.86
List Price:  ৳11,886.14
You save:  ৳3,396.28
CA$136.75
List Price:  CA$191.45
You save:  CA$54.70
CHF 95.21
List Price:  CHF 133.29
You save:  CHF 38.08
kr663.72
List Price:  kr929.24
You save:  kr265.51
€89.05
List Price:  €124.67
You save:  €35.62
£81.40
List Price:  £113.97
You save:  £32.56
HK$774.97
List Price:  HK$1,084.98
You save:  HK$310.01
₹7,549.84
List Price:  ₹10,570.09
You save:  ₹3,020.24
RM428.45
List Price:  RM599.85
You save:  RM171.39
₦38,746.12
List Price:  ₦54,246.12
You save:  ₦15,500
kr970.31
List Price:  kr1,358.48
You save:  kr388.16
NZ$156.01
List Price:  NZ$218.42
You save:  NZ$62.41
₱4,982.50
List Price:  ₱6,975.71
You save:  ₱1,993.20
₨16,818.31
List Price:  ₨23,546.31
You save:  ₨6,728
S$139.47
List Price:  S$195.27
You save:  S$55.79
฿3,090.69
List Price:  ฿4,327.09
You save:  ฿1,236.40
₺685.47
List Price:  ₺959.69
You save:  ₺274.21
R1,732.88
List Price:  R2,426.10
You save:  R693.22
Already have an account? Log In

Transcript

Either this time I will talk about some of the ancillary techniques under filter, although not that critical, but still once in a while, you may want to use this in 2007 version of Excel they came out with a color based filter. So if I choose the data and I apply a filter, I will have the option under the drop down which will say filter by color. So, if I choose the orange one, notice all the orange cells the ones which had colored in the orange color have been filtered out. So, I can go back and say clear filter from location. Another technique which is part of the text filter, you will find that in the drop down line name, let's assume that you want to pick up those names which contain which contain meals and the word PVD private. So, I go to text filters and I choose contains and I choose PVT contains PBT and at the same time it should contain mil mil.

Okay, so I'm getting just one name which contains mil and the word private. So there you go. These are just some of the simple unfiltered tricks under filter tab. Thank you

Sign Up