Today’s video demonstrates how to group dates in Pivot Tables fields. As long as Excel sees the dates are in a date format, the group function allows you to easily group dates by a variety of time intervals, such as days, months, quarters, and/or years. It’s easy to pick multiple time periods (months and years, for example) as well. You’ll also see three different ways to display Pivot Tables, which may help when you’re trying to format a certain way for printing.
Stay tuned. The next video will discuss how to group text fields instead of dates.