{"id":2236,"date":"2019-10-15T00:00:00","date_gmt":"2019-10-14T22:00:00","guid":{"rendered":"http:\/\/kit.pef.czu.cz\/nezarazene\/ms-excel-zimni-semestr-2019-2020\/"},"modified":"2023-08-22T18:23:40","modified_gmt":"2023-08-22T16:23:40","slug":"ms-excel-zimni-semestr-2019-2020","status":"publish","type":"post","link":"http:\/\/kit.pef.czu.cz\/en\/zpravy-akce-prednasky\/ms-excel-zimni-semestr-2019-2020\/","title":{"rendered":"MS Excel \u2013 winter semester 2019\/2020"},"content":{"rendered":"

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 \u010cZU in Prague).<\/strong><\/p>\n

 <\/p>\n

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 \u010cZU in Prague).<\/p>\n

Topics covered:<\/strong><\/p>\n

    \n
  1. Entering and selecting data, editing cell contents
    Automatic filtering - solution to task #184<\/li>\n
  2. Copy, move, delete cells
    Statistical functions for conditional count and conditional sum - solution to task #222<\/li>\n
  3. Selection of cells, rows, columns
    Database functions - solution to task #252<\/li>\n
  4. Pivot tables<\/li>\n
  5. Cell formatting
    Calculations in contingency tables - solution to task No. 312<\/li>\n
  6. Work with leaves
    Combined chart - solution to task #343<\/li>\n
  7. Creating formulas<\/li>\n
  8. Working with functions<\/li>\n
  9. Preparation for credit<\/li>\n<\/ol>\n
    \u00a0<\/div>\n\n\n\n
    \n
    Course <\/span>for PAA, <\/span><\/strong>HKS and USSR <\/span>in progress\u00a0from 15\/10 to 10\/12\/2019<\/strong><\/div>\n
    Every Tuesday from 8:45 to 10:15<\/div>\n
    Room: C24
    Number of lessons: 9 (13.5 hours)
    Lesson duration: 90 minutes
    Lecturer: Vladim\u00edr O\u010den\u00e1\u0161ek
    Course price: 2,662 CZK <\/strong>(including VAT)<\/div>\n<\/td>\n
    		\n
    Course for PAE,<\/span> <\/strong>HKS and USSR<\/span><\/span> in progress\u00a0from 21\/10 to 17\/12\/2019<\/strong><\/div>\n
    Every Monday from 8:45 to 10:15<\/div>\n
    Room: C24
    Number of lessons: 9 (13.5 hours)
    Lesson duration: 90 minutes
    Lecturer: Vladim\u00edr O\u010den\u00e1\u0161ek
    Course price: 2,662 CZK <\/strong>(including VAT)<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    If you are interested, register<\/strong> with<\/strong> and make a payment<\/strong> to October 21, 2019.<\/strong>
    You will receive payment instructions in the confirmation email.<\/p>\n

    New<\/strong> <\/span>Monday (course for PAE, HKS and VSRR) 8:45 \u2013 10-15, C24 \u2013 Registration<\/span><\/strong><\/span><\/a><\/p>\n

    Tuesday (PAA only) 8.45am \u2013 10.15am, C24 \u2013 Registration<\/a><\/span><\/strong><\/p>\n

    (The capacity of the course is 20 places. In case of great interest, another course can be opened on an alternate date.)<\/em><\/p>\n

    Enrollment in the course is determined by the order of application and timely payment!<\/span><\/p>\n

    For further questions, contact Mgr. Ing. Vladim\u00edra O\u010den\u00e1\u0161ka, Ph.D.: ocenasek@pef.czu.cz<\/p>","protected":false},"excerpt":{"rendered":"

    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 \u010cZU 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 course exercises, assignments in Moodle and exam requirements from this course. Recommended for the fields of PaE, PaA, HKS and VSRR (for the 1st years of bachelor's degree studies at PEF \u010cZU in Prague). Topics covered: Entering and selecting data, editing cell content, Automatic filtering - solutions<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_uag_custom_page_level_css":"","ngg_post_thumbnail":0,"footnotes":""},"categories":[],"tags":[],"class_list":["post-2236","post","type-post","status-publish","format-standard","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false},"uagb_author_info":{"display_name":"admin","author_link":"http:\/\/kit.pef.czu.cz\/en\/zpravy-akce-prednasky\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"wp nab\u00edz\u00ed dopl\u0148kov\u00fd kurz MS Excel. N\u00e1pln\u00ed kurzu je roz\u0161\u00ed\u0159en\u00ed znalost\u00ed pro pln\u011bn\u00ed podm\u00ednek z\u00e1po\u010dtu z p\u0159edm\u011btu Informa\u010dn\u00ed a komunika\u010dn\u00ed technologie (t\u00fdk\u00e1 se 1. ro\u010dn\u00edk\u016f bakal\u00e1\u0159sk\u00e9ho stupn\u011b studia na PEF \u010cZU v Praze).   Katedra informa\u010dn\u00edch technologi\u00ed PEF po\u0159\u00e1d\u00e1 dopl\u0148kov\u00fd kurz MS Excel pro studenty. T\u00e9mata kurzu jsou prov\u00e1z\u00e1na s vybran\u00fdmi t\u00e9maty cvi\u010den\u00ed p\u0159edm\u011btu Informa\u010dn\u00ed…","_links":{"self":[{"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts\/2236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/comments?post=2236"}],"version-history":[{"count":0,"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts\/2236\/revisions"}],"wp:attachment":[{"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/media?parent=2236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/categories?post=2236"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/tags?post=2236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}