Duration: 3 hours per week - 13 weeks [ECTS: 5]

Course outline

This course develops and uses Excel spreadsheets as a modeling platform, for a wide range of economic computations. Students learn to apply Excel commands, functions, and add‐ins and practice good spreadsheet design. In case discussions, students explore the effectiveness of various spreadsheet models.

Learning Modules

1.      Introduction to Spreadsheets.
2.      Performing calculations in spreadsheets of Excel (v. Microsoft Office 365).
3.      Function syntax in Excel.
            a. Mathematical functions in Excel.
            b. Statistical functions in Excel.
            c. Financial functions in Excel.
4.      Logical functions in Excel.
5.      Lookup and reference functions.
6.      How to plot in Excel.
7.      How to organize large amounts of similar data in lists
8.      PivotTables and PivotCharts.
9.      Special topics in business and financial applications.