Software for Managers 1

Lecturer:

Tutor:

Supervisor:

Department of Economics, Management and Humanities

Synopsis:

Use of spreadsheet EXCEL: basic calculations, block commands, standard set of functions, graphs, database operations, macros, user environment, basics of user applications building.

Requirements:

Syllabus of lectures:

Syllabus of tutorials:

1. Operating system MS Windows XP (general overview)

2. Spreadsheet (Quattro Pro for Windows) - introduction

3. Block manipulations

4. Grafic layout of tables

5. Simple calculations

6. Standard functions of Quattro Pro

7. Graphs (basics)

8. Graphs (continuing)

9. Database functions

10. Data import and export

11. Advanced mathematic calculations

12. Macros (introduction)

13. Macros (buttons, user menus)

14. Macros (user dialogs)

Study Objective:

Study materials:

[1] EXCEL documentation

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: