Learning Results
Acquisition of fundamental knowledge that enhance the optimization procedures in the economic and financial area
via a Spreadsheet – Microsoft Excel. Specifically, knowledge and understanding of simple functions with formulas,
managing automatic filters and advanced charting and pivot tables in databases.
Understand and use more specific functions: statistical functions, database functions, date and time functions and
financial functions.
Mastering the aspects related to modeling and operations research problems using the tools Solver and Achieving
Purpose for their resolution.
Program
1. Management information
2. Introduction to Spreadsheet
3. Representation and interpretation of data through graphics
4. Statistical Functions
5. Database
6. Pivot Tables
7. Financial Functions
8. Linear Programming
Internship(s)
NAO
Bibliography
Carvalho A., “Exercícios resolvidos com Excel para Economia & Gestão 2ª Ed. Act. e Aum.”, FCA – Editora
Informática, 2007, ISBN 972-722-472-5
Jorge Sequeira, “Excel: guião de funções para economia e finanças”, Lisboa Escolar Editora, 2006.
Mário Paulo Pinto, “Microsoft Excel 2010”, Edições Centro Atlântico, ISBN: 978-989-615-109-6
Martins, A. , “Excel aplicado à gestão”, 2ª ed., corrigida. – Lisboa : Sílabo, 2006
Rodrigues, L., “Utilização do Excel 2010 para Economia & Gestão”, FCA – Editora Informática, ISBN:
978-972-722-669-6