Menu Display

Breadcrumb

Activity Record

Basic
 

Introduction to the spreadsheet (Multission) - Virtual classroom

Learn how to use a spreadsheet and learn about its work environment, with the options to scroll inside it and entering data: menus, formatting cells, status bar, tabs, hiding rows and columns... and also learn to enter basic formulas, ranks, different types of most used functions (numerical, dates, text), relative and absolute references and the name manager, ...

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


In this activity we will learn the general concepts of spreadsheets, as well as the specific names of them, such as formatting the cells, knowing the most used menus and practice with the work area. We will also learn how to use formulas, functions, ranges... Find out about their characteristics and how to use them with your spreadsheets.

Specific objectives

- Learn to create a spreadsheet
- To know the specific vocabulary (cells, rows, columns, formula bar, work area,...)
- Understand the different menu options that we can find in spreadsheets

- Learn to enter simple mathematical formulas: use of the symbols s, *, ( ) ,...
- To know and understand the different types of data ranges.
- Become familiar with different numerical functions, date and text and their arguments.


Syllabus

First session

- The different software: Calc, Excel,...
- Work area
- Titlebar
- Menu bar
- Formula bar
- Scrollbar
- Tabs
- Status bar
- Format Cells
- Cloud computing software

Second session

- Formulas
- Ranges
- Numerical functions
- Date Functions
- Text functions
- Relative and absolute references
- Name manager.

Editions

Edition 1
Modality: Virtual classroom
Language: Catalan
Dates: From 08/07/2025 to 10/07/2025
2 virtual classroom sessions
  • Tuesday 8 July · 10:00h - 12:00h
  • Thursday 10 July · 10:00h - 12:00h
  • Places available Sign me up
    Edition 2
    Modality: Virtual classroom
    Language: Catalan
    Dates: From 16/07/2025 to 18/07/2025
    2 virtual classroom sessions
  • Wednesday 16 July · 16:00h - 18:00h
  • Friday 18 July · 16:00h - 18:00h
  • Places available Sign me up
    Edition 3
    Modality: Virtual classroom
    Language: Catalan
    Dates: From 23/07/2025 to 25/07/2025
    2 virtual classroom sessions
  • Wednesday 23 July · 10:00h - 12:00h
  • Friday 25 July · 10:00h - 12:00h
  • Opening of registration 08/07/2025 to 08:30 h.
    Edition 4
    Modality: Virtual classroom
    Language: Catalan
    Dates: From 29/07/2025 to 31/07/2025
    2 virtual classroom sessions
  • Tuesday 29 July · 16:00h - 18:00h
  • Thursday 31 July · 16:00h - 18:00h
  • Opening of registration 14/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 08/07/2025 to 10/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

    Introduction to the spreadsheet (Multission) - Virtual classroom: Edition 1

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

    Virtual classroom

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

    Virtual classroom

    Introduction to the spreadsheet (Multission) - Virtual classroom: Edition 2

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

    Virtual classroom

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

    Virtual classroom

    Introduction to the spreadsheet (Multission) - Virtual classroom: Edition 3

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

    Virtual classroom

    Fri 25/07/25 10:00-12:00h

    Virtual classroom

    Introduction to the spreadsheet (Multission) - Virtual classroom: Edition 4

    Tue 29/07/25 16:00-18:00h

    Virtual classroom

    Thu 31/07/25 16:00-18:00h

    Virtual classroom

    Personal information

    Full Name:

    Screen Name: 20101

    Email: default@liferay.com

    I agree registration conditions