{"id":421,"date":"2013-11-04T14:22:49","date_gmt":"2013-11-04T13:22:49","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=421"},"modified":"2019-04-02T15:29:14","modified_gmt":"2019-04-02T13:29:14","slug":"rossz-helyre-teszed-a-szummat","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/","title":{"rendered":"Rossz helyre teszed a Szumm\u00e1t"},"content":{"rendered":"<p>Sokakn\u00e1l l\u00e1tom, hogy szumm\u00e1z\u00e1sn\u00e1l megszok\u00e1sb\u00f3l kijel\u00f6lik az \u00f6sszeadand\u00f3 adatokat, \u00e9s csak ut\u00e1na nyomj\u00e1k meg az AutoSzum gombot.<\/p>\n<p>Elvileg m\u0171k\u00f6d\u0151k\u00e9pes a m\u00f3dszer, de az\u00e9rt rejteget hib\u00e1kat. P\u00e9ld\u00e1ul ha nem figyelsz, m\u00e1sol\u00e1sn\u00e1l a teljes kijel\u00f6l\u00e9st &#8222;viszed&#8221;, nem csak a k\u00e9pletet.<!--more--><\/p>\n<p>Vagy mi van, ha nem k\u00f6zvetlen\u00fcl a sz\u00e1msor v\u00e9g\u00e9n van sz\u00fcks\u00e9ged az eredm\u00e9nyre?<\/p>\n<h3>Hogyan szumm\u00e1zz, vagy \u00edrj be egy f\u00fcggv\u00e9nyt az Excelbe?<\/h3>\n<p>A be\u00edr\u00e1s logik\u00e1ja mindig az, hogy <strong>azt a cell\u00e1t jel\u00f6l\u00f6d ki, ahov\u00e1 \u00edrni akarsz<\/strong>. P\u00e9ld\u00e1ul az A2-re kattintasz, \u00e9s be\u00edrod, hogy Alma. Ut\u00e1na a B2-re, \u00e9s be\u00edrod, hogy 15.<\/p>\n<p>Ugyan\u00edgy m\u0171k\u00f6dik ez a Szumm\u00e1val \u00e9s a t\u00f6bbi <a href=\"https:\/\/sosexcel.com\/exceltippek\/fuggvenyek-olyanok-mint-az-automatak\/\" target=\"_blank\" rel=\"noopener\">f\u00fcggv\u00e9nnyel<\/a>\u00a0is:\u00a0azt a cell\u00e1t jel\u00f6ld ki, ahov\u00e1 a v\u00e9geredm\u00e9nyt akarod kapni. Ez a hely jellemz\u0151en az adatsor v\u00e9g\u00e9n szokott lenni.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg\"><img decoding=\"async\" class=\"alignleft wp-image-433 size-full\" style=\"border: 1px solid grey;\" title=\"AutoSzum\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg\" alt=\"A Szumma villog\u00f3 kerete mutatja a kijel\u00f6lt sz\u00e1mokat.\" width=\"153\" height=\"160\" \/><\/a><\/p>\n<p>Ezut\u00e1n kattints a men\u00fcsor jobb v\u00e9g\u00e9n tal\u00e1lhat\u00f3 Autoszum gombra.<\/p>\n<p>Az Excel megpr\u00f3b\u00e1lja kital\u00e1lni, hogy mely sz\u00e1mokat szeretn\u00e9d \u00f6sszes\u00edteni, \u00e9s mag\u00e1t\u00f3l megkeresi a legk\u00f6zelebbi \u00e9rt\u00e9keket.<\/p>\n<p>Mivel val\u00f3sz\u00edn\u0171leg a\u00a0m\u00e1r be vannak \u00edrva a t\u00e1bl\u00e1zatba,\u00a0ez\u00e9rt kijel\u00f6li a k\u00e9plet felett, vagy t\u0151le balra tal\u00e1lhat\u00f3 sz\u00e1mokat.<\/p>\n<p>Ha a villog\u00f3 keret j\u00f3 helyen van, neked csak az <strong>Entert<\/strong> kell megnyomnod, hogy r\u00f6gz\u00edtsd a k\u00e9pletet.<\/p>\n<p>Ha azonban szeretn\u00e9l m\u00f3dos\u00edtani a kijel\u00f6l\u00e9sen (vagy nincs is kijel\u00f6l\u00e9s, mert t\u00e1volabbi helyre sz\u00fartad be a k\u00e9pletet), akkor az eg\u00e9rrel ugyan\u00fagy jel\u00f6ld ki a cell\u00e1kat, mintha pl. form\u00e1zni akarn\u00e1d.<\/p>\n<p>Vigy\u00e1zz, mert a program az \u00e9vsz\u00e1mokat is sz\u00e1mnak n\u00e9zi, \u00e9s bele akarja venni az \u00f6sszes\u00edt\u00e9sbe. Ilyenkor mindenk\u00e9pp m\u00f3dos\u00edtsd a kijel\u00f6l\u00e9st.<\/p>\n<p>Ha t\u00e9nyleg sorokat \u00e9s oszlopokat kell \u00f6sszes\u00edtened, haszn\u00e1lhatod <a title=\"Gyors \u00f6sszes\u00edt\u00e9s\" href=\"https:\/\/sosexcel.com\/exceltippek\/gyors-osszesites\/\">ezt az egyszer\u0171s\u00edt\u00e9st<\/a>.<\/p>\n<p>Ha szeretn\u00e9d jobban \u00e9rteni az Excelt, akkor <a href=\"http:\/\/exceltitok.hu\/excel-alapok\/\">kezdd az alapokkal<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sokakn\u00e1l l\u00e1tom, hogy szumm\u00e1z\u00e1sn\u00e1l megszok\u00e1sb\u00f3l kijel\u00f6lik az \u00f6sszeadand\u00f3 adatokat, \u00e9s csak ut\u00e1na nyomj\u00e1k meg az AutoSzum gombot. Elvileg m\u0171k\u00f6d\u0151k\u00e9pes a m\u00f3dszer, de az\u00e9rt rejteget hib\u00e1kat. P\u00e9ld\u00e1ul ha nem figyelsz, m\u00e1sol\u00e1sn\u00e1l a teljes kijel\u00f6l\u00e9st &#8222;viszed&#8221;, nem csak a k\u00e9pletet.<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[102,4],"tags":[28],"class_list":["post-421","post","type-post","status-publish","format-standard","hentry","category-excel-tablazat-keszitese","category-gyakori-hibak","tag-fuggveny"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!\" \/>\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\/rossz-helyre-teszed-a-szummat\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/\" \/>\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=\"2013-11-04T13:22:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-02T13:29:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Rossz helyre teszed a Szumm\u00e1t\",\"datePublished\":\"2013-11-04T13:22:49+00:00\",\"dateModified\":\"2019-04-02T13:29:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/\"},\"wordCount\":380,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/autoszum.jpg\",\"keywords\":[\"f\u00fcggv\u00e9ny\"],\"articleSection\":[\"Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se\",\"Gyakori hib\u00e1k\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/\",\"name\":\"Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/autoszum.jpg\",\"datePublished\":\"2013-11-04T13:22:49+00:00\",\"dateModified\":\"2019-04-02T13:29:14+00:00\",\"description\":\"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/autoszum.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/11\\\/autoszum.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/rossz-helyre-teszed-a-szummat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rossz helyre teszed a Szumm\u00e1t\"}]},{\"@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":"Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!","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\/rossz-helyre-teszed-a-szummat\/","og_locale":"hu_HU","og_type":"article","og_title":"Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!","og_url":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-11-04T13:22:49+00:00","article_modified_time":"2019-04-02T13:29:14+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Rossz helyre teszed a Szumm\u00e1t","datePublished":"2013-11-04T13:22:49+00:00","dateModified":"2019-04-02T13:29:14+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/"},"wordCount":380,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg","keywords":["f\u00fcggv\u00e9ny"],"articleSection":["Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se","Gyakori hib\u00e1k"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/","url":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/","name":"Rossz helyre teszed a Szumm\u00e1t - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg","datePublished":"2013-11-04T13:22:49+00:00","dateModified":"2019-04-02T13:29:14+00:00","description":"Hogyan haszn\u00e1ld a Szumm\u00e1t? Ismerd meg a legegyszer\u0171bb m\u00f3dszert a sok szumm\u00e1z\u00e1si lehet\u0151s\u00e9g k\u00f6z\u00fcl!","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/11\/autoszum.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Rossz helyre teszed a Szumm\u00e1t"}]},{"@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\/421","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=421"}],"version-history":[{"count":9,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":7427,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/421\/revisions\/7427"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}