MEBn5047 Introduction to Excel

Faculty of Social Studies
Spring 2025
Extent and Intensity
0/4/0. 1 credit(s). Type of Completion: z (credit).
In-person direct teaching
Teacher(s)
doc. Mgr. Jan Osička, Ph.D. (lecturer)
Mgr. Mohammed Ramadan (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. In addition, the course provides basic skills for managing data and designing interactive dashboards in Microsoft Power BI, which equips students with a fundamental skillset in professional visualizations and powerful data analysis.
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; navigate Power BI and Power Query interfaces; design interactive dashboards; Manipulate and visualize data; Cleanse and prepare datasets; Extract desired data outcomes; and optimize workflow between Power BI and Excel. .
Syllabus
  • Excel interface
  • Data manipulation
  • Data analysis
  • Data visualization
  • Power BI
  • Power Query
  • Dashboards
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 2024.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fss/spring2025/MEBn5047