Join Gini von Courter for an in-depth discussion in this video Create and format a PivotTable, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] This table of third quarter sales data…only has about three dozen rows,…and yet even with this small table…if we charted it we'd get something that was legible,…but crowded, and a little bit of a mess.…If we're going to present data like this in Excel…we need to figure out a way to summarize it.…The tool that is provided for us to summarize…tabular information with is called a PivotTable.…And if you're new to PivotTables…or you've tried them and had trouble with them,…as some people do, don't worry about it.…
PivotTables are really wicked easy,…particularly if you know exactly…what it is you'd like to be able to do with your data.…This data is already formatted as a table,…so if I go to the Table Tools Design tab…there's a choice to Summarize with PivotTable.…There's also a command to insert a PivotTable…if your data is in a range rather than in an existing table.…But I'm going to use the Table Tools tab…and choose Summarize with PivotTable.…And the first thing that happens…is I'm asked to choose the data that I want to analyze.…
- 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.