{"id":11789,"date":"2024-09-25T08:00:13","date_gmt":"2024-09-25T06:00:13","guid":{"rendered":"https:\/\/www.slovensko.ai\/?p=11789"},"modified":"2024-10-20T18:35:53","modified_gmt":"2024-10-20T16:35:53","slug":"ako-vytvarat-a-pouzivat-efektivne-vzorce-v-exceli-a-google-sheets","status":"publish","type":"post","link":"https:\/\/www.slovensko.ai\/en\/ako-vytvarat-a-pouzivat-efektivne-vzorce-v-exceli-a-google-sheets\/","title":{"rendered":"Ako vytv\u00e1ra\u0165 a pou\u017e\u00edva\u0165 efekt\u00edvne vzorce v Exceli a Google Sheets"},"content":{"rendered":"<div class='epvc-post-count'><span class='epvc-eye'><\/span>  <span class=\"epvc-count\"> 1,152<\/span><span class='epvc-label'> Viden\u00ed<\/span><\/div><h4><span data-sheets-root=\"1\">Generovanie vzorcov v Exceli:<\/span><\/h4>\n<p><span data-sheets-root=\"1\">1. Vytvor vzorec na v\u00fdpo\u010det s\u00fa\u010dtu v bunk\u00e1ch A1 a\u017e A10<br \/>\n2. Vytvor vzorec na v\u00fdpo\u010det priemeru v bunk\u00e1ch H10 a\u017e H20<br \/>\n3. Vytvor vzorec, ktor\u00fd spo\u010d\u00edta len v\u00fddavky s hodnotou &#8220;No&#8221; v st\u013apci C<\/span><\/p>\n<h4><span data-sheets-root=\"1\">Vysvetlenie vzorca:<\/span><\/h4>\n<p><span data-sheets-root=\"1\">1. Vysvetli v\u00fdznam vzorca =SUM(A1:A10).<br \/>\n2. Vysvetli v\u00fdznam vzorca =AVERAGE(H10:H20).<br \/>\n3. Vysvetli v\u00fdznam vzorca SUMIF(C1,&#8221;No&#8221;, B1)<\/span><\/p>\n<h4><span data-sheets-root=\"1\">Pokro\u010dil\u00e9 vzorce, makr\u00e1 a VBA:<\/span><\/h4>\n<p><span data-sheets-root=\"1\">1. M\u00e1m tabu\u013eku s telef\u00f3nnymi \u010d\u00edslami v st\u013apci A vo form\u00e1te: (xxx) xxx-xxxx. Extrahuj \u010d\u00edsla v z\u00e1tvork\u00e1ch pomocou Excelu<br \/>\n2. Vytvor makro, ktor\u00e9 vypo\u010d\u00edta priemer hodn\u00f4t v bunk\u00e1ch B1 a\u017e B10 a vlo\u017e\u00ed v\u00fdsledok do bunky C1<br \/>\n3. Vytvor makro, ktor\u00e9 zorad\u00ed listy pod\u013ea n\u00e1zvu tabu pomocou VBA<\/span><\/p>\n<h4><span data-sheets-root=\"1\">Google Sheets:<\/span><\/h4>\n<p><span data-sheets-root=\"1\">1. Vytvor vzorec v Google Sheets na v\u00fdpo\u010det s\u00fa\u010dtu buniek v rozsahu A1 a\u017e A10<br \/>\n2. Vytvor vzorec v Google Sheets, ktor\u00fd vlo\u017e\u00ed d\u00e1ta z jedn\u00e9ho listu do aktu\u00e1lneho listu<br \/>\n3. Vysvetli tento pr\u00edkaz Google Sheet: [vlo\u017ei\u0165 pr\u00edkaz]\n<p><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1,152 Viden\u00edGenerovanie vzorcov v Exceli: 1. Vytvor vzorec na v\u00fdpo\u010det s\u00fa\u010dtu v bunk\u00e1ch A1 a\u017e A10 2. Vytvor vzorec na v\u00fdpo\u010det priemeru v bunk\u00e1ch H10 a\u017e H20 3. Vytvor vzorec, ktor\u00fd spo\u010d\u00edta len v\u00fddavky s hodnotou &#8220;No&#8221; v st\u013apci C Vysvetlenie vzorca: 1. Vysvetli v\u00fdznam vzorca =SUM(A1:A10). 2. Vysvetli v\u00fdznam vzorca =AVERAGE(H10:H20). 3. Vysvetli v\u00fdznam [&hellip;]<\/p>\n","protected":false},"author":51,"featured_media":11790,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[397],"tags":[427],"class_list":["post-11789","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-prompty","tag-excel-a-google-sheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/posts\/11789"}],"collection":[{"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/comments?post=11789"}],"version-history":[{"count":1,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/posts\/11789\/revisions"}],"predecessor-version":[{"id":11791,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/posts\/11789\/revisions\/11791"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/media\/11790"}],"wp:attachment":[{"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/media?parent=11789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/categories?post=11789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.slovensko.ai\/en\/wp-json\/wp\/v2\/tags?post=11789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}