Description
Microsoft Excel is the spreadsheet program most used in the world. Despite its popularity, many workers (e.g., managers and administrative staff) only use its most basic functions and lack a general understanding of its functioning and potential.
This course has been created for administrative and managing (non-teaching) staff from schools and educational organizations to uncover the enormous power of Microsoft Excel.
Participants will have the chance to study, analyze, and practice the variety of options afforded by the program. They will thus gain experience with adding data, as well as editing, formatting, managing, and analyzing them.
The course will explore the core foundational concepts in each of these areas, and provide participants with time to practice and discover new functions.
By the end of the course, participants will have a solid understanding of the foundations of Microsoft Excel, and be able to use it appropriately and with confidence in their daily work.
Requirements
Suggested computer proficiency: Intermediate
Learning outcomes
The course will help the participants to:
- Build a solid understanding of the Basics of Microsoft Excel;
- Navigate in Microsoft Excel;
- Choose the right formats for data entry and editing;
- Make calculations with formulas and functions (Time and date functions, Mathematical and statistical functions, logical functions, and Lookup functions)
- Format spreadsheets;
- Filter and sort table data;
- Create charts, tables, and pivot tables;
- Manage data and permissions;
- Do data cleaning;
- Analyze data with datasets and tables.
Tentative schedule
Day 1 – Introduction to the course and Microsoft Excel: Foundations
- Introduction to the course, the school, and the external week activities;
- Icebreaker activities;
- Presentations of the participants’ schools.
Microsoft Excel: Foundations
- Navigating in Microsoft Excel;
- Data formats;
- Entering and editing data.
Day 2 – Formulas and functions (1)
- Time and date functions;
- Logical functions.
Day 3 – Formulas and functions (2)
- Mathematical and statistical functions;
- Lookup functions.
Day 4 – Working with spreadsheets
- Creating charts, tables, and Pivot tables;
- Formatting spreadsheets;
- Managing data and permissions.
Day 5 – Data Analysis
- Filtering and sorting table data;
- Data cleaning;
- Analyzing data with datasets and tables.
Day 6 – Course closure and cultural activities
- Course evaluation: round-up of acquired competencies, feedback, and discussion;
- Awarding of the course Certificate of Attendance;
- Excursion and other external cultural activities.