Microsoft Excel supporting decision making

Recommended Prerequisites

Not applicable.

Teaching Methods

This is a distance-learning course that will be based on e-learning technologies. Several types of materials will be available to enable participants to achieve the proposed objectives. Many activities will be proposed allowing participants to use and consolidate the acquired knowledge. Activities that call for collaboration and mutual aid among participants will also be proposed. Teachers will monitor all activities.

Learning Outcomes

At the end of the course participants should be able to use Microsoft Excel as advanced users, using it as a support tool for decision making, being able to structure a spreadsheet and use it in problem solving. They should develop skills in the organization and structuring of data in a spreadsheet and in the design and implementation of spreadsheets for data analysis.

Work Placement(s)

No

Syllabus

1. Introduction to the Excel Environment

2. Building spreadsheets and basic operations

3. Using functions and formulas

4. Building Charts

5. Data Management using Excel

6. Data Analysis using Excel I

7. Data Analysis using Excel II

8. Using Macros.

Head Lecturer(s)

Joana Maria Pina Cabral Matos Dias

Assessment Methods

Assessment
Learners' participation in activities: 30.0%
Assignments submitted during the course: 70.0%

Bibliography

Microsoft Excel 2013 Bible: the comprehensive tutorial resource; John Walkenbach; John Wiley and Sons; 2013.

Microsoft Excel 2013 Inside Out; Mark Dodge and Craig Stinson; Microsoft Press; 2013