Excel: Dynamic Tables
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
Specific goals | Temary
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
Level 1
Excel: Working with data tables - Online
Level 1
Excel: Pivot tables - Online
Level 2
Excel: Formulas, pivot tables, and charts
Editions
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.
Course ratings
Trainer's name
FERRER MARTÍNEZ
Related courses
- Excel: Automate processes with VBA Macros
- Excel: Conditional Formats
- Excel Intensive 1: Preparation for the official Microsoft MO-200 certification
- Excel Intensive 2: Preparation for the official Microsoft MO-201 certificate
- Excel: Pivot Tables and Pivot Charts
- Excel: Power Pivot
- Excel: Power Query
- Excel: Working with data tables
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
