Use Pivot Tables to Summarize Dates
Summarizing dates in a pivot table can be a little tricky. The pivot table video linked to below from Danny Rocks gives a nice short pivot table tutorial on how to summarize dates. I especially like the fast pace and clear explanations in the pivot table video. Check it out.
Use Pivot Tables to Summarize by Year, Quarter and Month
Can you imagine trying to use Excel Subtotals to summarize a long column sales, listed by date? It would be a nightmare! Pivot Tables, on the other hand, can give you this summary with a few mouse clicks!
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
