{"id":2750,"date":"2022-11-02T23:08:33","date_gmt":"2022-11-02T23:08:33","guid":{"rendered":"https:\/\/global.tab-tv.com\/ro\/?p=2750"},"modified":"2022-11-02T23:08:34","modified_gmt":"2022-11-02T23:08:34","slug":"cum-sa-reimprospatati-un-tabel-pivot-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/ro\/cum-sa-reimprospatati-un-tabel-pivot-in-microsoft-excel\/","title":{"rendered":"Cum s\u0103 re\u00eemprosp\u0103ta\u021bi un tabel pivot \u00een Microsoft Excel"},"content":{"rendered":"\n<p>\u00cen lumea de ast\u0103zi, \u021binerea eviden\u021belor a devenit destul de simpl\u0103. Zeci de aplica\u021bii speciale au fost create \u00een acest scop. Printre acestea se num\u0103r\u0103 \u0219i Microsoft Excel. Unul dintre instrumentele convenabile ale acestui program este crearea de tabele pivot. Cu toate acestea, mul\u021bi utilizatori nu \u0219tiu c\u0103 astfel de tabele pot fi actualizate din c\u00e2nd \u00een c\u00e2nd, astfel \u00eenc\u00e2t datele dvs. s\u0103 r\u0103m\u00e2n\u0103 mereu la zi.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>De ce ave\u021bi nevoie pentru a actualiza un tabel pivot \u00een Excel<\/strong><\/h1>\n\n\n\n<p>\u00cen lumea de ast\u0103zi, munca de birou \u0219i de contabilitate s-a mutat de mult timp \u00een spa\u021biul digital. Este destul de convenabil atunci c\u00e2nd toate informa\u021biile de care ave\u021bi nevoie sunt stocate \u00een mai multe documente pe PC-ul dumneavoastr\u0103 \u0219i le pute\u021bi gestiona dup\u0103 cum dori\u021bi.<\/p>\n\n\n\n<p>\u00cen acest scop, au fost create o mul\u021bime de aplica\u021bii de birou diferite. De fapt, astfel de aplica\u021bii v\u0103 ofer\u0103 o gam\u0103 foarte larg\u0103 de posibilit\u0103\u021bi diferite. Cu ajutorul diferitelor programe, utilizatorii pot crea \u0219i edita documente de text, pot face prezent\u0103ri, pot efectua apeluri de lucru \u0219i, bine\u00een\u021beles, pot crea foi de calcul cu date.<\/p>\n\n\n\n<p>Microsoft Excel este un program cunoscut tuturor celor care au f\u0103cut cel pu\u021bin o dat\u0103 \u00een via\u021b\u0103 munc\u0103 de birou pe calculator. Acest program v\u0103 ajut\u0103 s\u0103 salva\u021bi, s\u0103 structura\u021bi \u0219i s\u0103 analiza\u021bi datele cu ajutorul diferitelor tabele.<\/p>\n\n\n\n<p>\u00cen prezent, exist\u0103 din ce \u00een ce mai multe analogii diferite ale Excel, inclusiv servicii online, cum ar fi Google Sheets. Cu toate acestea, Microsoft Excel este \u00een continuare cel mai popular program pentru stocarea datelor. Acest lucru se datoreaz\u0103 faptului c\u0103 Excel are destul de multe func\u021bii la \u00eendem\u00e2n\u0103 \u0219i o personalizare flexibil\u0103 care le permite utilizatorilor s\u0103i s\u0103 personalizeze tabelul de date \u00een func\u021bie de nevoile lor individuale. Acest lucru este destul de convenabil.<\/p>\n\n\n\n<p>O astfel de caracteristic\u0103 care v\u0103 poate deveni indispensabil\u0103 dac\u0103 ave\u021bi prea multe \u00eenregistr\u0103ri \u00eengr\u0103m\u0103dite \u0219i trebuie s\u0103 le analiza\u021bi \u0219i s\u0103 le structura\u021bi \u00een mod corespunz\u0103tor este capacitatea de a crea un tabel pivot. Este o caracteristic\u0103 destul de util\u0103 care v\u0103 poate simplifica munca. Cu toate acestea, nu to\u021bi utilizatorii \u0219tiu c\u0103 un astfel de tabel trebuie s\u0103 fie actualizat din c\u00e2nd \u00een c\u00e2nd, pentru a nu pierde relevan\u021ba datelor din el. De fapt, re\u00eemprosp\u0103tarea v\u0103 ia doar c\u00e2teva minute pentru a o face.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>De ce ave\u021bi nevoie de un tabel pivot \u00een Excel<\/strong><\/h2>\n\n\n\n<p>Mul\u021bi utilizatori nu sunt deloc con\u0219tien\u021bi de capacit\u0103\u021bile unui tabel pivot \u0219i de ce ar putea avea nevoie de el. De fapt, Pivot Table este un instrument universal pentru prelucrarea datelor. Acest tabel este conceput pentru a rezuma datele din alte tabele.<\/p>\n\n\n\n<p>Un astfel de tabel poate sorta, calcula sau calcula automat media datelor din datele \u00eenregistrate \u00een tabelul c\u0103ruia \u00eei este atribuit tabelul pivot. Acest instrument este utilizat \u00een principal pentru vizualizarea datelor, cum ar fi analiza de afaceri.<\/p>\n\n\n\n<p>De fapt, este un tabel separat care afi\u0219eaz\u0103 rezultatele algoritmilor pre-programa\u021bi pentru a procesa datele din tabelul dorit. Acest instrument va fi deosebit de util dac\u0103 trebuie s\u0103 analiza\u021bi o cantitate mare de date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ce trebuie s\u0103 face\u021bi pentru a re\u00eemprosp\u0103ta manual tabelul pivotant \u00een Excel<\/strong><\/h2>\n\n\n\n<p>Deoarece datele din tabelul la care este legat tabelul pivot se pot actualiza din c\u00e2nd \u00een c\u00e2nd, utilizatorii trebuie s\u0103 re\u00eemprosp\u0103teze tabelul pivot din c\u00e2nd \u00een c\u00e2nd. A face acest lucru \u00een Excel este, de fapt, destul de u\u0219or. Pentru a re\u00eemprosp\u0103ta manual datele din Tabelul pivotant, trebuie s\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Deschide\u021bi Excel \u0219i <strong>selecta\u021bi documentul pe care <\/strong>dori\u021bi s\u0103 \u00eel edita\u021bi.<\/li><li>Dup\u0103 aceea, trebuie s\u0103 <strong>selecta\u021bi foaia \u00een care se <\/strong>afl\u0103 tabelul dumneavoastr\u0103.<\/li><li>Pentru a actualiza datele din tabel, trebuie doar s\u0103 <strong>face\u021bi clic dreapta <\/strong>pe el \u0219i s\u0103 selecta\u021bi <strong>Actualizare<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel.webp\" alt=\"\" class=\"wp-image-2751\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-300x106.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Pute\u021bi face acest lucru \u0219i cu ajutorul butonului <strong>PivotTable din partea de <\/strong>sus a ecranului.<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1.webp\" alt=\"\" class=\"wp-image-2752\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-1-300x130.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Atunci c\u00e2nd ajunge\u021bi la <strong>panoul de editare a tabelelor pivotante, <\/strong>trebuie s\u0103 face\u021bi clic pe <strong>Refresh All (Re\u00eemprosp\u0103tarea tuturor) <\/strong>sau doar pe <strong>Refresh (Re\u00eemprosp\u0103tarea) pentru a <\/strong>actualiza un anumit tabel.<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2.webp\" alt=\"\" class=\"wp-image-2753\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/What-to-do-to-manually-refresh-the-Pivot-Table-in-Excel-2-300x127.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Dup\u0103 cum pute\u021bi vedea, actualizarea unui tabel pivot \u00een Excel este destul de simpl\u0103 \u0219i nu v\u0103 va lua mult timp s\u0103 o face\u021bi, doar c\u00e2teva clicuri.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Cum se configureaz\u0103 re\u00eemprosp\u0103tarea automat\u0103 a unui tabel pivot<\/strong><\/h2>\n\n\n\n<p>\u00cen plus, ave\u021bi \u00eentotdeauna op\u021biunea de a seta tabelul pivotant s\u0103 se actualizeze automat. Acest lucru poate fi foarte util \u00een cazul \u00een care tabelul principal este actualizat \u00een mod constant cu date diferite, iar faptul de a intra \u0219i de a actualiza tabelul pivotant de fiecare dat\u0103 dup\u0103 ad\u0103ugarea la tabel poate fi destul de deranjant.<\/p>\n\n\n\n<p>\u00cen acest caz, pute\u021bi utiliza aceste instruc\u021biuni:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u00cen primul r\u00e2nd, trebuie s\u0103 <strong>deschide\u021bi documentul \u00een care se afl\u0103 tabelul pivotant <\/strong>\u0219i s\u0103 <strong>face\u021bi clic pe <\/strong>acesta.<\/li><li>Dup\u0103 aceea, \u00een linia de editare de sus, trebuie s\u0103 g\u0103si\u021bi elementul <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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table.webp\" alt=\"\" class=\"wp-image-2754\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-300x127.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Selecta\u021bi apoi elementul <strong>Settings (Set\u0103ri).<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1.webp\" alt=\"\" class=\"wp-image-2755\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-1-300x122.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Aici trebuie s\u0103 parcurge\u021bi lista \u0219i s\u0103 bifa\u021bi caseta de selectare <strong>Refresh data on the file open (Actualizare date la deschiderea fi\u0219ierului).<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2.webp\" alt=\"\" class=\"wp-image-2756\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2.webp 1024w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/11\/How-to-set-up-auto-refresh-of-a-Pivot-Table-2-300x142.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Acest lucru va permite tabloului pivotant s\u0103 se re\u00eemprosp\u0103teze de fiecare dat\u0103 c\u00e2nd fi\u0219ierul este deschis. \u00cen acest fel, v\u0103 pute\u021bi p\u0103stra \u00eentotdeauna datele actualizate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00cen lumea de ast\u0103zi, \u021binerea eviden\u021belor a devenit destul de simpl\u0103. Zeci de aplica\u021bii speciale au fost create \u00een acest scop. Printre acestea se num\u0103r\u0103 \u0219i Microsoft Excel. Unul dintre instrumentele convenabile ale acestui program este crearea de tabele pivot. Cu toate acestea, mul\u021bi utilizatori nu \u0219tiu c\u0103 astfel de tabele pot fi actualizate din [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2757,"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":[29],"class_list":{"0":"post-2750","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ghiduri","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/2750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/comments?post=2750"}],"version-history":[{"count":1,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/2750\/revisions"}],"predecessor-version":[{"id":2758,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/2750\/revisions\/2758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/media\/2757"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/media?parent=2750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/categories?post=2750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/tags?post=2750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}