{"id":5456,"date":"2017-09-20T08:51:16","date_gmt":"2017-09-20T06:51:16","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5456"},"modified":"2018-06-27T12:44:09","modified_gmt":"2018-06-27T10:44:09","slug":"excel-tablazat-hasznalata-3-alap-funkcio","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/","title":{"rendered":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene"},"content":{"rendered":"<p>Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, \u00edgy egyre fontosabb, hogy a\u00a0<strong>napi munk\u00e1t megk\u00f6nny\u00edt\u0151 funkci\u00f3kat minden felhaszn\u00e1l\u00f3 ismerje<\/strong>.<\/p>\n<p>Aki m\u00e1r rutinosan haszn\u00e1lja ezeket, tal\u00e1n el sem tudja k\u00e9pzelni, hogy l\u00e9teznek olyanok, akik m\u00e9g nem tudj\u00e1k.\u00a0<!--more--><\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/3-funkcio-Excel-tablazat-hasznalata.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft size-medium wp-image-5731\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/3-funkcio-Excel-tablazat-hasznalata-300x251.png\" alt=\"\" width=\"300\" height=\"251\" \/><\/a>Szakszer\u0171 \u00fatmutat\u00f3 n\u00e9lk\u00fcl azonban sokaknak gondot okoz az elej\u00e9n az Excel t\u00e1bl\u00e1zat haszn\u00e1lata.\u00a0(Tan\u00e1rk\u00e9nt sok &#8222;furcsas\u00e1got&#8221; l\u00e1tok, \u00e9s m\u00e9g t\u00f6bb &#8222;r\u00e9mt\u00f6rt\u00e9netet&#8221; hallok..)<\/p>\n<p>De sokszor m\u00e9g a rutinos felhaszn\u00e1l\u00f3k megold\u00e1sait is <strong>van hov\u00e1 egyszer\u0171s\u00edteni.<\/strong><\/p>\n<p>Ebben a cikkben \u00f6sszeszedtem a 3 legalapabb, &#8222;mindenkinek-tudnia-kell&#8221; funkci\u00f3kat: <a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#keplet\">Excel k\u00e9pletek \u00e9s sz\u00e1m\u00edt\u00e1sok<\/a>, <a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#rendezes\">Adatok sorba rendez\u00e9se<\/a> \u00e9s <a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#formazas\">Felt\u00e9teles form\u00e1z\u00e1s<\/a><\/p>\n<p>B\u00e1tran k\u00fcldd tov\u00e1bb, ha van olyan ismer\u0151s\u00f6d, akinek hasznos lehet.<\/p>\n<h2 id=\"keplet\">Excel k\u00e9pletek, matematikai sz\u00e1m\u00edt\u00e1sok<\/h2>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/calculator-2-1259849-m.jpg\"><img decoding=\"async\" class=\"wp-image-988 size-full alignright\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/calculator-2-1259849-m.jpg\" alt=\"Excel t\u00e1bl\u00e1zat haszn\u00e1lata sz\u00e1mol\u00f3g\u00e9pk\u00e9nt k\u00e9pletekkel\" width=\"300\" height=\"201\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/calculator-2-1259849-m.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/calculator-2-1259849-m-240x160.jpg 240w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>Az Excel \u00fagy m\u0171k\u00f6dik mint egy sz\u00e1mol\u00f3g\u00e9p!<\/p>\n<p><em>(M\u00e9gis vannak, akik ink\u00e1bb k\u00fcl\u00f6n sz\u00e1molnak, \u00e9s csak a v\u00e9geredm\u00e9nyt \u00edrj\u00e1k be a megfelel\u0151 Excel cell\u00e1ba.)<\/em><\/p>\n<p><strong>Gyorsan \u00e9s pontosan tud sz\u00e1molni<\/strong>, s\u0151t, m\u00e9g a m\u0171veletek sorrendj\u00e9t is ismeri!<\/p>\n<p>Ha sz\u00e1moln\u00e1l vele, egyszer\u0171en kezdd = vagy + jellel \u00e9s \u00edrd be ugyan\u00fagy a sz\u00e1m\u00edt\u00e1st, mint egy sz\u00e1mol\u00f3g\u00e9pe. (Ezt h\u00edvjuk\u00a0<strong>k\u00e9pletnek<\/strong>.)<\/p>\n<pre>Mondjuk h\u00e1ny n\u00e9gyzetm\u00e9ter lamin\u00e1lt padl\u00f3 kell a 2 szob\u00e1ba:\r\n =3,5*4,2+3,8*3,6\r\n Az Enter ut\u00e1n m\u00e1r meg is jelenik a v\u00e9geredm\u00e9ny: 28,38<\/pre>\n<p>Egy fokkal praktikusabb, ha ink\u00e1bb a &#8222;cell\u00e1kkal sz\u00e1molsz&#8221; (ezt h\u00edvj\u00e1k az Excelben <strong>hivatkoz\u00e1snak<\/strong>).<\/p>\n<pre>Ha a p\u00e9ld\u00e1ul a k\u00e9szletedet k\u00f6veted nyomon, ahol B2 \r\na nyit\u00f3 \u00e9rt\u00e9k, C2 a beszerz\u00e9s \u00e9s D2 az elad\u00e1s, akkor \r\nezt \u00e9rdemes be\u00edrnod:\r\n=B2+C2-D2<\/pre>\n<p><strong>A hivatkoz\u00e1s 2 legnagyobb el\u0151nye<\/strong>, hogy<\/p>\n<ul>\n<li>\u00e1t\u00edrva a cell\u00e1kban a sz\u00e1mokat, mindig naprak\u00e9sz eredm\u00e9nyt mutat a k\u00e9plet,<\/li>\n<li>illetve lem\u00e1solva egy m\u00e1sik sorba ott is megism\u00e9tli a sz\u00e1mol\u00e1st.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignleft wp-image-433 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg\" alt=\"Excel t\u00e1bl\u00e1zat haszn\u00e1lata f\u00fcggv\u00e9nyekkel \" width=\"153\" height=\"160\" \/><\/p>\n<p>Az Excelben vannak <strong>el\u0151re gy\u00e1rtott f\u00fcggv\u00e9nyek<\/strong>, egy-egy konkr\u00e9t sz\u00e1m\u00edt\u00e1sra.<\/p>\n<p>A legismertebb a SZUM (angolul SUM), amely a kijel\u00f6lt sz\u00e1mokat egyes\u00e9vel \u00f6sszeadja.<\/p>\n<p>Vagy hasonl\u00f3 f\u00fcggv\u00e9ny az \u00c1TLAG (angolul AVERAGE), amely a\u00a0kijel\u00f6lt sz\u00e1mok matematikai \u00e1tlag\u00e1t adja eredm\u00e9ny\u00fcl: azaz \u00f6sszead\u00e1s ut\u00e1n elosztja a darabsz\u00e1mmal.<\/p>\n<pre>P\u00e9ld\u00e1ul nem kell be\u00edrnod:\r\n =F2+F3+F4+F5+F6+F7+F8+F9+F10\r\n\r\nHanem helyette gyorsabb f\u00fcggv\u00e9nnyel:\r\n =SZUM(F2:F10)<\/pre>\n<p>Beg\u00e9pel\u00e9s helyett haszn\u00e1lhatod a men\u00fc jobb sz\u00e9l\u00e9n tal\u00e1lhat\u00f3\u00a0AutoSzum gombot, amely \u00f6szt\u00f6n\u00f6sen ki is jel\u00f6li a k\u00e9plet f\u00f6l\u00f6tt tal\u00e1lhat\u00f3 sz\u00e1mokat.<\/p>\n<pre>Ha szeretn\u00e9l t\u00f6bbet tudni, olvasd el ezeket a cikkeket is:\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\">Hogyan \u00edrj k\u00e9pleteket az Excelben?<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/gyorsabb-kepletezes\/\">Gyorsabb k\u00e9pletez\u00e9s: itt is haszn\u00e1lj billenty\u0171zetet!<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-muveletek-sorrendje-es-mikor-kell-zarojelet-hasznalni\/\">Mi a m\u0171veletek sorrendje, \u00e9s mikor kell z\u00e1r\u00f3jel?<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/mit-viszonyitsak-mihez-azaz-a-szazalekszamitas-buktatoi\/\">Mit viszony\u00edtsak mihez, azaz a sz\u00e1zal\u00e9ksz\u00e1m\u00edt\u00e1s buktat\u00f3i<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-feladat-megoldas-formazas-6\/\">Alap szint\u0171 Excel feladat megold\u00e1sa l\u00e9p\u00e9sr\u0151l-l\u00e9p\u00e9sre<\/a><\/pre>\n<h2 id=\"rendezes\">Adatok sorba rendez\u00e9se<\/h2>\n<p>Min\u00e9l t\u00f6bb adatod van, ann\u00e1l val\u00f3sz\u00edn\u0171bb, hogy m\u00e1s-m\u00e1s sorrendben szeretn\u00e9d id\u0151nk\u00e9nt list\u00e1zni \u0151ket. Mondjuk van egy vev\u0151list\u00e1d: egyszer id\u0151rendben szeretn\u00e9d l\u00e1tni a vev\u0151ket, m\u00e1skor a fizetett \u00f6sszeg szerint cs\u00f6kken\u0151 sorrendben (kik a legnagyobb vev\u0151k), megint m\u00e1skor meg n\u00e9vsorban.<\/p>\n<p>Szerencs\u00e9re nem kell minden alkalommal k\u00e9zzel \u00e1trendezned vagy \u00fajra \u00edrnod az adatokat <em>(igen, van, aki neki\u00e1ll ennek)<\/em>, hanem haszn\u00e1lhatod az Excel be\u00e9p\u00edtett funkci\u00f3j\u00e1t.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/01\/K\u00e9perny\u0151fot\u00f3-2017-01-07-1.17.40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-4709 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/01\/K\u00e9perny\u0151fot\u00f3-2017-01-07-1.17.40.png\" alt=\"A sorba rendez\u00e9s gyakran el\u0151fordul az Excel t\u00e1bl\u00e1zat haszn\u00e1lata k\u00f6zben\" width=\"238\" height=\"224\" \/><\/a>A sorba rendez\u00e9skor is okos az Excel, \u00e9s <strong>a teljes t\u00e1bl\u00e1zatot fogja &#8222;mozgatni&#8221;<\/strong>\u00a0&#8211; rekordonk\u00e9nt, azaz soronk\u00e9nt.<\/p>\n<p>\u00cdgy <strong>el\u00e9g abban az oszlopban\u00a0<span style=\"text-decoration: underline;\">egy adatot\u00a0kijel\u00f6lni<\/span>, amely szerint rendezni akarsz.<\/strong> (Ezt az Excel \u00fagy \u00e9rtelmezi, mintha kijel\u00f6lted volna a t\u00e1bl\u00e1zatodat.)<\/p>\n<p>A men\u00fc jobb sz\u00e9l\u00e9n az (AutoSzum mellett) keresd a Rendez\u00e9s \u00e9s sz\u0171r\u00e9s gombot, \u00e9s itt v\u00e1laszd az A-Z (N\u00f6vekv\u0151) vagy\u00a0Z-A (Cs\u00f6kken\u0151) parancsot.<\/p>\n<p>Ak\u00e1r t\u00f6bb ezer adatot is egy szempillant\u00e1s alatt \u00e1trendez az Excel.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Tipp:<\/strong><\/span>\u00a0ha sz\u00fcks\u00e9ged van az &#8222;eredeti&#8221; sorrendre is, akkor legyen egy sorsz\u00e1m oszlopod is, amely szerint b\u00e1rmikor visszarendezheted az adatokat.<\/p>\n<pre>Ha szeretn\u00e9l t\u00f6bbet tudni, olvasd el ezeket a cikkeket is:\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/hiba-sorba-rendezesnel-oszlopot-jelolsz-ki\/\">Hogyan kell az adatokat sorba rendezni?\r\n<\/a><a href=\"https:\/\/sosexcel.com\/exceltippek\/tobb-szempont-szerint-rendezni-az-adatokat\/\">Lehet-e egyszerre t\u00f6bb szempont szerint rendezni az adatokat?<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\">Hogyan tudsz napok szerint rendezni?<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-hasznald-szurest-az-informacio-kinyeresere\/\">Hogyan haszn\u00e1ld a sz\u0171r\u00e9st az inform\u00e1ci\u00f3 kinyer\u00e9s\u00e9re?<\/a><\/pre>\n<h2 id=\"formazas\">Felt\u00e9teles form\u00e1z\u00e1s<\/h2>\n<p>A felt\u00e9teles form\u00e1z\u00e1s egy szuper funkci\u00f3, hogy &#8222;\u00e9letre keltsd&#8221; az adataidat. R\u00e1ad\u00e1sul egyszer\u0171 is, \u00edgy ak\u00e1r \u00f6n\u00e1ll\u00f3an is felfedezheted!<\/p>\n<p><strong>Automatikusan be tudod vele sz\u00edneztetni a kiugr\u00f3, vagy sz\u00e1modra fontos \u00e9rt\u00e9keket<\/strong>, \u00edgy &#8222;r\u00e1n\u00e9z\u00e9sre&#8221; meg fogod tal\u00e1lni \u0151ket.\u00a0<em>(Vagyis nem kell mindig keresg\u00e9lni \u00e9s k\u00fcl\u00f6n szinezgetni a cell\u00e1kat.)<\/em><\/p>\n<p><strong><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-5554 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint.png\" alt=\"Felt\u00e9teles form\u00e1z\u00e1s az Excel t\u00e1bl\u00e1zat d\u00edsze\" width=\"766\" height=\"499\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint.png 766w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint-300x195.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint-660x430.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/felteteles-formazas-nagyobb-mint-240x156.png 240w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a>Egy dologra figyelj: el\u0151sz\u00f6r jel\u00f6ld ki a cell\u00e1kat, amiket sz\u00ednezni szeretn\u00e9l!\u00a0<\/strong><\/p>\n<p>B\u00e1tran n\u00e9zd v\u00e9gig a lehet\u0151s\u00e9geket!<\/p>\n<ul>\n<li>A Cellakijel\u00f6l\u00e9si szab\u00e1lyok \u00e9s a Legfels\u0151\/legals\u00f3 \u00e9rt\u00e9kek kateg\u00f3ri\u00e1k hasonl\u00f3 opci\u00f3kat k\u00edn\u00e1lnak, mint a sz\u0171r\u00e9s: csak itt elrejt\u00e9s-list\u00e1z\u00e1s helyett <strong>sz\u00ednekkel emelheted ki az \u00e9rt\u00e9keket.<\/strong><\/li>\n<li>Az Adats\u00e1vok, Sz\u00ednsk\u00e1l\u00e1k, Ikonk\u00e9szletek <strong>az \u00f6sszes adatot megjel\u00f6lik<\/strong>, \u00e9s azon bel\u00fcl alkalmaznak egyfajta &#8222;sk\u00e1l\u00e1z\u00e1st&#8221;, \u00edgy itt is egyb\u0151l megk\u00fcl\u00f6nb\u00f6ztethet\u0151ek az alacsony \u00e9s magas \u00e9rt\u00e9kek.<\/li>\n<\/ul>\n<p>Ha sz\u00fcks\u00e9ges, a szab\u00e1lyokat ut\u00f3lag is m\u00f3dos\u00edthatod, \u00e9s az egy\u00e9ni \u00edzl\u00e9sedre form\u00e1lhatod a sz\u00edneket \u00e9s felt\u00e9teleket is.<\/p>\n<pre>Ha szeretn\u00e9l t\u00f6bbet tudni, olvasd el ezeket a cikkeket is:\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/felteteles-formazas-szovegek-alapjan\/\">Felt\u00e9teles form\u00e1z\u00e1s \u2013 sz\u00f6vegek alapj\u00e1n<\/a>\r\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/ismetlodo-ertekek\/\">\u00cdgy tal\u00e1lhatod meg hamar az ism\u00e9tl\u0151d\u0151 \u00e9rt\u00e9keket<\/a><\/pre>\n<h2>Excel t\u00e1bl\u00e1zat haszn\u00e1lata rutinosabban<\/h2>\n<p>Itt is igaz, hogy a gyakorlat teszi a mestert. Teh\u00e1t nem el\u00e9g olvasgatni az Excelr\u0151l, hanem \u00e1t kell \u00fcltetni a gyakorlatba.<\/p>\n<p>Folyamatosan fejleszd magad, \u00e9s ha r\u00e1j\u00f6ssz, hogy esetleg eddig valamit nem j\u00f3l csin\u00e1lt\u00e1l, akkor figyelj oda \u00e9s jav\u00edtsd ki magad.<\/p>\n<p>Ha szeretn\u00e9l konkr\u00e9t gyakorl\u00f3 feladatokat, <strong>\u00e9s szem\u00e9lyre szabott tippeket kapni, <\/strong>akkor gyere el (vagy k\u00fcldd el a munkat\u00e1rsaidat) egy <a href=\"http:\/\/exceltitok.hu\/arak\" target=\"_blank\" rel=\"noopener noreferrer\">egy\u00e9ni Excel tanfolyam<\/a>ra!<\/p>\n\n<blockquote class=\"wp-embedded-content\" data-secret=\"DWJZ0DuOcA\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-feladat-megoldas-formazas-6\/\">Alap szint\u0171 Excel feladat megold\u00e1sa l\u00e9p\u00e9sr\u0151l-l\u00e9p\u00e9sre<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Alap szint\u0171 Excel feladat megold\u00e1sa l\u00e9p\u00e9sr\u0151l-l\u00e9p\u00e9sre&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/excel-feladat-megoldas-formazas-6\/embed\/#?secret=9allPWddWg#?secret=DWJZ0DuOcA\" data-secret=\"DWJZ0DuOcA\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hJnEtjFiUW\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-fajl-bezarasa\/\">Hogyan z\u00e1rod be az Excel f\u00e1jlokat?<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Hogyan z\u00e1rod be az Excel f\u00e1jlokat?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/excel-fajl-bezarasa\/embed\/#?secret=wt0bho9VTi#?secret=hJnEtjFiUW\" data-secret=\"hJnEtjFiUW\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, \u00edgy egyre fontosabb, hogy a\u00a0napi munk\u00e1t megk\u00f6nny\u00edt\u0151 funkci\u00f3kat minden felhaszn\u00e1l\u00f3 ismerje. Aki m\u00e1r rutinosan haszn\u00e1lja ezeket, tal\u00e1n el sem tudja k\u00e9pzelni, hogy l\u00e9teznek olyanok, akik m\u00e9g nem tudj\u00e1k.\u00a0<\/p>\n","protected":false},"author":1,"featured_media":5719,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[19,58,75,35],"class_list":["post-5456","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-formazas","tag-kezdoknek","tag-rendezes","tag-szamolas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, ezeket az alap funkci\u00f3kat musz\u00e1j ismerni: Excel sz\u00e1m\u00edt\u00e1sok, Adatok sorba rendez\u00e9se \u00e9s Felt\u00e9teles form\u00e1z\u00e1s\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Ebben a cikkben \u00f6sszeszedtem a 3 legalapabb, napi munk\u00e1t megk\u00f6nny\u00edt\u0151, \u201cmindenkinek-tudnia-kell\u201d funkci\u00f3t: - Excel k\u00e9pletek \u00e9s sz\u00e1m\u00edt\u00e1sok, - Adatok sorba rendez\u00e9se \u00e9s - Felt\u00e9teles form\u00e1z\u00e1s\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-20T06:51:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-06-27T10:44:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/3-funkcio-Excel-tablazat-hasznalata.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"788\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene\",\"datePublished\":\"2017-09-20T06:51:16+00:00\",\"dateModified\":\"2018-06-27T10:44:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\"},\"wordCount\":917,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png\",\"keywords\":[\"form\u00e1z\u00e1s\",\"kezd\u0151knek\",\"rendez\u00e9s\",\"sz\u00e1mol\u00e1s\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\",\"name\":\"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png\",\"datePublished\":\"2017-09-20T06:51:16+00:00\",\"dateModified\":\"2018-06-27T10:44:09+00:00\",\"description\":\"Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, ezeket az alap funkci\u00f3kat musz\u00e1j ismerni: Excel sz\u00e1m\u00edt\u00e1sok, Adatok sorba rendez\u00e9se \u00e9s Felt\u00e9teles form\u00e1z\u00e1s\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png\",\"width\":1200,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, ezeket az alap funkci\u00f3kat musz\u00e1j ismerni: Excel sz\u00e1m\u00edt\u00e1sok, Adatok sorba rendez\u00e9se \u00e9s Felt\u00e9teles form\u00e1z\u00e1s","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:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/","og_locale":"hu_HU","og_type":"article","og_title":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Ebben a cikkben \u00f6sszeszedtem a 3 legalapabb, napi munk\u00e1t megk\u00f6nny\u00edt\u0151, \u201cmindenkinek-tudnia-kell\u201d funkci\u00f3t: - Excel k\u00e9pletek \u00e9s sz\u00e1m\u00edt\u00e1sok, - Adatok sorba rendez\u00e9se \u00e9s - Felt\u00e9teles form\u00e1z\u00e1s","og_url":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2017-09-20T06:51:16+00:00","article_modified_time":"2018-06-27T10:44:09+00:00","og_image":[{"width":940,"height":788,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/3-funkcio-Excel-tablazat-hasznalata.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"6 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene","datePublished":"2017-09-20T06:51:16+00:00","dateModified":"2018-06-27T10:44:09+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/"},"wordCount":917,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png","keywords":["form\u00e1z\u00e1s","kezd\u0151knek","rendez\u00e9s","sz\u00e1mol\u00e1s"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/","url":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/","name":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png","datePublished":"2017-09-20T06:51:16+00:00","dateModified":"2018-06-27T10:44:09+00:00","description":"Az Excel t\u00e1bl\u00e1zat haszn\u00e1lata egyre elterjedtebb, ezeket az alap funkci\u00f3kat musz\u00e1j ismerni: Excel sz\u00e1m\u00edt\u00e1sok, Adatok sorba rendez\u00e9se \u00e9s Felt\u00e9teles form\u00e1z\u00e1s","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/08\/3-Excel-funkcio-amit-ismerni-kell.png","width":1200,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"3 Excel funkci\u00f3, amit mindenkinek ismernie kellene"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=5456"}],"version-history":[{"count":19,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5456\/revisions"}],"predecessor-version":[{"id":6660,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5456\/revisions\/6660"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/5719"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}