Learning Results
This course aims to provide students with advanced conceptual capabilities and practical skills in the field of
spreadsheets and in particular to Microsoft Excel.
As specific objectives of this course it is intended that students are able to use spreadsheets to perform data
analysis, simulation and automation of procedures.
Upon completion of the course the student should be able to: identify conditions of use of the functions of
databases, building pivot tables and graphs, taking advantage of options for defining the data table, the sorting
and filtering operations on fields table, taking into account different criteria and procedures, using the simulation
tools of scenarios, goal seek and Solver, and be able to create and use macros to automate commands and
procedures using the technology Visual Basic for Applications (VBA); and be able to create forms, taking
advantage of the available controls and automation tools.
Program
1. Database functions
2. Pivot Tables and Charts
2.1. Pivot Tables: configuration and options;
2.2. Creating Pivot Charts:data structure and chart options.
3. What-If analysis
3.1. Scenarios
3.2. Goal seek
3.3. Solver
4. Macros and VBA (Visual Basic for Applications)
5. Construction of Standard Forms.
Internship(s)
NAO
Bibliography
[1] Maria Adelaide Carvalho, Exercícios resolvidos com Excel para a Economia e Gestão, 4.ª Edição Atualizada
e Aumentada, ISBN 978-972-722-729-7, FCA – Editora Informática, 2012.
[2] Maria José Sousa, Excel 2010, ISBN 978-972-722-706-8, FCA – Editora Informática, 2011.
[3] Maria José Sousa, Excel 2010, ISBN 978-972-722-691-7, FCA – Editora Informática, 2011.
[4] Paula Peres, Excel Avançado, ISBN 978-972-618-640-3, Edições Silabo, 2011
[5] Luís Silva Rodrigues, Utilização do Excel 2010 para Economia & Gestão, ISBN 978-972-722-669-6, FCA –
Editora Informática, 2011.
[6] Paulo Capela Marques, “Exercícios de Excel 2010”, FCA Editora de Informática Lda, 2011.
[7] Katherine Smith, Smith Murphy and Lawrence Smith (2002), “Microsoft Excel for Accounting: The First
Course”, Prentice Hall.
[8] John Walkenbach, “Excel 2010 Bible”, John Wiley & Sons, 2010.