Wednesday, February 8, 2012
Then select the data that you wish to filter on your spreadsheet, and choose the Filter (looks like a Funnel). DropDown arrows will immediately appear on your column headers, allowing you to Slice & Dice your data as you wish.
Now is Where the Fun Begins!
Let’s say you are a teacher of manager that wishes to quickly Identify all of the Scores in your database that are greater-than 80% and less-than 90%. Piece of Cake!
All you need to do is click on the Down-Arrow of your Scores field and choose: “Number Filters”. This will bring up a dialogue box that will enable you pick for a vast variety of Customizable Parameters.
You’ll soon be Slicing and Dicing so well, you will be ready for your own show on Food Network!