{"id":2178,"date":"2018-01-03T08:00:00","date_gmt":"2018-01-03T07:00:00","guid":{"rendered":"http:\/\/kit.pef.czu.cz\/nezarazene\/excel-for-business-summer-semester-2017-2018-cz\/"},"modified":"2023-08-22T18:23:34","modified_gmt":"2023-08-22T16:23:34","slug":"excel-for-business-summer-semester-2017-2018-cz","status":"publish","type":"post","link":"https:\/\/kit.pef.czu.cz\/en\/zpravy-akce-prednasky\/excel-for-business-summer-semester-2017-2018-cz\/","title":{"rendered":"Excel for Business \u2013 Summer Semester 2017\/2018 \u2013 CZ"},"content":{"rendered":"<p style=\"text-align: justify;\"><strong>The Department of Information Technologies and the Center for Data Analytics and Intelligence (CENDAI) brings you a new course Excel for Business designed exclusively for students of English programs at FEM CULS.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>This course will help you to become more efficient in analyzing your data for projects or thesis. All skills and knowledge that you learn will also be very useful at work in a variety of companies and are highly appreciated at job interviews.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Topics:<\/strong> <\/span><\/p>\n<ul>\n<li>Review of basics<\/li>\n<li>Effective data analysis with pivot tables<\/li>\n<li>Search functions (VLOOKUP, MATCH, INDEX)<\/li>\n<li>Advanced charts<\/li>\n<li>Conditional formatting<\/li>\n<li>Using Form Controls<\/li>\n<li>Financial calculations<\/li>\n<li>Basic statistical functions<\/li>\n<li>Data imports<\/li>\n<li>Layout and format features<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\"><strong>Basic information about the course:<\/strong><\/span><\/p>\n<p>Start: 19.2. \u2013 23\/04\/2018<\/p>\n<p>Time: Mondays from 15:45 to 17:15 (room D326) or Tuesdays 15:45 \u2013 17:15 (room C17)<\/p>\n<p>Course length: 9 sessions (13.5 hours)<\/p>\n<p>Instructor: Milo\u0161 Ulman<\/p>\n<p>At the end of the course, participants completing the course successfully will receive a certificate.<\/p>\n<p>If you are interested please register by 16th February 2018 here: <a href=\"https:\/\/goo.gl\/forms\/rSqE3k4Yz03pYoK22\">https:\/\/goo.gl\/forms\/rSqE3k4Yz03pYoK22<\/a><\/p>\n<p>Should you have any questions, please contact Mr. Milo\u0161 Ulman at <a href=\"mailto:ulman@pef.czu.cz\">Secretariat<\/a>.<\/p>\n<p>\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>The Department of Information Technologies and the Center for Data Analytics and Intelligence (CENDAI) brings you a new course Excel for Business designed exclusively for students of English programs at FEM CULS.  This course will help you to become more efficient in analyzing your data for projects or thesis. All skills and knowledge that you learn will also be very useful at work in a variety of companies and are highly appreciated at job interviews. Topics: Review of basics Effective data analysis with pivot tables Search functions (VLOOKUP, MATCH, INDEX) Advanced charts Conditional formatting Using Form Controls Financial calculations Basic<\/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":[46,49],"tags":[],"class_list":["post-2178","post","type-post","status-publish","format-standard","hentry","category-akce","category-zpravy"],"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":"https:\/\/kit.pef.czu.cz\/en\/zpravy-akce-prednasky\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"The Department of Information Technologies and the Centre for Data Analytics and Intelligence (CENDAI) brings you a new course Excel for Business designed exclusively for students of English programmes at FEM CULS. &nbsp; This course will help you to become more efficient in analysing your data for projects or thesis. All skills and knowledge that&hellip;","_links":{"self":[{"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts\/2178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/comments?post=2178"}],"version-history":[{"count":0,"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/posts\/2178\/revisions"}],"wp:attachment":[{"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/media?parent=2178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/categories?post=2178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kit.pef.czu.cz\/en\/wp-json\/wp\/v2\/tags?post=2178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}