Menu Display

Breadcrumb

Activity Record

Basic
 

Advance with the spreadsheet (Multission) - Virtual Classroom

Advance in your knowledge of spreadsheets: do you work with many rows and columns and want to be able to correctly manage and analyze the information? Would you like to do a summary box of the data automatically? Would you like to show the data in the form of a graph? Would you like to create automatic lists or validate the values entered? Take advantage of the tools provided by spreadsheets and save time.

Specific goals | Temary

IMPORTANT: This activity is divided into two sessions. They will be taught virtually in streaming through the free platform Microsoft Teams. The registered people will receive by email, before the first session, a unique link for all the sessions and the access instructions.

Objectives and syllabus

Advance knowledge of spreadsheets: Learn to make lists, protect sheets, make dynamic tables and work with many data efficiently.


General objective

Learn new concepts from spreadsheets such as dynamic tables, graphic creation, validations, lists, protection of our sheets and integration of graphics and tables in Word documents.

Specific objectives

- Learn to create and manipulate dynamic tables.
- Learn to generate graphics from our data.
- Know how to use the sorting, filtering and subtotals options of spreadsheets.
- Learn to create lists and validations of cell contents.
- Learn to protect cells and sheets with password.
- Integrate tables and graphics in our Word documents.


Complete syllabus (2 sessions)

- Sorting, filtering and subtotals
- Creation of dynamic tables and their manipulation
- Calculated fields of dynamic tables
- Graphics creation
- Graphics from dynamic tables
- Validations of cell contents.
- Creation of lists linked to cells.
- Protection of cells, sheets and book by password.
- Integration of tables in Word documents.
- Integration of graphics in Word documents


Editions

Edition 1
Modality: Virtual classroom
Language: Catalan
Dates: From 15/07/2025 to 17/07/2025
2 virtual classroom sessions
  • Tuesday 15 July · 10:00h - 12:00h
  • Thursday 17 July · 10:00h - 12:00h
  • Places available Sign me up
    Edition 2
    Modality: Virtual classroom
    Language: Catalan
    Dates: From 23/07/2025 to 25/07/2025
    2 virtual classroom sessions
  • Wednesday 23 July · 16:00h - 18:00h
  • Friday 25 July · 16:00h - 18:00h
  • Opening of registration 08/07/2025 to 08:30 h.
    Edition 3
    Modality: Virtual classroom
    Language: Catalan
    Dates: From 30/07/2025 to 01/08/2025
    2 virtual classroom sessions
  • Wednesday 30 July · 10:00h - 12:00h
  • Friday 1 August · 10:00h - 12:00h
  • Opening of registration 15/07/2025 to 08:30 h.

    General information

    In the activities of the Virtual Classroom, all those who have accessed the space in the first 30 minutes of the training will be considered as "assisted". People who join later will be counted as "not assisted" and will not be generated the corresponding certificate.

    The language in which each session is taught is informed in the description of each activity.

    Any of Cibernàrium¿s training actions may be recorded through an image capture system that aims to disseminate them later through a medium or support in the field of the Barcelona Activa mission to contribute to economic promotion and employment. In the recording process, images of those attending the training can be recorded. Registration for the activities of Cibernàrium implies the authorization of Barcelona Activa to use these images for the previous purpose.

    Modality: Virtual classroom
    Duration: 2 sessions (4 hours)
    Language: Catalan
    Dates: From 15/07/2025 to 17/07/2025

    Theme: Formació bàsica - Online / Productivity

    Course ratings

    Average
    8.8

    Trainer's person

    LLUÍS

    SENMARTI ARENILLAS

      Personal Data Protection Law

    Personal Data Protection Law

    There is a new version of Personal Information Protection law.
    Please, accept it before continuing the registration.

      You are registering

    Advance with the spreadsheet (Multission) - Virtual Classroom: Edition 1

    Tue 15/07/25 10:00-12:00h

    Virtual classroom

    Thu 17/07/25 10:00-12:00h

    Virtual classroom

    Advance with the spreadsheet (Multission) - Virtual Classroom: Edition 2

    Wed 23/07/25 16:00-18:00h

    Virtual classroom

    Fri 25/07/25 16:00-18:00h

    Virtual classroom

    Advance with the spreadsheet (Multission) - Virtual Classroom: Edition 3

    Wed 30/07/25 10:00-12:00h

    Virtual classroom

    Fri 01/08/25 10:00-12:00h

    Virtual classroom

    Personal information

    Full Name:

    Screen Name: 20101

    Email: default@liferay.com

    I agree registration conditions