• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

Notice the two PivotTable formats in Figure 24.62. The first format is the standard format when a PivotTable is created. The second, or the PivotTable to the right has custom formats applied as well as grouped dates by month. One of the unique features about PivotTables is that you can group dates by hour, day, month, Qtr, and so on from a list of dates. You could also create these summaries with formulas; however, PivotTables offer a much easier solution to the problem.

Figure 24.62. Use grouping to group days into months and custom formats to create an organized look to your information.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint