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...
by Nate Moore | Sep 30, 2013 | Excel 2013, Tables
We’ll start our discussion of Tables features in Excel Video 381 with sorting. The big advantage of sorting data in Tables is that you don’t have to select the entire data range to sort. If you’ve sorted data in Excel before, you know you have to carefully select the...
by Nate Moore | Sep 23, 2013 | Excel 2013, Tables
Excel Video 380 starts our discussion of Tables in Excel 2013. Tables are different than the Pivot Tables you’ve heard me talk a lot about. We’ll start by simply creating tables. If you already have a Pivot Table, creating a table is easy, simply double click the...
by Nate Moore | Sep 16, 2013 | Excel 2013
Excel Video 379 has some ways to customize Timelines, some gotchas, and a powerful feature of Timelines. The customization options for Timelines are fairly straight-forward. The thing I spend extra time on in this Excel Video is two gotchas to watch out for. Slicers...
