Breadcrumb

ActivitatsDetall

Excel: Working with data tables

Description
This course will teach you how to create data tables from scratch and use their advanced features and formulas. You will start with an introduction to the definition and use of tables, followed by table creation and key characteristics. You¿ll learn how to apply formulas both inside and outside the tables, as well as how to work with matrices and the totals row, enhancing data management and processing efficiency.
Content

OBJECTIVES

  • Create tables from scratch
  • Use of advanced functionalities and formulas

SYLLABUS

  1. Introduction to data tables
    • Definition and use of data tables
    • Creating a data table
    • Characteristics of a data table
    • It is a named list
  2. 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 - Online

Level 1

Excel: Pivot tables - Online

Level 2

Excel: Formulas, pivot tables, and charts
Teachers
FERRER MARTÍNEZ, ENRIC
Driving
Enric Ferrer

Calendar

Days and times
Venue
Language of instruction
Registration
Online
1 Oct, 2025
31 Dec, 2025
Language of instruction:Catalan
I want to sign up →

Find out more

Learn at your own pace
Online training is self-training, quarterly and you can register at any time.
Enjoy learning from wherever you want, at your own pace and without schedules.

Access
The activities are available at the Virtual Campus of Barcelona Activa 

Certificate
To obtain the certificate of completion, the final questionnaire of the course must be completed. Once passed, you can download it in the Personal Area 

ActivitatsAnnexos