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

Excel in Practice

For this Excel in Practice I show you two common uses of PivotTables: grouping data and managing employee costs and hours worked.

Grouping Data in Pivot Tables

Notice the two PivotTable formats in Figure 24.46. 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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