Recommended Prior Knowledge

-

Objectives

· Identify and explore spreadsheet features that enable them to enter and process numeric and alphanumeric data in this format.

· Understand and apply spreadsheet features for inserting and editing data.

· Understand and apply pivot table and charting functionalities.

· Understand and apply the main functions used to extract new information from core data.

Teaching Methods

The Curricular Unit (UC) is delivered through a flexible e-learning framework. The online sessions integrate synchronous and asynchronous activities, centered on student effort and active participation.

Continuous evaluation

Assessment Methods:

• Completion of one Test (T), with a minimum passing grade of 10 points (out of 20);


• Class Participation and in-class activities/exercises (PA).

The Final Grade for the Curricular Unit is calculated based on the following weightings: Final Grade = 60% (T) + 40% (PA).

Internship(s)

Não

Syllabus

1. Fundamental Concepts

2. Functions

2.1. Simple functions

2.2. Functions with criteria

2.4. Functions for Decision and text manipulation

2.5. Search and reference

3. Create data tables

4. Pivot tables/charts

5. Additional topics

5.1. Data Validation

5.2. Form Controls

5.3. Power Query

6. Spreadsheet Organization

Content Explanation

-

Methodology Explanation

-

Responsible Lecturer(s)

Vítor Manuel Meneses Barbosa - 1.º Quarter

Bibliography

· Curso, J., Vieira, D. (2023) Excel para Economia e Gestão (5ª Edição). Edições Sílabo

· Martins, A., Alturas, B. (2022) Aprenda Excel com Casos Práticos (2ª edição). Edições Sílabo

· Martins, A. (2020). Excel Aplicado à Gestão. Edições Sílabo (edição portuguesa). ISBN: 9789895610426.

· Rodrigues, L. (2016). Utilização do Excel para Economia & Gestão. FCA