nline Course - Excel: Working with data tables
nline Course - Excel: Working with data tables
Working with data tables will allow you to create, configure and optimize data tables in Excel, as well as to integrate them into advanced formulas and dynamic tables for a more effective and updated data analysis.
Specific goals | Temary
This Excel course is designed to provide you with the tools and knowledge necessary to transform your Excel listings into powerful data tables.
During the course, you will learn to create tables from scratch, to configure them efficiently and to use their advanced functionalities to improve the analysis and presentation of your data. In addition, you will discover how data tables can facilitate the use of complex formulas, improving the precision and effectiveness of your work.
With this training, you will raise your Excel level of knowledge, opening the door to new possibilities for data analysis and presentation that can enrich your projects and professional reports.
Topic
Introduction to Data Tables
- Definition and use of data tables
- Creating a Data Table
- Characteristics of a data table
- It's a named list
Formulas using data tables
- Creating formulas within the table itself
- Creating formulas from outside the table
- Formulas with matrices from the data table
- Total Row
Editions
From Mon 01/04/24 al Tue 30/04/24
From Sat 01/06/24 al Sun 30/06/24
General information
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.
Course ratings
Lesson taught by
FERRER MARTÍNEZ