|
Lecturer(s)
|
-
Jonášová Hana, Ing. Ph.D.
|
|
Course content
|
unspecified
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Work with text (with textbook, with book), Methods of individual activities
|
|
Learning outcomes
|
The aim of the course is to introduce with functions and tools of MS Excel 2007 to a level such that student would be able to use it effectively in practice. The course is focused on analytical, financial, logical and other functions. Also it is focused on the use tools for simulation and analysis (solver, search for solutions, advanced filters, pivot tables, reports, groups, trends). Creating and editing simple macros in MS Excel on the user level, in particular for automatic processing and editing tables is integral part this subject.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Student performance assessment
|
|
Recommended literature
|
-
Laurenčík, M., Jurák, Z. EXCEL pro management, ekonomy a podnikatele.. Computer Media, 2012. ISBN 978-80-7402-096-4.
-
Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
-
Brož, M. Microsoft Office Excel 2007. Podrobná uživatelská příručka. Computer Press, 2007. ISBN 978-80-251-1822-8.
-
Jonášová, Hana. Zpracování dat v Excelu. Pardubice: Univerzita Pardubice, 2009. ISBN 978-80-7395-192-4.
-
Mark Dodge, Craig Stinson Douglas. Mistrovství v Microsoft Excel 2010. COMPUTER PRESS, 2011. ISBN 9788025133545.
|