{"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":"[:sr]Najtra\u017eenije i najkorisnije funkcije u EXCEL-u[:en]Popular Excel functions[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 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\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/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[:sr]\r\n\r\n\r\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\">Osnovne funkcije u EXCEL-u<\/p>\r\n[:en]\r\n<p class=\"wp-block-paragraph\">When getting an assignment at work, the first question that arises is &#8220;when should it be done?&#8221; and the answer &#8220;For yesterday!&#8221; it puts us in a situation to do it the way we know-how. It doesn&#8217;t always have to be the &#8220;smartest&#8221;, but it is the way we know and in the result we trust. On this occasion, we will use the most sought-after and\/or most useful functions in Excel.<\/p>\r\n<p>The solution to our problem can be using a known function or formula, and you can read about the differences in our article &#8220;The difference between a formula and a function in Excel&#8221;.<\/p>\r\n<p>If this is a recurring task, we may need to find a better solution. New features in the latest versions of Excel should then be explored, which may provide answers to many questions in improving the solution. In the search for a solution, you should first look at the most sought-after and useful functions in Excel that other Excel users use, and perhaps there is already a solution in the form of a ready-made excel file or template.<\/p>\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mathematical_operations_in_EXCEL\"><\/span>Mathematical operations in EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Many data processing will be easily completed by mathematical operations of addition, subtraction, multiplication and division, and the most important thing is to know how to use the dollar! I mean not as a currency but as a sign $ A $ 1, when when copying mathematical operations some value is not variable. The best example of this is the exchange rate.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Let&#8217;s say we have a column with prices in euros [\u20ac] and we want to calculate the value in today&#8217;s second column at today&#8217;s middle exchange rate<a href=\"https:\/\/nbs.rs\/sr_RS\/indeks\/\"> National Bank of Serbia<\/a>. You can find more about absolute and relative addressing of table cells in<a href=\"https:\/\/kalkulacija.com\/wordpress\/promenljive-u-excel-formulama\/\"> Variables in Excel formulas.<\/a><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Basic_functions_in_EXCEL\"><\/span>Basic functions in EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">If we have clarified this, we can now deal with the functions that first appeared in EXCEL, and this is probably the most useful summation formula.<\/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>Function<\/strong><\/th>\r\n<th><strong>Description<\/strong><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>SUM<\/strong><\/td>\r\n<td>Use this function to collect the selected values \u200b\u200b(in one column, one row or several different values \u200b\u200bselected by intentional selection using the Ctrl button).<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>COUNT<\/strong><\/td>\r\n<td>Use this function to count values \u200b\u200bin cells.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>AVERAGE<\/strong><\/td>\r\n<td>Use this function to calculate the mean value in the selected cells.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<figcaption>Basics functions in EXCEL<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Advanced_functions_in_EXCEL\"><\/span>Advanced functions in EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">As you progress through the spreadsheet space, you will soon need to link data from multiple tables. Here you inevitably encounter the functions VLOOKUP, INDEX, MATCH, as well as many others.<\/p>\r\n\r\n\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>Function<\/strong><\/th>\r\n<th><strong>Description<\/strong><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>VLOOKUP<\/strong><\/td>\r\n<td>Use this function when you need to find something in a table or range that is filtered in order. For example, search for an employee&#8217;s last name by employee number, or search for a phone number by searching for the last name (just like in the phonebook). Watch this video on using the VLOOKUP function. (<a href=\"https:\/\/kalkulacija.com\/wordpress\/sr\/2016\/12\/28\/vlookup-funkcija-ili-vertical-lookup\/\">Details explained<\/a>)<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>INDEX<\/strong><\/td>\r\n<td>Use this function to return a value or reference to a value from a table or range. Most requested functions in EXCEL<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>MATCH<\/strong><\/td>\r\n<td>Use this function to search for an item in a range of cells and then return the relative position of that item in the range. For example, if the range A1: A3 contains the values \u200b\u200b5, 7 and 38, the formula = MATCH (7, A1: A3,0) gives the number 2 because 7 is the second item in the range.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>CHOOSE<\/strong><\/td>\r\n<td>Use this function to select one of a maximum of 254 index-based values. For example, if arguments value1 to value7 are given per week, the CHOOSE function returns one of the days when a number between 1 and 7 is used as the number_index argument.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>IF<\/strong><\/td>\r\n<td>Use this function to return one value if the condition is met and another if it is not. Here is a video on using the IF function.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>DATE<\/strong><\/td>\r\n<td>Use this function to return a sequential sequence number that represents the date. This feature is most useful in situations where cell formulas or references provide year, month, and day. For example, you might have a worksheet that contains dates in a format that Excel does not recognize, such as YYYYMMDD.Use the DATEDIF function to calculate the number of days, months or years between two dates.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>DAYS<\/strong><\/td>\r\n<td>Use this function to return the number of days between two dates.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>FIND and FINDB<\/strong><\/td>\r\n<td>The FIND and FINDB functions find one text string within another text string. They give the starting number of the first text string from the first character of the second text string.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>LOOKUP<\/strong><\/td>\r\n<td>Use this function when you need to search one row or column and find a value from the same position in another row or column.<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<figcaption>Advanced Functions in Excel<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Najtra\u017eenije i najkorisnije funkcije u EXCEL-u[:en]Popular Excel functions[:]&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>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] Prilikom dobijanja zadatka na poslu, prvo pitanje koje se pojavljuje je &#8220;za kada treba da bude gotovo?&#8221; i odgovor<\/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 v28.7 - 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\":\"[:sr]Najtra\u017eenije i najkorisnije funkcije u EXCEL-u[:en]Popular Excel functions[:]\",\"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\":\"en-US\"},{\"@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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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":"[:sr]Najtra\u017eenije i najkorisnije funkcije u EXCEL-u[:en]Popular Excel functions[:]","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":"en-US"},{"@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":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/najtrazenije-i-najkorisnije-funkcije-u-excel-u\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@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}]}}