Information Technologies 2 ZN02021

Course content: data types, their entry and editing, formatting numeric data, basic operations on the cells, use formulas user; knowledge of mathematical functions, different methods of addressing cells; calculation worksheets using the logic functions, calculation worksheets using the search function, calculation sheets selected using financial functions, techniques of data presentation graficnej, lists and operations on lists - sorting, filtering, array formulas and their application in data analysis, analysis of "what-if" - data tables and scenarios, analysis of data by using the "solver "and" search result "analysis with pivot tables, designing simple forms in Excel.

Learning outcomes: The student knows the functions and capabilities of spreadsheets Student acquires the ability to prepare kalkulac. of use. formulas and functions