Maintain correct data lists

• Difference between a list and a table (and switching between them)
• Creation of a correct data list
• Explore the functionalities of a data list
• Draw up a data list and its additional parameters (alternating rows/columns, etc.)
• Sort a data list by one or more columns
• Filter a data list using the autofilter
• Filter a data list with the advanced filter
• Secure data entry with data validation rules

Analyzing a data list with PivotTables

• Analyzing a data list using conditional formatting
• Design and customize a pivot table
• Group values in a pivot table (for dates, figures, texts)
• The layout of a pivot table (with predefined or custom styles).
• Add new fields in a PivotTable
• The formatting of a (numeric) field in a pivot table
• General formatting settings of a pivot table
• The display options on numeric fields: as % of the total, etc.
• Use slicers to filter in a pivot table

Chart attached to a pivot table

• Quickly create a (pivot) chart based on a pivot table
• Changing a PivotChart