Training: Excel – Analyze your data

Module 1: Filtering and extracting data

• Use the advanced filter
• Set up your criteria zones
• Define the extraction zone

Module 2: Inserting a pivot table

• Prepare the data
• Inserting a pivot table
• Adding fields to a pivot table
• Reorganize the fields in a pivot table
• Delete fields from the pivot table
• Refresh a pivot table

Module 3: Field settings

• Modify summarizing in a pivot table
• Use a calculated field in a pivot table
• Insert a calculated field in a pivot table

Module 4: Pivot Charts

• Create a pivot chart
• Add and customize chart elements
• Modify the format of pivot charts

Module 5: Using Slicers and Timelines

• Insert a slicer
• Insert a timeline
• Manage slicer settings
• Manage report connections