{"id":3652,"date":"2022-12-01T22:40:17","date_gmt":"2022-12-01T21:40:17","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3652"},"modified":"2022-12-06T11:52:28","modified_gmt":"2022-12-06T10:52:28","slug":"excel-dashboard","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","title":{"rendered":"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sadr\u017eaj<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Izrada_Excel_Dashboard_kontrolne_table\" >Izrada Excel (Dashboard) kontrolne table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Izvor_podataka_za_prikazivanje_na_kontrolnoj_tabli\" >Izvor podataka za prikazivanje na kontrolnoj tabli<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Auditorijum_%E2%80%93_kome_je_namenjena_kontrolna_tabla\" >Auditorijum &#8211; kome je namenjena kontrolna tabla<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Vrsta_informacija_po_vaznosti_koje_prikazujete\" >Vrsta informacija po va\u017enosti koje\u00a0prikazujete<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Pojednostavite_prikaz_svega_posebno_brojeva_u_redu_velicina_hilj_mil_mlrd\" >Pojednostavite prikaz svega, posebno brojeva u redu veli\u010dina, hilj. mil. mlrd;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#_Grupisite_informacije\" >\u00a0Grupi\u0161ite informacije<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Izbegavajte_dekorativne_elemente_%E2%80%93_neopterecujte_ekran_sa_nepotrebnim_stvarima\" >Izbegavajte dekorativne elemente &#8211; neoptere\u0107ujte ekran sa nepotrebnim stvarima;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Koristite_crvenu_i_zelenu_boju_da_auditorijum_zna_da_li_je_u_redu_ili_ne\" >Koristite crvenu i zelenu boju da auditorijum zna da li je u redu ili ne.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Najbol%D1%98e_prakse_za_dizajn_kontrolne_table\" >Najbol\u0458e prakse za dizajn kontrolne table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Odredite_svrhu_kontrolne_table\" >Odredite svrhu kontrolne table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Jednostavan_oblik\" >Jednostavan oblik<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Doslednost_%E2%80%93_tipsko_resenje\" >Doslednost &#8211; tipsko re\u0161enje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Blizina\" >Blizina<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Uskladivanje\" >Uskla\u0111ivanje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Razmak\" >Razmak<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Boja\" >Boja<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Fontovi\" >Fontovi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Formati_brojeva\" >Formati brojeva<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Etikete\" >Etikete<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Personalizacija_i_prilagodavanje\" >Personalizacija i prilago\u0111avanje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Tabele_ili_liste_podataka\" >Tabele ili liste podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Da_sumiram\" >Da sumiram<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#EXCEL_DASHBOARD_CONTROL_PANEL_INSTRUCTIONS_AND_SAMPLE_FILES\" >EXCEL (DASHBOARD) CONTROL PANEL INSTRUCTIONS AND SAMPLE FILES<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Creating_an_Excel_Dashboard_control_panel\" >Creating an Excel (Dashboard) control panel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Best_practices_for_dashboard_design\" >Best practices for dashboard design<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Determine_the_purpose_of_the_dashboard\" >Determine the purpose of the dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Simple_shape\" >Simple shape<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Consistency_%E2%80%93_type_solution\" >Consistency &#8211; type solution<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Vicinity\" >Vicinity<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Harmonization\" >Harmonization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Space\" >Space<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Color\" >Color<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Fontovi-2\" >Fontovi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Number_formats\" >Number formats<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Labels\" >Labels<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Personalization_and_customization\" >Personalization and customization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#Tables_or_lists_of_data\" >Tables or lists of data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#They_disappeared\" >They disappeared<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\nExcel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju. Svakako ne treba zaboraviti definiciju: &#8220;Kontrolna tabla je vizuelni prikaz najva\u017enijih informacija potrebnih da se postigne cilj ili ciljevi. Objedinjene i organizovane na jedan ekran za jedan pogled.&#8221; ako \u017eelite dublje da se pozabavite ovom temom uradite to od <a href=\"https:\/\/www.amazon.com\/Stephen-Few\/e\/B001H6IQ5M\">Stephen Few<\/a> oca kontrolne table.<\/p>\n<p>Sada ve\u0107 moram re\u0107i da u &#8220;beskona\u010dnom&#8221; moru veb sajtova mo\u017eete prona\u0107i isto toliko pametnih saveta kako napraviti dobru Excel komandnu tablu. Dosta tog sadr\u017eaja manje ili vi\u0161e navodi osnovne principe. Kojih se treba dr\u017eati prilikom kreiranja kontrolne table. Zato \u0107u ovde navesti one elemente koji su dovoljni da izradite korisnu kontrolnu tablu.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Izrada_Excel_Dashboard_kontrolne_table\"><\/span>Izrada Excel (Dashboard) kontrolne table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Mnogo va\u017enije od dizajna je da vam kontrolna tabla slu\u017ei svrsi, pru\u017ea informacije ili da omogu\u0107i analizu ili pronala\u017eenje neke pojave, doga\u0111aja ili druge me\u0111uzavisnosti u podacima. Zato uvek imajte na umu:<\/p>\n<ol>\n<li><strong>Izvor podataka<\/strong> &#8211; koji su promenljivi u vremenu;<\/li>\n<li><strong>Auditorijum<\/strong> &#8211; kome je namenjena;<\/li>\n<li>Koje <strong>va\u017ene informacije<\/strong> prikazujete, a koje po\u017eeljne;<\/li>\n<li><strong>Pojednostavite prikaz<\/strong> svega, posebno brojeva u redu veli\u010dina, hilj. mil. mlrd;<\/li>\n<li>\u00a0<strong>Grupi\u0161ite<\/strong> informacije;<\/li>\n<li><strong>Izbegavajte dekorativne elemente<\/strong> &#8211; neoptere\u0107ujte ekran sa nepotrebnim stvarima;<\/li>\n<li>Koristite <strong>crvenu i zelenu boju<\/strong> da auditorijum zna da li je u redu ili ne.<\/li>\n<\/ol>\n<p>Sada \u0107emo se pozabaviti ovim elementima.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Izvor_podataka_za_prikazivanje_na_kontrolnoj_tabli\"><\/span>Izvor podataka za prikazivanje na kontrolnoj tabli<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kontrolna tabla bi trebala biti neka vrsta &#8220;\u017eive&#8221; veze (online) sa izvorom podataka. Najbolje je sve pokazati izradom kontrolne table prodaje. Prvo, izvor podataka je baza podataka ili izve\u017eeni izve\u0161taj u nekom od tabelarnih formata kao \u0161to je CSV, TXT, MDB, DB, XLSX, itd, formata u kojima se ta\u010dno zna \u0161ta se u kojoj koloni nalazi. Tim pitanjima kako preuzeti i povezati podatke iz baza podataka, razli\u010ditih tabela i evidencija bavimo se na ovom sajtu u \u010dlancima:<\/p>\n<ol>\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/\">U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel<\/a><\/li>\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/\">Prevla\u010denje-u\u010ditavanje-importovanje podataka iz datoteka formata TXT u Excel\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/\">Istorija Power Query &#8211; Za\u0161to nam je potreban PowerQuery?<\/a><\/li>\n<li><a href=\"https:\/\/kalkulacija.com\/wordpress\/preuzimanje-dnevnih-izvoda-banke\/\">Preuzimanje dnevnih izvoda banke<\/a>, itd.<\/li>\n<\/ol>\n<p>Uzmimo za primer da periodi\u010dno, dnevno, nedeljno, mese\u010dno itd. pratimo rezultate poslovanja komercijalnog sektora na\u0161e firme, na osnovu kojih \u0107emo ispla\u0107ivati bonuse trgovcima. Ako ste rukovodilac koji ostvaruje varijabilni deo plate ili prima bonuse za dobre poslovne rezultate, najmanje su vam potrebni podaci o koli\u010dinama, ugovorenim, isporu\u010denim ili napla\u0107enim iznosima, gde i kako ste ostvarili taj rezultat, zna\u010di u kojem prodajnom objektu, preko kog prodajnog kanala, u kom mestu, gradu, regionu, za koju grupu proizvoda itd.<\/p>\n<figure id=\"attachment_3678\" aria-describedby=\"caption-attachment-3678\" style=\"width: 1047px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3678\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/12\/kt01.png\" alt=\"Izvor podataka za kontrolnu tablu\" width=\"1047\" height=\"324\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/12\/kt01.png 1047w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/12\/kt01-300x93.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/12\/kt01-1024x317.png 1024w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/12\/kt01-768x238.png 768w\" sizes=\"auto, (max-width: 1047px) 100vw, 1047px\" \/><figcaption id=\"caption-attachment-3678\" class=\"wp-caption-text\">Izvor podataka za kontrolnu tablu<\/figcaption><\/figure>\n<p>Tabela sadr\u017ei: redni broj ra\u010duna, datum kada je izra\u0111en, prioritet isporuke, grad, okrug, region, segment portfolia, kategorija robe, podkategorija, iznos, koli\u010dina&#8230;..<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Auditorijum_%E2%80%93_kome_je_namenjena_kontrolna_tabla\"><\/span>Auditorijum &#8211; kome je namenjena kontrolna tabla<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>U ovom slu\u010daju na\u0161 auditorijum je rukovodstvo firme na svim nivoima. Pored organizacione uloge neophodno je imati saznanje koliko su &#8220;ra\u010dunarski pismeni&#8221; koliko poznaju excel funkcionalnosti kako bi im obezbedili interaktivne funkcionalnosti na kontrolnoj tabli. Isto tako morate dogovoriti nivo funkcionalnosti, koje informacije o\u010dekuju da prona\u0111u na kontrolnoj tabli itd.<\/p>\n<p>Ako smo re\u0161ili da izradimo kontrolnu tablu prodaje za \u0161efa komercijale, glavna merna jedinica se izra\u017eava u iznosu novca, prometu, fakturisanom iznosu, napla\u0107enom iznosu itd.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vrsta_informacija_po_vaznosti_koje_prikazujete\"><\/span><strong>Vrsta informacija po va\u017enosti koje<\/strong>\u00a0prikazujete<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Interesuje nas prodaja po regionima, po vrsti i podvrsti robe, najmanji i najve\u0107i iznosi, kakva su kretanja u odnosu na prethodni izve\u0161tajni period, potrebni su nam podaci o koli\u010dinama, ugovorenim, isporu\u010denim ili napla\u0107enim iznosima, gde i kako ste ostvarili taj rezultat, zna\u010di u kojem prodajnom objektu, preko kog prodajnog kanala, u kom mestu, gradu, regionu, za koju grupu proizvoda itd.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Pojednostavite_prikaz_svega_posebno_brojeva_u_redu_velicina_hilj_mil_mlrd\"><\/span><strong>Pojednostavite prikaz<\/strong> svega, posebno brojeva u redu veli\u010dina, hilj. mil. mlrd;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kako \u0107e te promeniti prikaz brojeva u Excelu bez izmene apsolutnih vrednosti mo\u017eete pogledati u \u010dlanku <a href=\"https:\/\/kalkulacija.com\/wordpress\/cifre-u-hiljadama-milionima\/\">Cifre u hiljadama i milionima<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"_Grupisite_informacije\"><\/span>\u00a0<strong>Grupi\u0161ite<\/strong> informacije<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ima\u0107emo tri grupe podataka i to: prema lokaciji, region, grad, itd, druga grupa podataka prema vrsti, podvrsti portfoliju, robe koja se prodaje, a tre\u0107a vrsta mo\u017ee biti rok pla\u0107anja od strane na\u0161ih kupaca, itd.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Izbegavajte_dekorativne_elemente_%E2%80%93_neopterecujte_ekran_sa_nepotrebnim_stvarima\"><\/span><strong>Izbegavajte dekorativne elemente<\/strong> &#8211; neoptere\u0107ujte ekran sa nepotrebnim stvarima;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Koristite_crvenu_i_zelenu_boju_da_auditorijum_zna_da_li_je_u_redu_ili_ne\"><\/span>Koristite <strong>crvenu i zelenu boju<\/strong> da auditorijum zna da li je u redu ili ne.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kada govorimo o bojenju kontrolne table, nezaobilazna je crvena i zelena boja kao indikator da li je neka vrednost ispravna ili nije. Kako koristiti automatizovano ili Uslovno bojenje sadr\u017eaja tabele mo\u017eete vi\u0161e pro\u010ditati u na\u0161em \u010dlanku <a href=\"https:\/\/kalkulacija.com\/wordpress\/uslovno-formatiranje-tabela\/\">Uslovno formatiranje tabela<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Najbol%D1%98e_prakse_za_dizajn_kontrolne_table\"><\/span><strong>Najbol\u0458e prakse za dizajn kontrolne table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Dakle, te\u017eimo\u00a0dizajnu kontrolne table\u00a0koji prikazuje korisne metrike iz izvora podataka u realnom vremenu i prikazuje poslovne cil\u0458eve u jednom prozoru.<\/p>\n<p>Zvu\u010di prili\u010dno izazovno, i jeste. Ali sa ovim osnovnim savetima za dizajn kontrolne table, za kratko vreme \u0107ete profesionalno predstaviti podatke.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Odredite_svrhu_kontrolne_table\"><\/span><strong style=\"font-size: 1.0625rem;\">Odredite svrhu kontrolne table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Da biste ta\u010dno prikazali informacije na kontrolnoj tabli, prvo morate odrediti svrhu koja \u0107e slu\u017eiti.\u00a0Kontrolne table su podel\u0458ene u nekoliko kategorija na osnovu njihove namene.\u00a0Naj\u0161ire i naj\u010de\u0161\u0107e kategorije su analiti\u010dke kontrolne table i operativne kontrolne table.\u00a0Oni tako\u0111e mogu imati u\u017eu kategoriju, kao \u0161to su finansijske kontrolne table,\u00a0<strong>prodajne kontrolne table<\/strong>, pa \u010dak i strate\u0161ke kontrolne table.<\/p>\n<p>Glavni cil\u0458 operativnih kontrolnih tabli je da brzo i jasno prenesu relevantne informacije korisnicima koji treba da preduzmu hitnu akciju.\u00a0Oni su osetl\u0458ivi na vreme i poma\u017eu korisnicima da budu proaktivni i efikasni.<\/p>\n<p><strong>Primer kontrolne table:<\/strong>\u00a0ova Shopifi + Google analitika kontrolna tabla je napravl\u0458ena u svrhu pra\u0107enja postizanja prodajnih cil\u0458eva.\u00a0Iz njega mo\u017eete lako da pro\u010ditate podatke o aktivnim korisnicima veb lokacije, ukupnoj prodaji i cil\u0458evima prodaje, stopi konverzije i jo\u0161 mnogo toga \u2013 sve u jednom prozoru.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/dashboard-design-for-shopify.png\" alt=\"\u0414\u0438\u0437\u0430\u0458\u043d \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043d\u0435 \u0442\u0430\u0431\u043b\u0435 \u0437\u0430 \u0421\u0445\u043e\u043f\u0438\u0444\u0438\" width=\"1419\" height=\"810\" \/><\/p>\n<p>S druge strane, analiti\u010dke kontrolne table su manje osetl\u0458ive na vreme i fokusiraju se na pomaganje \u010ditaocima da analiziraju trendove, da na najbol\u0458i na\u010din razumeju podatke i\u00a0\u00a0<a href=\"https:\/\/whatagraph.com\/blog\/articles\/sales-dashboard\">podsti\u010du dono\u0161enje odluka<\/a>\u00a0.\u00a0Ove dve kategorije mogu imati dva potpuno razli\u010dita pristupa dizajnu kontrolne table.<\/p>\n<p>Kada dizajnirate bilo koji od ovih formata kontrolne table, razmislite o tome \u0161ta korisnici o\u010dekuju da vide.\u00a0Ako je njihov fokus na vremenski osetl\u0458ivim podacima, izaberite odgovaraju\u0107u metriku sa pristupom koji je na prvom mestu vizuelno, a da ne ulazite u previ\u0161e detal\u0458a.<\/p>\n<p>S druge strane, ako je va\u0161a kontrolna tabla analiti\u010dka i slu\u017ei za pokretanje poslovnih strategija, mo\u017eete sebi priu\u0161titi da u\u0111ete u vi\u0161e detal\u0458a.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Jednostavan_oblik\"><\/span><strong style=\"font-size: 1.0625rem;\">Jednostavan oblik<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Za odli\u010dan dizajn kontrolne table, jedan od glavnih cil\u0458eva je predstavl\u0458anje relevantnih informacija u\u00a0\u00a0jednostavnom i lako razuml\u0458ivom obliku\u00a0.<\/p>\n<p>Dakle, nemojte iznositi previ\u0161e informacija ili koristiti vi\u0161e kolona da biste to uradili. Oslobodite se svih suvi\u0161nih informacija. Iskoristite beli prostor, ostavl\u0458aju\u0107i samo dovol\u0458no da gledalac razume strukturu podataka.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doslednost_%E2%80%93_tipsko_resenje\"><\/span><strong style=\"font-size: 1.0625rem;\">Doslednost &#8211; tipsko re\u0161enje<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Va\u0161 op\u0161ti dizajn kontrolne table mora da ostane dosledan.\u00a0Jednom kada odredite svrhu kontrolne table, uspostavite njenu vizuelnu hijerarhiju i formu, ne mo\u017eete iznenada promeniti ova pravila.\u00a0Podaci su samo jedan deo ukupne doslednosti\u00a0.\u00a0Ne mo\u017eete da kontroli\u0161ete \u0161ta marketin\u0161ki kanali proizvode kao podatke, ali mo\u017eete da kontroli\u0161ete kako dizajnirate i predstavl\u0458ate relevantne podatke.<\/p>\n<p>Konzistentnost dolazi u razli\u010ditim oblicima.\u00a0Male stvari poput pra\u0107enja doslednog formatiranja datuma i konvencija o imenovanju mogu olak\u0161ati stvari korisniku.\u00a0Predstavl\u0458anje podataka u linijskim grafikonima, kru\u017enim grafikonima,\u00a0<a href=\"https:\/\/chartexpo.com\/charts\/radar-chart\">radarskim grafikonima<\/a> i trakastim grafikonima istog stila tako\u0111e \u0107e pomo\u0107i korisniku da obra\u0111uje podatke pristupa\u010dnijim.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Blizina\"><\/span><strong style=\"font-size: 1.0625rem;\">Blizina<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Da biste pomogli \u010ditaocima da lak\u0161e i br\u017ee razumeju informacije, trebalo bi da prika\u017eete povezane detal\u0458e bli\u017ee jedan drugom umesto da ih razbacujete po celoj kontrolnoj tabli.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Uskladivanje\"><\/span><strong style=\"font-size: 1.0625rem;\">Uskla\u0111ivanje<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Elementi kontrolne table treba da budu uskla\u0111eni jedan sa drugim radi uravnote\u017eenog izgleda koji omogu\u0107ava dobro korisni\u010dko iskustvo.\u00a0Mre\u017ee vam omogu\u0107avaju da postignete efikasnu doslednost i poravnanje i napravite \u0161ablon za dizajn va\u0161e kontrolne table.<\/p>\n<p><strong>Primer kontrolne table:<\/strong>\u00a0ovde vidite savr\u0161eno poravnatu mre\u017eu.\u00a02\/3 kontrolne table prikazuje performanse tokom du\u017eeg vremenskog perioda kroz razli\u010dite dimenzije.\u00a01\/3 kontrolne table na desnoj strani je uredno naslagano da prikazuje samo najrelevantnije statistike potrebne za uvid.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/youtube-dashboard-design.png\" alt=\"\u0414\u0438\u0437\u0430\u0458\u043d \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043d\u0435 \u0442\u0430\u0431\u043b\u0435 \u0437\u0430 \u0418\u043e\u0443\u0442\u0443\u0431\u0435 \u043a\u0430\u043d\u0430\u043b\" width=\"1440\" height=\"824\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Razmak\"><\/span><strong style=\"font-size: 1.0625rem;\">Razmak<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Razmak igra va\u017enu ulogu u dizajnu va\u0161e kontrolne table. Omogu\u0107ava \u010ditaocu da napravi pauzu od gledanja svih informacija i ostavl\u0458a vi\u0161e vremena za obradu podataka. Kori\u0161\u0107enje razmaka spre\u010dava zatrpan prikaz i poma\u017ee vam da vizuelno grupi\u0161ete povezane informacije. Mo\u017eda ste \u010duli da se to naziva i negativnim prostorom.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Boja\"><\/span><strong style=\"font-size: 1.0625rem;\">Boja<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Boja igra zna\u010dajnu ulogu u efektivnom dizajnu kontrolne table. Izbor pravih boja i kori\u0161\u0107enje maksimalnog kontrasta mo\u017ee vam pomo\u0107i da vodite \u010ditaoca kroz informacije na jednostavan i lako razuml\u0458iv na\u010din. Mo\u017ee olak\u0161ati \u010ditanje sadr\u017eaja. Dakle, vodite ra\u010duna o kontrastnim bojama i izbegavajte kori\u0161\u0107enje neefikasnih gradijenata.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Fontovi\"><\/span><strong style=\"font-size: 1.0625rem;\">Fontovi<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Osim ako nema razloga da koristite odre\u0111eni font, koristite standardne za sadr\u017eaj na kontrolnoj tabli.\u00a0Lak\u0161e ih je skenirati, \u010ditati i razumeti.\u00a0Nemojte koristiti SVE velika slova jer to ote\u017eava \u010ditanje.<\/p>\n<p>Dakle, izaberite standardni font odgovaraju\u0107e veli\u010dine da biste predstavili informacije.\u00a0Fontovi poput Times Nev Roman, Arial, Roboto i Calibri \u0107e u\u010diniti trik.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Formati_brojeva\"><\/span><strong style=\"font-size: 1.0625rem;\">Formati brojeva<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Koristite okrugle brojeve umesto dugih kad god je to mogu\u0107e da ne biste zbunili \u010ditaoca. Ne zaboravite da dodate napomenu da se \u201ebrojevi mo\u017eda ne\u0107e sabirati zbog zaokru\u017eivanja\u201c. To je jednostavan na\u010din da se objasni za\u0161to ponekad tortni grafikoni ne sadr\u017ee stotinu ili drugih sli\u010dnih slu\u010dajeva.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Etikete\"><\/span><strong style=\"font-size: 1.0625rem;\">Etikete<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Rotirane etikete su generalno te\u017ee \u010ditl\u0458ive i apsorbovane za l\u0458udski um.\u00a0Zato koristite etikete koje brzo i efikasno saop\u0161tavaju informacije.\u00a0Standardne skra\u0107enice treba koristiti kad god je to mogu\u0107e.<\/p>\n<p><strong>Primer kontrolne table:<\/strong> na ovoj kontrolnoj tabli LinkedIn-a, svi brojevi i grafikoni su ozna\u010deni jednom ili dve re\u010di. To \u010dini da kontrolna tabla izgleda nenatrpano i manje zastra\u0161uju\u0107e, dok i dal\u0458e pru\u017ea neophodne informacije.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/linkedin-dashboard-design.png\" alt=\"\u0414\u0438\u0437\u0430\u0458\u043d \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043d\u0435 \u0442\u0430\u0431\u043b\u0435 \u0437\u0430 \u041b\u0438\u043d\u043a\u0435\u0434\u0418\u043d \u043a\u0430\u043d\u0430\u043b\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Personalizacija_i_prilagodavanje\"><\/span><strong style=\"font-size: 1.0625rem;\">Personalizacija i prilago\u0111avanje<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u010citaoci o\u010dekuju da \u0107e prona\u0107i relevantne informacije na svojoj kontrolnoj tabli, a dve tehnike koje omogu\u0107avaju da se to desi su personalizacija i prilago\u0111avanje.<\/p>\n<p>Personalizacija je kada napravite dizajn kontrolne table koji se pridr\u017eava imid\u017ea brenda va\u0161eg klijenta.\u00a0To mo\u017ee zna\u010diti dodavanje\u00a0<a href=\"https:\/\/designcrowd.com\/logo-design\/\">dizajna logotipa<\/a>\u00a0, odabir odgovaraju\u0107ih boja grafikona ili dodavanje odre\u0111enih oznaka metrikama ili kanalima.<\/p>\n<p>Prilago\u0111avanje je prilago\u0111avanje dizajna kontrolne table za prikazivanje relevantnih podataka i razli\u010ditih kl\u0458u\u010dnih metrika.\u00a0To mo\u017ee zna\u010diti preure\u0111ivanje sredstava kontrolne table da bi se podaci predstavili na drugi na\u010din.\u00a0Ili izaberite i istaknite razli\u010dite KPI-je da odgovaraju interesovanju klijenta.<\/p>\n<p>Kada dizajnirate kontrolne table, i personalizacija i prilago\u0111avanje treba da rade u tandemu.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tabele_ili_liste_podataka\"><\/span><strong style=\"font-size: 1.0625rem;\">Tabele ili liste podataka<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Integrisanje\u00a0\u00a0<span style=\"font-size: 1.0625rem;\">tabela sa podacima<\/span><span style=\"font-size: 1.0625rem;\">\u00a0\u00a0je korisno kada imate mnogo informacija za razli\u010dite stavke koje mo\u017eete predstaviti.\u00a0Oni su najbol\u0458i na\u010din za predstavl\u0458anje informacija kao \u0161to je lista klijenata sa njihovim ID-om, poslednjom aktivno\u0161\u0107u, kontaktima, statusom itd.<\/span><\/p>\n<p>Tabele podataka obezbe\u0111uju laku skalabilnost, dobro kori\u0161\u0107enje prostora i mogu da u\u010dine proces projektovanja manje komplikovanim.\u00a0Sa njima je lako raditi, jer ve\u0107ina l\u0458udi ima iskustva u radu sa Microsoft Ekcel-om.\u00a0Samo se pobrinite da tabele i liste budu manje zastra\u0161uju\u0107i!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Da_sumiram\"><\/span><strong>Da sumiram<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kontrolne table bi trebalo da isporu\u010duju slo\u017eene podatke na jednostavan na\u010din koji bi u\u0161tedeo vreme i trud.\u00a0Trebalo bi da budu strukturirani na na\u010din koji \u0107e odr\u017eavati\u00a0\u00a0vizuelnu hijerarhiju\u00a0.\u00a0Da li \u0107e slu\u017eiti ovoj svrsi ili ne zavisi od dizajna kontrolne table, koja bi trebalo da bude usmerena na cil\u0458eve i korisnika.<\/p>\n<p>Iako svaka kontrolna tabla ima jedinstven cil\u0458, ograni\u010denja i zahteve, pra\u0107enje ovih najbol\u0458ih praksi \u0107e vam pomo\u0107i da napravite odli\u010dne dizajne kontrolne table.<\/p>\n<p>Da bi ste izbegli <a href=\"https:\/\/kalkulacija.com\/wordpress\/dashboard\/\">Dashboard &#8211; Po\u010detni\u010dke gre\u0161ke<\/a> pogledajte istoimeni tekst na na\u0161em sajtu.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3652&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (2 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju. Svakako ne treba<\/p>\n","protected":false},"author":1,"featured_media":3651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46,15,62],"tags":[],"class_list":["post-3652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dashboard","category-kalkulacija","category-microsoft-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Dashboard kontrolna tabla uputstvo i primer datoteke<\/title>\n<meta name=\"description\" content=\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Dashboard kontrolna tabla uputstvo i primer datoteke\" \/>\n<meta property=\"og:description\" content=\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-01T21:40:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T10:52:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1103\" \/>\n\t<meta property=\"og:image:height\" content=\"655\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke\",\"datePublished\":\"2022-12-01T21:40:17+00:00\",\"dateModified\":\"2022-12-06T10:52:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"},\"wordCount\":3423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"articleSection\":[\"Dashboard - komandna tabla\",\"Kalkulacija\",\"Microsoft\u00ae Excel\"],\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\",\"name\":\"Excel Dashboard kontrolna tabla uputstvo i primer datoteke\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"datePublished\":\"2022-12-01T21:40:17+00:00\",\"dateModified\":\"2022-12-06T10:52:28+00:00\",\"description\":\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"width\":1103,\"height\":655,\"caption\":\"Dashboard - po\u010detni\u010dke gre\u0161ke\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","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:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","og_locale":"en_US","og_type":"article","og_title":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","og_description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","og_url":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-12-01T21:40:17+00:00","article_modified_time":"2022-12-06T10:52:28+00:00","og_image":[{"width":1103,"height":655,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke","datePublished":"2022-12-01T21:40:17+00:00","dateModified":"2022-12-06T10:52:28+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"},"wordCount":3423,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","articleSection":["Dashboard - komandna tabla","Kalkulacija","Microsoft\u00ae Excel"],"inLanguage":"sr-SR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","url":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","name":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","datePublished":"2022-12-01T21:40:17+00:00","dateModified":"2022-12-06T10:52:28+00:00","description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","width":1103,"height":655,"caption":"Dashboard - po\u010detni\u010dke gre\u0161ke"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3652"}],"version-history":[{"count":28,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3652\/revisions"}],"predecessor-version":[{"id":3684,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3652\/revisions\/3684"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3651"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}