{"id":1393,"date":"2020-07-12T22:37:34","date_gmt":"2020-07-12T20:37:34","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=1393"},"modified":"2020-10-30T16:14:54","modified_gmt":"2020-10-30T15:14:54","slug":"excel-formulas-and-calculations","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-formulas-and-calculations\/","title":{"rendered":"Excel vzorce a funkcie"},"content":{"rendered":"\n<p>Kurz sa venuje pokro\u010dilej tvorbe funkci\u00ed respekt\u00edve vzorcov. Vzorce a funkcie s\u00fa jeden zo z\u00e1kladn\u00fdch funk\u010dn\u00fdch prvkov programu Excel. V\u010faka n\u00edm sa d\u00e1 automatizova\u0165 pr\u00e1ca a spracov\u00e1va\u0165 d\u00e1ta. Obsahom tohto kurzu je podrobn\u00e9 prebratie pou\u017e\u00edvania funkci\u00ed v mnoh\u00fdch praktick\u00fdch pr\u00edkladoch. Na kurze sa \u00fa\u010dastn\u00edk dozvie ako pou\u017e\u00edva\u0165 v\u00fdpo\u010dtov\u00e9 funkcie, spr\u00e1vne pou\u017e\u00edvanie relat\u00edvnych a absol\u00fatnych odkazov, zad\u00e1vanie podmienok, pou\u017e\u00edva\u0165 vyh\u013ead\u00e1vacie funkcie a mnoh\u00e9 in\u00e9 t\u00e9my. K absolvovaniu kurzu je odpor\u00fa\u010dan\u00e1 predo\u0161l\u00e1 sk\u00fasenos\u0165 s programom Excel aspo\u0148 na \u00farovni absolvovania kurzu Excel level 1 &#8211; za\u010diato\u010dn\u00edk.<\/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;\">\u00davod do problematiky tvorby vzorcov a funkci\u00ed<\/h3>\n<ul><li>Matematick\u00e9 oper\u00e1cie: plus, m\u00ednus, n\u00e1sobenie, delenie, z\u00e1tvorky<\/li>\n<li><span class=\"su-tooltip\" data-close=\"no\" data-behavior=\"hover\" data-my=\"bottom center\" data-at=\"top center\" data-classes=\"su-qtip qtip-bootstrap su-qtip-size-default qtip-rounded\" data-title=\"\" title=\"Spr\u00e1vne zoradenie jednotliv\u00fdch v\u00fdrazov vo funkci\u00e1ch.\">Syntax funkcie [i]<\/span><\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Tvorenie funkcie<\/h3>\n<ul><li>Sp\u00f4soby vkladania funkci\u00ed<\/li>\n<li><span class=\"su-tooltip\" data-close=\"no\" data-behavior=\"hover\" data-my=\"bottom center\" data-at=\"top center\" data-classes=\"su-qtip qtip-bootstrap su-qtip-size-default qtip-rounded\" data-title=\"\" title=\"Pou\u017eitie funkcie vo funkcii, sl\u00fa\u017ei na vyhnutie sa zbyto\u010dn\u00fdm st\u013apcom v tabu\u013eke.\">Vnorenie funkcie [i]<\/span><\/li>\n<li>Okno vlo\u017eenie funkcie a riadok vzorcov<\/li>\n<li>Kateg\u00f3rie funkci\u00ed<\/li>\n<li>Z\u00e1kladn\u00e9 funkcie SUM, AVERAGE, MAX, MIN, COUNT, COUNTA<\/li>\n<li>Po\u010d\u00edtanie s percentami<\/li>\n<\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Odkazovanie na bunky<\/h3>\n<ul><li>relat\u00edvne, absol\u00fatne a zmie\u0161an\u00e9 odkazy<\/li>\n<li>Prep\u00e1janie h\u00e1rkov (odkaz na in\u00fd h\u00e1rok) a zo\u0161itov (odkaz na in\u00fd zo\u0161it)<\/li>\n<li>Pomenovanie rozsahu &#8211; definovan\u00e9 n\u00e1zvy<\/li>\n<li><span class=\"su-tooltip\" data-close=\"no\" data-behavior=\"hover\" data-my=\"bottom center\" data-at=\"top center\" data-classes=\"su-qtip qtip-bootstrap su-qtip-size-default qtip-rounded\" data-title=\"\" title=\"Niekedy naz\u00fdvan\u00e9 Maticov\u00e9 vzorce.\">Vzorce po\u013ea [i]<\/span><\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Podmienky a podmienen\u00e9 v\u00fdpo\u010dty<\/h3>\n<ul><li>Logick\u00e9 funkcie IF, OR, AND<\/li>\n<li>Vn\u00e1ranie logick\u00fdch funkci\u00ed<\/li>\n<li>Podmienen\u00e9 v\u00fdpo\u010dty s funkciami SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS<\/li>\n<li>Informa\u010dn\u00e9 funkcie: ISNUMBER, ISTEXT, ISERROR<\/li>\n<li>Funkcia IFERROR<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vyh\u013ead\u00e1vanie a sp\u00e1janie tabuliek<\/h3>\n<ul><li>Funkcie VLOOKUP, HLOOKUP, LOOKUP: sp\u00e1janie zdrojovej a cie\u013eovej tabu\u013eky, tvorba vyh\u013ead\u00e1vac\u00edch formul\u00e1rov<\/li>\n<li>Funkcie INDEX, MATCH: vyh\u013ead\u00e1vanie v tabu\u013ek\u00e1ch<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Textov\u00e9 funkcie<\/h3>\n<ul><li><span class=\"su-tooltip\" data-close=\"no\" data-behavior=\"hover\" data-my=\"bottom center\" data-at=\"top center\" data-classes=\"su-qtip qtip-bootstrap su-qtip-size-default qtip-rounded\" data-title=\"\" title=\"V nov\u00fdch verzi\u00e1ch Office sa nach\u00e1dza CONCAT, ktor\u00e1 je skoro toto\u017en\u00e1.\">Sp\u00e1janie textov\u00fdch re\u0165azcov s funkciou CONCATENATE [i]<\/span><\/li>\n<li>Rozde\u013eovanie textov\u00fdch re\u0165azcov s funkciami LEFT, MID, RIGHT<\/li>\n<li>Funkcie LEN, FIND, SEARCH<\/li>\n<li>Nahr\u00e1dzanie textov\u00fdch re\u0165azcov s funkciou SUBSTITUTE<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">D\u00e1tumov\u00e9 funkcie<\/h3>\n<ul><li>Zis\u0165ovanie aktu\u00e1lneho d\u00e1tumu a \u010dasu: funkcie TODAY, NOW<\/li>\n<li>Pr\u00e1ca s d\u00e1tumami v tabu\u013eke: funkcie DAY, MONTH, YEAR, DATE<\/li>\n<li>V\u00fdpo\u010det rozdielu dn\u00ed: funkcie DATEDIF, WORKDAY, NETWORKDAYS<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Zaokr\u00fah\u013eovanie<\/h3>\n<ul><li>Porovnanie zaokr\u00fahlenia form\u00e1tovan\u00edm a funkciou<\/li>\n<li>Funkcie: ROUND, ROUNDUP, ROUNDDOWN<\/li>\n<li>Funkcie: CEILING, FLOOR, TRUNC<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Kontrola vzorcov<\/h3>\n<ul><li>Zobrazenie vzorcov<\/li>\n<li>Kontrola vzorcov<\/li>\n<li>Okno sledovania<\/li>\n<li>\u0160\u00edpky predchodcov a n\u00e1sledn\u00edkov<\/li><\/ul>\n\n\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron roz-pole-kurz 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\">\nOspravedl\u0148ujeme sa, na obsahu akur\u00e1t pracujeme<br \/>\nPre viac inform\u00e1ci\u00ed n\u00e1s nev\u00e1hajte kontaktova\u0165<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>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. Z\u00e1kladn\u00e1 orient\u00e1cia v programe MS Excel na \u00farovni absolvovania kurzu Excel level 1 \u2013 za\u010diato\u010dn\u00edk.<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 vzorce a funkcie 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;\">\nMatematick\u00e9 funkcie: SUM, ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, TRUNC<br \/>\n\u0160tatistick\u00e9 funkcie: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, SUMIF, SUMIFS, MIN, MAX<br \/>\nLogick\u00e9 funkcie: IF, OR, AND, IFERROR<br \/>\nVyh\u013ead\u00e1vacie funkcie: VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH<br \/>\nTextov\u00e9 funkcie: LEFT, MID, RIGHT, LEN, FIND, SEARCH, CONCATENATE, SUBSTITUTE<br \/>\nD\u00e1tumov\u00e9 funkcie: TODAY, NOW, DAY, MONTH, YEAR, DATE, DATEDIF, NETWORKDAYS, WORKDAY<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 1 &#8211; za\u010diato\u010dn\u00edk<br \/>\n<strong>Po kurze:<\/strong><br \/>\nExcel grafy, Excel pr\u00e1ca s rozsiahlymi d\u00e1tami, 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\">Inform\u00e1cie o kurze na stiahnutie v PDF<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kurz sa venuje pokro\u010dilej tvorbe funkci\u00ed respekt\u00edve vzorcov. Vzorce a funkcie s\u00fa jeden zo z\u00e1kladn\u00fdch funk\u010dn\u00fdch prvkov programu Excel. V\u010faka &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-1393","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 vzorce a funkcie<\/title>\n<meta name=\"description\" content=\"V\u00fdpo\u010dtov\u00e9 funkcie, spr\u00e1vne pou\u017e\u00edvanie relat\u00edvnych a absol\u00fatnych odkazov, zad\u00e1vanie podmienok, pou\u017e\u00edva\u0165 vyh\u013ead\u00e1vacie funkcie a mnoh\u00e9 in\u00e9 t\u00e9my.\" \/>\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-formulas-and-calculations\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EduBeliso - Kurz Excel vzorce a funkcie\" \/>\n<meta property=\"og:description\" content=\"V\u00fdpo\u010dtov\u00e9 funkcie, spr\u00e1vne pou\u017e\u00edvanie relat\u00edvnych a absol\u00fatnych odkazov, zad\u00e1vanie podmienok, pou\u017e\u00edva\u0165 vyh\u013ead\u00e1vacie funkcie a mnoh\u00e9 in\u00e9 t\u00e9my.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-formulas-and-calculations\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-30T15:14:54+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-formulas-and-calculations\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-formulas-and-calculations\/\",\"name\":\"EduBeliso - Kurz Excel vzorce a funkcie\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-07-12T20:37:34+00:00\",\"dateModified\":\"2020-10-30T15:14:54+00:00\",\"description\":\"V\\u00fdpo\\u010dtov\\u00e9 funkcie, spr\\u00e1vne pou\\u017e\\u00edvanie relat\\u00edvnych a absol\\u00fatnych odkazov, zad\\u00e1vanie podmienok, pou\\u017e\\u00edva\\u0165 vyh\\u013ead\\u00e1vacie funkcie a mnoh\\u00e9 in\\u00e9 t\\u00e9my.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-formulas-and-calculations\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1393","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=1393"}],"version-history":[{"count":15,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1393\/revisions"}],"predecessor-version":[{"id":2550,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1393\/revisions\/2550"}],"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=1393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}