{"id":983,"date":"2022-07-08T08:44:38","date_gmt":"2022-07-08T08:44:38","guid":{"rendered":"https:\/\/global.tab-tv.com\/sk\/?p=983"},"modified":"2022-07-08T08:44:39","modified_gmt":"2022-07-08T08:44:39","slug":"ako-pouzivat-krajac-v-harkoch-google","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/sk\/ako-pouzivat-krajac-v-harkoch-google\/","title":{"rendered":"Ako pou\u017e\u00edva\u0165 kr\u00e1ja\u010d v h\u00e1rkoch Google"},"content":{"rendered":"\n<p>Kr\u00e1ja\u010d je naozaj u\u017eito\u010dn\u00e1 funkcia h\u00e1rkov Google. Roz\u0161iruje mo\u017enosti kr\u00ed\u017eov\u00fdch tabuliek a s\u00fahrnn\u00fdch grafov v tabu\u013ek\u00e1ch Google. A pou\u017e\u00edvanie kr\u00e1ja\u010da je dos\u0165 jednoduch\u00e9.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>\u010co potrebujete na pou\u017e\u00edvanie kr\u00e1ja\u010da v h\u00e1rkoch Google<\/strong><\/h1>\n\n\n\n<p>Posuvn\u00edk je n\u00e1stroj tabu\u013ekov\u00e9ho procesora Google, ktor\u00fd v\u00e1m umo\u017e\u0148uje r\u00fdchlo a jednoducho filtrova\u0165 tabu\u013eky, tabu\u013ekov\u00e9 preh\u013eady a grafy kliknut\u00edm na tla\u010didlo. Vzn\u00e1\u0161aj\u00fa sa nad mrie\u017ekou a nie s\u00fa pripojen\u00e9 k \u017eiadnej bunke, tak\u017ee ich m\u00f4\u017eete \u013eahko pres\u00fava\u0165 po okne, zarovn\u00e1va\u0165 a umiest\u0148ova\u0165, ako sa v\u00e1m p\u00e1\u010di.<\/p>\n\n\n\n<p>Posuvn\u00edk sa tak naz\u00fdva preto, lebo ako filter prech\u00e1dza \u00fadajmi a poskytuje v\u00e1m prisp\u00f4soben\u00fa anal\u00fdzu \u00fadajov. Je v\u0161ak lep\u0161\u00ed ako filter, preto\u017ee je ove\u013ea atrakt\u00edvnej\u0161\u00ed a pou\u017e\u00edvate\u013esky pr\u00edvetivej\u0161\u00ed.<\/p>\n\n\n\n<p>Pomocou aplik\u00e1cie Slicer m\u00f4\u017eete analyzova\u0165 \u00fadaje ove\u013ea interakt\u00edvnej\u0161\u00edm sp\u00f4sobom. Priamo na pracovnom h\u00e1rku Google Sheets m\u00f4\u017eete vytv\u00e1ra\u0165 skuto\u010dne \u00fa\u017easn\u00e9 interakt\u00edvne zostavy a informa\u010dn\u00e9 panely. V skuto\u010dnosti, ke\u010f si raz osvoj\u00edte pou\u017e\u00edvanie slicerov, u\u017e sa nikdy nebudete chcie\u0165 vr\u00e1ti\u0165 k pou\u017e\u00edvaniu be\u017en\u00fdch filtrov.<\/p>\n\n\n\n<p>Tu je n\u00e1vod, ako pou\u017e\u00edva\u0165 rozde\u013eova\u010d v h\u00e1rkoch Google.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako vytvori\u0165 reza\u010dku v h\u00e1rkoch Google<\/strong><\/h2>\n\n\n\n<p>Ak chcete do svojho dokumentu v tabu\u013ek\u00e1ch Google prida\u0165 kr\u00e1ja\u010d, mus\u00edte postupova\u0165 pod\u013ea t\u00fdchto krokov:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Najsk\u00f4r vyberte graf alebo tabu\u013eku, na ktor\u00fa chcete pou\u017ei\u0165 rozde\u013eova\u010d.<\/li><li>Potom kliknite na kartu &#8220;<strong>\u00dadaje&#8221; <\/strong>a vyberte mo\u017enos\u0165 <strong>&#8220;Prida\u0165 rezn\u00fa \u010das\u0165&#8221;<\/strong>.<\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"662\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets.webp\" alt=\"\" class=\"wp-image-984\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-300x194.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-768x497.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>Zobraz\u00ed sa reza\u010dka, ktor\u00e1 vyzer\u00e1 ako pl\u00e1vaj\u00faci panel n\u00e1strojov. M\u00f4\u017eete ho presun\u00fa\u0165 na \u013eubovo\u013en\u00e9 miesto na h\u00e1rku.<\/li><li>Potom v zobrazenom bo\u010dnom paneli vyberte st\u013apec, ktor\u00fd chcete filtrova\u0165. Ak bo\u010dn\u00fd panel nevid\u00edte, dvojklikom na polo\u017eku <strong>&#8220;Slicer&#8221; <\/strong>ho otvorte.<\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"976\" height=\"577\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-1.webp\" alt=\"\" class=\"wp-image-985\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-1.webp 976w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-1-300x177.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-1-768x454.webp 768w\" sizes=\"auto, (max-width: 976px) 100vw, 976px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>V rozba\u013eovacom zozname <strong>&#8220;St\u013apec&#8221; <\/strong>by sa mali zobrazi\u0165 ozna\u010denia st\u013apcov pre \u00fadaje, ktor\u00e9 ste pou\u017eili. Vyberte jeden z nich a zobraz\u00ed sa v reze.<\/li><li>Kliknut\u00edm na ikonu filtra alebo na rozba\u013eovaciu \u0161\u00edpku na v\u00fdseku pou\u017eijete filter na dan\u00fd st\u013apec.<ul><li>Uvid\u00edte, \u017ee m\u00f4\u017eete filtrova\u0165 pod\u013ea podmienok, napr\u00edklad text obsahuj\u00faci k\u013e\u00fa\u010dov\u00e9 slovo alebo hodnoty v\u00e4\u010d\u0161ie ako ur\u010dit\u00e1 suma.<\/li><\/ul><ul><li>M\u00f4\u017eete tie\u017e filtrova\u0165 pod\u013ea hodnoty zru\u0161en\u00edm v\u00fdberu hodn\u00f4t, ktor\u00e9 nechcete, a ponechan\u00edm zv\u00fdraznen\u00fdch hodn\u00f4t, ktor\u00e9 chcete.<\/li><\/ul><\/li><li>Kliknut\u00edm na tla\u010didlo <strong>&#8220;OK&#8221; <\/strong>pou\u017eite filter a okam\u017eite sa v\u00e1m zobrazia \u00fadaje a aktualizuje sa graf alebo tabu\u013eka. Po\u010det filtrovan\u00fdch polo\u017eiek m\u00f4\u017eete vidie\u0165 aj na samotnom posuvn\u00edku.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako prisp\u00f4sobi\u0165 rozde\u013eova\u010d v aplik\u00e1cii Tabu\u013eky Google<\/strong><\/h2>\n\n\n\n<p>Ak chcete zmeni\u0165 sadu \u00fadajov, st\u013apec filtra alebo vzh\u013ead svojho rozde\u013eova\u010da, mus\u00edte postupova\u0165 pod\u013ea t\u00fdchto krokov:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Vyberte kr\u00e1ja\u010d a kliknite na ikonu <strong>&#8220;troch bodiek&#8221; <\/strong>v pravom hornom rohu.<\/li><li>Potom vyberte polo\u017eku <strong>&#8220;Upravi\u0165 kr\u00e1ja\u010d&#8221;<\/strong>.<\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"425\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-2.webp\" alt=\"\" class=\"wp-image-986\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-2.webp 653w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-2-300x195.webp 300w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>Otvor\u00ed sa bo\u010dn\u00fd panel <strong>&#8220;Slicer&#8221; s <\/strong>kartami <strong>&#8220;Data&#8221; <\/strong>a <strong>&#8220;Customize&#8221;.<\/strong><\/li><li>Pomocou karty <strong>&#8220;\u00dadaje&#8221; <\/strong>upravte rozsah \u00fadajov alebo pomocou rozba\u013eovacieho st\u013apca vyberte in\u00fd st\u013apec filtra.<\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"615\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-3.webp\" alt=\"\" class=\"wp-image-987\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-3.webp 471w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-3-230x300.webp 230w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>Pomocou karty <strong>&#8220;Prisp\u00f4sobi\u0165&#8221; <\/strong>m\u00f4\u017eete zmeni\u0165 z\u00e1hlavie, \u0161t\u00fdl p\u00edsma, ve\u013ekos\u0165, form\u00e1t alebo farbu a zmeni\u0165 farbu pozadia.<\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"957\" height=\"641\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-4.webp\" alt=\"\" class=\"wp-image-988\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-4.webp 957w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-4-300x201.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/07\/How-to-create-a-slicer-in-Google-Sheets-4-768x514.webp 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ak\u00e9 s\u00fa hlavn\u00e9 pojmy na pou\u017e\u00edvanie rezu v h\u00e1rkoch Google<\/strong><\/h2>\n\n\n\n<p>Na z\u00e1ver uv\u00e1dzame nieko\u013eko d\u00f4le\u017eit\u00fdch vec\u00ed, ktor\u00e9 je potrebn\u00e9 ma\u0165 na pam\u00e4ti pri pou\u017e\u00edvan\u00ed rezov v tabu\u013ek\u00e1ch Google:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Pl\u00e1tok m\u00f4\u017eete <strong>pripoji\u0165 k viac ako jednej <\/strong>tabu\u013eke, s\u00fahrnnej tabu\u013eke a\/alebo grafu.<\/li><li>Na filtrovanie pod\u013ea jedn\u00e9ho st\u013apca m\u00f4\u017eete ma\u0165 len <strong>jeden <\/strong>pl\u00e1tok.<\/li><li>Na filtrovanie toho ist\u00e9ho s\u00faboru \u00fadajov pod\u013ea r\u00f4znych st\u013apcov m\u00f4\u017eete <strong>pou\u017ei\u0165 viacero rezov.<\/strong><\/li><li>Tento rez sa vz\u0165ahuje na v\u0161etky tabu\u013eky a grafy na h\u00e1rku, pokia\u013e maj\u00fa rovnak\u00e9 z\u00e1kladn\u00e9 zdrojov\u00e9 \u00fadaje.<\/li><li>Rezy sa aplikuj\u00fa len na akt\u00edvny list.<\/li><li>Rezy sa nevz\u0165ahuj\u00fa na vzorce na h\u00e1rku.<\/li><\/ul>\n\n\n\n<p>To je v\u0161etko, \u010do potrebujete vedie\u0165 o pl\u00e1tkoch v tabu\u013ek\u00e1ch Google.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kr\u00e1ja\u010d je naozaj u\u017eito\u010dn\u00e1 funkcia h\u00e1rkov Google. Roz\u0161iruje mo\u017enosti kr\u00ed\u017eov\u00fdch tabuliek a s\u00fahrnn\u00fdch grafov v tabu\u013ek\u00e1ch Google. A pou\u017e\u00edvanie kr\u00e1ja\u010da je dos\u0165 jednoduch\u00e9. \u010co potrebujete na pou\u017e\u00edvanie kr\u00e1ja\u010da v h\u00e1rkoch Google Posuvn\u00edk je n\u00e1stroj tabu\u013ekov\u00e9ho procesora Google, ktor\u00fd v\u00e1m umo\u017e\u0148uje r\u00fdchlo a jednoducho filtrova\u0165 tabu\u013eky, tabu\u013ekov\u00e9 preh\u013eady a grafy kliknut\u00edm na tla\u010didlo. Vzn\u00e1\u0161aj\u00fa sa nad [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":989,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2],"tags":[115],"class_list":{"0":"post-983","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sprievodcovia","8":"tag-google-sheets"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/comments?post=983"}],"version-history":[{"count":1,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/983\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/983\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media\/989"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media?parent=983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/categories?post=983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/tags?post=983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}