Excel: Formulas, dynamic tables and graphics
Excel: Formulas, dynamic tables and graphics
In this activity we will go through the different types of formulas that exist in Excel: numerical, text, date, logical and search formulas. Summary of data with pivot tables, how they are created, control of the data source, the four configuration zones, adding, counting and calculating percentages, segmentation and time scales. Creation of dynamic charts.
Specific goals | Temary
OBJECTIVES
- Master the use and application of formulas
- Summary of lists in the form of a pivot table
- Data filtering with data segmentation
SYLLABUS
- Types of data
- Definition of formula and function
- Types of references
- Types of functions
- Pivot tables
- Pivot charts
TRAINING PATH
Level 1
Excel: Working with data tables - Online
Level 1
Excel: Pivot tables - Online
Level 2
Excel: Formulas, pivot tables, and charts
Editions
Fri 20/09/24 (16:00-20:00h)
Fri 27/09/24 (16:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Wed 16/10/24 (16:00-20:00h)
Thu 17/10/24 (16:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Tue 05/11/24 (16:00-20:00h)
Wed 06/11/24 (16:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Tue 26/11/24 (16:00-20:00h)
Wed 27/11/24 (16:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Mon 16/12/24 (16:00-19:00h)
Tue 17/12/24 (16:00-19:00h)
Virtual classroom
General information
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
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.