Advance with Spreadsheet (Biblioteques)
Advance with Spreadsheet (Biblioteques)
Advance in your knowledge of spreadsheets: do you work with many rows and columns and want 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.
Objectius específics | Temari
Objectives and syllabus
Advance knowledge of spreadsheets: Learn to make lists, protect sheets, make dynamic tables and work with many data efficiently
General objective
Know advanced concepts of spreadsheet and learn to manage dynamic tables, graphic creation, validations, lists, sheet protection and integration of graphics and tables in text documents and presentations.
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 text documents and presentations
Syllabus
- 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 and graphics in text documents and presentations.
This activity is taught in the Antenes Cibernàrium located in the multimedia spaces of the Biblioteques de Barcelona network.
Check here which antennas you can do the activity, the available dates and register.
Informació general
Entry to the classroom will not be allowed after 15 minutes of class start.
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.
Nom del formador
Llei Orgànica de Protecció de Dades de caràcter Personal
Hi ha una nova versió de la Llei Orgànica de Protecció de Dades de Caràcter Personal.
Si us plau, accepta-la per poder continuar amb la inscripció.
