Detall formació
Breadcrumb
ActivitatsDetall
Online course - 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
Enrolment
>> This online activity is available between the first and last day of each month.
>> Registration is possible even if it has already been started.
>> To enroll in any online activity you need to have a web user created. You can create it here.
>> Once enrolled you will find the course in your Personal Space --> Activities --> Activities in progress (barcelonactiva.cat)
>> You can access the materials of the activity while editing is active.
>> This online course is self-training.
>> To view the videos subtitled, click on the CC button you will find in the video playbar and select language.
Certificate
>> You will get a certificate of accomplishment when completing all modules and overcoming the activities/test, of the formation before the end of the editing in which the enrolment was made.
>> Course completion status. Within the same course you will find the Results menu point, you will find the Export option (top right). Clicking will open a document showing a report with the status of each lesson. If there are any lessons that are not approved, the contents need to be re-examined as there is some part left undisplayed/made.
>> Once the training is completed, within 24 to 48 hours you will be able to download the certificate to your Personal Space --> Activities --> Activities performed (barcelonactiva.cat)
Recommendations
>> It is recommended to perform training from a computer and not from mobile or tablets.
>> The most used browsers are: Google Chrome, Safari (for iOS operating systems), Microsoft Edge (for Windows operating systems) and Mozilla Firefox.