{"id":8202,"date":"2021-12-13T18:42:38","date_gmt":"2021-12-13T17:42:38","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&#038;p=8202"},"modified":"2026-10-16T19:15:07","modified_gmt":"2026-10-16T17:15:07","slug":"online-kurz-google-workspace-google-sheets-tabulky","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/cs\/online-kurz-google-workspace-google-sheets-tabulky\/","title":{"rendered":"Online kurz Google Workspace &#8211; Tabu\u013eky (Google Sheets)"},"content":{"rendered":"<p>Online kurz Google Workspace \u2013 Tabu\u013eky (Google Sheets) je pre v\u00e1s ide\u00e1lny, ak chcete samostatne vytv\u00e1ra\u0165 preh\u013eadn\u00e9 tabu\u013eky, spracov\u00e1va\u0165 \u00fadaje a pou\u017e\u00edva\u0165 v\u00fdpo\u010dty pri ka\u017edodennej pr\u00e1ci. <strong>Ide o certifikovan\u00fd online kurz na Google Workspace \u2013 Tabu\u013eky (Google Sheets).<\/strong> Spolo\u010dne si vysvetl\u00edme pou\u017e\u00edvate\u013esk\u00e9 rozhranie a vytvor\u00edme prv\u00fa tabu\u013eku, v ktorej budeme pracova\u0165 s textom, \u010d\u00edslami a d\u00e1tumami. Nau\u010d\u00edme sa organizova\u0165 h\u00e1rky, vybera\u0165 bunky a rozsahy aj spr\u00e1vne zad\u00e1va\u0165 a upravova\u0165 \u00fadaje. Uk\u00e1\u017eeme si, ako kop\u00edrovanie a duplikovanie ur\u00fdch\u013euje opakuj\u00face sa \u010dinnosti. Google Tabu\u013eky vyu\u017eijete napr\u00edklad na evidenciu objedn\u00e1vok, sledovanie v\u00fddavkov, pr\u00edpravu zoznamov alebo organizovanie pracovn\u00fdch \u00faloh. Kurz je vhodn\u00fd aj pre pou\u017e\u00edvate\u013eov Excelu, ktor\u00ed chc\u00fa spozna\u0165 prostredie Google Sheets a pracova\u0165 s tabu\u013ekami v internetovom prehliada\u010di.<\/p>\n<p>&nbsp;<\/p>\n<p>Pri praktickej pr\u00e1ci prepoj\u00edme form\u00e1tovanie, filtre, vzorce a funkcie do postupov vyu\u017eite\u013en\u00fdch na vlastn\u00fdch \u00fadajoch. Vysvetl\u00edme si, ako usporiada\u0165 d\u00e1ta do zrozumite\u013en\u00fdch st\u013apcov a vytvori\u0165 tabu\u013eku s jasn\u00fdmi n\u00e1zvami a jednotn\u00fdm form\u00e1tovan\u00edm. Pomocou filtrov zobraz\u00edme z\u00e1znamy pod\u013ea zvolen\u00fdch podmienok, aby sme nemuseli cel\u00fd zoznam prech\u00e1dza\u0165 ru\u010dne. Pri v\u00fdpo\u010dtoch si uk\u00e1\u017eeme rozdiel medzi vzorcom a funkciou a nau\u010d\u00edme sa pracova\u0165 s odkazmi na bunky. Osobitne sa zameriame na relat\u00edvne a absol\u00fatne odkazy, ktor\u00e9 ovplyv\u0148uj\u00fa spr\u00e1vanie v\u00fdpo\u010dtov pri kop\u00edrovan\u00ed. Obozn\u00e1mime sa aj s limitmi Google Tabuliek a z\u00e1sadami ochrany \u00fadajov. Rozl\u00ed\u0161ime nastavenie pr\u00edstupu k s\u00faboru od obmedzenia \u00faprav konkr\u00e9tnych buniek, aby sme dok\u00e1zali lep\u0161ie predch\u00e1dza\u0165 nechcen\u00fdm zmen\u00e1m.<\/p>\n<p>&nbsp;<\/p>\n<p>Google Tabu\u013eky m\u00f4\u017eete \u0161tudova\u0165 plne online, v sloven\u010dine a vlastn\u00fdm tempom. Z\u00edskate ro\u010dn\u00fd pr\u00edstup, materi\u00e1ly na stiahnutie, prezent\u00e1ciu a \u0165ah\u00e1ky, ku ktor\u00fdm sa m\u00f4\u017eete vraca\u0165 pri samostatnej pr\u00e1ci. Odpor\u00fa\u010dame priebe\u017ene sk\u00fa\u0161a\u0165 postupy na vlastnej evidencii alebo cvi\u010dnej tabu\u013eke a sledova\u0165, ako sa pri zmene vstupn\u00fdch \u00fadajov prepo\u010d\u00edtaj\u00fa v\u00fdsledky. Takto si precvi\u010d\u00edte zad\u00e1vanie d\u00e1t aj kontrolu pou\u017eit\u00fdch odkazov a funkci\u00ed. Vedomosti si over\u00edte v priebe\u017en\u00fdch testoch a z\u00e1vere\u010dnom teste. Po \u00faspe\u0161nom absolvovan\u00ed z\u00edskate certifik\u00e1t VITA. Z\u00edskan\u00e9 zru\u010dnosti vyu\u017eijete v administrat\u00edve, podnikan\u00ed, \u0161kolstve aj pri osobnom pl\u00e1novan\u00ed. Ak sa chcete skuto\u010dne nau\u010di\u0165 pracova\u0165 s Google Tabu\u013ekami, organizova\u0165 \u00fadaje a pou\u017e\u00edva\u0165 vzorce, funkcie a filtre, tak toto je ide\u00e1lny vstupn\u00fd online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Online kurz Google Workspace &#8211; Tabu\u013eky (Google Sheets) v\u00e1s nau\u010d\u00ed efekt\u00edvne pracova\u0165 s tabu\u013ekami a d\u00e1tami, pou\u017e\u00edva\u0165 vzorce, funkcie, filtre, form\u00e1tovanie a n\u00e1stroje na organizovanie a anal\u00fdzu \u00fadajov.","protected":false},"author":4,"featured_media":17928,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[66,363,73],"product_tag":[1870,1871,1872,1873,1874,187,433,527,1689,1840,1868,1869],"class_list":{"0":"post-8202","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-kancelarske-baliky","7":"product_cat-online-kurzy-google-workspace","8":"product_cat-bez-kategorie","9":"product_tag-vzorce-a-funkcie","10":"product_tag-odkazy-na-bunky","11":"product_tag-formatovanie-tabuliek","12":"product_tag-ochrana-harkov","13":"product_tag-spracovanie-udajov","14":"product_tag-kancelarske-baliky","15":"product_tag-google-workspace","16":"product_tag-google","17":"product_tag-filtrovanie-udajov","18":"product_tag-google-tabulky","19":"product_tag-google-sheets","20":"product_tag-tabulkove-procesory","22":"first","23":"instock","24":"sale","25":"virtual","26":"sold-individually","27":"taxable","28":"purchasable","29":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.0 (Yoast SEO v25.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Online kurz Google Workspace - Google Tabu\u013eky 2026 | VITA<\/title>\n<meta name=\"description\" content=\"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Google Workspace - Tabu\u013eky (Google Sheets)\" \/>\n<meta property=\"og:description\" content=\"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/VitaAcademySK\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-16T17:15:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/\",\n\t            \"name\": \"Online kurz Google Workspace - Google Tabu\u013eky {Y} | VITA\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png\",\n\t            \"datePublished\": \"2021-12-13T17:42:38+00:00\",\n\t            \"dateModified\": \"2026-10-16T17:15:07+00:00\",\n\t            \"description\": \"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"cs\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"cs\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png\",\n\t            \"width\": 360,\n\t            \"height\": 360,\n\t            \"caption\": \"Kurz Google Workspace \u2013 Tabu\u013eky (Google Sheets)\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"VITA Academy\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/cs\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"Shop\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/shop\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"Kancel\u00e1rske Bal\u00edky (Microsoft Office)\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 4,\n\t                    \"name\": \"Google Workspace\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-google-workspace\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 5,\n\t                    \"name\": \"Online kurz Google Workspace &#8211; Tabu\u013eky (Google Sheets)\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/#website\",\n\t            \"url\": \"https:\/\/www.vita.sk\/\",\n\t            \"name\": \"VITA Academy - Online Kurzy a \u0160kolenia\",\n\t            \"description\": \"\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.vita.sk\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"cs\"\n\t        },\n\t        {\n\t            \"email\": \"admin@vita.sk\",\n\t            \"logo\": \"https:\/\/www.vita.sk\/img\/vita_logo.png \",\n\t            \"address\": {\n\t                \"type\": \"PostalAddress\",\n\t                \"streetAddress\": \"Tom\u00e1\u0161ikova 50\/A\",\n\t                \"addressLocality\": \"Bratislava\",\n\t                \"postalCode\": \"83104\",\n\t                \"addressCountry\": {\n\t                    \"name\": \"SK\",\n\t                    \"type\": \"Country\"\n\t                }\n\t            },\n\t            \"contactPoint\": {\n\t                \"type\": \"ContactPoint\",\n\t                \"telephone\": \"+421 907 375\u00a0543\",\n\t                \"Email\": \"admin@vita.sk\",\n\t                \"contactType\": \"customer service\"\n\t            },\n\t            \"sameAs\": [\n\t                \"https:\/\/www.facebook.com\/VitaAcademySK\/\",\n\t                \"https:\/\/www.linkedin.com\/company\/vita-academy\/\"\n\t            ]\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Online kurz Google Workspace - Google Tabu\u013eky 2026 | VITA","description":"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/","og_locale":"cs_CZ","og_type":"article","og_title":"Online kurz Google Workspace - Tabu\u013eky (Google Sheets)","og_description":"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2026-10-16T17:15:07+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/","url":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/","name":"Online kurz Google Workspace - Google Tabu\u013eky {Y} | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png","datePublished":"2021-12-13T17:42:38+00:00","dateModified":"2026-10-16T17:15:07+00:00","description":"V online kurze Google Workspace \u2013 Sheets (Tabu\u013eky) sa nau\u010d\u00edte efekt\u00edvne pracova\u0165 s Google Tabu\u013ekami a efekt\u00edvne spravova\u0165 \u00fadaje. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2021\/12\/Online-kurz-Google-Workspace-Tabulky.png","width":360,"height":360,"caption":"Kurz Google Workspace \u2013 Tabu\u013eky (Google Sheets)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-google-workspace-google-sheets-tabulky\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/cs\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Kancel\u00e1rske Bal\u00edky (Microsoft Office)","item":"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/"},{"@type":"ListItem","position":4,"name":"Google Workspace","item":"https:\/\/www.vita.sk\/online-kurzy-google-workspace\/"},{"@type":"ListItem","position":5,"name":"Online kurz Google Workspace &#8211; Tabu\u013eky (Google Sheets)"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA Academy - Online Kurzy a \u0160kolenia","description":"","publisher":{"@id":"https:\/\/www.vita.sk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vita.sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"email":"admin@vita.sk","logo":"https:\/\/www.vita.sk\/img\/vita_logo.png ","address":{"type":"PostalAddress","streetAddress":"Tom\u00e1\u0161ikova 50\/A","addressLocality":"Bratislava","postalCode":"83104","addressCountry":{"name":"SK","type":"Country"}},"contactPoint":{"type":"ContactPoint","telephone":"+421 907 375\u00a0543","Email":"admin@vita.sk","contactType":"customer service"},"sameAs":["https:\/\/www.facebook.com\/VitaAcademySK\/","https:\/\/www.linkedin.com\/company\/vita-academy\/"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product\/8202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/comments?post=8202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media\/17928"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media?parent=8202"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_brand?post=8202"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat?post=8202"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_tag?post=8202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}