Filtering data is a very useful tool. You select your range of data and then click the filter icon in the Sort & Filter dropdown. Filtering will put dropdown arrows on ever column giving you access to select a value from any column really quick. You can select one value or multiple values, using the checkboxes next to each value (this multiple selection feature is nice when you want to see YTD values, you can select say January – June to see the see the June YTD). The other great feature about filtering data is when you click on the drop down on the top of one of the columns you can select filter by colors or number filters. Using number filters you can choose to filter number greater than x, or less than y, or in between x and y or equals. You have a lot of control over the criteria that data is displayed.