Join Gini von Courter for an in-depth discussion in this video Use other summary functions, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Narrator] This is a pivot table…that we created previously.…I'd like to create another pivot table…that calculates in a different manner.…This pivot table is presenting our total number…of units sold.…But I'm also curious about how many different orders…were placed in each month,…in each of our four sales regions.…I have two choices.…I can modify this pivot table or create a new one.…And the decision really depends on…whether I need to have both of them exist…at the same point in time.…
You might notice that even though I'm in the pivot table,…I'm not seeing my field list.…I probably turned that off at some point.…You'll do that too.…And if you wish, you can simply go back…to the pivot table tool's "Analyze" tab…and click the button to show the field list again,…in the same that we can show or hide the headers…for our pivot table.…"Units sold" is our value field.…It's the number that's being totaled.…If I click on "units sold",…and choose the value field settings,…you'll notice that I have access…to other summarization methods.…
- Identify the theme used by the default paste option.
- Recall what is embedded when you copy an Excel table and then embed the table in a PowerPoint presentation.
- Recognize the actions that may compromise data or yield incorrect results if a data table is missing descriptive labels.
- Recall the benefits of using a slicer over using a filter.
- Name a great way to illustrate the timeline and progress of a project.
- Explain what PivotTables do to tabular data.