EX301 - M6 - Excel. Pivot tables. Slicer formatting (data segmentation). | 76/113 | UPV
Título: EX301 - M6 - Excel. Pivot tables. Slicer formatting (data segmentation).
Descripción automática: In this video a tutorial is presented on how to format a slicer for data segmentation in a table. The goal is to display total sales amount by country.
The process involves adding a slicer to the "orders" section where shipping countries are listed. To make the slicer more manageable, options can be adjusted to specify the number of columns desired.
Once formatted, the slicer allows users to select one or multiple countries and filter data accordingly, with the option to link it to multiple tables if needed.
Autor/a: Despujol Zabala Ignacio
Curso: Este vídeo es el 76/113 del curso Excel: Importing and analyzing data. • Excel: Importing and a...
+ Universitat Politècnica de València UPV: www.upv.es
+ Más vídeos en: / valenciaupv
+ Accede a nuestros MOOC: upvx.es
#
Пікірлер