Excel in Economics

Total Hours in Course81

Number of hours for seminars and practical classes32

Independent study hours49

Date of course confirmation03.05.2011

Responsible UnitInstitute of Economics and Finance

Course developer

lect.

Aija Jurevica

Mg. paed.

Course abstract

The course is provided for acquaintance with possibilities of Excel and its application in data processing, calculations in economics, data consolidation, selection (Advanced Filter), analysis (Pivot Table and Subtotals), and optimization (Table, Goal Seek).

Learning outcomes and their assessment

Knowledge – on data gathering and processing methods provided by MS Excel software – consolidation, pivot table, filtering and subtotals; application peculiarities, advantages and disadvantages. Skills – to apply MS Excel data processing methods for processing large tables and obtaining the results. Competences – ability to choose reasonably the most appropriate data processing method for solving a particular task and/or to modify data structure according to the requirements of data processing method to calculate the required results.

Compulsory reading

1. Aizpuriete V. Microsoft Excel profesionālai izglītībai. Rīga: Mācību grāmata 2002., 252 lpp.
2. Dukulis I. Apgūsim jauno Excel!: Microsoft Office Excel 2003. Rīga: Turība, 2007., 173 lpp.
3. Ķinķere A. Excel 2000 ... no A līdz Z. 2.grāmata. Rīga: Datorzinību centrs, 2000.
4. Карлберг К. Бизнес-анализ с помощью Excel 2000. Москва, 2000. 479 c.

Atsauksmes