Information Technologies LN02021

Course content:Acquaint students with: data types, methods to address the cells and basic operations on cells, calculation at spreadsheets using user formulas, logical functions, search formulas and selected financial functions. Acquire by students knowledge about the basic techniques of graphical data presentation, array formulas and data analysis such as what-if. Support tools like solver and search result, analysis using adjustable tables and simple design forms in Excel.

Learning outcomes:ability to use Microsoft Excel: perform calculations at spreadsheets using own formulas, logical, search and financial functions, use graphical representation of data, consolidating worksheets, use array formulas, lists, data tables, scenarios, application solver, adjustable tables and
simple forms.