Excel: Dynamic Tables
Excel: Dynamic Tables
Do you want to learn how to use Excel dynamic tables to optimize your work with data? You will learn how to create a step-by-step pivot table, customize fields and update data.
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 - 24/7
Level 1
Excel: Pivot tables - 24/7
Level 2
Excel: Formulas, pivot tables, and charts
Editions
General information
>> Online activities are asynchronous. You can enroll at any time.
>> During the enrollment period, you can find the activity in your Personal Space or by directly accessing it through the virtual campus link.
>> You will receive a certificate of completion once you complete at least one of the training modules. You can download it in your personal space.
Course ratings
Lesson taught by
FERRER MARTÍNEZ
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.