{"id":100,"date":"2016-12-25T13:52:21","date_gmt":"2016-12-25T12:52:21","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=100"},"modified":"2022-06-08T08:26:14","modified_gmt":"2022-06-08T06:26:14","slug":"najtrazenije-i-najkorisnije-funkcije-u-excel-u","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/","title":{"rendered":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u"},"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\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Matematicke_operacije_u_EXCEL-u\" >Matemati\u010dke operacije u EXCEL-u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Osnovne_funkcije_u_EXCEL-u\" >Osnovne funkcije u EXCEL-u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Napredne_funkcije_u_EXCEL-u\" >Napredne funkcije u EXCEL-u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Mathematical_operations_in_EXCEL\" >Mathematical operations in EXCEL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Basic_functions_in_EXCEL\" >Basic functions in EXCEL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#Advanced_functions_in_EXCEL\" >Advanced functions in EXCEL<\/a><\/li><\/ul><\/nav><\/div>\n<p>Prilikom dobijanja zadatka na poslu, prvo pitanje koje se pojavljuje je &#8220;za kada treba da bude gotovo?&#8221; i odgovor &#8220;Za ju\u010de!&#8221; nas dovodi u situaciju da ga obavimo onako kako znamo. To ne mora biti uvek i &#8220;najpametnije&#8221; ali je onaj na\u010din koji mi znamo i u \u010diji rezultat imamo poverenja.\u00a0 Tom prilikom \u0107emo upotrebiti najtra\u017eenije i\/ili najkorisnije funkcije u Excel-u.<\/p>\r\n<p>Re\u0161enje na\u0161eg zadatka mo\u017ee biti upotrebom poznate funkcije ili formule, a koje su razlike mo\u017eete pro\u010ditati u na\u0161em \u010dlanku &#8220;<a href=\"https:\/\/kalkulacija.com\/wordpress\/razlika-izmedu-formule-i-funkcije-u-excel-u\/\">Razlika izme\u0111u formule i funkcije u Excel-u<\/a>&#8220;.<\/p>\r\n\r\n\r\n\r\n<p>Ako je re\u010d o zadatku koji se ponavlja periodi\u010dno, mo\u017eda treba da prona\u0111emo bolje re\u0161enje. Tada treba istra\u017eiti nove funkcije u poslednjim verzijama Excela, koje mo\u017eda mogu dati odgovor na mnoga pitanja u pobolj\u0161anju re\u0161enja. U potrazi za re\u0161enjem treba prvo pogledati koje su najtra\u017eenije i najkorisnije funkcije u Excel-u koje drugi korisnici Excela koriste, a mo\u017eda ve\u0107 postoji re\u0161enje u vidu gotove excel datoteke ili \u0161ablona.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Matematicke_operacije_u_EXCEL-u\"><\/span>Matemati\u010dke operacije u EXCEL-u<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>Mnoge obrade podataka \u0107ete jednostavno zavr\u0161iti matemati\u010dkim operacijama sabiranjem, oduzimanjem, mno\u017eenjem i deljenjem i tu je najva\u017enije znati upotrebiti dolar! Mislim ne kao valutu nego znak $A$1, kada kod kopiranja matemati\u010dkih operacija neka vrednost nije promenljiva. Za to je najbolji primer devizni kurs.<\/p>\r\n\r\n\r\n\r\n<p>Recimo da imamo kolonu sa cenama u evrima [\u20ac] i da \u017eelimo u drugoj koloni izra\u010dunati vrednost po dana\u0161njem srednjem kursu<a href=\"https:\/\/nbs.rs\/sr_RS\/indeks\/\" target=\"_blank\" rel=\"noopener\"> Narodne banke Srbije<\/a>. Vi\u0161e o apsolutnom i relativnom adresiranju \u0107elija tabele mo\u017eete prona\u0107i u<a href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/\"> Promenljive u Excel formulama.<\/a><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Osnovne_funkcije_u_EXCEL-u\"><\/span>Osnovne funkcije u EXCEL-u<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>Ako smo to razjasnili sada se mo\u017eemo pozabaviti funkcijama koje su se prve pojavile u EXCEL-u, a re\u010d je pre svega verovatno i najkorisnija formula sabiranja (sumiranja).<\/p>\r\n<div class=\"wptb-container-legacy\" data-table-id=\"2707\">\n    <table class=\"wptb-preview-table wptb-element-main-table_setting-2707\" data-reconstraction=\"1\" style=\"border: 1px solid rgb(209, 209, 209);\" data-wptb-table-tds-sum-max-width=\"547\" data-wptb-extra-styles=\"LyogRW50ZXIgeW91ciBjdXN0b20gQ1NTIHJ1bGVzIGhlcmUgKi8=\" role=\"table\" data-table-columns=\"2\"><tbody><tr class=\"wptb-row\"><td class=\"wptb-cell\" style=\"border: 1px solid rgb(209, 209, 209); width: 81px;\" data-x-index=\"0\" data-y-index=\"0\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-25\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p><strong>Funkcija<\/strong><\/p><\/div><\/div><\/td><td class=\"wptb-cell\" data-y-index=\"0\" data-x-index=\"1\" style=\"border: 1px solid rgb(209, 209, 209); width: 403px;\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-6\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p><strong>OPIS<\/strong><\/p><p><\/p><\/div><\/div><\/td><\/tr><tr class=\"wptb-row\"><td class=\"wptb-cell\" style=\"border: 1px solid rgb(209, 209, 209); width: 81px;\" data-x-index=\"0\" data-y-index=\"1\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-26\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>SUM<\/p><\/div><\/div><\/td><td class=\"wptb-cell\" data-y-index=\"1\" data-x-index=\"1\" style=\"border: 1px solid rgb(209, 209, 209); width: 403px;\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-12\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>Koristite ovu funkciju da biste sabrali selektovane vrednosti (u jednoj koloni, jednom redu ili vi\u0161e razli\u010ditih vrednosti odabrani namernom selekcijom upotrebom Ctrl dugmeta). Vi\u0161e o tome mo\u017eete pro\u010ditati kod <a data-mce-href=\"https:\/\/internetzanatlija.com\/2016\/04\/12\/funkcije-sum-sumif-sumifs-u-excelu\/\" href=\"https:\/\/internetzanatlija.com\/2016\/04\/12\/funkcije-sum-sumif-sumifs-u-excelu\/\" target=\"_blank\" rel=\"noopener\" title=\"SUM funkcija\" data-mce-selected=\"inline-boundary\">InternetZanatlije<\/a>.<\/p><\/div><grammarly-extension data-grammarly-shadow-root=\"true\" style=\"position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\" class=\"cGcvT\"><\/grammarly-extension><grammarly-extension data-grammarly-shadow-root=\"true\" class=\"cGcvT\" style=\"mix-blend-mode: darken; position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\"><\/grammarly-extension><\/div><\/td><\/tr><tr class=\"wptb-row\"><td class=\"wptb-cell\" style=\"border: 1px solid rgb(209, 209, 209); width: 81px;\" data-x-index=\"0\" data-y-index=\"2\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-27\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>COUNT<\/p><\/div><\/div><\/td><td class=\"wptb-cell\" data-y-index=\"2\" data-x-index=\"1\" style=\"border: 1px solid rgb(209, 209, 209); width: 403px;\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-18\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>&nbsp;Koristite ovu funkciju da biste prebrojali vrednosti u \u0107elije. Vi\u0161e o tome mo\u017eete prona\u0107i na stranici <a data-mce-href=\"https:\/\/mojkursexcela.mozello.com\/excel\/params\/post\/997469\/funkcije-count-counta-countablank-countif-countifs\" href=\"https:\/\/mojkursexcela.mozello.com\/excel\/params\/post\/997469\/funkcije-count-counta-countablank-countif-countifs\" target=\"_blank\" rel=\"noopener\" title=\"COUNT funkcija\" data-mce-selected=\"inline-boundary\">Moj Kurs Excela<\/a>.<\/p><\/div><grammarly-extension data-grammarly-shadow-root=\"true\" style=\"position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\" class=\"cGcvT\"><\/grammarly-extension><grammarly-extension data-grammarly-shadow-root=\"true\" style=\"mix-blend-mode: darken; position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\" class=\"cGcvT\"><\/grammarly-extension><\/div><\/td><\/tr><tr class=\"wptb-row\"><td class=\"wptb-cell\" style=\"border: 1px solid rgb(209, 209, 209); width: 81px;\" data-x-index=\"0\" data-y-index=\"3\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-28\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>AVERAGE<\/p><\/div><\/div><\/td><td class=\"wptb-cell\" data-y-index=\"3\" data-x-index=\"1\" style=\"border: 1px solid rgb(209, 209, 209); width: 403px;\"><div class=\"wptb-text-container wptb-ph-element wptb-element-text-24 edit-active\" style=\"color: rgb(74, 85, 104); font-size: 15px;\"><div class=\"\" style=\"position: relative;\"><p>Koristite ovu funkciju da biste izra\u010dunali srednju vrednost u odabranim \u0107elijama. O tome pogledajte film na <a data-mce-href=\"https:\/\/klikskola.com\/epizoda\/excel-osnove\/funkcije-excel\" href=\"https:\/\/klikskola.com\/epizoda\/excel-osnove\/funkcije-excel\" target=\"_blank\" rel=\"noopener\" title=\"AVERAGE funkcija\" data-mce-selected=\"inline-boundary\">Klik \u0160koli<\/a>.<\/p><\/div><grammarly-extension data-grammarly-shadow-root=\"true\" style=\"position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\" class=\"cGcvT\"><\/grammarly-extension><grammarly-extension data-grammarly-shadow-root=\"true\" style=\"mix-blend-mode: darken; position: absolute; top: -1px; left: -1px; pointer-events: none; z-index: auto;\" class=\"cGcvT\"><\/grammarly-extension><\/div><\/td><\/tr><\/tbody><\/table>\n<\/div>\n\r\n<p>\r\n\r\n<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Napredne_funkcije_u_EXCEL-u\"><\/span>Napredne funkcije u EXCEL-u<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>\u010cim napredujete kroz prostor tabelarnih obrada podataka ubrzo vam se nametne i potreba da pove\u017eete podatke iz vi\u0161e tabela. Tu se neizostavno susre\u0107ete sa funkcijama VLOOKUP, INDEX, MATCH, kao i mnogim drugim.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-table is-style-stripes\">\r\n<table>\r\n<thead>\r\n<tr>\r\n<th><strong>Funkcija<\/strong><\/th>\r\n<th><strong>Opis<\/strong><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>VLOOKUP<\/strong><\/td>\r\n<td>Koristite ovu funkciju kada treba da prona\u0111ete ne\u0161to u tabeli ili u opsegu koji je filtriran po redu. Na primer, potra\u017eite prezime zaposlenog po broju zaposlenog ili prona\u0111ite broj telefona tako \u0161to \u0107ete potra\u017eiti prezime (ba\u0161 kao u imeniku). Pogledajte ovaj video o kori\u0161\u0107enju funkcije VLOOKUP. (<a href=\"https:\/\/kalkulacija.com\/wordpress\/sr\/2016\/12\/28\/vlookup-funkcija-ili-vertical-lookup\/\">Detaljije obja\u0161njeno<\/a>)<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>INDEX<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste vratili vrednost ili referencu na vrednost iz tabele ili opsega.Najtra\u017eenije funkcije u EXCEL-u<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>MATCH<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste potra\u017eili stavku u opsegu \u0107elija, a zatim vratili relativnu poziciju te stavke u opsegu. Na primer, ako opseg A1:A3 sadr\u017ei vrednosti 5, 7 i 38, formula =MATCH(7,A1:A3,0) daje broj 2 zato \u0161to je 7 druga stavka u opsegu.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>CHOOSE<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste izabrali jednu od maksimalno 254 vrednosti koje su zasnovane na broju indeksa. Na primer, ako su argumenti vred1 do vred7 dani u sedmici, funkcija CHOOSE daje jedan od dana kada se broj izme\u0111u 1 i 7 koristi kao argument indeks_broja.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>IF<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste vratili jednu vrednost ako je uslov ispunjen, a drugu vrednost ako nije. Evo video zapisa o kori\u0161\u0107enju funkcije IF.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>DATE<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste vratili sekvencijalni redni broj koji predstavlja datum. Ova funkcija je najkorisnija u situacijama gde formule ili reference \u0107elija obezbe\u0111uju godinu, mesec i dan. Na primer, mo\u017eda imate radni list koji sadr\u017ei datume u formatu koji Excel ne prepoznaje, kao \u0161to je YYYYMMDD.Koristite funkciju DATEDIF da biste izra\u010dunali broj dana, meseci ili godina izme\u0111u dva datuma.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>DAYS<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste vratili broj dana izme\u0111u dva datuma.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>FIND i FINDB<\/strong><\/td>\r\n<td>Funkcije FIND i FINDB pronalaze jednu tekstualnu nisku u okviru druge tekstualne niske. One daju broj po\u010detne pozicije prve tekstualne niske od prvog znaka druge tekstualne niske.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>LOOKUP<\/strong><\/td>\r\n<td>Koristite ovu funkciju kada treba da pretra\u017eite jedan red ili kolonu i prona\u0111ete vrednost iz iste pozicije u drugom redu ili koloni.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<figcaption>Napredne funkcije u EXCEL-u<\/figcaption>\r\n<\/figure>\r\n\r\n<p class=\"c12\"><span class=\"c1\">\u00a0<\/span><\/p>\r\n\r\n<table>\r\n<thead>\r\n<tr>\r\n<th><strong>Funkcija<\/strong><\/th>\r\n<th><strong>Opis<\/strong><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>SUM<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste sabrali selektovane vrednosti (u jednoj koloni, jednom redu ili vi\u0161e razli\u010ditih vrednosti odabrani namernom selekcijom upotrebom Ctrl dugmeta). Vi\u0161e o tome mo\u017eete pro\u010ditati kod <a href=\"https:\/\/internetzanatlija.com\/2016\/04\/12\/funkcije-sum-sumif-sumifs-u-excelu\/\" target=\"_blank\" rel=\"noopener\">InternetZanatlije<\/a>.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>COUNT<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste prebrojali vrednosti u \u0107elije. Vi\u0161e o tome mo\u017eete prona\u0107i na stranici <a href=\"https:\/\/mojkursexcela.mozello.com\/excel\/params\/post\/997469\/funkcije-count-counta-countablank-countif-countifs\" target=\"_blank\" rel=\"noopener\">Moj Kurs Excela<\/a>.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>AVERAGE<\/strong><\/td>\r\n<td>Koristite ovu funkciju da biste izra\u010dunali srednju vrednost u odabranim \u0107elijama. O tome pogledajte film na <a href=\"https:\/\/klikskola.com\/epizoda\/excel-osnove\/funkcije-excel\" target=\"_blank\" rel=\"noopener\">Klik \u0160koli<\/a>.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p>Osnovne funkcije u EXCEL-u<\/p>\r\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;100&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;Najtra\u017eenije i najkorisnije funkcije u EXCEL-u&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>Prilikom dobijanja zadatka na poslu, prvo pitanje koje se pojavljuje je &#8220;za kada treba da bude gotovo?&#8221; i odgovor &#8220;Za<\/p>\n","protected":false},"author":1,"featured_media":1243,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Najtra\u017eenije i najkorisnije funkcije u EXCEL-u<\/title>\n<meta name=\"description\" content=\"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.\" \/>\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\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u\" \/>\n<meta property=\"og:description\" content=\"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-25T12:52:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-08T06:26:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"257\" \/>\n\t<meta property=\"og:image:height\" content=\"196\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u\",\"datePublished\":\"2016-12-25T12:52:21+00:00\",\"dateModified\":\"2022-06-08T06:26:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\"},\"wordCount\":1551,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/obuke.jpg\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"sr-SR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\",\"name\":\"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/obuke.jpg\",\"datePublished\":\"2016-12-25T12:52:21+00:00\",\"dateModified\":\"2022-06-08T06:26:14+00:00\",\"description\":\"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/obuke.jpg\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/obuke.jpg\",\"width\":257,\"height\":196},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u\"}]},{\"@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":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u","description":"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.","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\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/","og_locale":"en_US","og_type":"article","og_title":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u","og_description":"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.","og_url":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2016-12-25T12:52:21+00:00","article_modified_time":"2022-06-08T06:26:14+00:00","og_image":[{"width":257,"height":196,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u","datePublished":"2016-12-25T12:52:21+00:00","dateModified":"2022-06-08T06:26:14+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/"},"wordCount":1551,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg","articleSection":["Poslovni Excel"],"inLanguage":"sr-SR"},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/","url":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/","name":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg","datePublished":"2016-12-25T12:52:21+00:00","dateModified":"2022-06-08T06:26:14+00:00","description":"Najtrazenije i najkorisnije funkcije u EXCEL-u: SUM, COUNT, AVERAGE, VLOOKUP, INDEX, MATCH, IF, CHOOSE, OFFSET, SUMIFS, COUNTIFS.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/obuke.jpg","width":257,"height":196},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Najtra\u017eenije i najkorisnije funkcije u EXCEL-u"}]},{"@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\/100","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=100"}],"version-history":[{"count":56,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":3218,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/100\/revisions\/3218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/1243"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}