Base Knowledge
Basic knowledge of Microsoft Excel.
Teaching Methodologies
The expository methodology will be used for the presentation of the concepts of the curricular unit, supported by practical experimentation through the realization of exercises of application of the transmitted concepts, in the computers. Practical experimentation will seek to approach, whenever possible, the situations that students will encounter in their professional lives. In addition to classes, students must develop complementary work, which will be indicated throughout the course.
Learning Results
Aims and Learning Outcomes
This curricular unit aims to provide students with advanced instrumental and conceptual skills in the field of spreadsheets and in particular Microsoft Excel.
Skills
By attending this course, it is intended that students are able to use spreadsheets to perform data analysis, simulations, and automation of procedures. After completing the curricular unit, the student should be able to: identify the conditions for using the database functions; build tables and dynamic charts, taking advantage of the definition options of the
data table, of sorting and filtering operations on table fields, considering different criteria and procedures; use scenario simulation tools, achieve goal and Solver; and be able to create and use command macros and automate procedures using Visual Basic for Applications (VBA) technology.
Program
1. Database functions
2. Dynamic tables and graphs
2.1. PivotTable areas and configuration
2.2. Dynamic graphics setup
3. Simulation
3.1. Scenarios
3.2. achieve goal
3.3. solver
4. Macros
5. VBA (Visual Basic for Applications)
Curricular Unit Teachers
Internship(s)
NAO
Bibliography
Reference books
- Paulo Capela Marques / Nuno Costa (2013), “Fundamental do Excel (2013)”, FCA – Editora de Informática Lda, 978- 972-722-800-3
- Luís Silva Rodrigues (2011), “Utilização do Excel 2010 para Economia & Gestão”, FCA Editora de Informática Lda.
- Paulo Capela Marques (2011), “Exercícios de Excel 2010”, FCA Editora de Informática Lda.
- Jorge Sequeira (2005), “Excel – guião de funções para Economia e Finanças”, Escolar Editora.
- Adelaide Carvalho (2009), “Programação com Excel para Economia & Gestão – 2ª Edição Actualizada e Aumentada”, FCA Editora de Informática Lda.
- Adelaide Carvalho (2009), “Programação com Excel para Economia & Gestão – 2ª Edição Actualizada e Aumentada – Volume II”, FCA Editora de Informática Lda.
- Henrique Loureiro (2007), “Excel 2007 Macros & VBA – Curso Completo”, FCA Editora de Informática Lda.
Reference books in the English version
- Katherine Smith, Smith Murphy and Lawrence Smith (2002), “Microsoft Excel for Accounting: The First Course”, Prentice Hall.
- Bill Jelen (2010), “Microsoft Excel 2010 in Depth”, QUE.
- John Walkenbach (2010), “Excel 2010 Bible”, John Wiley & Sons.