JEB111 - Advanced Data Analysis in MS Excel

Credit: 3
Status: Bachelors - All
Bachelors - elective
BEF - elective
English
Semester - summer
Semester - winter
Course supervisors: Mgr. Petr Polák MSc.
Course homepage: JEB111
Literature: Craig Stinson, Mark Dodge: Mistrovství v Microsoft Office Excel 2003 (Microsoft excel Inside out), Computer Press. – but any handbook will do. No book is required, but might come in handy.
Description: This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we turn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MS Excel which should help students make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
July 2020
MonTueWedThuFriSatSun
  12345
6789101112
13141516171819
20212223242526
2728293031  

Partners

Deloitte

Sponsors

CRIF
McKinsey
Patria Finance