Practical application of Excel 2400-ZU1INF12
Classes 1-3 – Excel functions that are most often used at daily work – text functions, date functions, conditional counting and summing functions, search functions, function if and logical operators, error handling functions. A lot of tasks will be dedicated to complex functions that will be making use of functions mentioned above and allowing to perform more complicated operations.
Classes 4-5 – Importing external files, text to columns, pivot tables (inserting, changing views, different value presence, calculated fields), solver tool, generating random numbers
Classes 6 – Non-standard charts in Excel
Type of course
Course coordinators
Learning outcomes
Course is supposed to prepare attendants to effective work with Excel, teach how to select appropriate function and expedite daily work.
Assessment criteria
Form of classification: Final colloquium.
Bibliography
Walkenbach J., Excel 2010 PL. Programowanie w VBA. Vademecum Walkenbacha, Helion, 2011
Gonet M., Zrozumieć Excela. Funkcje i wyrażenia, Helion 2019
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: