Programma

Working with clean and accurate data lists:
Understanding the difference between a list and a table (and how to switch between them)
Creating a proper data list
Exploring the features and functionality of a data list
Formatting a data list and using extra options like alternating rows or columns
Sorting a data list by one or multiple columns
Filtering a data list using AutoFilter
Filtering using the Advanced Filter
Protecting data entry using Data Validation

Analyzing a data list with PivotTables:
Using Conditional Formatting to analyze data
Designing and customizing a PivotTable
Grouping values in a PivotTable (like dates, numbers, or text)
Formatting a PivotTable using built-in or custom styles
Adding new fields to a PivotTable
Formatting a numeric field in a PivotTable
Adjusting general formatting settings for a PivotTable
Displaying numbers as a percentage of the total, and other summary options
Using slicers to filter your PivotTable visually

Creating a chart that’s linked to a PivotTable:
Quickly generating a PivotChart from a PivotTable
Modifying a PivotChart

Opmerkingen

Dit is een opengestelde opleiding van Volvo Group Belgium NV, denk zeker aan je eigen lunch en indien nodig, je eigen laptop.

---

Locatie

Smalle Heerweg 31, 9041 Gent