Select Page

Excel Video 385 Search Box Filter

The Search Box is another way to filter your data in Excel Video 385. The Search Box lets you look for text anywhere inside your data. That’s helpful, but the Add current selection to filter check box is even more helpful because it allows you to do an “or” filter....

Excel Video 384 Text, Number and Date Filters

Excel Video 384 covers three quick ways to filter data in a Table based on the type of data stored in each column. We’ll work through text, number, and date filters with examples of how you might use each. Again, text, number and date filters can be combined to drill...

Excel Video 383 Manual Filtering in Tables

Excel Video 383 gets us started with the basics of filtering data in Tables. Once your data is in a Table, it’s as easy as checking and unchecking boxes to filter Tables. Notice that I apply multiple filters at the same time so with a few clicks you can drill down to...

Excel Video 382 Sorting by Color in Tables

If you’ve never sorted cells by color before, watch Excel Video 382. You’re probably used to sorting cells alphabetically or numerically, but did you know you can sort by the cell color, the font color, or the cell icon? Excel makes it easy. Watch how Excel goes...