{"id":1388,"date":"2020-07-12T22:31:06","date_gmt":"2020-07-12T20:31:06","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=1388"},"modified":"2020-08-02T19:10:09","modified_gmt":"2020-08-02T17:10:09","slug":"excel-pivot-tables","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-pivot-tables\/","title":{"rendered":"Excel kontingen\u010dn\u00e9 tabu\u013eky"},"content":{"rendered":"\n<p>Kurz je orientovan\u00fd na pr\u00e1cu s kontingen\u010dn\u00fdmi tabu\u013ekami (po anglicky: Pivot tables). V r\u00e1mci kurzu bud\u00fa h\u013abkovo vysvetlen\u00e9 kontingen\u010dn\u00e9 tabu\u013eky a v\u0161etky ich d\u00f4le\u017eit\u00e9 vlastnosti, bude uk\u00e1zan\u00e9 ako pripravi\u0165 \u00fadaje na tvorbu kontingen\u010dnej tabu\u013eky, ako pou\u017e\u00edva\u0165 polia v kontingen\u010dn\u00fdch tabu\u013ek\u00e1ch a prep\u00e1janie kontingen\u010dn\u00fdch tabuliek s r\u00f4znymi zdrojov\u00fdmi d\u00e1tami. K absolvovaniu kurzu bude \u00fa\u010dastn\u00edk potrebova\u0165 pozna\u0165 z\u00e1kladn\u00fa orient\u00e1ciu v programe MS Excel a ch\u00e1pa\u0165 z\u00e1kladn\u00e9 princ\u00edpy programu Excel (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 kontingen\u010dn\u00fdch tabuliek<\/h3>\n<ul><li>Vysvetlenie pojmu kontingen\u010dn\u00e1 tabu\u013eka<\/li>\n<li>Pr\u00edprava zdrojovej tabu\u013eky na tvorbu kontingen\u010dnej tabu\u013eky<\/li>\n<li>\u010cast\u00e9 chyby pri tvorbe zdrojovej a kontingen\u010dnej tabu\u013eky<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vytvorenie kontingen\u010dnej tabu\u013eky<\/h3>\n<ul><li>Typy zdrojov\u00fdch \u00fadajov<\/li>\n<li>Pr\u00e1ca s po\u013eami kontingen\u010dnej tabu\u013eky<\/li>\n<li>Rozlo\u017eenie tabu\u013eky: pr\u00e1ca so st\u013apcami, riadkami a hodnotami<\/li>\n<li>Tvorba viac\u00farov\u0148ov\u00fdch zoznamov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Prisp\u00f4sobenie kontingen\u010dnej tabu\u013eky<\/h3>\n<ul><li>Zmena n\u00e1zvov pol\u00ed<\/li>\n<li>Nastavenie po\u013ea hodnoty: typ v\u00fdpo\u010dtu, form\u00e1t \u010d\u00edsla, sp\u00f4sob zobrazenia hodn\u00f4t<\/li>\n<li>Zobrazenia hodn\u00f4t ako percento z vybranej \u010dasti a porovnanie s in\u00fdmi polo\u017ekami po\u013ea<\/li>\n<li>Zoskupovanie \u00fadajov: pod\u013ea d\u00e1tumov, vlastn\u00e9 zoskupenie<\/li>\n<li>Filtrovanie \u00fadajov<\/li>\n<li>Povolenie viacer\u00fdch filtrov pre jedno pole<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">N\u00e1vrh a prezent\u00e1cia kontingen\u010dnej tabu\u013eky<\/h3>\n<ul><li>Pr\u00edprava na prezent\u00e1ciu: pou\u017eitie r\u00fdchleho filtra a \u010dasovej osi<\/li>\n<li>Rozlo\u017eenie kontingen\u010dnej tabu\u013eky<\/li>\n<li>Podmienen\u00e9 form\u00e1tovanie v kontingen\u010dnej tabu\u013eke<\/li>\n<li>Prisp\u00f4sobenie riadkov medzis\u00fa\u010dtov a s\u00fa\u010dtov<\/li>\n<li>\u0160t\u00fdly kontingen\u010dnej tabu\u013eky<\/li>\n<li>Kop\u00edrovanie kontingen\u010dnej tabu\u013eky do Wordu alebo PowerPointu<\/li>\n<li>Tvorba kontingen\u010dn\u00e9ho grafu<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Pr\u00e1ca s \u00fadajmi<\/h3>\n<ul><li>Vypo\u010d\u00edtavan\u00e9 polia a vypo\u010d\u00edtavan\u00e9 polo\u017eky<\/li>\n<li>Poradie v\u00fdpo\u010dtov a zoznam vzorcov<\/li>\n<li>Funkcia GETPIVOTDATA: Zahrnutie \u00fadajov z kontingen\u010dnej tabu\u013eky mimo kontingen\u010dnej tabu\u013eky<\/li>\n<li>Zmena zdrojov\u00fdch \u00fadajov<\/li>\n<li>Automatick\u00e9 prid\u00e1vanie \u00fadajov zo zdrojovej tabu\u013eky<\/li>\n<li>Pou\u017eitie extern\u00fdch zdrojov \u00fadajov <\/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\">\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>Cena:<\/strong> 65,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. Odpor\u00fa\u010dan\u00e9 s\u00fa vedomosti na \u00farovni absolvovania kurzu Excel level 1 \u2013 za\u010diato\u010dn\u00edk. Nie s\u00fa potrebn\u00e9 predo\u0161l\u00e9 sk\u00fasenosti s kontingen\u010dn\u00fdmi tabu\u013ekami.<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 kontingen\u010dn\u00e9 tabu\u013eky 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;\">\nGETPIVOTDATA<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 vzorce a funkcie<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 je orientovan\u00fd na pr\u00e1cu s kontingen\u010dn\u00fdmi tabu\u013ekami (po anglicky: Pivot tables). V r\u00e1mci kurzu bud\u00fa h\u013abkovo vysvetlen\u00e9 kontingen\u010dn\u00e9 tabu\u013eky &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-1388","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 kontingen\u010dn\u00e9 tabu\u013eky<\/title>\n<meta name=\"description\" content=\"Pr\u00edprava \u00fadajov na tvorbu kontingen\u010dnej tabu\u013eky, ako pou\u017e\u00edva\u0165 polia v kontingen\u010dn\u00fdch tabu\u013ek\u00e1ch a prep\u00e1janie kontingen\u010dn\u00fdch tabuliek s r\u00f4znymi d\u00e1tami.\" \/>\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-pivot-tables\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EduBeliso - Kurz Excel kontingen\u010dn\u00e9 tabu\u013eky\" \/>\n<meta property=\"og:description\" content=\"Pr\u00edprava \u00fadajov na tvorbu kontingen\u010dnej tabu\u013eky, ako pou\u017e\u00edva\u0165 polia v kontingen\u010dn\u00fdch tabu\u013ek\u00e1ch a prep\u00e1janie kontingen\u010dn\u00fdch tabuliek s r\u00f4znymi d\u00e1tami.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-pivot-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-02T17:10:09+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-pivot-tables\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-pivot-tables\/\",\"name\":\"EduBeliso - Kurz Excel kontingen\\u010dn\\u00e9 tabu\\u013eky\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-07-12T20:31:06+00:00\",\"dateModified\":\"2020-08-02T17:10:09+00:00\",\"description\":\"Pr\\u00edprava \\u00fadajov na tvorbu kontingen\\u010dnej tabu\\u013eky, ako pou\\u017e\\u00edva\\u0165 polia v kontingen\\u010dn\\u00fdch tabu\\u013ek\\u00e1ch a prep\\u00e1janie kontingen\\u010dn\\u00fdch tabuliek s r\\u00f4znymi d\\u00e1tami.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-pivot-tables\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1388","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=1388"}],"version-history":[{"count":16,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1388\/revisions"}],"predecessor-version":[{"id":2431,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/1388\/revisions\/2431"}],"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=1388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}