by Nate Moore | Oct 28, 2013 | Excel 2013, Tables
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....
by Nate Moore | Oct 21, 2013 | Excel 2013, Tables
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...
by Nate Moore | Oct 14, 2013 | Excel 2013, 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...
by Nate Moore | Oct 7, 2013 | Excel 2013, 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...
