Sum of Amount

8. Try it: Format the Data

Sum of Amount is money-sales data.

Select Column B.

Go to Home->Number.

Click on Currency.

 

Select Column B, again.

Go to Home->Number.

Click on Decrease Decimals twice.

 
Try This, Too: Save the PivotTable

Go to File->Save As.

Name the workbook: MyName PivotCharts.

Save. Save. Save.

 

Very good.

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Edit the Value Field Settings

Home ->Number