{"id":46,"date":"2026-01-16T09:00:00","date_gmt":"2026-01-16T09:00:00","guid":{"rendered":"https:\/\/magyar.info\/?p=46"},"modified":"2026-01-16T09:00:00","modified_gmt":"2026-01-16T09:00:00","slug":"excel-tudas-a-legfontosabb-funkciok-30-perc-alatt","status":"publish","type":"post","link":"https:\/\/magyar.info\/?p=46","title":{"rendered":"Excel tud\u00e1s \u2014 A legfontosabb funkci\u00f3k 30 perc alatt"},"content":{"rendered":"

Mi\u00e9rt fontos az Excel?<\/h2>\n

Az Excel a legelterjedtebb irodai szoftver \u2014 szinte minden munkahelyen haszn\u00e1lj\u00e1k. Az alapfunkci\u00f3k ismerete minim\u00e1lis elv\u00e1r\u00e1s, de aki a halad\u00f3 funkci\u00f3kat is ismeri, az kit\u0171nik a mez\u0151nyb\u0151l.<\/p>\n

10 legfontosabb funkci\u00f3<\/h2>\n

1. SZUM (SUM)<\/h3>\n

=SZUM(A1:A10) \u2014 \u00d6sszead egy cellatartom\u00e1nyt. Az abszol\u00fat alap.<\/p>\n

2. \u00c1TLAG (AVERAGE)<\/h3>\n

=\u00c1TLAG(A1:A10) \u2014 \u00c1tlagot sz\u00e1mol.<\/p>\n

3. DARAB (COUNT \/ COUNTA)<\/h3>\n

=DARAB(A1:A10) \u2014 Megsz\u00e1molja a sz\u00e1mokat tartalmaz\u00f3 cell\u00e1kat.<\/p>\n

4. HA (IF)<\/h3>\n

=HA(A1>100;”Magas”;”Alacsony”) \u2014 Felt\u00e9teles logika. D\u00f6nt\u00e9seket automatiz\u00e1lhatsz vele.<\/p>\n

5. FKERES (VLOOKUP)<\/h3>\n

=FKERES(keresett_\u00e9rt\u00e9k;t\u00e1bla;oszlop;HAMIS) \u2014 Kikeresi egy \u00e9rt\u00e9ket egy t\u00e1bl\u00e1zatb\u00f3l. Az egyik leghaszn\u00e1ltabb funkci\u00f3.<\/p>\n

6. SZUMHA (SUMIF)<\/h3>\n

=SZUMHA(A:A;”Budapest”;B:B) \u2014 Felt\u00e9tel alapj\u00e1n \u00f6sszegez. Pl. csak a budapesti elad\u00e1sokat adja \u00f6ssze.<\/p>\n

7. SZ\u00d6VEG.\u00d6SSZEF\u0170Z (CONCATENATE)<\/h3>\n

=A1&” ”&B1 \u2014 Sz\u00f6vegeket f\u0171z \u00f6ssze.<\/p>\n

8. D\u00c1TUM funkci\u00f3k<\/h3>\n

=MA() az aktu\u00e1lis d\u00e1tum. =\u00c9V(), =H\u00d3NAP(), =NAP() a d\u00e1tum r\u00e9szeit adj\u00e1k.<\/p>\n

9. Pivot t\u00e1bla<\/h3>\n

Nem f\u00fcggv\u00e9ny, hanem eszk\u00f6z \u2014 nagy adathalmazokat \u00f6sszegez \u00e9s elemez p\u00e1r kattint\u00e1ssal. Besz\u00far\u00e1s \u2192 Kimutat\u00e1s.<\/p>\n

10. Felt\u00e9teles form\u00e1z\u00e1s<\/h3>\n

Automatikusan kisz\u00ednezi a cell\u00e1kat felt\u00e9tel alapj\u00e1n. Pl. pirossal jel\u00f6li a lej\u00e1rt hat\u00e1rid\u0151ket.<\/p>\n

\ud83d\udca1 Tipp:<\/strong> A Ctrl+C, Ctrl+V mellett tanuld meg: Ctrl+Z (visszavon\u00e1s), Ctrl+Shift+L (sz\u0171r\u0151), Alt+= (gyors \u00f6sszeg), F2 (cella szerkeszt\u00e9se).<\/div>\n","protected":false},"excerpt":{"rendered":"

FKERES, SZUMHA, pivot t\u00e1bla \u00e9s m\u00e1s Excel funkci\u00f3k, amelyeket minden irodai dolgoz\u00f3nak ismernie kell.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-tanulas"],"_links":{"self":[{"href":"https:\/\/magyar.info\/index.php?rest_route=\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/magyar.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/magyar.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/magyar.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/magyar.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46"}],"version-history":[{"count":0,"href":"https:\/\/magyar.info\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions"}],"wp:attachment":[{"href":"https:\/\/magyar.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/magyar.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/magyar.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}