Description
Pivot tables allow you to quickly analyze a large volume of data by obtaining a summary table in just a few clicks. Reorganized as desired, they allow you to view the same information from different angles. This very powerful feature owes its success to its ease and flexibility of use. However, it requires carefully preparing the database to be analyzed.
Who is this training for ?
For whom ?Anyone who uses and analyzes data in Excel 2013 or Excel 2016.
Prerequisites
Training objectives
Training program
- Prepare the database
- Organize the data: the rules to follow.
- 'Clean' the imported data: remove unnecessary spaces, cell mergers.
- Put the data under table form to facilitate updates.
- Complete the data to refine the analysis: add information from another table dissociate or merge data.
- Construct pivot tables and charts
- Set up a one-, two- or three-dimensional pivot table.
- Show, hide, sort information.
- Modify summary calculation: average , minimum, count.
- Display percentages, variance calculations or totals.
- Group information by numerical range.
- Dispatch a crosstab across multiple sheets.
- Filter data with segments or timeline.
- Associate a PivotChart.
- Refresh data.
- Optimize their formatting
- Hide field headers.
- Apply a table style.
- Change report layout.
- Add sub -totals.
- Customize number format.
- Apply conditional formatting.
