Cod: 61020
Department: DCSG
Scientific area: Management
Total working hours: 156
Total contact time: 15

This unit introduces concepts of electronic spreadsheets, namely in Excel, applicable to different domains in economy and management. Study and solving Linear Programming problems through the efficient allocation of limited resources to achieve a certain goal will be considered. Application of MS Excel Solver tool in solving linear programming problems. Techniques to develop data visualization graphics.

Spreadsheet application
MS Excel
Linear Programming
Data Visualization

It is intended that students get knowledge how to use MS Excel spreadsheet, respective functionalities and applications to solve management problems. After being approved in the unit, the student must be able to:
• Good command of the rules to develop functions and formulas;
• Analysis, treatment and database management
• Automatization of tasks through the use of command and functions macros
• Solve Linear Programing problems using the MS Excel Solver.
• Understand and know how to use the integration with SQL databases.
• Know how to use the Ms Excel Data visualization tools.


1. Introduction
2. Fundamental Elements
3. Functions
4. Charts and graphics
5. Operations with Tables
6. Tools for Prediction and Simulation
7. Programming on Excel: Macros
8. Linear Programming (LP) with the MS Excel
9. Integration with SQL Data Baes,
10. Data Visualization
11. Practical Applications

Mandatory Bibliography:
Bernardo, Maria do Rosário Matos; Negas, Mário Carrilho; Isaías, Pedro (2013). Excel Aplicado. FCA - Editora Informática. ISBN: 9789727227556
Other (supportive) Bibliography:
Walkenbach, John (2013). Excel 2013 Bible. John Wiley & Sons, Inc.. ISBN: 978-1-118-49036-5


Continuous assessment is privileged: 2 or 3 digital written documents (e-folios) during the semester (40%) and a presence-based final exam (p-folio) in the end of the semester (60%). In due time, students can alternatively choose to perform one final presence-based exam (100%).

Basic texts are written in Portuguese, however students are recommended to be competent in English as complementary readings may be in that language, if needed.