{"id":3336,"date":"2024-09-03T13:10:05","date_gmt":"2024-09-03T13:10:05","guid":{"rendered":"https:\/\/howtogeek.blog\/lt\/?p=3336"},"modified":"2024-09-03T13:10:05","modified_gmt":"2024-09-03T13:10:05","slug":"how-to-create-a-dashboard-in-excel-lt","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lt\/how-to-create-a-dashboard-in-excel-lt\/","title":{"rendered":"Kaip sukurti informacijos suvestin\u0119 \u201eExcel\u201c."},"content":{"rendered":"<p>Jei j\u016bs\u0173 \u201eExcel\u201c lapuose yra daug duomen\u0173, galite sukurti interaktyvi\u0105 prietais\u0173 skydel\u012f, leid\u017eiant\u012f lengvai tvarkyti tuos duomenis. Prietais\u0173 skydelyje apibendrinama pagrindin\u0117 informacija, kad gal\u0117tum\u0117te greitai gauti reikiam\u0105 informacij\u0105. Pirmiausia turite nuspr\u0119sti, koki\u0105 informacij\u0105 norite rodyti prietais\u0173 skydelyje. Per\u017ei\u016br\u0117kite savo duomenis ir nuspr\u0119skite, k\u0105 \u012ftraukti \u012f prietais\u0173 skydel\u012f ir kaip t\u0105 informacij\u0105 rodyti. Galite pasirinkti pavaizduoti j\u012f kaip linijines diagramas, skritulines diagramas, ta\u0161kines diagramas ar k\u0105 nors kita.<\/p>\n<p>Kai nuspr\u0119site, kokius duomenis \u012ftraukti ir kaip juos rodyti prietais\u0173 skydelyje, laikas juos paruo\u0161ti. Paruo\u0161\u0119 savo duomenis prietais\u0173 skydeliui, gal\u0117site lengviau nustatyti prietais\u0173 skydel\u012f, u\u017etikrinti skland\u0173 jos veikim\u0105 ir sutaupyti daug laiko. \u012esitikinkite, kad kiekvienas darbaknyg\u0117s lapas, i\u0161 kurio naudosite duomenis kurdami prietais\u0173 skydel\u012f, turi atskir\u0105 pavadinim\u0105.<\/p>\n<h2 id=\"step-1-import-the-data-into-excel\">1 veiksmas: importuokite duomenis \u012f \u201eExcel\u201c.<\/h2>\n<p>Galite i\u0161 karto prad\u0117ti kurti prietais\u0173 skydel\u012f, jei j\u016bs\u0173 duomenys jau yra programoje \u201eExcel\u201c. Jei ne, pirmiausia tur\u0117site j\u012f importuoti \u012f program\u0105. Tai galite padaryti \u012fvairiais b\u016bdais, pvz., nukopijuoti ir \u012fklijuoti \u012f \u201eExcel\u201c darbaknyg\u0119, naudodami API, pvz., \u201eOpen Database Connectivity\u201c (ODBC) arba \u201eSupermetrics\u201c, arba pried\u0105, pvz., \u201eMicrosoft Power Query\u201c. Ta\u010diau papras\u010diausias b\u016bdas yra tiesiog naudoti parinkt\u012f \u201eGauti duomenis\u201c.<\/p>\n<ul>\n<li>Atidarykite tu\u0161\u010di\u0105 \u201eExcel\u201c lap\u0105 ir spustel\u0117kite vir\u0161uje esant\u012f skirtuk\u0105 \u201eDuomenys\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"484\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-14-27-40-1.webp\" title=\"\" width=\"861\"\/><\/figure>\n<ul>\n<li>Kai b\u016bsite skirtuke Duomenys, spustel\u0117kite kair\u0117je esan\u010di\u0105 parinkt\u012f \u201eGauti duomenis\u201c, tada eikite \u012f \u201eI\u0161 failo\u201c, tada spustel\u0117kite \u201eI\u0161 Excel darbaknyg\u0117s\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"528\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-14-27-400-1.webp\" title=\"\" width=\"939\"\/><\/figure>\n<ul>\n<li>Tada eikite \u012f norim\u0173 importuoti duomen\u0173 viet\u0105 ir pasirinkite juos. Palaukite, kol \u201eExcel\u201c importuos duomenis ir paruo\u0161 juos naudoti.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"465\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-15-02-03-1.webp\" title=\"\" width=\"827\"\/><\/figure>\n<h2 id=\"step-2-set-up-your-workbook\">2 veiksmas: nustatykite darbaknyg\u0119<\/h2>\n<ul>\n<li>Atidarykite nauj\u0105 \u201eExcel\u201c darbaknyg\u0119 ir sukurkite bent du skirtukus arba darbalapius. Pavyzd\u017eiui, sukurkite tris skirtukus ir pavadinkite juos \u201eNeapdoroti duomenys\u201c, \u201eDiagramos duomenys\u201c ir \u201eInformacijos suvestin\u0117\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"448\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-15-10-16-1.webp\" title=\"\" width=\"796\"\/><\/figure>\n<ul>\n<li>Neapdoroti duomenys darbaknyg\u0117je tur\u0117t\u0173 b\u016bti \u201eExcel\u201c lentel\u0117s forma su \u012fvairiais duomen\u0173 ta\u0161kais skirtinguose langeliuose. \u0160is procesas da\u017enai vadinamas \u201eduomen\u0173 valymu\u201c, tod\u0117l galite pasinaudoti \u0161ia galimybe, kad surastum\u0117te ir pa\u0161alintum\u0117te visas galimas klaidas.<\/li>\n<li>Kai i\u0161valysite duomenis, laikas juos analizuoti. I\u0161studijuokite duomenis ir nuspr\u0119skite, k\u0105 norite \u012ftraukti \u012f \u201eExcel\u201c prietais\u0173 skydel\u012f.<\/li>\n<li>Nor\u0117dami prid\u0117ti reikiamus duomen\u0173 ta\u0161kus \u012f darbalap\u012f \u201eDiagramos duomenys\u201c, nukopijuokite juos ir \u012fklijuokite \u012f darbalap\u012f.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"466\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-12-1.webp\" title=\"\" width=\"828\"\/><\/figure>\n<h2 id=\"step-3-create-your-dashboard\">3 veiksmas: sukurkite savo prietais\u0173 skydel\u012f<\/h2>\n<p>Paruo\u0161\u0119 duomenis \u201eExcel\u201c darbalapyje ir apsisprend\u0119 d\u0117l prietais\u0173 skydelio tikslo, laikas j\u012f sukurti. \u0160iuo metu jau tur\u0117jote nustatyti, kaip norite, kad duomenys b\u016bt\u0173 rodomi vizualiai, kaip skritulin\u0117 diagrama, sukamoji diagrama, juostin\u0117 diagrama ir kt. Prad\u0117kime nuo sugrupuotos stulpeli\u0173 diagramos.<\/p>\n<ul>\n<li>Spustel\u0117kite \u201eExcel\u201c darbaknyg\u0117s apa\u010dioje esant\u012f darbalap\u012f \u201eprietais\u0173 skydelis\u201c, kad \u012f j\u012f perjungtum\u0117te.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-13-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Atsid\u016br\u0119 \u201eprietais\u0173 skydelio\u201c darbalapyje spustel\u0117kite vir\u0161uje esant\u012f meniu \u201e\u012eterpti\u201c, tada spustel\u0117kite i\u0161skleid\u017eiam\u0105j\u012f mygtuk\u0105 \u0161alia piktogramos \u201estulpeliai\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-46-52-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Pasirod\u017eiusiame i\u0161skleid\u017eiamajame meniu spustel\u0117kite piktogram\u0105 \u201esugrupuoti stulpeliai\u201c. Piktogramos gali b\u016bti rodomos kitaip, jei naudojate senesn\u0119 \u201eExcel\u201c versij\u0105.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-46-52-2-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Dabar prietais\u0173 skydelio darbalapyje tur\u0117t\u0173 b\u016bti rodomas tu\u0161\u010dias laukelis. De\u0161iniuoju pel\u0117s mygtuku spustel\u0117kite j\u012f, tada spustel\u0117kite \u201ePasirinkti duomenis\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"494\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-51-01-1.webp\" title=\"\" width=\"878\"\/><\/figure>\n<ul>\n<li>Tada spustel\u0117kite apa\u010dioje esant\u012f skirtuk\u0105 \u201eDiagramos duomenys\u201c ir pasirinkite duomenis, kuriuos norite \u012ftraukti \u012f prietais\u0173 skydel\u012f. Nesirinkite antra\u0161ti\u0173, kai pasirenkate duomenis, kurie turi b\u016bti \u012ftraukti \u012f stulpeli\u0173 diagram\u0105.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"491\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-56-25-1.webp\" title=\"\" width=\"872\"\/><\/figure>\n<ul>\n<li>Paspauskite Enter ir prie\u0161 jus tur\u0117t\u0173 pasirodyti sugrupuotos stulpeli\u0173 diagramos prietais\u0173 skydelis.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"457\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-01-11-1.webp\" title=\"\" width=\"812\"\/><\/figure>\n<ul>\n<li>Galite redaguoti diagram\u0105 dar kart\u0105 spustel\u0117dami j\u0105 de\u0161iniuoju pel\u0117s mygtuku ir spustel\u0117dami parinkt\u012f \u201ePasirinkti duomenis\u201c, kaip anks\u010diau.<\/li>\n<li>Bus atidarytas dialogo langas \u201ePasirinkti duomen\u0173 \u0161altin\u012f\u201c. Prie\u0161 pasirinkdami duomenis, kuriuos norite rodyti, skiltyje \u201eHorizontalios (kategorijos) a\u0161ies etiket\u0117s\u201c \u200b\u200bspustel\u0117kite mygtuk\u0105 Redaguoti.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"439\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-09-33-1.webp\" title=\"\" width=\"781\"\/><\/figure>\n<ul>\n<li>Taip pat diagramai galite suteikti pavadinim\u0105. Tiesiog dukart spustel\u0117kite diagramos vir\u0161uje, kur para\u0161yta \u201ediagramos pavadinimas\u201c, ir \u012fveskite pavadinim\u0105, kur\u012f norite naudoti.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"498\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-12-41-1.webp\" title=\"\" width=\"885\"\/><\/figure>\n<h3 id=\"things-to-know\">K\u0105 reikia \u017einoti<\/h3>\n<ul>\n<li>Priklausomai nuo to, kuri\u0105 Microsoft Office versij\u0105 naudojate, skirtinguose meniu ir skirtukuose gali b\u016bti \u012fvairi\u0173 parink\u010di\u0173, pvz., valdan\u010di\u0173 diagramos dizain\u0105.<\/li>\n<li>Kad prietais\u0173 skydelis b\u016bt\u0173 efektyviausias, b\u016btinai naudokite nuoseklias spalv\u0173 schemas, \u0161rift\u0173 stilius ir formatavim\u0105.<\/li>\n<li>Jei norite, kad prietais\u0173 skydelis automati\u0161kai atspind\u0117t\u0173 duomen\u0173 poky\u010dius, kurdami prietais\u0173 skydel\u012f galite pasirinkti dinamin\u0119 diagram\u0105.<\/li>\n<li>Suk\u016br\u0119 prietais\u0173 skydel\u012f, prid\u0117kite etiketes ir komentarus prie skirting\u0173 element\u0173, kad b\u016bt\u0173 lengva perduoti informacij\u0105 \u017ei\u016brovams.<\/li>\n<li>Taip pat galite prid\u0117ti element\u0173, pvz., mygtuk\u0173, filtr\u0173 ir i\u0161skleid\u017eiam\u0173j\u0173 meniu, kad prietais\u0173 skydelis b\u016bt\u0173 interaktyvus ir pritaikomas.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Jei j\u016bs\u0173 \u201eExcel\u201c lapuose yra daug duomen\u0173, galite sukurti interaktyvi\u0105 prietais\u0173 skydel\u012f, leid\u017eiant\u012f lengvai tvarkyti tuos duomenis. Prietais\u0173 skydelyje apibendrinama pagrindin\u0117 informacija, kad gal\u0117tum\u0117te greitai gauti reikiam\u0105 informacij\u0105. Pirmiausia turite nuspr\u0119sti, koki\u0105 informacij\u0105 norite rodyti prietais\u0173 skydelyje. Per\u017ei\u016br\u0117kite savo duomenis ir nuspr\u0119skite, k\u0105 \u012ftraukti \u012f prietais\u0173 skydel\u012f ir kaip t\u0105 informacij\u0105 rodyti. Galite pasirinkti pavaizduoti [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[56,123,282],"class_list":["post-3336","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/3336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/comments?post=3336"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/3336\/revisions"}],"predecessor-version":[{"id":3337,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/3336\/revisions\/3337"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/media?parent=3336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/categories?post=3336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/tags?post=3336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}