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 | Mar 24, 2010 | Tables
Excel Video 43 simplifies the way Excel references cells inside a table in formulas. When you look at the table reference in a formula it looks hairy, but if you simply arrow over (or click on) the table cell you want to reference, Excel does all of the syntax for...
by Nate Moore | Mar 22, 2010 | Tables
Excel Video 42 demonstrates the three options in the Tools section of the Table Tools Design tab, in the Tools area. First, there’s an easy way to convert the table you’ve been working on to a Pivot Table. Even if you’ve filtered the data in the table, Excel brings...
