{"id":263,"date":"2020-05-09T15:10:00","date_gmt":"2020-05-09T13:10:00","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=263"},"modified":"2022-04-28T09:08:47","modified_gmt":"2022-04-28T07:08:47","slug":"excel-level-1","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-1\/","title":{"rendered":"Excel level 1 &#8211; za\u010diato\u010dn\u00edk"},"content":{"rendered":"\n<p>Tento kurz je venovan\u00fd z\u00e1ujemcom, ktor\u00ed chc\u00fa za\u010da\u0165 pou\u017e\u00edva\u0165 program MS Excel a nemaj\u00fa s n\u00edm zatia\u013e sk\u00fasenosti. Priebeh \u0161kolenia m\u00e1 vo\u013enej\u0161ie tempo s mno\u017estvom priestoru na ot\u00e1zky. Za\u010diatok kurzu je venovan\u00fd spozn\u00e1vaniu prostredia programu MS Excel a&nbsp;postupn\u00e9mu rie\u0161eniu praktick\u00fdch pr\u00edkladov v prostred\u00ed programu MS Excel, ktor\u00e9 simuluj\u00fa re\u00e1lne potreby u\u017e\u00edvate\u013eov v dennodennej praxi ako s\u00fa napr\u00edklad zad\u00e1vanie \u00fadajov do tabuliek, v\u00fdpo\u010dty v tabu\u013ek\u00e1ch alebo zora\u010fovanie a filtrovanie d\u00e1t.<\/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;\">MS Excel a jeho postavenie v MS Office<\/h3>\n<ul><li>Alternat\u00edvne bal\u00edky a tabu\u013ekov\u00e9 programy<\/li>\n<li>V\u00fdznam \u010fal\u0161\u00edch aplik\u00e1ci\u00ed MS Office<\/li>\n<li>Porovnanie verzi\u00ed a licenci\u00ed MS Office<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Obozn\u00e1menie sa s prostred\u00edm MS Excel<\/h3>\n<ul><li>Panel n\u00e1strojov (Ribbon) &#8211; predstavenie z\u00e1lo\u017eiek, rozdelenie pr\u00edkazov do skup\u00edn<\/li>\n<li>Pole n\u00e1zvov a riadok vzorcov<\/li>\n<li>Pracovn\u00e1 oblas\u0165 a stavov\u00fd riadok<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Z\u00e1kladn\u00e9 pojmy a \u00fakony<\/h3>\n<ul><li>Ulo\u017eenie a na\u010d\u00edtanie s\u00faboru<\/li>\n<li>St\u013apec, riadok, bunka, bunkov\u00fd kurzor<\/li>\n<li>Prid\u00e1vanie a mazanie riadkov\/st\u013apcov<\/li>\n<li>Skr\u00fdvanie a odkr\u00fdvanie riadkov\/st\u013apcov<\/li>\n<li>Ozna\u010denie cel\u00e9ho st\u013apca alebo riadka, ozna\u010dovanie s\u00favisl\u00fdch a nes\u00favisl\u00fdch oblast\u00ed<\/li>\n<li>Z\u00e1kladn\u00e9 kl\u00e1vesov\u00e9 skratky<\/li>\n<li>Pr\u00e1ca s h\u00e1rkami: vytvorenie nov\u00e9ho h\u00e1rku, premenovanie, premiestnenie a odstra\u0148ovanie h\u00e1rkov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vizu\u00e1lne spracovanie tabuliek<\/h3>\n<ul><li>Form\u00e1tovanie buniek: zarovnanie, zl\u00fa\u010denie, farba p\u00edsma a v\u00fdplne a \u010fal\u0161ie<\/li>\n<li>Or\u00e1movanie tabuliek: typy \u010diar, farba or\u00e1movania<\/li>\n<li>Nastavenie sp\u00f4sobu zobrazenia hodn\u00f4t v bunk\u00e1ch (Form\u00e1t \u010d\u00edsiel): \u010c\u00edslo, Mena, \u00da\u010dtovn\u00edcke, D\u00e1tum, Percent\u00e1 a Text<\/li>\n<li>Automatick\u00fd form\u00e1t tabu\u013eky<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vzorce a funkcie<\/h3>\n<ul><li>Zad\u00e1vanie z\u00e1kladn\u00fdch vzorcov<\/li>\n<li>Z\u00e1kladn\u00e9 funkcie: SUM, AVERAGE, COUNT, MAX, MIN<\/li>\n<li>Sp\u00f4soby zad\u00e1vania vzorcov a funkci\u00ed<\/li>\n<li>Kop\u00edrovanie vzorcov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Kop\u00edrovanie a automatick\u00e9 rady<\/h3>\n<ul><li>Kop\u00edrovanie a vkladanie, prilepi\u0165 \u0161peci\u00e1lne: vzorce, hodnoty, form\u00e1tovanie, transponova\u0165<\/li>\n<li>Vytv\u00e1ranie postupnost\u00ed: \u010d\u00edseln\u00e9 rady, d\u00e1tumov\u00e9 rady, rady dn\u00ed a mesiacov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Kop\u00edrovanie a automatick\u00e9 rady<\/h3>\n<ul><li>Kop\u00edrovanie a vkladanie, prilepi\u0165 \u0161peci\u00e1lne: vzorce, hodnoty, form\u00e1tovanie, transponova\u0165<\/li>\n<li>Vytv\u00e1ranie postupnost\u00ed: \u010d\u00edseln\u00e9 rady, d\u00e1tumov\u00e9 rady, rady dn\u00ed a mesiacov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Zora\u010fovanie, filtrovanie a tla\u010d<\/h3>\n<ul><li>Zora\u010fovanie \u00fadajov pod\u013ea r\u00f4znych krit\u00e9ri\u00ed: \u010d\u00edseln\u00e9 hodnoty, d\u00e1tumy a texty<\/li>\n<li>Filtrovanie \u00fadajov pomocou automatick\u00e9ho filtra na z\u00e1klade r\u00f4znych krit\u00e9ri\u00ed<\/li>\n<li>Vhodn\u00e9 z\u00e1sady pre zora\u010fovanie a filtrovanie<\/li>\n<li>Vytv\u00e1ranie postupnost\u00ed: \u010d\u00edseln\u00e9 rady, d\u00e1tumov\u00e9 rady, rady dn\u00ed a mesiacov<\/li><\/ul>\n\n\n\n<h3 style=\"margin-bottom: 0px;\">Vizualiz\u00e1cia \u00fadajov (grafy)<\/h3>\n<ul><li>Vytv\u00e1ranie z\u00e1kladn\u00fdch grafov: kol\u00e1\u010dov\u00fd, st\u013apcov\u00fd, \u010diarov\u00fd<\/li>\n<li>Form\u00e1tovanie grafov: zmena \u0161t\u00fdlu grafu, ve\u013ekos\u0165 a umiestenie, farby grafu<\/li>\n<li>Prid\u00e1vanie\/odoberanie prvkov grafu, ich nastavenie a v\u00fdznam<\/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> 120,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.<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 1 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 s grafmi m\u00f4\u017eu vyskytova\u0165 zna\u010dn\u00e9 rozdiely v porovnan\u00ed s aktu\u00e1lnej\u0161\u00edmi verziami. V ostatn\u00fdch t\u00e9mach nie s\u00fa v\u00fdrazn\u00e9 rozdiely naprie\u010d 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>Z\u00e1kladn\u00e9 funkcie:<\/strong> SUM, AVERAGE, COUNT, MAX, MIN<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 \/>\n\u017diadne<br \/>\n<strong>Po kurze:<\/strong><br \/>\nExcel level 2<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<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tento kurz je venovan\u00fd z\u00e1ujemcom, ktor\u00ed chc\u00fa za\u010da\u0165 pou\u017e\u00edva\u0165 program MS Excel a nemaj\u00fa s n\u00edm zatia\u013e sk\u00fasenosti. Priebeh \u0161kolenia &hellip; <\/p>\n","protected":false},"author":1,"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-263","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 1 - za\u010diato\u010dn\u00edk<\/title>\n<meta name=\"description\" content=\"Spozn\u00e1vanie prostredia programu MS Excel, zad\u00e1vanie \u00fadajov do tabuliek, v\u00fdpo\u010dty v tabu\u013ek\u00e1ch pomocou vzorcov, zora\u010fovanie a filtrovanie d\u00e1t.\" \/>\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-1\/\" \/>\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 1 - za\u010diato\u010dn\u00edk\" \/>\n<meta property=\"og:description\" content=\"Spozn\u00e1vanie prostredia programu MS Excel, zad\u00e1vanie \u00fadajov do tabuliek, v\u00fdpo\u010dty v tabu\u013ek\u00e1ch pomocou vzorcov, zora\u010fovanie a filtrovanie d\u00e1t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-1\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-28T07:08:47+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=\"mirko\">\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-1\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-1\/\",\"name\":\"EduBeliso - Kurz Excel level 1 - za\\u010diato\\u010dn\\u00edk\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2020-05-09T13:10:00+00:00\",\"dateModified\":\"2022-04-28T07:08:47+00:00\",\"description\":\"Spozn\\u00e1vanie prostredia programu MS Excel, zad\\u00e1vanie \\u00fadajov do tabuliek, v\\u00fdpo\\u010dty v tabu\\u013ek\\u00e1ch pomocou vzorcov, zora\\u010fovanie a filtrovanie d\\u00e1t.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/excel-level-1\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/263","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/comments?post=263"}],"version-history":[{"count":163,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/263\/revisions"}],"predecessor-version":[{"id":2778,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/263\/revisions\/2778"}],"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=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}