Excel: Dynamic Tables
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
OBJECTIVES
- Master the use and application of formulas
- Understand the key aspects of pivot tables
SYLLABUS
- Introduction to pivot tables
- What are pivot tables?
- Data sources
- Structure of a pivot table
- 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
- 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
Available dates for the activity
Edition 1
Modality: Online
Language: Catalan
Dates: From 01/10/25 to 31/12/25
Edition 2
Modality: Online
Language: Catalan
Dates: From 01/01/26 to 31/12/26
Opening of registration 31/12/2025 to 23:59 h.
General information
>> 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.
