Summer Semester 2007/08
Summer Semester 2008/09
Summer Semester 2009/10
Summer Semester 2010/11
Winter Semester 2011/12
Information Technologies TN02021
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.
(in Polish) Rodzaj przedmiotu
Course coordinators
Bibliography
a) basic references:
1. Abdulezer L., Excel :praktyczne zastosowania w biznesie, Wyd. Helion, Gliwice 2005.
2. Barańczuk Z. (red.), Excel w zarządzaniu firmą :podstawy, Wyd. Politechniki Bialostockiej,Białystok 2005.
3. Masłowski K., Excel 2003 PL :ćwiczenia zaawansowane, Wyd. Helion, Gliwice 2004.
b) supplementary references:
1. Hawley R., Hawley D., 100 sposobów na Excel, Gliwice 2004.
2. Kuciński K., ABC... Excela XP 2005, Wyd. Edition 2000, Kraków, 2004.
3. Masłowski K., Excel 2003 PL :161 praktycznych porad, Wyd. Helion, Gliwice 2004.