Working with the computer MS Office 2 (follow-up)

31. 3. 2026 02:03 ● Author: Lada Hájková

Guaranteeing department: KTS

Guarantor:doc. Ing. Radek Kolman, Ph.D.

Lecturer:Ondřej Chalupa, DiS.

Lecturer's medallion:

Annotation: This course is designed for anyone who wants to effectively use Microsoft Excel and PowerPoint for their work, study or personal needs. The course is designed to provide participants with practical skills and learn how to use the advanced features of both programs. You will learn how to create spreadsheets, enter and edit data, format cells, use basic functions, filter data and create charts. You will learn how to create professional presentations, insert images, videos, audio and animations into presentations, and use advanced PowerPoint features such as transitions, animations and timing.

Number of semesters: 2

Teaching day: Thursday

Teaching Time: 2:00pm-3:30pm

Course End:

Recommended reading: to be specified in class

Registration: from 1 June 2025 via e-enrolment

Please note: The team of the University of the Third Age of the College of Polytechnics reserves the right to make changes for organizational reasons (lecturer, date, time of teaching). Any changes will always be communicated to those interested in the course in a timely manner.

Registration for the year 2025/2026 is no longer possible, the course capacity has been filled.

	Date	Lecture topic
1	2. 10.	Excel - introduction, basic operation
2	9. 10.	Excel - Creating Simple Spreadsheets
3	October 16	Excel - Creating more complex spreadsheets
4	October 23.	Excel - Cell Format - Class Canceled
5	30. 10.	Excel - cell format - classes canceled
6	6. 11.	Excel - Math Operations
7	13. 11.	Excel - Basic Functions
8	20. 11.	Excel - Relative and Absolute Addressing
9	27. 11.	Excel - Conditional Formatting
10	4. 12.	Excel - filtering
11	11. 12.	Excel - Charts
12	8. 1.	Excel - practicing acquired knowledge
13	22. 1.	Excel - practicing acquired knowledge
14	29. 1.	Powerpoint - introduction, basic controls
15	05. 2.	Powerpoint - working with slides
16	12. 2.	Powerpoint - inserting and editing images
17	19. 2.	Powerpoint - Transitions
18	26. 2.	Powerpoint - Animation
19	5. 3.	Powerpoint - independent presentation creation
20	12. 3.	Powerpoint - independent presentation creation
21	19. 3.	Powerpoint - presenting created presentations
22	26. 3.	Powerpoint - Automatic Timing and Sound
23	9. 4.	Powerpoint - Creating an Advanced Presentation
24	16. 4.	Powerpoint - Creating an Advanced Presentation

Working with the computer MS Office 2 (follow-up)

Registration for the year 2025/2026 is no longer possible, the course capacity has been filled.

We use cookies

Our website (within the vspj.cz domain) uses basic cookies to ensure it functions properly and analytics cookies to understand how you interact with it. These are set only after you have given your consent.