Decision Making Support with Excel

Recommended Prerequisites

NA

Teaching Methods

The process of teaching and learning is done through: (a) mixed sessions of theory and practice, with description of the subjects by the teacher; (b) active intervention of the participants, with clarification by demonstration and experimentation; (c) exercises and simulation of practical situations with proposed resolutions.

Learning Outcomes

1. Provide participants the necessary knowledge to become competent users of Excel in order to be able to, in the future, solve autonomously new challenges to be faced.

2. Use Excel at an advanced level, as a tool to support decision making, being able to structure a spreadsheet and use it to support the resolution of problems.

The skills to be developed by the participants are: (1) organizing and structuring data in one or more spreadsheets; (2) carry out the analysis, processing, and management of data in order to extract useful information in the decision-making process; (3) use the ability of automation and integration with other applications.

Work Placement(s)

No

Syllabus

1. Introduction to modeling with Excel;
2. Advanced functions and formulas;
3. Tables and Graphics (automatic and pivot);
4. What-if analysis and problem solving:
5. Using Excel in a collaborative environment;
6. Automating tasks with macros and
7. Communication with other applications and Internet integration.

Head Lecturer(s)

Óscar Manuel Domingos Lourenço

Assessment Methods

Assessment
The assessment includes a computer test (50%) and the resolution of 3 small challenges associated with the topics covered (50%): 100.0%

Bibliography

BALAKRISHNAN, N., RENDER, B. & STAIR, R. M. (2012) Managerial Decision Modeling with Spreadsheets, 3rd edition, Pearson.

WALKENBACH, J. (2016) Microsoft Excel 2016 Bible, John Wiley & Sons, Inc.

ALEXANDER, M., DECKER, J. & WEHBE, B. (2014) Business Intelligence Tools for Excel Analysts, John Wiley & Sons, Inc.

ALEXANDER, M. & KUSLEIKA, D. (2016) Excel 2016 Formulas, John Wiley & Sons, Inc.

ALEXANDER, M. & KUSLEIKA, R. (2016) Excel 2016 Power Programming with VBA, Wiley.