{"id":971,"date":"2020-05-30T11:48:52","date_gmt":"2020-05-30T09:48:52","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=971"},"modified":"2022-04-28T09:07:35","modified_gmt":"2022-04-28T07:07:35","slug":"excel-level-3","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/","title":{"rendered":"Excel level 3 &#8211; stredne pokro\u010dil\u00fd"},"content":{"rendered":"\n<p>Tento kurz je priamym nasledovn\u00edkom kurzu Excel level 2 \u2013 mierne pokro\u010dil\u00fd. Kurz rozv\u00edja osvojen\u00e9 zru\u010dnosti v&nbsp;programe MS Excel. Je vhodn\u00fd pre \u00fa\u010dastn\u00edkov, ktor\u00ed u\u017e poznaj\u00fa program MS Excel. Kurz pripravuje najm\u00e4 na efekt\u00edvne pou\u017e\u00edvanie tabuliek a&nbsp;minimaliz\u00e1ciu manu\u00e1lnej pr\u00e1ce prostredn\u00edctvom vyu\u017e\u00edvania r\u00f4znych funkci\u00ed a&nbsp;n\u00e1strojov. Oproti predo\u0161lej \u00farovni prib\u00fada do osnov najm\u00e4 pr\u00edprava na pr\u00e1cu v&nbsp;kolekt\u00edve prostredn\u00edctvom n\u00e1strojov rev\u00edzie, mno\u017estvo funkci\u00ed vr\u00e1tane VLOOKUP, roz\u0161\u00edren\u00fd filter, overovanie \u00fadajov a r\u00f4zne \u010fal\u0161ie t\u00e9my. Ku absolvovaniu kurzu je odpor\u00fa\u010dan\u00e9 pozna\u0165 relat\u00edvne a absol\u00fatne odkazy, tvorbu funkci\u00ed a orientova\u0165 sa v 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;\">Spr\u00e1vne z\u00e1sady pri tvorbe tabu\u013eky<\/h3>\n<ul><li>N\u00e1vrh \u0161trukt\u00fary tabu\u013eky<\/li>\n<li>Vysvetlenie pojmov: tabu\u013eka, rozsah, hlavi\u010dka tabu\u013eky, z\u00e1znam a pole <\/li>\n<li>Form\u00e1tova\u0165 ako tabu\u013eku &#8211; vyu\u017eitie v in\u00fdch funkci\u00e1ch, vkladanie sumariza\u010dn\u00fdch funkci\u00ed (riadok s\u00fa\u010dtu)<\/li>\n<li>Mo\u017enosti tabu\u013eky, \u0161t\u00fdly tabu\u013eky<\/li>\n<li>\u010cast\u00e9 chyby pri tvorbe tabu\u013eky<\/li>\n<li>Z\u00e1kladn\u00e9 porovnanie lokaliz\u00e1ci\u00ed Excelu<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">N\u00e1stroje pre pr\u00e1cu s \u00fadajov\u00fdmi tabu\u013ekami<\/h3>\n<ul><li>Roz\u0161\u00edren\u00fd filter<\/li>\n<li>Nastavenie kriteri\u00e1lnej tabu\u013eky, z\u00e1stupn\u00e9 symboly &#8222;*&#8220; a &#8222;?&#8220;<\/li>\n<li>Kop\u00edrovanie filtrovan\u00fdch \u00fadajov na in\u00e9 miesto<\/li>\n<li>N\u00e1stroje pre \u00fadaje: Text na st\u013apce, Dynamick\u00e9 dop\u013a\u0148anie, Odstr\u00e1ni\u0165 duplicity<\/li>\n<li>Overenie \u00fadajov: Nastavenie krit\u00e9ri\u00ed overenia, vstupn\u00e1 spr\u00e1va, chybov\u00e9 hl\u00e1senie<\/li>\n<li>H\u013eada\u0165, nahradi\u0165, prejs\u0165 na \u0161peci\u00e1lne<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vzorce a funkcie<\/h3>\n<ul><li>Vytv\u00e1ranie odkazov na in\u00e9 bunky vo vzorcoch: relat\u00edvne, absol\u00fatne a zmie\u0161an\u00e9 odkazy<\/li>\n<li>Vytv\u00e1ranie odkazov na in\u00e9 h\u00e1rky a zo\u0161ity<\/li>\n<li>Odkazy na cel\u00e9 st\u013apce a cel\u00e9 riadky<\/li>\n<li>Syntax funkci\u00ed a vn\u00e1ranie funkci\u00ed<\/li>\n<li>Logick\u00e9 funkcie: IF, AND, OR<\/li>\n<li>Informa\u010dn\u00e9 funkcie: ISNUMBER, ISBLANK a podobn\u00e9<\/li>\n<li>V\u00fdpo\u010dty na z\u00e1klade podmienky pomocou funkci\u00ed: COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS, AVERAGEIFS<\/li>\n<li>Vyh\u013ead\u00e1vacie funkcie: VLOOKUP, HLOOKUP, INDEX, MATCH<\/li>\n<li>Textov\u00e9 funkcie a oper\u00e1tor &#8222;&#038;&#8220;: CONCATENATE (CONCAT), UPPER, LOWER, PROPER, TRIM, SUBSTITUTE, REPLACE<\/li>\n<li>Funkcie TODAY, NOW, DATE, DAY, MONTH, YEAR<\/li><li>Funkcie WEEKDAY, ISOWEEKNUM, DATEDIF<\/li><li>Pr\u00e1ca s&nbsp;pracovn\u00fdmi d\u0148ami a&nbsp;sviatkami funkciami WORKDAY, NETWORKDAYS<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Kontingen\u010dn\u00e9 tabu\u013eky<\/h3>\n<ul><li>\u00davod do kontingen\u010dn\u00fdch tabuliek<\/li>\n<li>Pr\u00e1ca s poliami kontinge\u010dnej tabu\u013eky<\/li>\n<li>V\u00fdber funkcie na sumariz\u00e1ciu \u00fadajov vybran\u00e9ho po\u013ea<\/li>\n<li>Filtrovanie a zora\u010fovanie \u00fadajov<\/li>\n<li>Nastavenie \u010d\u00edseln\u00e9ho form\u00e1tu<\/li>\n<li>Zoskupovanie polo\u017eiek po\u013ea<\/li>\n<li>Zmena rozlo\u017eenia kontingen\u010dnej tabu\u013eky (medzis\u00fa\u010dty)<\/li>\n<li>Vkladanie r\u00fdchleho filtru a \u010dasovej osi<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Pr\u00e1ca so zo\u0161itom<\/h3>\n<ul><li>Koment\u00e1re a pozn\u00e1mky<\/li>\n<li>Chr\u00e1nenie zo\u0161ita: za\u0161ifrovanie heslom, zabezpe\u010denie h\u00e1rku, zabezpe\u010denie zo\u0161ita, povolenie rozsahu \u00faprav<\/li>\n<li>Nastavenie hesla na otvorenie a na \u00fapravy<\/li>\n<li>Prida\u0165 prepojenie (Hypertextov\u00fd odkaz)<\/li>\n<\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Nastavenia Excelu<\/h3>\n<ul><li>Prisp\u00f4sobenie p\u00e1su n\u00e1strojov a r\u00fdchly pr\u00edstup<\/li>\n<li>Nastavenie stavov\u00e9ho riadka<\/li>\n<li>Automatick\u00e9 ukladanie<\/li>\n<li>Zmena predvolen\u00e9ho umiestnenia s\u00faborov<\/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 kurzu:<\/strong> 135,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. Ku absolvovaniu kurzu je odpor\u00fa\u010dan\u00e9 pozna\u0165 relat\u00edvne a absol\u00fatne odkazy, tvorbu funkci\u00ed a orientova\u0165 sa 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 3 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<br \/>\n<strong>Informa\u010dn\u00e9 funkcie:<\/strong> ISNUMBER, ISBLANK<br \/>\n<strong>\u0160tatistick\u00e9 funkcie:<\/strong> COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS<br \/>\n<strong>Matematick\u00e9 funkcie:<\/strong> SUMIF, SUMIFS<br \/>\n<strong>Vyh\u013ead\u00e1vacie funkcie:<\/strong> VLOOKUP, HLOOKUP, INDEX, MATCH<br \/>\n<strong>Textov\u00e9 funkcie:<\/strong> CONCATENATE (CONCAT), UPPER, LOWER, PROPER, TRIM, SUBSTITUTE, REPLACE<br \/>\n<strong>D\u00e1tumov\u00e9 a \u010dasov\u00e9 funkcie:<\/strong> DAY, MONTH, YEAR, TODAY, NOW, DATE, WEEKDAY, ISOWEEKNUM, DATEDIF, WORKDAY, NETWORKDAYS<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 4 &#8211; pokro\u010dil\u00fd<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<h2 class=\"wp-block-heading\">Va\u0161e recenzie<\/h2>\n\n\n<div class=\"glsr glsr-default\" id=\"glsr_a897b05d\" data-from='block' data-shortcode='site_reviews' data-assigned_posts='971' data-display='50' data-hide='[&quot;title&quot;]'><div class=\"glsr-reviews-wrap\">\n    <div class=\"glsr-reviews\">\n        <div class=\"glsr-review\" data-type=\"local\" id=\"review-3024\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">4. j\u00fana 2024<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>\u0160kolenie splnilo \u00fa\u010del, cel\u00fd Excel bol ve\u013emi zauj\u00edmav\u00fd ani chv\u00ed\u013eku som sa nenudila. Lektor bol ve\u013emi sympatick\u00fd, praktick\u00fd, dok\u00e1zal v\u0161etko jednoducho a trefne odprezentova\u0165 a vysvetli\u0165. Super \u0161kolenie, ve\u013ek\u00fd pr\u00ednos, odpor\u00fa\u010dam. U\u017e teraz sa te\u0161\u00edm na nov\u00fd level:-) \u010fakujem.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Zita<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2993\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">29. m\u00e1ja 2023<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Po ukon\u010den\u00ed levelu 2 , som sa rozhodol pokra\u010dova\u0165 vy\u0161\u0161\u00edm levelom . Bol som milo prekvapen\u00fd , ako skvelo mi bolo v\u0161etko vysvetlen\u00e9 a z\u00e1rove\u0148 som si mohol v\u0161etko vysk\u00fa\u0161a\u0165 na pr\u00edkladoch . Ak mi nie\u010do ne\u0161lo , vr\u00e1tili sme sa , pre\u0161li znova a op\u00e4\u0165 sk\u00fasili . Kvalitn\u00fd profesion\u00e1lny pr\u00edstup . Len odpor\u00fa\u010da\u0165 m\u00f4\u017eem .<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Juraj<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2782\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">22. m\u00e1ja 2022<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Skvele skolenie, interaktivne, s odpovedami na v\u0161etky na\u0161e ot\u00e1zky.Vrelo odpor\u00fa\u010dam ka\u017ed\u00e9mu, kto pracuje s Excelom<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Milan<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2783\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">22. m\u00e1ja 2022<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>v\u00fdborn\u00fd pr\u00edstup, felxibilita. Oce\u0148ujem jednoduchos\u0165 a praktickos\u0165 podania inform\u00e1cii.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Martina<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2784\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">22. m\u00e1ja 2022<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Velmi ocenujem skolitelove znalosti ako ucetela a toto vyuzil aj pri uceni zakladov funkcii , roznych skratiek. Po dlhej dobe velmi prinosne skolenie, ktore vyuzijem na skratenie casu prace s excelom.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Ivana<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2642\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">22. marca 2022<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>V prvom rade sa chcem Petrovi po\u010fakova\u0165.<\/p>\n<p>\u0160kolenie bolo veden\u00e9 v pr\u00edjemnej atmosf\u00e9re. V\u0161etky zadan\u00e9 okruhy, ktpr\u00e9 sme chceli rie\u0161i\u0165 sme realne rie\u0161ili.<\/p>\n<p>Peter m\u00e1 pr\u00edjemn\u00fd kultivovan\u00fd prejav, je trpezliv\u00fd, vie zauja\u0165 a je profesion\u00e1l.<\/p>\n<p>Ur\u010dite ho ako \u0161kolite\u013ea doporu\u010dejem a ver\u00edm, \u017ee s n\u00edm e\u0161te nejak\u00e9 \u0161kolenie absolvujem.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Milan<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2634\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">29. apr\u00edla 2021<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Ve\u013emi u\u017eito\u010dn\u00e9 inform\u00e1cie, primeran\u00e1 r\u00fdchlos\u0165 aj podanie zrozumite\u013en\u00e9.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">So\u0148a<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2628\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">28. apr\u00edla 2021<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>P\u00e1\u010dilo sa mi d\u00f4kladn\u00e9 vysvetlenie krok za krokom.<\/p>\n<p>Osobne pracujem viac s tabu\u013ekami ako v\u00e4\u010d\u0161ina \u00fa\u010dastn\u00edkov z mojej skupiny, preto som za\u010diatok \u201eopakovanie\u201c vn\u00edmala ako pomal\u00e9 a sk\u00f4r pre za\u010diato\u010dn\u00edkov. N\u00e1sledn\u00fd obsah v\u0161ak zaujal aj s prvkami opakovania a tempo prisp\u00f4soben\u00e9 skupine.<\/p>\n<p class=\"glsr-hidden-text\" data-show-less='Show less' data-show-more='Show more' data-trigger='expand'>Ve\u013emi oce\u0148ujem, \u017ee pr\u00edklady boli nastaven\u00e9 tak, aby sa precvi\u010dilo aj logick\u00e9 myslenie pri <span class=\"glsr-hidden\">kombin\u00e1cii vzorcov. Takto pomerne jednoduch\u00e9 vzorce sa uk\u00e1zali viac u\u017eito\u010dn\u00e9 pre vyu\u017eitie v praxi.<\/span><\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">L. C.<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2630\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">28. apr\u00edla 2021<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Vyborne skolenie, idealne pre pokrocilych.<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Tibor<\/span><\/div> \n    \n<\/div>\n<div class=\"glsr-review\" data-type=\"local\" id=\"review-2623\" data-assigned='{\"assigned_posts\":[971],\"assigned_terms\":[47]}'>\n    \n    <div class=\"glsr-review-rating\"><div class=\"glsr-star-rating glsr-stars\" data-rating=\"5\" data-reviews=\"0\">\n    <span class=\"screen-reader-text\">Rated <strong>5<\/strong> out of 5<\/span>\n    <span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span><span class=\"glsr-star glsr-star-full\" aria-hidden=\"true\"><\/span>\n<\/div><\/div> <div class=\"glsr-review-date\"><span class=\"glsr-tag-value\">22. apr\u00edla 2021<\/span><\/div>\n    <div class=\"glsr-review-assigned_links\"><span class=\"glsr-tag-value\">Review of <a href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\">Excel level 3 &#8211; stredne pokro\u010dil\u00fd<\/a><\/span><\/div>\n    <div class=\"glsr-review-content\"><div class=\"glsr-tag-value\" data-expanded='false'><p>Super \u0161kolenie, ve\u013ea inform\u00e1cii naraz, ale tempo bolo dobre nastaven\u00e9<\/p>\n<p>\u010fakujem<\/p><\/div><\/div>\n     <div class=\"glsr-review-author\"><span class=\"glsr-tag-value\">Adriana<\/span><\/div> \n    \n<\/div>\n    <\/div>\n    \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Tento kurz je priamym nasledovn\u00edkom kurzu Excel level 2 \u2013 mierne pokro\u010dil\u00fd. Kurz rozv\u00edja osvojen\u00e9 zru\u010dnosti v&nbsp;programe MS Excel. Je &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":4.25,"_glsr_reviews":10,"footnotes":""},"class_list":["post-971","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 3 - stredne pokro\u010dil\u00fd<\/title>\n<meta name=\"description\" content=\"Pr\u00edprava na pr\u00e1cu v kolekt\u00edve prostredn\u00edctvom n\u00e1strojov rev\u00edzie, mno\u017estvo funkci\u00ed vr\u00e1tane VLOOKUP, roz\u0161\u00edren\u00fd filter, overovanie \u00fadajov a r\u00f4zne \u010fal\u0161ie 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-level-3\/\" \/>\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 3 - stredne pokro\u010dil\u00fd\" \/>\n<meta property=\"og:description\" content=\"Pr\u00edprava na pr\u00e1cu v kolekt\u00edve prostredn\u00edctvom n\u00e1strojov rev\u00edzie, mno\u017estvo funkci\u00ed vr\u00e1tane VLOOKUP, roz\u0161\u00edren\u00fd filter, overovanie \u00fadajov a r\u00f4zne \u010fal\u0161ie t\u00e9my.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-28T07:07:35+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-3\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\",\"name\":\"EduBeliso - Kurz Excel level 3 - stredne pokro\\u010dil\\u00fd\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-05-30T09:48:52+00:00\",\"dateModified\":\"2022-04-28T07:07:35+00:00\",\"description\":\"Pr\\u00edprava na pr\\u00e1cu v kolekt\\u00edve prostredn\\u00edctvom n\\u00e1strojov rev\\u00edzie, mno\\u017estvo funkci\\u00ed vr\\u00e1tane VLOOKUP, roz\\u0161\\u00edren\\u00fd filter, overovanie \\u00fadajov a r\\u00f4zne \\u010fal\\u0161ie t\\u00e9my.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-3\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/971","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=971"}],"version-history":[{"count":42,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/971\/revisions"}],"predecessor-version":[{"id":2776,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/971\/revisions\/2776"}],"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=971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}