Base Knowledge
Basic concepts of Mathematics.
Teaching Methodologies
The concepts are introduced first and then are applied in problem-solving based on Microsoft Excel software.
Learning Results
1. Objectives: to understand how a spreadsheet works and the potential of its application to the resolution of real problems, in the several fields addressed throughout the course.
2. Generic skills: application of knowledge and understanding of concepts; decision-making; communication; self-learning.
Program
- Fundamentals of Microsoft Excel (version 2021/Office 365).
- Formulas and functions.
- Information organization.
- Charts.
- Advanced data analysis: pivot tables and pivot tables; scenarios; goal-seeking.
- Importing and exporting information.
- Excel programming: automation of tasks through Macros; Visual Basic for Applications (VBA) programming language.
Curricular Unit Teachers
Grading Methods
Avaliação Contínua
- - Teste Prático - 100.0%
- - Teste Prático - 100.0%
Internship(s)
NAO
Bibliography
Smart, M. (2022a). Learn Excel 365 essential skills with The Smart Method (6th ed.).
Smart, M. (2022b). Learn Excel 365 expert skills with The Smart Method (6th ed.).
Alexander, M., & Kusleika, D. (2022). Microsoft Excel 365 bible. John Wiley and Sons.