by Nate Moore | Nov 28, 2009 | Pivot Tables
Lesson 9 picks up where Lesson 8 left off. Lesson 8 showed how label filters can filter Pivot Table data based on the row or column labels in the table. You can also filter based on the values in the data section of the Pivot Table, and these value filters offer a...
by Nate Moore | Nov 23, 2009 | Pivot Tables
Lesson 8 demonstrates a cool new feature in Excel 2007, label filters. Label filters allow you to filter rows and columns based on the text of the label. Excel offers a variety of logical choices to filter with (Begins with, Doesn’t begin with, Ends with, Doesn’t end...
by Nate Moore | Nov 21, 2009 | Pivot Tables
Pivot Tables have a clever feature that allows you to drag multiple rows and columns to the same Pivot Table to add a whole new level of flexibility to your analysis. This video starts by showing you a way to clear all of the filters in a Pivot Table at once. We then...
by Nate Moore | Nov 19, 2009 | Pivot Tables
If you’ve ever been challenged on whether a number in your report is correct, you need to know how to drill down to see the details behind that number. This video shows how to drill down to look at the data underlying a cell in a Pivot Table. All you have to do is...
by Nate Moore | Nov 17, 2009 | Pivot Tables
The last video demonstrated the way Excel groups dates in a Pivot Table. This video demonstrates how to apply the same grouping tools to text fields. You can also learn how to hide and show details of what you’ve grouped, which is helpful when printing or summarizing...
