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
