{"id":2715,"date":"2022-11-02T23:13:20","date_gmt":"2022-11-02T23:13:20","guid":{"rendered":"https:\/\/global.tab-tv.com\/sk\/?p=2715"},"modified":"2022-11-02T23:13:22","modified_gmt":"2022-11-02T23:13:22","slug":"ako-obnovit-otocnu-tabulku-v-programe-microsoft-excel","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/sk\/ako-obnovit-otocnu-tabulku-v-programe-microsoft-excel\/","title":{"rendered":"Ako obnovi\u0165 oto\u010dn\u00fa tabu\u013eku v programe Microsoft Excel"},"content":{"rendered":"\n<p>Vedenie z\u00e1znamov je v dne\u0161nom svete pomerne jednoduch\u00e9. Na tento \u00fa\u010del boli vytvoren\u00e9 desiatky \u0161peci\u00e1lnych aplik\u00e1ci\u00ed. Medzi ne patr\u00ed aj Microsoft Excel. Jedn\u00fdm z praktick\u00fdch n\u00e1strojov tohto programu je vytv\u00e1ranie oto\u010dn\u00fdch tabuliek. Mnoh\u00ed pou\u017e\u00edvatelia v\u0161ak nevedia, \u017ee tak\u00e9to tabu\u013eky mo\u017eno z \u010dasu na \u010das aktualizova\u0165, tak\u017ee va\u0161e \u00fadaje zostan\u00fa v\u017edy aktu\u00e1lne.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>\u010co potrebujete na aktualiz\u00e1ciu pivotnej tabu\u013eky v programe Excel<\/strong><\/h1>\n\n\n\n<p>Kancel\u00e1rske a \u00fa\u010dtovn\u00edcke pr\u00e1ce sa v dne\u0161nom svete u\u017e d\u00e1vno presunuli do digit\u00e1lneho priestoru. Je celkom pohodln\u00e9, ke\u010f s\u00fa v\u0161etky potrebn\u00e9 inform\u00e1cie ulo\u017een\u00e9 v nieko\u013ek\u00fdch dokumentoch v po\u010d\u00edta\u010di a m\u00f4\u017eete s nimi naklada\u0165 pod\u013ea svojich potrieb.<\/p>\n\n\n\n<p>Na tento \u00fa\u010del bola vytvoren\u00e1 cel\u00e1 rada r\u00f4znych kancel\u00e1rskych aplik\u00e1ci\u00ed. Tak\u00e9to aplik\u00e1cie v\u00e1m v skuto\u010dnosti poskytuj\u00fa ve\u013emi \u0161irok\u00fa \u0161k\u00e1lu r\u00f4znych mo\u017enost\u00ed. Pomocou r\u00f4znych programov m\u00f4\u017eu pou\u017e\u00edvatelia vytv\u00e1ra\u0165 a upravova\u0165 textov\u00e9 dokumenty, vytv\u00e1ra\u0165 prezent\u00e1cie, uskuto\u010d\u0148ova\u0165 pracovn\u00e9 hovory a, samozrejme, vytv\u00e1ra\u0165 tabu\u013eky s \u00fadajmi.<\/p>\n\n\n\n<p>Microsoft Excel je program, ktor\u00fd pozn\u00e1 ka\u017ed\u00fd, kto aspo\u0148 raz v \u017eivote pracoval na po\u010d\u00edta\u010di s ak\u00fdmko\u013evek druhom kancel\u00e1rskej pr\u00e1ce. Tento program v\u00e1m pom\u00e1ha uklada\u0165, \u0161trukt\u00farova\u0165 a analyzova\u0165 \u00fadaje pomocou r\u00f4znych tabuliek.<\/p>\n\n\n\n<p>V s\u00fa\u010dasnosti existuje \u010doraz viac r\u00f4znych anal\u00f3gov programu Excel vr\u00e1tane online slu\u017eieb, ako s\u00fa napr\u00edklad tabu\u013eky Google. Microsoft Excel je v\u0161ak st\u00e1le najob\u013e\u00fabenej\u0161\u00edm programom na ukladanie \u00fadajov. Je to tak preto, \u017ee Excel m\u00e1 pomerne ve\u013ea praktick\u00fdch funkci\u00ed a flexibiln\u00e9 prisp\u00f4sobenie, ktor\u00e9 umo\u017e\u0148uje jeho pou\u017e\u00edvate\u013eom prisp\u00f4sobi\u0165 si tabu\u013eku \u00fadajov svojim individu\u00e1lnym potreb\u00e1m. To je pomerne pohodln\u00e9.<\/p>\n\n\n\n<p>Jednou z tak\u00fdchto funkci\u00ed, ktor\u00e1 sa pre v\u00e1s m\u00f4\u017ee sta\u0165 nepostr\u00e1date\u013enou, ak m\u00e1te nahromaden\u00fdch pr\u00edli\u0161 ve\u013ea z\u00e1znamov a potrebujete ich analyzova\u0165 a spr\u00e1vne \u0161trukt\u00farova\u0165, je mo\u017enos\u0165 vytvori\u0165 Pivot Table. Je to celkom praktick\u00e1 funkcia, ktor\u00e1 v\u00e1m m\u00f4\u017ee zjednodu\u0161i\u0165 pr\u00e1cu. Nie v\u0161etci pou\u017e\u00edvatelia v\u0161ak vedia, \u017ee tak\u00fato tabu\u013eku je potrebn\u00e9 z \u010dasu na \u010das obnovi\u0165, aby \u00fadaje v nej nestratili na aktu\u00e1lnosti. Obnovenie v\u00e1m v skuto\u010dnosti zaberie len nieko\u013eko min\u00fat.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Na\u010do potrebujete Pivot Table v programe Excel<\/strong><\/h2>\n\n\n\n<p>Mnoh\u00ed pou\u017e\u00edvatelia si v\u00f4bec neuvedomuj\u00fa mo\u017enosti oto\u010dnej tabu\u013eky a d\u00f4vody, pre\u010do by ju mohli potrebova\u0165. V skuto\u010dnosti je Pivot Table univerz\u00e1lnym n\u00e1strojom na spracovanie \u00fadajov. T\u00e1to tabu\u013eka je ur\u010den\u00e1 na sumariz\u00e1ciu \u00fadajov v in\u00fdch tabu\u013ek\u00e1ch.<\/p>\n\n\n\n<p>Tak\u00e1to tabu\u013eka m\u00f4\u017ee automaticky triedi\u0165, po\u010d\u00edta\u0165 alebo spriemerova\u0165 \u00fadaje z \u00fadajov, ktor\u00e9 s\u00fa zaznamenan\u00e9 v tabu\u013eke, ku ktorej je priraden\u00e1 Pivot Table. Tento n\u00e1stroj sa pou\u017e\u00edva najm\u00e4 na vizualiz\u00e1ciu \u00fadajov, napr\u00edklad na obchodn\u00fa anal\u00fdzu.<\/p>\n\n\n\n<p>V skuto\u010dnosti ide o samostatn\u00fa tabu\u013eku, ktor\u00e1 zobrazuje v\u00fdsledky naprogramovan\u00fdch algoritmov na spracovanie \u00fadajov z po\u017eadovanej tabu\u013eky. Tento n\u00e1stroj bude u\u017eito\u010dn\u00fd najm\u00e4 vtedy, ak potrebujete analyzova\u0165 ve\u013ek\u00e9 mno\u017estvo \u00fadajov.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>\u010co robi\u0165, ak chcete ru\u010dne obnovi\u0165 tabu\u013eku Pivot v programe Excel<\/strong><\/h2>\n\n\n\n<p>Ke\u010f\u017ee \u00fadaje v tabu\u013eke, s ktorou je Pivot Table prepojen\u00e1, sa m\u00f4\u017eu z \u010dasu na \u010das aktualizova\u0165, pou\u017e\u00edvatelia musia svoju Pivot Table z \u010dasu na \u010das obnovi\u0165. Urobi\u0165 to v programe Excel je v skuto\u010dnosti celkom jednoduch\u00e9. Aby ste mohli ru\u010dne obnovi\u0165 \u00fadaje v Pivot Table, mus\u00edte:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Otvorte aplik\u00e1ciu Excel a <strong>vyberte dokument, ktor\u00fd <\/strong>chcete upravi\u0165.<\/li><li>Potom mus\u00edte <strong>vybra\u0165 h\u00e1rok, <\/strong>na ktorom sa nach\u00e1dza va\u0161a tabu\u013eka.<\/li><li>Ak chcete aktualizova\u0165 \u00fadaje v tabu\u013eke, sta\u010d\u00ed <strong>na<\/strong> \u0148u <strong>klikn\u00fa\u0165 prav\u00fdm tla\u010didlom my\u0161i <\/strong>a vybra\u0165 polo\u017eku <strong>Obnovi\u0165<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"363\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel.webp\" alt=\"\" class=\"wp-image-2716\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-300x106.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-768x272.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>M\u00f4\u017eete to urobi\u0165 aj pomocou tla\u010didla <strong>PivotTable <\/strong>v hornej \u010dasti obrazovky.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"444\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2717\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1-300x130.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1-768x333.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Ke\u010f sa dostanete na <strong>panel \u00faprav pivotov\u00fdch tabuliek, <\/strong>mus\u00edte klikn\u00fa\u0165 na tla\u010didlo <strong>Obnovi\u0165 v\u0161etko <\/strong>alebo len <strong>Obnovi\u0165, <\/strong>ak chcete aktualizova\u0165 jednu konkr\u00e9tnu tabu\u013eku.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"435\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2.webp\" alt=\"\" class=\"wp-image-2718\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2-300x127.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2-768x326.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Ako vid\u00edte, aktualiz\u00e1cia pivotnej tabu\u013eky v aplik\u00e1cii Excel je pomerne jednoduch\u00e1 a nezaberie v\u00e1m ve\u013ea \u010dasu, len p\u00e1r kliknut\u00ed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako nastavi\u0165 automatick\u00e9 obnovenie pivotnej tabu\u013eky<\/strong><\/h2>\n\n\n\n<p>Okrem toho m\u00e1te v\u017edy mo\u017enos\u0165 nastavi\u0165 automatick\u00fa aktualiz\u00e1ciu pivotnej tabu\u013eky. To m\u00f4\u017ee by\u0165 ve\u013emi u\u017eito\u010dn\u00e9, ak sa va\u0161a hlavn\u00e1 tabu\u013eka neust\u00e1le aktualizuje r\u00f4znymi \u00fadajmi a vstupovanie do Pivot Table a jej aktualiz\u00e1cia zaka\u017ed\u00fdm po doplnen\u00ed tabu\u013eky m\u00f4\u017ee by\u0165 dos\u0165 ru\u0161iv\u00e9.<\/p>\n\n\n\n<p>V takom pr\u00edpade m\u00f4\u017eete pou\u017ei\u0165 tieto pokyny:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Najprv mus\u00edte <strong>otvori\u0165 dokument, v <\/strong>ktorom sa nach\u00e1dza <strong>oto\u010dn\u00e1 tabu\u013eka, a klikn\u00fa\u0165 na<\/strong> \u0148u.<\/li><li>Potom v hornom riadku \u00faprav mus\u00edte n\u00e1js\u0165 polo\u017eku <strong>PivotTable<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"435\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table.webp\" alt=\"\" class=\"wp-image-2719\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-300x127.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-768x326.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Potom vyberte polo\u017eku <strong>Nastavenia<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"417\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1.webp\" alt=\"\" class=\"wp-image-2720\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1-300x122.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1-768x313.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Tu je potrebn\u00e9 posun\u00fa\u0165 sa v zozname nadol a <strong>za\u010diarknu\u0165 <\/strong>pol\u00ed\u010dko <strong>Obnovi\u0165 \u00fadaje pri otvoren\u00ed s\u00faboru<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"483\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2.webp\" alt=\"\" class=\"wp-image-2721\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2.webp 1024w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2-300x142.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2-768x362.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To umo\u017en\u00ed, aby sa va\u0161a Pivot Table obnovila pri ka\u017edom otvoren\u00ed s\u00faboru. Takto m\u00f4\u017eete ma\u0165 svoje \u00fadaje v\u017edy aktu\u00e1lne.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vedenie z\u00e1znamov je v dne\u0161nom svete pomerne jednoduch\u00e9. Na tento \u00fa\u010del boli vytvoren\u00e9 desiatky \u0161peci\u00e1lnych aplik\u00e1ci\u00ed. Medzi ne patr\u00ed aj Microsoft Excel. Jedn\u00fdm z praktick\u00fdch n\u00e1strojov tohto programu je vytv\u00e1ranie oto\u010dn\u00fdch tabuliek. Mnoh\u00ed pou\u017e\u00edvatelia v\u0161ak nevedia, \u017ee tak\u00e9to tabu\u013eky mo\u017eno z \u010dasu na \u010das aktualizova\u0165, tak\u017ee va\u0161e \u00fadaje zostan\u00fa v\u017edy aktu\u00e1lne. \u010co potrebujete na aktualiz\u00e1ciu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2722,"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":[30],"class_list":{"0":"post-2715","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sprievodcovia","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/2715","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=2715"}],"version-history":[{"count":1,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/2715\/revisions"}],"predecessor-version":[{"id":2723,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/2715\/revisions\/2723"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media\/2722"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media?parent=2715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/categories?post=2715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/tags?post=2715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}