Excel: Working with data tables
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
OBJECTIVES
- Create tables from scratch
- Use of advanced functionalities and formulas
SYLLABUS
- Introduction to data tables
- Definition and use of data tables
- Creating a data table
- Characteristics of a data table
- It is a named list
- Formulas using data tables
- Creating formulas within the table itself
- Creating formulas from outside the table
- Formulas with arrays from the data table
- Totals row
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.