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
Learn at your own pace
The online training courses are self-paced and you can register at any time.
Enjoy learning from wherever you want, at your own pace and without schedules.
Access
The activities are available at Campus Virtual de Barcelona Activa Certificate
To obtain the certificate of completion, it is necessary to complete the final questionnaire of the course. Once passed, you can download it to your
Personal space.
