Learning Results
This course aims to provide students with conceptual and instrumental skills in the field of spreadsheets that
are particularly useful in the context of other courses as well as the subsequent effective and efficient exercise
of students’ professional activity.
The specific objectives of this course aim to give students a basic understanding of management technology
and information systems and the role they play in the organizations; students should be able to use
spreadsheets to solve problems, perform data analysis, create reports and the expound conclusions.
At the end of the course, students should have developed the ability to solve problems using spreadsheet
applications, using advanced features of these tools.
Program
1. Introduction to InformationSystems
2. MicrosoftExcel Spreadsheet
2.1. Basic features
2.2. Study of functions
2.2.1. Introduction to formulasandfunctions
2.2.2. Math functions
2.2.3. Statistical functions
2.2.4. AnalysisToolpakTool
2.2.5. Financial functions
2.2.6. Date and Time functions
2.2.7. Logic functions
2.2.8. Lookup functions
2.3. Charts and graphics
2.4. Data Tables
2.4.1. Data sort
2.4.2. Data filtering
2.4.3. Subtotals
Internship(s)
NAO
Bibliography
1. Luís Silva Rodrigues (2011), “Utilização do Excel 2010 para Economia & Gestão”, FCA Editora de Informática
Lda.
2. Paulo Capela Marques (2011), “Exercícios de Excel 2010”, FCA Editora de Informática Lda.
3. Maria José Sousa (2011), “Fundamental do Excel 2010”, FCA Editora de Informática Lda.
4. António Martins (2004), “Excel aplicado à gestão”, 2ª edição, Edições Sílabo.
5. Jorge Sequeira (2005), “Excel – guião de funções para Economia e Finanças”, Escolar Editora.
6. Katherine Smith, Smith Murphy and Lawrence Smith (2002), “Microsoft Excel for Accounting: The First
Course”, Prentice Hall.
7. Bill Jelen (2010), “Microsoft Excel 2010 in Depth”, QUE.
8. John Walkenbach (2010), “Excel 2010 Bible”, John Wiley & Sons.