Detall formació
Breadcrumb
ActivitatsDetall
Excel: Dynamic Tables
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
Calendar
Find out more
>> 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.