by Nate Moore | Feb 17, 2010 | Tables
Excel Video 34 covers filtering text in tables. Filtering text is more straight-forward with fewer options than filtering dates or numbers, so I’m including a couple of other tricks in this video as well. Watch the demonstration of using custom filters to see how to...
by Nate Moore | Feb 15, 2010 | Tables
Excel Video 33 demonstrates some of many methods Excel offers to filter date fields in tables. When you filter a field containing dates, Excel recognizes the dates and customizes your filter options accordingly. The date filtering options you’re used to seeing in...
by Nate Moore | Feb 10, 2010 | Tables
Welcome back for more Excel videos! Excel Video 32 shows you how clicking the Total Row the Table Tools Design Tab puts a total row at the bottom of your table. The cool thing is that next to each cell in the total row is a drop-down arrow with a variety of choices...
by Nate Moore | Feb 8, 2010 | Tables
Excel Video 31 demonstrates how easy it is to add data to an existing table. If you need to add more rows of data, simply go to the bottom of the table and start typing. Excel will carry over the formatting of the existing table and include the new data in your...
by Nate Moore | Feb 3, 2010 | Tables
Excel Video 30 introduces Tables in Excel 2007. Tables are different than the Pivot Tables we’ve been discussing, but have many similar features. We’ll start by simply creating tables. If you already have a Pivot Table, creating a table is easy, simply double click...