MEBn5047 Introduction to Excel

Faculty of Social Studies
Spring 2024
Extent and Intensity
0/4/0. 1 credit(s). Type of Completion: z (credit).
Taught in person.
Teacher(s)
doc. Mgr. Jan Osička, Ph.D. (lecturer)
Guaranteed by
doc. Mgr. Jan Osička, Ph.D.
Department of International Relations and European Studies – Faculty of Social Studies
Contact Person: Olga Cídlová, DiS.
Supplier department: Department of International Relations and European Studies – Faculty of Social Studies
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
This course is designed to provide students with a fundamental understanding of Microsoft Excel, a powerful spreadsheet application widely used in various professional fields. The focus is on building essential skills for data manipulation, analysis, and visualization. Through hands-on exercises and practical examples, students will gain confidence in using Excel for both personal and professional tasks.
Learning outcomes
At the end of the course, the students will be able to: Understand and navigate Excel interface components; Enter and edit data accurately; Format text, numbers, and dates; Manage worksheets; Sort data; Create and customize basic charts; Create and use PivotTables.
Syllabus
  • Excel interface
  • Data manipulation
  • Data analysis
  • Data visualization
Literature
  • Skinner, H., 2023, Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience for Maximum Productivity and Efficiency With all Formulas & Functions and Practical Examples. ISBN-13: 979-8370855887
  • Clark, M., 2024, Excel Made Easy: The Ultimate Crash Course to Master Excel Without Getting Overwhelmed – Secret Winning Formulas to Stand Out from the Crowd and Impress Your Boss. ISBN-13: 979-8390979518
Teaching methods
teaching will be conducted through interactive seminars, emphasizing hands-on practical exercises to enhance students' proficiency in Microsoft Excel. Each seminar will delve into specific topics, providing a balanced blend of theoretical insights and practical applications.
Assessment methods
Students will be required to prepare a final assignment that serves as a comprehensive revision of the skills acquired throughout the course.
Language of instruction
English
Further Comments
Study Materials
The course is taught annually.
The course is taught: in blocks.
The course is also listed under the following terms Spring 2025.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fss/spring2024/MEBn5047