MS Excel – winter semester 2019/2020

example, category, and, terms

wp offers an additional MS Excel course. The content of the course is to expand knowledge for fulfilling the conditions for credit from the subject Information and Communication Technology (applies to the 1st years of the bachelor's degree study at PEF ČZU in Prague).

 

The PEF Department of Information Technology organizes an additional MS Excel course for students. The topics of the course are linked to the selected topics of the Information and Communication Technology subject exercises, assignments in Moodle and exam requirements from this subject. Recommended for the fields of PaE, PaA, HKS and VSRR (for 1st years of bachelor's degree studies at PEF ČZU in Prague).

Topics covered:

  1. Entering and selecting data, editing cell contents
    Automatic filtering - solution to task #184
  2. Copy, move, delete cells
    Statistical functions for conditional count and conditional sum - solution to task #222
  3. Selection of cells, rows, columns
    Database functions - solution to task #252
  4. Pivot tables
  5. Cell formatting
    Calculations in contingency tables - solution to task No. 312
  6. Work with leaves
    Combined chart - solution to task #343
  7. Creating formulas
  8. Working with functions
  9. Preparation for credit
 
Course for PAA, HKS and USSR in progress from 15/10 to 10/12/2019
Every Tuesday from 8:45 to 10:15
Room: C24
Number of lessons: 9 (13.5 hours)
Lesson duration: 90 minutes
Lecturer: Vladimír Očenášek
Course price: 2,662 CZK (including VAT)
Course for PAE, HKS and USSR in progress from 21/10 to 17/12/2019
Every Monday from 8:45 to 10:15
Room: C24
Number of lessons: 9 (13.5 hours)
Lesson duration: 90 minutes
Lecturer: Vladimír Očenášek
Course price: 2,662 CZK (including VAT)

If you are interested, register with and make a payment to October 21, 2019.
You will receive payment instructions in the confirmation email.

New Monday (course for PAE, HKS and VSRR) 8:45 – 10-15, C24 – Registration

Tuesday (PAA only) 8.45am – 10.15am, C24 – Registration

(The capacity of the course is 20 places. In case of great interest, another course can be opened on an alternate date.)

Enrollment in the course is determined by the order of application and timely payment!

For further questions, contact Mgr. Ing. Vladimíra Očenáška, Ph.D.: ocenasek@pef.czu.cz