{"id":8772,"date":"2020-06-16T17:22:18","date_gmt":"2020-06-16T15:22:18","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=8772"},"modified":"2025-05-28T11:32:18","modified_gmt":"2025-05-28T09:32:18","slug":"miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/","title":{"rendered":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat?"},"content":{"rendered":"\n<p>Ma m\u00e1r nem vita, a vil\u00e1g az adatokr\u00f3l sz\u00f3l, <a rel=\"noreferrer noopener\" aria-label=\"a big data kora van (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/big-data-robotok-merre-tart-vilag\/\" target=\"_blank\">a big data kora van<\/a>, \u00e9s minden c\u00e9g rengeteg adattal rendelkezik. Ezeket az adatokat valahogy t\u00e1rolni kell, \u00fagy, hogy abb\u00f3l b\u00e1rmikor k\u00f6nnyen kinyerj\u00fck az adatokat. <\/p>\n\n\n\n<p>K\u00e9t f\u0151 ir\u00e1nyzat l\u00e9tezik: <strong>az egyik a v\u00e9geredm\u00e9ny fel\u0151l k\u00f6zel\u00edt,<\/strong> hogyan lesz k\u00f6nnyen \u00e9rtelmezhet\u0151 az adat. <strong>A m\u00e1sik a t\u00e1rol\u00e1st optimaliz\u00e1lja<\/strong>, \u00e9s c\u00e9lja, hogy k\u00f6nnyen elemezhet\u0151, \u00f6sszehasonl\u00edthat\u00f3 legyen az adat &#8211; ez\u00e9rt ink\u00e1bb list\u00e1kban (adatb\u00e1zisban) gy\u0171jti az adatokat.<\/p>\n\n\n\n<p>N\u00e9zd meg a vide\u00f3ban r\u00e9szletesebben, vagy olvasd tov\u00e1bb a cikket:<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/SG0OZL0O67M\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e1trix, a \u201cr\u00e9gi m\u00f3dszer\u201d&nbsp;<\/h2>\n\n\n\n<p>Sok helyen l\u00e1tom, hogy <a rel=\"noreferrer noopener\" aria-label=\"m\u00e1trixos rendszerbe (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/exceltitok.hu\/matrix-az-excelben\/\" target=\"_blank\">m\u00e1trixos rendszerbe<\/a> r\u00f6gz\u00edtik az adatokat. <strong>El\u0151nye, hogy k\u00f6nnyen \u00e9rtelmezhet\u0151ek az adatok, egyb\u0151l leolvashat\u00f3ak a r\u00e9sz\u00f6sszegek. <\/strong>P\u00e9ld\u00e1ul melyik term\u00e9kb\u0151l mennyi az \u00e9rt\u00e9kes\u00edt\u00e9s az egyes r\u00e9gi\u00f3kban, de a konkr\u00e9t kombin\u00e1ci\u00f3k (pl. \u00c9szak-Alf\u00f6ld, monitor: 87) is k\u00f6nnyen megtal\u00e1lhat\u00f3.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2020\/06\/matrix-excel-tabla.png\" alt=\"\" class=\"wp-image-5409\"\/><\/figure>\n\n\n\n<p><strong>K\u00e9t szempont kit\u0171n\u0151en elf\u00e9r a k\u00e9t tengelyen<\/strong>, \u00e9s val\u00f3ban megk\u00f6nny\u00edti az adatok \u00e9rtelmez\u00e9s\u00e9t. <\/p>\n\n\n\n<p>Ha azonban t\u00f6bb csoportos\u00edt\u00e1si-sz\u0171r\u00e9si szempont van, p\u00e9ld\u00e1ul valamilyen id\u0151t is hozz\u00e1rendelnek az adatokhoz, az m\u00e1r nem f\u00e9r ki a t\u00e1bl\u00e1zatba. Ez\u00e9rt logikusan az Excel f\u00fclek lesznek h\u00f3napok vagy a negyed\u00e9vek. Esetleg m\u00e9g egy szempont bej\u00f6het, \u00e9s az alapj\u00e1n k\u00fcl\u00f6n Excelekbe ker\u00fclnek az adatok, de egyre nehezebb lesz \u00e1tl\u00e1tni \u0151ket.<\/p>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background\">Ennek persze sz\u00e1mtalan verzi\u00f3ja van. P\u00e9ld\u00e1ul az \u00e9rt\u00e9kes\u00edt\u0151k k\u00fcl\u00f6n f\u00fcl\u00f6n vezetik a napi adataikat, vagy a partnerekt\u0151l kapott \u00e1rlist\u00e1k foglalj\u00e1k el a k\u00fcl\u00f6n f\u00fcleket.<\/p>\n\n\n\n<p>Amikor valahogy \u00f6sszes\u00edteni kell a f\u00fclek vagy f\u00e1jlok k\u00f6z\u00f6tt, akkor m\u00e1r nagyon kaotikus \u00e9s <strong>k\u00f6vethetetlen lesz a sz\u00e9tsz\u00f3rt adattenger.<\/strong><\/p>\n\n\n\n<p>Ez\u00e9rt fontos, hogy m\u00e1r az elej\u00e9t\u0151l adatb\u00e1zisban gondolkozunk \u00e9s a kezdetekt\u0151l adatb\u00e1zisokat gy\u0171jts\u00fcnk.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mit jelent az adatb\u00e1zis?&nbsp;<\/h2>\n\n\n\n<p>Azt jelenti, hogy az elemi adatokat (azaz rekordokat) egy sorban r\u00f6gz\u00edtj\u00fck. P\u00e9ld\u00e1ul \u00c9szak-Alf\u00f6ld, monitor elad\u00e1s 87 db.<\/p>\n\n\n\n<figure class=\"wp-block-image alignleft is-resized\"><img decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2020\/06\/adatbazis_adatgyujtes.png\" alt=\"\" class=\"wp-image-5410\" style=\"width:405px;height:250px\"\/><\/figure>\n\n\n\n<p>Az oszlopokat nevezem el (R\u00e9gi\u00f3, Term\u00e9k, Darabsz\u00e1m).<\/p>\n\n\n\n<p>El\u0151nye, hogy lefel\u00e9 \u00e9s oldalra is <strong>korl\u00e1tlanul b\u0151v\u00edthet\u0151<\/strong>. \u00cdgy nem kell azon gondolkodni, hogy hov\u00e1 f\u00e9rnek el az \u00faj dimenzi\u00f3k, hiszen csak egy \u00faj oszlopot kell besz\u00farni.<\/p>\n\n\n\n<p>P\u00e9ld\u00e1ul r\u00f6gt\u00f6n beker\u00fclhet \u00faj oszlopba az \u00e9v, ak\u00e1r a konkr\u00e9t nap is, az \u00e9rt\u00e9kes\u00edt\u0151, s\u0151t, ak\u00e1r az \u00fcgyf\u00e9l neve is. Teh\u00e1t eleve sokkal <strong>r\u00e9szletesebben gy\u0171jthet\u0151ek (elemezhet\u0151ek) az adatok.<\/strong> \u00cdgy ak\u00e1r \u00e9vekre visszamen\u0151leg l\u00e1thatom, hogy ki-mikor-kinek-mit adott el.<\/p>\n\n\n\n<p>M\u00e1r a <a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-hasznald-szurest-az-informacio-kinyeresere\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"sz\u0171r\u0151vel (\u00faj f\u00fcl\u00f6n nyitja meg)\">sz\u0171r\u0151vel<\/a>, <a rel=\"noreferrer noopener\" aria-label=\"szeletel\u0151vel (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-szeletelo\/\" target=\"_blank\">szeletel\u0151vel<\/a> is rengeteg inform\u00e1ci\u00f3 kiolvashat\u00f3 a t\u00e1bl\u00e1zatokb\u00f3l.<\/p>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background\"><strong>Ezt a 2 dolgot mindenk\u00e9ppen ker\u00fcld:<\/strong> t\u00f6bbsoros fejl\u00e9cek \u00e9s egyes\u00edtett cell\u00e1k. Ha teheted, haszn\u00e1ld a <a rel=\"noreferrer noopener\" aria-label=\"T\u00e1bl\u00e1zat form\u00e1tumot! (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/formazas-tablazatkent\/\" target=\"_blank\">T\u00e1bl\u00e1zat form\u00e1tumot!<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">R\u00e9gi adatok \u00e1talak\u00edt\u00e1sa adatb\u00e1ziss\u00e1<\/h2>\n\n\n\n<p>A &#8222;rossz form\u00e1ban&#8221; r\u00f6gz\u00edtett adat is jobb, mintha semmilyen adat sem lenne. <\/p>\n\n\n\n<p>Alapvet\u0151en azt aj\u00e1nlom, hogy<strong> kezdj tiszta lappal egy \u00faj t\u00e1bl\u00e1zatot<\/strong>, \u00e9s innent\u0151l abban gy\u0171jtsed az adatokat. A r\u00e9gi adatok \u00e1temel\u00e9s\u00e9hez b\u00e1tran k\u00e9rj  seg\u00edts\u00e9get &#8211; <a href=\"https:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\" rel=\"noreferrer noopener\">egy\u00e9ni oktat\u00e1s keret\u00e9ben <\/a>megoldjuk -, szerencs\u00e9re m\u00e1r rengeteg modern eszk\u00f6zt k\u00edn\u00e1l erre is az Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Adatelemz\u00e9s j\u00e1tszva a pivot t\u00e1bl\u00e1val<\/h2>\n\n\n\n<p>Ha j\u00f3k az adataid, akkor p\u00e1r kattint\u00e1ssal tetsz\u00e9s szerinti <a href=\"https:\/\/exceltitok.hu\/kimutatas-keszites-covid-adatokkal\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u00f6sszes\u00edt\u0151 t\u00e1bl\u00e1zatokat k\u00e9sz\u00edthetsz<\/a>. Ha m\u00e9g nem l\u00e1ttad a fenti vide\u00f3t, akkor<a href=\"https:\/\/www.youtube.com\/watch?v=SG0OZL0O67M&amp;t=282s\"> legal\u00e1bb ezt a r\u00e9szt n\u00e9zd meg<\/a>. <\/p>\n\n\n\n<figure class=\"wp-block-image alignleft is-resized\"><img decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2020\/06\/iranyitopult-pivot-tabla-1024x858.jpg\" alt=\"\" class=\"wp-image-5422\" style=\"width:344px;height:288px\"\/><\/figure>\n\n\n\n<p>Persze a legjobb, ha elj\u00f6ssz egy <a rel=\"noreferrer noopener\" aria-label=\"Adatelemz\u00e9s - pivot t\u00e1bla workshopra (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/exceltitok.hu\/adatok-hatekony-menedzselese\/\" target=\"_blank\">Adatelemz\u00e9s &#8211; pivot t\u00e1bla workshopra<\/a>, ahol alaposan begyakorolhatod, hogy mi mindenre j\u00f3 a <a href=\"https:\/\/www.youtube.com\/watch?v=O1bV6gQiei0\" target=\"_blank\" rel=\"noreferrer noopener\">Kimutat\u00e1sk\u00e9sz\u00edt\u00e9s<\/a>, \u00e9s hogyan tudsz komplett m\u0171szerfalakat k\u00e9sz\u00edteni.<\/p>\n\n\n\n<p>Komplett <a href=\"https:\/\/exceltitok.hu\/iranyitopult-excel-pivot-tablaval\/\">ir\u00e1ny\u00edt\u00f3pultokat k\u00e9sz\u00edthetsz<\/a>, ahol a <a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-szeletelo\/\">szeletel\u0151k<\/a> seg\u00edts\u00e9g\u00e9vel egyszerre sz\u0171rhetsz t\u00f6bb t\u00e1bl\u00e1zatra, diagramra, \u00edgy elemezve a konkr\u00e9t term\u00e9keket \/ r\u00e9gi\u00f3kat, vagy amit \u00e9ppen szeretn\u00e9l.<\/p>\n\n\n\n<p>\u00cdgy j\u00e1t\u00e9k lesz az adatok elemz\u00e9se. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">B\u0151vebben az adatokr\u00f3l<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/hiba-sorba-rendezesnel-oszlopot-jelolsz-ki\/\" target=\"_blank\" rel=\"noreferrer noopener\">Hogyan kell az adatokat sorba rendezni?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-hasznald-szurest-az-informacio-kinyeresere\/\" target=\"_blank\" rel=\"noreferrer noopener\">Hogyan haszn\u00e1ld a sz\u0171r\u00e9st az inform\u00e1ci\u00f3 kinyer\u00e9s\u00e9re?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/tobb-szempont-szerint-rendezni-az-adatokat\/\" target=\"_blank\" rel=\"noreferrer noopener\">Lehet-e egyszerre t\u00f6bb szempont szerint rendezni az adatokat?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/kereses-excelben-es-mashol\/\" target=\"_blank\" rel=\"noreferrer noopener\">3 tipp az Excel keres\u00e9shez<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-hasznald-szurest-az-informacio-kinyeresere\/\" target=\"_blank\" rel=\"noreferrer noopener\">Hogyan haszn\u00e1ld a sz\u0171r\u00e9st az inform\u00e1ci\u00f3 kinyer\u00e9s\u00e9re?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/szures-gyorsan-szuro-hasznalata-nelkul\/\" target=\"_blank\" rel=\"noreferrer noopener\">Sz\u0171r\u00e9s gyorsan \u2013 a sz\u0171r\u0151 haszn\u00e1lata n\u00e9lk\u00fcl<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/exceltitok.hu\/5-szuro-trukk\/\" target=\"_blank\" rel=\"noreferrer noopener\">Ismered ezt az 5 sz\u0171r\u0151 tr\u00fckk\u00f6t?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-szeletelo\/\">Excel szeletel\u0151 \u2013 egyszer\u0171bb sz\u0171r\u00e9s<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/exceltitok.hu\/kimutatas-keszites-covid-adatokkal\/\" target=\"_blank\" rel=\"noreferrer noopener\">Kimutat\u00e1s k\u00e9sz\u00edt\u00e9s COVID adatokkal<\/a><\/li>\n<\/ul>\n\n\n\n<figure><iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/SB7xCRkDZac\" allowfullscreen=\"\"><\/iframe><\/figure>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">L\u00e1thatatlan adatkincs vezet\u0151knek: Fedezd fel, mennyi \u00e9rt\u00e9kes adattal rendelkezel!<\/h2>\n\n\n\n<p>Minden v\u00e1llalkoz\u00e1s rengeteg \u00e9rt\u00e9kes adatot halmoz fel nap mint nap \u2013 sz\u00e1ml\u00e1k, \u00fcgyf\u00e9ladatok, term\u00e9kinform\u00e1ci\u00f3k, elad\u00e1si statisztik\u00e1k \u2013&nbsp;<strong>de a legt\u00f6bben nem tudj\u00e1k, hogyan hasznos\u00edts\u00e1k ezt a kincset.<\/strong><\/p>\n\n\n\n<p>Ne k\u00f6lts sz\u00e1zezreket extra szoftverekre! A megold\u00e1s m\u00e1r ott van a g\u00e9peden: az EXCEL! Ez nem a \u201ekock\u00e1s f\u00fczet\u201d Excel, amit egykor megismert\u00e9l. A modern Excel olyan fejlett eszk\u00f6z\u00f6kkel rendelkezik, mint a&nbsp;<strong>Power Query \u00e9s Pivot t\u00e1bla, amelyekkel:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-media-text is-stacked-on-mobile\" style=\"grid-template-columns:39% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2019\/08\/rendszerezett-adatok-adatelemzes.png\" alt=\"\" class=\"wp-image-4271 size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<ul class=\"wp-block-list\">\n<li>Pillanatok alatt rendszerezheted az adat\u00f6z\u00f6nt<\/li>\n\n\n\n<li><strong>Automatiz\u00e1lhatod az ism\u00e9tl\u0151d\u0151 feladatokat<\/strong><\/li>\n\n\n\n<li>Gombnyom\u00e1sra friss\u00edthet\u0151 riportokat k\u00e9sz\u00edthetsz<\/li>\n\n\n\n<li>\u00c1tl\u00e1thatod v\u00e1llalkoz\u00e1sod val\u00f3di teljes\u00edtm\u00e9ny\u00e9t<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>\u201eDe ez biztosan bonyolult\u2026\u201d \u2013 gondolod most. Pedig nem kell programoz\u00f3i tud\u00e1s vagy IT szak\u00e9rtelem! El\u0151ad\u00e1sunkon megmutatjuk, hogyan saj\u00e1t\u00edthatja el b\u00e1rki ezeket az Excel-k\u00e9pess\u00e9geket, f\u00fcggetlen\u00fcl az informatikai el\u0151k\u00e9pzetts\u00e9gt\u0151l.<\/p>\n\n\n\n<p><strong>K\u00e9rd el a d\u00edjmentes el\u0151ad\u00e1sunk felv\u00e9tel\u00e9t,<\/strong>&nbsp;\u00e9s gy\u0151z\u0151dj meg r\u00f3la, milyen automatiz\u00e1lt rendszereket hozhatsz l\u00e9tre az Excellel:<\/p>\n\n\n\n<iframe\n  src=\"https:\/\/link.ugyfelszerzes.hu\/widget\/form\/bQ30pVq6DpccMRWKo52r\"\n  style=\"width:100%;height:100%;border:none;border-radius:3px\"\n  id=\"inline-bQ30pVq6DpccMRWKo52r\" \n  data-layout=\"{'id':'INLINE'}\"\n  data-trigger-type=\"alwaysShow\"\n  data-trigger-value=\"\"\n  data-activation-type=\"alwaysActivated\"\n  data-activation-value=\"\"\n  data-deactivation-type=\"neverDeactivate\"\n  data-deactivation-value=\"\"\n  data-form-name=\"Excel Vezet\u0151 Webinar 20250526\"\n  data-height=\"432\"\n  data-layout-iframe-id=\"inline-bQ30pVq6DpccMRWKo52r\"\n  data-form-id=\"bQ30pVq6DpccMRWKo52r\"\n  title=\"Excel Vezet\u0151 Webinar 20250526\"\n      >\n<\/iframe>\n<script src=\"https:\/\/link.ugyfelszerzes.hu\/js\/form_embed.js\"><\/script>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat-1024x576.png\" alt=\"\" class=\"wp-image-9956\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat-1024x576.png 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat-300x169.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat-768x432.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/06\/Automatizalt-adat-folyamat.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Ma m\u00e1r nem vita, a vil\u00e1g az adatokr\u00f3l sz\u00f3l, a big data kora van, \u00e9s minden c\u00e9g rengeteg adattal rendelkezik. Ezeket az adatokat valahogy t\u00e1rolni kell, \u00fagy, hogy abb\u00f3l b\u00e1rmikor k\u00f6nnyen kinyerj\u00fck az adatokat. K\u00e9t f\u0151 ir\u00e1nyzat l\u00e9tezik: az egyik a v\u00e9geredm\u00e9ny fel\u0151l k\u00f6zel\u00edt, hogyan lesz k\u00f6nnyen \u00e9rtelmezhet\u0151 az adat. A m\u00e1sik a t\u00e1rol\u00e1st optimaliz\u00e1lja, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8774,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","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":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","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":[102,1],"tags":[],"class_list":["post-8772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\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\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Ma m\u00e1r nem vita, a vil\u00e1g az adatokr\u00f3l sz\u00f3l, a big data kora van, \u00e9s minden c\u00e9g rengeteg adattal rendelkezik. Ezeket az adatokat valahogy t\u00e1rolni kell, \u00fagy, hogy abb\u00f3l b\u00e1rmikor k\u00f6nnyen kinyerj\u00fck az adatokat. K\u00e9t f\u0151 ir\u00e1nyzat l\u00e9tezik: az egyik a v\u00e9geredm\u00e9ny fel\u0151l k\u00f6zel\u00edt, hogyan lesz k\u00f6nnyen \u00e9rtelmezhet\u0151 az adat. A m\u00e1sik a t\u00e1rol\u00e1st optimaliz\u00e1lja, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/\" \/>\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=\"2020-06-16T15:22:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-28T09:32:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\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=\"5 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat?\",\"datePublished\":\"2020-06-16T15:22:18+00:00\",\"dateModified\":\"2025-05-28T09:32:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/\"},\"wordCount\":1073,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/matrix_vagy_lista.png\",\"articleSection\":[\"Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se\",\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/\",\"name\":\"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/matrix_vagy_lista.png\",\"datePublished\":\"2020-06-16T15:22:18+00:00\",\"dateModified\":\"2025-05-28T09:32:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/matrix_vagy_lista.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/matrix_vagy_lista.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat?\"}]},{\"@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":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","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\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/","og_locale":"hu_HU","og_type":"article","og_title":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Ma m\u00e1r nem vita, a vil\u00e1g az adatokr\u00f3l sz\u00f3l, a big data kora van, \u00e9s minden c\u00e9g rengeteg adattal rendelkezik. Ezeket az adatokat valahogy t\u00e1rolni kell, \u00fagy, hogy abb\u00f3l b\u00e1rmikor k\u00f6nnyen kinyerj\u00fck az adatokat. K\u00e9t f\u0151 ir\u00e1nyzat l\u00e9tezik: az egyik a v\u00e9geredm\u00e9ny fel\u0151l k\u00f6zel\u00edt, hogyan lesz k\u00f6nnyen \u00e9rtelmezhet\u0151 az adat. A m\u00e1sik a t\u00e1rol\u00e1st optimaliz\u00e1lja, [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2020-06-16T15:22:18+00:00","article_modified_time":"2025-05-28T09:32:18+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"5 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat?","datePublished":"2020-06-16T15:22:18+00:00","dateModified":"2025-05-28T09:32:18+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/"},"wordCount":1073,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png","articleSection":["Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se","Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/","url":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/","name":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png","datePublished":"2020-06-16T15:22:18+00:00","dateModified":"2025-05-28T09:32:18+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/06\/matrix_vagy_lista.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/miert-nem-mindegy-hogy-hogyan-gyujtod-az-adatokat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Mi\u00e9rt nem mindegy, hogy hogyan gy\u0171jt\u00f6d az adatokat?"}]},{"@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\/8772","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=8772"}],"version-history":[{"count":6,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/8772\/revisions"}],"predecessor-version":[{"id":9958,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/8772\/revisions\/9958"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/8774"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=8772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=8772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=8772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}