W-EX-TB Excel Pivot table

Course Overview

The dynamic cross table is a powerful data analysis tool. However, it is possible to install and use it simply. It would be unfortunate if its apparent complexity prevents you from benefiting from its functionalities.

The primary objective of this Webinar is to enable you to use an Excel dynamic cross table simply. It is therefore mainly intended for persons who have never created a table of this type on their own.

Prerequisites

Syllabus

Discover the usefulness of the tool:

Break the myth of complexity ;

• Discover a data analysis tool ;
• Present data dynamically ;
• Centralize the data filtering, sorting and grouping tools;

Create a table step by step :

• Select your data Organize your data ;
• Convert the table ;
• Format the data ;
• Filter the data .

Create a data chart :

• Link the data to the picture.