Breadcrumb

ActivitatsDetall

Excel: Dynamic Tables

Description
This course will teach you how to master the use of advanced formulas and gain an in-depth understanding of pivot tables. You will learn how to create and manage pivot tables from their data source to their structure, using rows, columns, values, filters, and more. You will also explore formatting, hierarchies, and data updates. Additionally, you'll discover how to perform comparative calculations, percentages, and dynamic charts to efficiently and visually analyze data. Ideal for optimizing data management and analysis
Content

OBJECTIVES

  • Master the use and application of formulas
  • Understand the key aspects of pivot tables

SYLLABUS

  1. Introduction to pivot tables
    • What are pivot tables?
    • Data sources
    • Structure of a pivot table
  2. How to create a pivot table
    • First steps, initial window
    • Rows, Columns, Values, Filters, Slicers, and Timelines
    • Formatting value fields and pivot table format
    • Using hierarchies
    • Data updates
  3. Different types of calculations
    • Basic types of calculations
    • Calculated fields
    • Obtaining percentages, comparisons, etc.
    • Time period comparison calculations
    • Pivot charts

TRAINING PATH EXCEL: FORMULAS AND TABLES

Level 1

Excel: Working with data tables - Online

Level 1

Excel: Pivot tables - Online

Level 2

Excel: Formulas, pivot tables, and charts
Teachers
FERRER MARTÍNEZ, ENRIC
Driving
Enric Ferrer

Calendar

Days and times
Venue
Language of instruction
Registration
Online
1 Apr, 2025
30 Jun, 2025
Language of instruction:Catalan
I want to sign up →

Find out more

>> Online activities are asynchronous. You can register at any time.

>> While the registration is open, you can find the activity in your Espai personal or by directly accessing the Campus virtual link.

>> You will receive a completion certificate once you finish the training. You can download it from your Espai personal.

ActivitatsAnnexos