Excel - gegevenslijsten analyseren - opengesteld English

Omschrijving

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.