PPT

How to Create a PivotTable Manually (5:37 min)

· https://support.microsoft.com/en-us/office/video-create-a-pivottable-manually-9b49f876-8abb-4e9a-bb2e-ac4e781df657

· Links to an external site.

·

How to Create a PivotTable (1:36 min)

· https://support.microsoft.com/en-us/office/video-create-a-pivottable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760

· Links to an external site.

·

How to Sort, Filter, and Calculate PivotTables (4:07 min)

· https://support.microsoft.com/en-us/office/video-sort-filter-summarize-and-calculate-your-pivottable-data-e3d4bee4-c5ef-4e3c-b990-61a7d540207c

· Links to an external site.

·

How to create formulas in a PivotTable

1. Click the PivotTable. ...

2. On the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.

3. In the Name box, type a name for the field.

4. In the Formula box, enter the formula for the field. ...

5. Click Add.

Use Slicers, Timelines, and PivotCharts (3:53 min)

Links to an external site.

· https://support.microsoft.com/en-us/office/video-use-slicers-timelines-and-pivotcharts-to-analyze-your-pivottable-data-4db5de3b-735e-4b03-b3b2-f2105d79dcb5

· Links to an external site.

·

List of Available Chart Types

· https://support.microsoft.com/en-us/office/available-chart-types-in-office-a6187218-807e-4103-9e0a-27cdb19afb90

· Links to an external site.

·