The following panel allows you to customize your consent preferences for any tracking technology used to help us achieve the features and activities described below. For more information on how these trackers help us and how they work, please see the cookie policy. You can review and change your choices at any time.
We use our own and third-party cookies to improve your browsing experience and to offer you content and services of interest.
Continued browsing on your part shall imply full acceptance of our cookies policy.
In this course of Excel dynamic tables you will learn what the dynamic tables are, how the necessary data and its essential parts are obtained.
We will show how to create a step-by-step pivot table, customize fields and update data.
And finally, you will explore different types of calculations, such as sums, media and percentages, in addition to creating dynamic graphics.
To do this course you only need to have a basic level of experience with Excel, since it is designed to adapt to both beginners in this tool, and people with intermediate knowledge.
Presentation of dynamic tables
- What are the dynamic tables?
- Origin of data
- Structure of a pivot table
How to create a pivot table
- First steps, start window
- Rows, Columns, Values, Filters, Segmenters and Time Scales
- Format of the value and format fields of the pivot table
- Data update
Different types of calculations
- Basic calculation types
- Calculated fields
- Obtaining percentages, comparisons, etc...
- Comparison calculations for time periods
- Dynamic Graphics
>> 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.