Spreadsheets and Programming

Course code

MLM6309.DT

old course code

Course title in Estonian

Tabelarvutus ja programmeerimine

Course title in English

Spreadsheets and Programming

ECTS credits

4.0

Assessment form

assessment

lecturer of 2021/2022 Spring semester

Maria Zeltser (language of instruction:English)

lecturer of 2022/2023 Autumn semester

lecturer not assigned

Course aims

The subject requires basic knowledge of Excel. The purpose of the subject is to teach you to manage large data tables in Excel, use various Excel functions, teach basic knowledge for writing macros in Excel

Brief description of the course

window splitting, sorting, filtering, custom filter and special filter. conditional format. Frequency tables, statistical functions. Diagrams, dates and times, date arithmetic, text functions, searching, validation, lookup functions, pivot tables.

Creating, repairing, and running VBA procedures. Using VBA Editor. Declaring variables. IF clause. Input and output sentences. Case statement. Basic VBA Functions. Loops. Useing dates and times. Arrays. String functions. Sub-programs and functions in VBA. Using forms. Using files to read and write data..

Creating, repairing, and running VBA procedures. Using VBA Editor. Declaring variables. IF clause. Input and output sentences. Case statement. Basic VBA Functions. Loops. Useing dates and times. Arrays. String functions. Sub-programs and functions in VBA. Using forms. Using files to read and write data..

Learning outcomes in the course

Upon completing the course the student:

- has skills in MS Excel advanced options, including various data analysis tools for spreadsheet calculations;

- can process and analyze large volumes of data, as well as use various Excel functions and combine them to make calculations;

- can create simple macros (sub-programs) in VBA;

- can search for program errors and check the progress of the program;

- can efficiently combine recorded and handwritten code;

- can create new user functions and use them on the Excel worksheet.

- has skills in MS Excel advanced options, including various data analysis tools for spreadsheet calculations;

- can process and analyze large volumes of data, as well as use various Excel functions and combine them to make calculations;

- can create simple macros (sub-programs) in VBA;

- can search for program errors and check the progress of the program;

- can efficiently combine recorded and handwritten code;

- can create new user functions and use them on the Excel worksheet.

Teacher

Maria Zeltser

Study programmes containing that course

Mathematics, Mathematical Economics and Data Analysis (MLMB/22.DT)

Integrated Natural Sciences (MLLB/22.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/21.DT)

Integrated Natural Sciences (MLLB/21.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/20.DT)

Integrated Natural Sciences (MLLB/20.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/19.DT)

Integrated Natural Sciences (MLLB/19.LT)

Integrated Natural Sciences (MLLB/18.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/18.DT)

Integrated Natural Sciences (MLLB/17.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/17.DT)

Integrated Natural Sciences (MLLB/22.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/21.DT)

Integrated Natural Sciences (MLLB/21.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/20.DT)

Integrated Natural Sciences (MLLB/20.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/19.DT)

Integrated Natural Sciences (MLLB/19.LT)

Integrated Natural Sciences (MLLB/18.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/18.DT)

Integrated Natural Sciences (MLLB/17.LT)

Mathematics, Mathematical Economics and Data Analysis (MLMB/17.DT)