by Nate Moore | Aug 22, 2012 | Pivot Tables
Watch Excel Video 286 to see how Excel customizes your filter options based on the type of data in your rows and columns. When we looked at label filters in the last Excel Video, we had a text field in the Row Label field we were filtering, so Excel gave us text based...
by Nate Moore | Aug 20, 2012 | Pivot Tables
Excel Video 285 adds some real power to your filtering skills by introducing Label Filters. Label Filters allow you to filter by whatever is in the Row or Column Label. In our example today, we’ll filter text data. It’s easy to select labels that begin with, don’t...
by Nate Moore | Aug 15, 2012 | Pivot Tables
Excel Video 284 shares an easy way to filter your Pivot Table data. There are several ways to filter, or limit the amount of data in your Pivot Table. Today we’ll discuss the easiest way to filter, simply by checking boxes. I call this way of filtering a manual filter...
by Nate Moore | Aug 13, 2012 | Pivot Tables
When sorting A-Z or Z-A isn’t good enough, watch Excel Video 283. Today we’ll discuss how manually sort data. When you need data in a different order then ascending or descending, just turn on manual sort and you can drag items in your list to rearrange them just the...
by Nate Moore | Aug 8, 2012 | Pivot Tables
Sorting Pivot Table data, as we’ll do in Excel Video 282, is much easier than sorting regular data in Excel. You’re probably aware that if you sort regular data in Excel you have to be very careful to select the entire range of data to sort in order to avoid...
by Nate Moore | Aug 6, 2012 | Pivot Tables
If you’ve wondered why Microsoft calls it a Pivot Table, watch Excel Video 281 today to see how easy it is to pivot rows and columns around a value. It’s easy to add and remove data from a Pivot Table. It’s just as easy to move data between rows and columns. Notice...
