This course does not require prior knowledge or having taken specific subjects.

This course is designed to provide students with the necessary skills to work with structured data in spreadsheet environments, fostering a functional, practical, and professional use of these tools. Throughout the course, students will develop an understanding of how to organize and analyze data, apply basic and intermediate functions, visually represent information, and prepare clear and useful documents to support decision-making. The course also encourages the use of spreadsheets as an accessible and reflective resource, committed to sustainability, digital inclusion, and basic security. Learning Objectives: - Create and organize workbooks and spreadsheets, efficiently managing cells and ranges. - Apply custom formats, generate lists and data series, and insert comments and notes. - Edit and reorganize sheets using features such as paste special, data validation, and row and column operations. - Use formulas with basic and mixed operators, and work with relative, absolute, and mixed references. - Link data across sheets and workbooks to integrate information from multiple sources. - Understand the general structure of a function and use logical, text, and lookup functions in real-life scenarios. - Create and format tables, sort and filter data using multiple criteria and custom filters. - Build basic pivot tables to summarize information and support data analysis. - Design appropriate charts based on the type of information, customize and combine them to create effective visual reports. - Prepare accessible spreadsheets, reflect on their social and environmental impact, and apply principles of equity and digital responsibility. Additionally, students will be able to: - Learn basic tools for automating repetitive tasks (forms, templates, validations) without the need for programming. - Understand the basic principles of digital signatures and their usefulness in professional contexts. - Digitally sign documents securely and recognize the validity of digital signatures. - Identify the most common digital security risks in office environments and apply best practices for information protection.

K8: Communicate to all types of audiences (specialized or not) in a clear and precise way, knowledge, methodologies, ideas, problems and solutions K9: Be able to debate and formulate critical reasoning, using precise terminology and specialized resources, on international and global phenomena, using both the concepts and knowledge of the different disciplines and the methodologies of analysis, paradigms and concepts of the Humanities and Social Sciences K10: To know the principles and values of democracy and sustainable development, in particular, respect for human rights and fundamental rights, gender equality and non-discrimination, the principles of universal accessibility and climate change. S10: Plan and organize teamwork by making the right decisions based on available information and gathering data in digital environments S11: Use the information by interpreting relevant data avoiding plagiarism, and in accordance with the academic and professional conventions of the area of study, being able to evaluate the reliability and quality of such information C5: Develop skills to convey clear and grounded ideas about history and politics, orally and in writing C6: Know and be able to manage interpersonal skills on initiative, responsibility, conflict resolution, negotiation, etc., that are required in the professional field

1. Introduction and Structure of a Spreadsheet 1.1. Key Concepts: workbooks, sheets, cells, ranges, and references 1.2. Editing and Organizing Spreadsheets 1.3. Importing from CSV, Excel, and Google Sheets 1.4. Managing Rows and Columns: insert, delete, group, hide 1.5. Comments, Notes, and Online Collaboration 2. Working with Cells and Sheets 2.1. Data Types: text, numeric, date, percentage, and custom 2.2. Cell Formatting: borders, fill, fonts, alignment 2.3. Advanced AutoFill and Custom Series 2.4. Data Validation: dropdown lists and error control 2.5. Using Named Ranges 3. Formulas and References 3.1. Basic and Combined Operators: arithmetic, logical, and text 3.2. Absolute, Relative, and Mixed References in Multi-Sheet Contexts 3.3. Using Common Functions 3.4. Tracing Dependents and Precedents 3.5. Formula Auditing: Step-by-Step Evaluation 4. Tables and Pivot Tables 4.1. Creating and Configuring Tables with Totals and Filters 4.2. Advanced Filtering, Slicers, and Multi-Level Sorting 4.3. Applying Professional Formatting to Tables 4.4. Introduction to Pivot Tables: Basic Construction and Usage 4.5. Practical Case Analysis with Pivot Tables 5. Data Analysis and Task Automation 5.1. Introduction to Analysis Functions 5.2. Using Date, Time, and Text Functions for Dynamic Reports 5.3. Introduction to Recording Simple Macros (No Code Editing) 5.4. Building Automated Templates 6. Data Visualization 6.1. Chart Types: column, line, area, pie, and combo 6.2. Selecting Charts According to Variable Type 6.3. Data Sources and Linked Charts 6.4. Customizing Axes, Labels, Titles, and Legends 6.5. Visual Design and Presentation: Color Palettes, Templates, and Styles 7. Accessibility and Document Creation from Spreadsheets 7.1. Basic Principles of Accessibility in Spreadsheets 7.2. Exporting and Generating Derived Documents (PDFs, Reports) 7.3. Simple Forms Integrated in Google Sheets or Excel 7.4. Print Settings and Previews 7.5. Reusing Spreadsheets for Presentations or Dashboards 8. Basic Cybersecurity Concepts 8.1. Basic Digital Security in Office Environments 8.2. File Types and Secure Information Management 8.3. Common Threats: Viruses, Phishing, and Preventive Measures 8.4. Best Practices for Passwords and Secure Storage 9. Digital Signature 9.1. What is a Digital Signature and How it Works 9.2. Introduction to Digital Certificates (FNMT, Cl@ve, DNIe) 9.3. Signing PDF Documents and Spreadsheets 9.4. Signature Validation and Visualization in Office Tools 9.5. Professional and Basic Legal Use Scenarios

Requirements - Students must bring their laptops to class. - The reference version will be Excel 365 for Windows, in Spanish or English, depending on the language of the enrolled group. - Additionally, students will have access to Excel 365 for Windows through the Virtual Classroom. Learning Activities Theoretical classes - Presentation of concepts Practical classes - Guided exercise solving - General tutoring sessions Individual work - Completion of the SPOC - Exercise development - Contribution to team activities - Study and preparation for the final assessment Teamwork - Exercise development - Completion of a group case study The group case study will involve the full development of a case, including data loading, analysis, and graph generation, with the aim of facilitating use and interpretation. This case study, as well as other exercises, will address sustainability-related topics and will have the cross-cutting objective of encouraging students to learn about and reflect on the Sustainable Development Goals (SDGs).