{"id":2022,"date":"2020-07-23T23:51:40","date_gmt":"2020-07-23T21:51:40","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=2022"},"modified":"2020-08-09T23:18:51","modified_gmt":"2020-08-09T21:18:51","slug":"excel-365","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/","title":{"rendered":"Excel 365"},"content":{"rendered":"\n<p>Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. Zhr\u0148uje najd\u00f4le\u017eitej\u0161ie a naju\u017eito\u010dnej\u0161ie postupy, ako je zdie\u013eanie dokumentu a s\u00fabe\u017en\u00e1 pr\u00e1ca na dokumente pomocou OneDrive. Na kurze s\u00fa prezentovan\u00e9 nov\u00e9 funkcie, ako je aj napr\u00edklad dlho o\u010dak\u00e1van\u00fd pr\u00edrastok XLOOKUP. Na absolvovanie kurzu odpor\u00fa\u010dame ma\u0165 predo\u0161l\u00e9 sk\u00fasenosti na \u00farovni absolvovania kurzu Excel level 2 &#8211; mierne pokro\u010dil\u00fd.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Term\u00edny<\/h2>\n\n\n\n\n\n<p>Ak ste nena\u0161li term\u00edn, ktor\u00fd v\u00e1m vyhovuje, nev\u00e1hajte n\u00e1s kontaktova\u0165. Viac inform\u00e1ci\u00ed&nbsp;<a href=\"https:\/\/edubeliso.eu\/sk\/we-adjust-to-your-need\/\">n\u00e1jdete tu<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Osnovy<\/h2>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Excel 365 ako s\u00fa\u010das\u0165 Microsoft 365<\/h3>\n<ul><li>S\u00fabe\u017en\u00e1 pr\u00e1ca viacer\u00fdch \u00fa\u010dastn\u00edkov na jednom dokumente pomocou OneDrive<\/li>\n<li>Zdie\u013eanie dokumentu cez OneDrive<\/li>\n<li>Nastavenie typu pr\u00edstupu: pln\u00fd pr\u00edstup \/ iba na \u010d\u00edtanie<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Nov\u00e9 funkcie (nedostupn\u00e9 v star\u0161\u00edch verzi\u00e1ch Office)<\/h3>\n<ul><li>IFS: navracia hodnotu na z\u00e1klade viacer\u00fdch podmienok<\/li><li>CONCAT: nahr\u00e1dza a vylep\u0161uje funkciu CONCATENATE<\/li><li>SWITCH: umo\u017e\u0148uje nahr\u00e1dza\u0165 vybran\u00e9 hodnoty za in\u00e9 hodnoty<\/li><li>TEXTJOIN: umo\u017e\u0148uje zl\u00fa\u010di\u0165 text to jedn\u00e9ho textov\u00e9ho re\u0165azca<\/li><li>MAXIFS, MINIFS: zis\u0165ovanie maxima alebo minima s podmienkou<\/li><li>FIELDVALUE: Dop\u013a\u0148anie geografick\u00fdch \u00fadajov: rozloha, popul\u00e1cia a r\u00f4zne in\u00e9<\/li><li>XLOOKUP: nahr\u00e1dza funkciu VLOOKUP a&nbsp;obohacuje o&nbsp;nov\u00e9 mo\u017enosti<\/li><li>XMATCH: nahr\u00e1dza a&nbsp;roz\u0161iruje funkciu MATCH<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Dynamick\u00e9 vzorce po\u013ea<\/h3>\n<ul><li>FILTER: vhodn\u00e1 na filtrovanie \u00fadajov<\/li><li>SEQUENCE: generuje zoznam postupn\u00fdch \u010d\u00edsel v&nbsp;poli<\/li><li>SORT: umo\u017e\u0148uje usporiada\u0165 rozsah po\u013ea<\/li><li>SORTBY: umo\u017e\u0148uje usporiada\u0165 pole na z\u00e1klade hodn\u00f4t z&nbsp;in\u00e9ho po\u013ea<\/li><li>UNIQUE: navr\u00e1ti zoznam jedine\u010dn\u00fdch hodn\u00f4t z&nbsp;rozsahu<\/li><li>Overenie \u00fadajov pomocou dynamick\u00fdch vzorcov po\u013ea<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Nov\u00e9 grafy<\/h3>\n<ul><li>Kartogram: tvorba farebn\u00fdch \u0161k\u00e1l na mape<\/li><li>Vodop\u00e1dov\u00fd graf; Lievikov\u00fd graf; Histogram<\/li><\/ul>\n\n\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron roz-pole-kurz no-dis su-spoiler-closed\" data-anchor=\"ukazka-tvorby\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Uk\u00e1\u017eka tvorby na \u0161kolen\u00ed<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\nBla, bla, bla<br \/>\n<\/div><\/div>\n\n\n\n<span id=\"course-info\"><\/span>\n\n\n<div class=\"su-tabs su-tabs-style-default su-tabs-mobile-stack tab-info text-blok\" data-active=\"1\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-tabs-nav\"><span class=\"\" data-anchor=\"informacie-o-skoleni\" data-url=\"\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Inform\u00e1cie o \u0161kolen\u00ed<\/strong><\/span><span class=\"\" data-anchor=\"vstupne-vedomosti\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Podporovan\u00e9 verzie programu<\/strong><\/span><span class=\"\" data-anchor=\"preberane-funkcie\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Zoznam v\u0161etk\u00fdch preberan\u00fdch funkci\u00ed<\/strong><\/span><span class=\"\" data-anchor=\"preberane-funkcie\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Odpor\u00fa\u010dan\u00e9 kurzy<\/strong><\/span><span class=\"\" data-anchor=\"vseobecne-informacie\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>V\u0161eobecn\u00e9 inform\u00e1cie<\/strong><\/span><\/div><div class=\"su-tabs-panes\"><div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Inform\u00e1cie o \u0161kolen\u00ed&lt;\/strong&gt;\">\n<strong>Cena:<\/strong> 70,00 \u20ac<br \/>\n<strong>D\u013a\u017eka trvania kurzu:<\/strong> 1 de\u0148<br \/>\n<strong>Celkov\u00fd po\u010det hod\u00edn:<\/strong> 5 hod\u00edn<br \/>\n<strong>Odpor\u00fa\u010dan\u00e9 minim\u00e1lne vstupn\u00e9 vedomosti:<\/strong> Z\u00e1kladn\u00e9 ovl\u00e1danie po\u010d\u00edta\u010da, pr\u00e1ca s prie\u010dinkami a s\u00fabormi. Tento kurz <strong>nie je vhodn\u00fd pre za\u010diato\u010dn\u00edkov<\/strong>, na absolvovanie kurzu odpor\u00fa\u010dame disponova\u0165 minim\u00e1lne sk\u00fasenos\u0165ami na \u00farovni absolvovania kurzu Excel level 2 &#8211; mierne pokro\u010dil\u00fd. Pokia\u013e ich nem\u00e1te, odpor\u00fa\u010dame za\u010da\u0165 kme\u0148ov\u00fdmi kurzami Excel level 1 alebo Excel level 2.<br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Podporovan\u00e9 verzie programu&lt;\/strong&gt;\">\nExcel 365 bude prezentovan\u00fd na verzii Microsoft 365. <strong>Tento kurz je mo\u017en\u00e9 absolvova\u0165 iba s verziou Microsoft 365. V pr\u00edpade, \u017ee nem\u00e1te najnov\u0161iu verziu, kontaktujte n\u00e1s.<\/strong><br \/>\n<a href=\"https:\/\/edubeliso.eu\/sk\/difference-betwen-microsoft-365-and-office-2019\/\" target=\"_blank\" rel=\"noopener noreferrer\">Rozdiel medzi Microsoft 365 a Office 2019<\/a><br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Zoznam v\u0161etk\u00fdch preberan\u00fdch funkci\u00ed&lt;\/strong&gt;\">\n<strong>Logick\u00e9 funkcie:<\/strong> IFS, SWITCH<br \/>\n<strong>Textov\u00e9 funkcie:<\/strong> CONCAT, TEXTJOIN,<br \/>\n<strong>\u0160tatistick\u00e9:<\/strong> MAXIFS, MINIFS<br \/>\n<strong>Vyh\u013ead\u00e1vacie:<\/strong> XLOOKUP, XMATCH, FIELDVALUE, FILTER, SORT, SORTBY, UNIQUE<br \/>\n<strong>Matematick\u00e9:<\/strong> SEQUENCE<br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Odpor\u00fa\u010dan\u00e9 kurzy&lt;\/strong&gt;\">\n<strong>Pred kurzom:<\/strong><br \/>\nExcel level 2 &#8211; mierne pokro\u010dil\u00fd<br \/>\n<strong>Po kurze:<\/strong><br \/>\nExcel level 3 &#8211; stredne pokro\u010dil\u00fd, Excel grafy, Excel kontingen\u010dn\u00e9 tabu\u013eky<br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;V\u0161eobecn\u00e9 inform\u00e1cie&lt;\/strong&gt;\">\n<div data-post-id='2426' class='insert-page insert-page-2426 '>\n<p>Pred samotn\u00fdm kurzom odpor\u00fa\u010dame prezrie\u0165 nasleduj\u00face \u010dl\u00e1nky:<br><a href=\"https:\/\/edubeliso.eu\/sk\/how-does-an-online-course-look-like\/\" target=\"_blank\" aria-label=\"undefined (otv\u00e1ra sa na novej karte)\" rel=\"noreferrer noopener\">Ako vyzer\u00e1 online kurz?<\/a><br><a href=\"https:\/\/edubeliso.eu\/sk\/how-to-join-an-online-course\/\" target=\"_blank\" aria-label=\"undefined (otv\u00e1ra sa na novej karte)\" rel=\"noreferrer noopener\">Ako sa pripoji\u0165 na online kurz?<\/a><\/p>\n<\/div>\n<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. Zhr\u0148uje najd\u00f4le\u017eitej\u0161ie a naju\u017eito\u010dnej\u0161ie postupy, &hellip; <\/p>\n","protected":false},"author":2,"featured_media":0,"parent":397,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"footnotes":""},"class_list":["post-2022","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EduBeliso - Excel 365<\/title>\n<meta name=\"description\" content=\"Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. R\u00f4zne nov\u00e9 funkcie, ako je aj napr\u00edklad XLOOKUP.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 365\" \/>\n<meta property=\"og:description\" content=\"Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. R\u00f4zne nov\u00e9 funkcie, ako je aj napr\u00edklad XLOOKUP.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-09T21:18:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2020\/08\/Excel-365-2020_08_09.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Autor:\">\n\t<meta name=\"twitter:data1\" content=\"Peter Beli\u010dka\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"2 min\u00faty\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\",\"url\":\"https:\/\/edubeliso.eu\/sk\/\",\"name\":\"EduBeliso\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/edubeliso.eu\/sk\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"sk-SK\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/\",\"name\":\"EduBeliso - Kurz [:sk]Excel 365[:]\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-07-23T21:51:40+00:00\",\"dateModified\":\"2020-08-09T21:18:51+00:00\",\"description\":\"Kurz Excel 365 poskytuje preh\\u013ead nov\\u00fdch funkci\\u00ed a n\\u00e1strojov pridan\\u00fdch v posledn\\u00fdch verzi\\u00e1ch programu Excel. R\\u00f4zne nov\\u00e9 funkcie, ako je aj napr\\u00edklad XLOOKUP.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-365\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/comments?post=2022"}],"version-history":[{"count":14,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2022\/revisions"}],"predecessor-version":[{"id":2429,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2022\/revisions\/2429"}],"up":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/397"}],"wp:attachment":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/media?parent=2022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}