Create a PivotTable. Select cell A5 and click the Table Name box [Table tab, Properties group]. Name the table tblHours. Click the Summarize with PivotTable button [Table tab, Tools group]. The range is identified as tblHours. Verify that New Worksheet is selected and click OK. Name the sheet PivotTable. Manage fields in a PivotTable. Show the Product/Service and Billable fields in the PivotTable. Drag the Billable field from the Field Name area below the Sum of Billable field in the Values area so that it appears twice in the report layout and the pane. Select cell C4 and open the Value Field Settings dialog box. NOTE: You can select any cell in column C within the PivotTable data in order to complete the following steps to modify the PivotTable column settings. Type Average Hours as the Custom Name, choose Average as the calculation, and set the Number Format to Number with two decimal places. Select cell B4 and open the Value Field Settings dialog box. Set its Custom Name to Total Hours and the number format to Number with two decimal places. Apply Dark Gray, Pivot Style Dark 11 with banded rows and columns. Select the Data sheet tab and copy cells A1:A2 to cell A1 on the PivotTable sheet. Left align cells A1:A2 on the PivotTable sheet (Figure 4-116)