{"id":1366,"date":"2020-07-12T12:09:01","date_gmt":"2020-07-12T10:09:01","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=1366"},"modified":"2023-10-28T16:04:40","modified_gmt":"2023-10-28T14:04:40","slug":"excel-level-4","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-4\/","title":{"rendered":"Excel level 4 &#8211; pokro\u010dil\u00fd"},"content":{"rendered":"\n<p>Tento kurz je priamym nasledovn\u00edkom kurzu Excel level 3 \u2013 stredne pokro\u010dil\u00fd. Kurz rozv\u00edja existuj\u00face sk\u00fasenosti \u00fa\u010dastn\u00edkov v&nbsp;programe MS Excel. Vhodn\u00fd je pre \u00fa\u010dastn\u00edkov s&nbsp;dlh\u0161\u00edmi sk\u00fasenos\u0165ami v&nbsp;programe MS Excel, na ktor\u00e9 tento kurz nadv\u00e4zuje. Na kurze sa pracuje s&nbsp;r\u00f4znymi funkciami vr\u00e1tane pokro\u010dil\u00e9ho pou\u017e\u00edvania funkcie VLOOKUP, OFFSET a&nbsp;r\u00f4znych in\u00fdch. Na kurze sa vyu\u010duje tvorba pokro\u010dil\u00fdch podmienok, pomocou vzorcov, pre podmienen\u00e9 form\u00e1tovanie a&nbsp;overovanie \u00fadajov. K absolvovaniu kurzu je odpor\u00fa\u010dan\u00e9 \u00fapln\u00e9 zvl\u00e1dnutie funkcie IF, tvorby relat\u00edvnych a&nbsp;absol\u00fatnych odkazov, poznanie funkcie VLOOKUP a&nbsp;dobr\u00e1 orient\u00e1cia v&nbsp;programe MS Excel.<\/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 <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;\">Opakovanie z\u00e1kladn\u00fdch techn\u00edk<\/h3>\n<ul><li>Z\u00e1sady pri tvorbe tabu\u013eky<\/li>\n<li>Relat\u00edvne, absol\u00fatne a zmie\u0161an\u00e9 odkazy<\/li>\n<\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Pr\u00e1ca s \u00fadajmi<\/h3>\n<ul><li>Pokro\u010dil\u00fd vlastn\u00fd form\u00e1t \u010d\u00edsla<\/li>\n<li>Vzorce po\u013ea<\/li><li>Definovanie n\u00e1zvov: spr\u00e1vca n\u00e1zvov<\/li><li>Pou\u017eitie n\u00e1zvu vo funkcii<\/li><li>Logick\u00e1 hodnota (TRUE, FALSE) ako obsah bunky<\/li><li>Podmienen\u00e9 form\u00e1tovanie pomocou vzorca<\/li><li>Roz\u0161\u00edren\u00fd filter: tvorba pokro\u010dilej podmienky pomocou vzorca<\/li><li>Kombinovan\u00e9 podmienky, filter rozli\u0161uj\u00faci mal\u00e9 a&nbsp;ve\u013ek\u00e9 p\u00edsmen\u00e1 (funkcia EXACT), filtrovanie pr\u00e1zdnych a&nbsp;nepr\u00e1zdnych buniek, filtrovanie zhodn\u00fdch hodn\u00f4t v&nbsp;dvoch st\u013apcoch<\/li><li>Datab\u00e1zov\u00e9 funkcie: DGET, DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN<\/li><li>N\u00e1stroje pre \u00fadaje: Text na st\u013apce, Dynamick\u00e9 dop\u013a\u0148anie, Odstr\u00e1ni\u0165 duplicity<\/li>\n<li>Overenie \u00fadajov: tvorba overovacej podmienky pomocou vzorcov (funkcie ISTEXT, ISNUMBER, ISBLANK a&nbsp;podobn\u00e9)<\/li>\n<li>Z\u00e1visl\u00e9 overenie \u00fadajov<\/li>\n<li>Vytvorenie z\u00e1visl\u00e9ho rozba\u013eovacieho zoznamu v&nbsp;bunke (funkcie OFFSET, INDIRECT)<\/li>\n<\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Pr\u00e1ca s textov\u00fdmi re\u0165azcami<\/h3>\n<ul><li>Rozde\u013eovanie textu (funkcie LEFT, MID, RIGHT)<\/li>\n<li>Textov\u00e9 funkcie LEN, SEARCH, FIND, CONCATENATE (CONCAT), SUBSTITUTE<\/li>\n<li>Oper\u00e1tor \u201e&#038;\u201c<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vyh\u013ead\u00e1vanie \u00fadajov<\/h3>\n<ul><li>Pokro\u010dil\u00e9 pou\u017e\u00edvanie funkci\u00ed VLOOKUP, HLOOKUP, LOOKUP, INDEX a&nbsp;MATCH<\/li><li>Tvorba vyh\u013ead\u00e1vac\u00edch formul\u00e1rov pomocou vyh\u013ead\u00e1vac\u00edch funkci\u00ed<\/li><li>Sp\u00e1janie tabuliek pomocou vyh\u013ead\u00e1vac\u00edch funkci\u00ed<\/li>\n<li>Odstr\u00e1nenie ch\u00fdb z buniek (funkcia IFERROR)<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">\u0160tatistick\u00e9 funkcie<\/h3>\n<ul><li>Hodnotenie \u00fadajov pod\u013ea ve\u013ekosti funkciou RANK (RANK.EQ, RANK.AVG)<\/li><li>Tvorba jednoduchej progn\u00f3zy pomocou funkcie FORECAST<\/li><li>Frekvencia v\u00fdskytu hodnoty pomocou funkcie FREQUENCY<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Ovl\u00e1dacie prvky<\/h3>\n<ul><li>Vyu\u017eitie ovl\u00e1dac\u00edch prvkov formul\u00e1ra<\/li><li>Zoskupenie ovl\u00e1dac\u00edch prvkov a prepojenie s bunkou<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Makro<\/h3><ul><li>Nahr\u00e1vanie makra a&nbsp;spustenie makra<\/li><li>Kl\u00e1vesov\u00e1 skratka makra<\/li><li>Relat\u00edvne a&nbsp;absol\u00fatne odkazy v&nbsp;makre<\/li><li>Tvorba jednoduch\u00e9ho makra: kop\u00edrovanie z\u00e1znamu na in\u00fd h\u00e1rok<\/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> 150,00 \u20ac<br \/>\n<strong>D\u013a\u017eka trvania kurzu:<\/strong> 2 dni<br \/>\n<strong>Celkov\u00fd po\u010det hod\u00edn:<\/strong> 10 hod\u00edn (5 hod. prv\u00fd de\u0148 a 5 hod. druh\u00fd de\u0148)<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. \u00dapln\u00e9 zvl\u00e1dnutie pou\u017e\u00edvania relat\u00edvnych a absol\u00fatnych odkazov, \u00fapln\u00e9 zvl\u00e1dnutie funkcie IF, poznanie vyh\u013ead\u00e1vac\u00edch funkci\u00ed, plynul\u00e1 orient\u00e1cia v programe MS Excel.<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 level 4 bude prezentovan\u00fd na verzii Microsoft 365. Vhodn\u00e9 verzie s\u00fa aj Office 365, MS Office 2019, MS Office 2016, MS Office 2013. Vo verzi\u00e1ch MS Office 2007 a 2010 sa pri pr\u00e1ci m\u00f4\u017eu vyskytova\u0165 rozdiely v porovnan\u00ed s aktu\u00e1lnej\u0161\u00edmi verziami.<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> IF, AND, OR, IFERROR<br \/>\n<strong>Informa\u010dn\u00e9 funkcie:<\/strong> ISNUMBER, ISBLANK, ISTEXT<br \/>\n<strong>\u0160tatistick\u00e9 funkcie:<\/strong> FREQUENCY, RANK (RANK.EQ, RANK.AVG), FORECAST<br \/>\n<strong>Datab\u00e1zov\u00e9 funkcie:<\/strong> DGET, DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN<br \/>\n<strong>Vyh\u013ead\u00e1vacie funkcie:<\/strong> VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH, INDIRECT<br \/>\n<strong>Textov\u00e9 funkcie:<\/strong> LEFT, MID, RIGHT, LEN, SEARCH, FIND, CONCATENATE (CONCAT), SUBSTITUTE, TEXTJOIN, EXACT<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 3 &#8211; stredne pokro\u010dil\u00fd<br \/>\n<strong>Po kurze:<\/strong><br \/>\nExcel 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\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button pdf-down-butt no-dis\"><a class=\"wp-block-button__link wp-element-button\">Inform\u00e1cie o kurze na stiahnutie v PDF<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tento kurz je priamym nasledovn\u00edkom kurzu Excel level 3 \u2013 stredne pokro\u010dil\u00fd. Kurz rozv\u00edja existuj\u00face sk\u00fasenosti \u00fa\u010dastn\u00edkov v&nbsp;programe MS Excel. &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":5,"_glsr_ranking":3.75,"_glsr_reviews":2,"footnotes":""},"class_list":["post-1366","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 - Kurz Excel level 4 - pokro\u010dil\u00fd<\/title>\n<meta name=\"description\" content=\"Kurz rozv\u00edja existuj\u00face sk\u00fasenosti \u00fa\u010dastn\u00edkov v programe MS Excel. Vhodn\u00fd je pre \u00fa\u010dastn\u00edkov s dlh\u0161\u00edmi sk\u00fasenos\u0165ami v programe MS Excel.\" \/>\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-level-4\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EduBeliso - Kurz Excel level 4 - pokro\u010dil\u00fd\" \/>\n<meta property=\"og:description\" content=\"Kurz rozv\u00edja existuj\u00face sk\u00fasenosti \u00fa\u010dastn\u00edkov v programe MS Excel. Vhodn\u00fd je pre \u00fa\u010dastn\u00edkov s dlh\u0161\u00edmi sk\u00fasenos\u0165ami v programe MS Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-4\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-28T14:04:40+00:00\" \/>\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=\"3 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-level-4\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-4\/\",\"name\":\"EduBeliso - Kurz Excel level 4 - pokro\\u010dil\\u00fd\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-07-12T10:09:01+00:00\",\"dateModified\":\"2023-10-28T14:04:40+00:00\",\"description\":\"Kurz rozv\\u00edja existuj\\u00face sk\\u00fasenosti \\u00fa\\u010dastn\\u00edkov v programe MS Excel. Vhodn\\u00fd je pre \\u00fa\\u010dastn\\u00edkov s dlh\\u0161\\u00edmi sk\\u00fasenos\\u0165ami v programe MS Excel.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-4\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1366","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=1366"}],"version-history":[{"count":31,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1366\/revisions"}],"predecessor-version":[{"id":3007,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1366\/revisions\/3007"}],"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=1366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}