Experience in the use of computers will be valuable.

-Be able to create books and spreadsheets organizing data and the management of data cells. -Acquire the skills to create series and insert comments including the spreadsheet styling and formatting. -Be able to manage spreadsheets: copy and paste operations, insert, remove cells, rows and columns. -Use different types of formula, absolute and relative references and management of operations and operators. -Be able to link different spreadsheets. -Understand the structure of a formula, sorting and filtering data. -Understand the use of tables: formatting, management and sorting and filtering of data. -Understand the creation and management of charts: titles, captions, edges, images, etc.

1. Introduction to the use of spreadsheets. 1.1. Foundations and concepts. 1.2. Spreadsheet as a concept. 1.3. Use of spreadsheets. 1.4. Online spreadsheets and collaborative work. 2. Structure of a spreadsheet: book, sheets and cells. 2.1. Foundations and concepts. 2.2. Basic functionalities to edit and manage books. 2.3. Basic functionalities to edit and manage sheets. Importing data and data sources. 2.4. Functionalities to edit and manage books: copy and paste. 2.5. Add, remove, show and hide rows and columns. 2.6. Add and manage comments. 2.7. Printing a spreadsheet: printing area, configuration and preview. 3. Working with cells and sheets. 3.1. Datatypes. 3.2. Formatting cells (styles). Paste special. 3.3. Autofill options. Design and use of macros. Series. 4. Formula and references. 4.1. Basic operations: arithmetic, string and comparison operators. 4.2. Building references: types and creation between books and sheets. 4.3. Linking spreadsheets. 4.4. Linking books. 4.5. Debugging formula 4.6. Functions and formula within the Journalism area. 4.7 Understanding formula and functions. 5. Tables and Pivot tables. 5.1. Creating a pivot table. Definition and fields. 5.2. Operations and management: filtering and sorting data. 5.3. Formatting pivot tables. 5.4. Data forms. Database functions. 5.5. How to create a pivot table. Definition and fields. 5.6 Understanding tables. 6. Data visualization. 6.1. Chart types. 6.2 Selecting the proper chart. 6.3. Data sources. 6.4. Edge customization 6.5. Formatting the chart area: title, caption and colors. 6.6. Inserting images. 7. Spreadsheets as a starting point. 7.1 Document generation. 7.2 Data export. 7.3 Add-ins and third-party tools to visualize and manage data. - There is a SPOC related with all these concepts.

Requirements: Students must bring their laptops to the face-to-face sessions. The reference version will be Excel 365 for Windows, Spanish or English language version, depending on the language of the enrolment group. Moreover, students will have access to Excel 365 for Windows in the Virtual Classroom. LEARNING ACTIVITIES Theoretical Lectures: - Show foundations and main concepts Practical Lectures: - Exercise resolution - General tutoring Individual Work: - SPOC - Exercises - Contribution to team activities - Study and preparation of final test Team Work: - Exercises - Development of a study case in group The group study case will consist of the development of a complete case from data loading, analysis, and graph generation with objective of use and interpretation.