Description
Course Outline
- pivot table fundamentals
-
- create a pivot table
-
- add/remove pivot table fields
-
- rearrange the layout of pivot table
-
- rename a field
-
- add a new field
-
- work with value areas
-
- reveal the source data
- summarize data
-
- use functions to summarize values
-
- display values as percentages
-
- compare totals and base value
-
- show running totals
-
- change the sort order
-
- show the ranking values
-
- changing the analysis function
- filters and slicers
-
- filter data using the report filter
-
- filter data using the pivot table filters
-
- organize the pivot table through the use of slicers
- design the pivot table
-
- styling the pivot table
-
- display sub-totals in different positions
-
- remove grand totals
-
- tabular view
-
- outline view
-
- formatting numbers in the data area
- group data
-
- creating custom groups
-
- group data by date
-
- group data by range
- work with multiple tables
-
- create and manage table relationships
- consolidation ranges
-
- consolidate data using a pivot table
-
- work with consolidated data
- pivot table calculations
-
- create calculated items and fields
-
- work the calculated items and fields
-
- understanding the getpivotdata function
- pivot charts
-
- create and format a pivot chart report
-
- work with pivot chart report data
- dashboard
-
- understanding dashboard
-
- create a dashboard