{"id":986,"date":"2014-08-07T12:13:48","date_gmt":"2014-08-07T10:13:48","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=986"},"modified":"2020-01-21T21:22:54","modified_gmt":"2020-01-21T20:22:54","slug":"villamgyors-szamolas-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/","title":{"rendered":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben"},"content":{"rendered":"<p>Az Excel legfontosabb tulajdons\u00e1ga az okoss\u00e1ga mellett a <strong>gyorsas\u00e1g<\/strong>. Ha egyszer elk\u00e9sz\u00fcl egy t\u00e1bl\u00e1zat, benne a megfelel\u0151 f\u00fcggv\u00e9nyekkel \u00e9s \u00f6sszes\u00edt\u0151 sorokkal, m\u00e1r csak be kell \u00edrni az \u00faj adatokat, \u00e9s m\u00e1ris kisz\u00e1molta a k\u00edv\u00e1nt v\u00e9geredm\u00e9nyt ez az okos kis tal\u00e1lm\u00e1ny.<\/p>\n<p>Csak gondolj bele, mennyit nyomkodhatn\u00e1d a sz\u00e1mol\u00f3g\u00e9pet, ha nem l\u00e9tezne az Excel!<\/p>\n<h3>Lehet a gyors Excel m\u00e9g gyorsabb?<\/h3>\n<p><!--more--><\/p>\n<p>Van n\u00e9h\u00e1ny olyan funkci\u00f3, amely m\u00e9g a gyorsat is gyorsabb\u00e1 teszi. Egyik kedvencem ezek k\u00f6z\u00fcl, amikor egy nagyobb t\u00e1bl\u00e1zatban szeretn\u00e9k r\u00e9szsz\u00e1m\u00edt\u00e1sokat v\u00e9gezni, de nincs kedvem emiatt k\u00fcl\u00f6n sort besz\u00farni \u00e9s szumm\u00e1t haszn\u00e1lni. S\u0151t, nem is akarom elt\u00e1rolni az adott r\u00e9szeredm\u00e9nyt, csak gyorsan meg akarom n\u00e9zni az \u00f6sszeget.<\/p>\n<p><strong>Erre van egy vill\u00e1mgyors megold\u00e1s:<\/strong>\u00a0Jel\u00f6ld ki az \u00f6sszeadand\u00f3 cell\u00e1kat\u00a0(ha egym\u00e1st\u00f3l t\u00e1volabb vannak, akkor a\u00a0<a title=\"Turb\u00f3zd fel az egeret!\" href=\"https:\/\/sosexcel.com\/exceltippek\/turbozd-fel-az-egeret\/\" target=\"_blank\" rel=\"noopener\">Ctrl seg\u00edts\u00e9g\u00e9vel<\/a>), \u00e9s alul, a sz\u00fcrke inform\u00e1ci\u00f3s cs\u00edkon olvasd le az adatokat:<\/p>\n<ul>\n<li><span style=\"line-height: 16px;\">az adott sz\u00e1mok \u00e1tlaga,<\/span><\/li>\n<li>a kijel\u00f6l\u00e9sben szerepl\u0151 nem \u00fcres cell\u00e1k sz\u00e1ma,<\/li>\n<li>az \u00f6sszeg (\u00e1ltal\u00e1ban ez kell).<\/li>\n<\/ul>\n<p>A gyorsas\u00e1ga miatt <strong>gyors \u00e9rt\u00e9k<\/strong>nek nevezik ezt a funkci\u00f3t.<\/p>\n<p>Ak\u00e1r a minimum\/maximum \u00e9rt\u00e9ket is kiteheted a &#8222;list\u00e1ba&#8221;. Ehhez kattints valamelyik \u00e9rt\u00e9ken a jobb eg\u00e9r gombbal.<\/p>\n<h3><span style=\"line-height: 27.428571701049805px;\">Mikor praktikus ez a megold\u00e1s? <\/span><\/h3>\n<p><span style=\"line-height: 27.428571701049805px;\"><a title=\"5 tipp, amit okvetlen\u00fcl tarts be adatt\u00e1bl\u00e1k k\u00e9sz\u00edt\u00e9sekor\" href=\"https:\/\/sosexcel.com\/exceltippek\/5-tipp-amit-okvetlenul-tarts-be-adattablak-keszitesekor\/\" target=\"_blank\" rel=\"noopener\">Nagyon nagy t\u00e1bl\u00e1zatok<\/a> eset\u00e9n okvetlen\u00fcl, hiszen ott nem praktikus a hossz\u00fa list\u00e1t megszak\u00edtani sz\u00e1mol\u00e1sokkal, hiszen senki nem fogja k\u00e9s\u0151bb megtal\u00e1lni ezeket az \u00e9rt\u00e9keket.\u00a0Jobban j\u00e1rsz, ha ink\u00e1bb k\u00fcl\u00f6n f\u00fcl\u00f6n k\u00e9sz\u00edtesz \u00f6sszes\u00edt\u00e9st.<\/span><\/p>\n<p>Kisebb t\u00e1bl\u00e1zatokn\u00e1l\u00a0m\u00e1r lehet \u00e9rtelme plusz sorokat\u00a0<a title=\"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?\" href=\"https:\/\/sosexcel.com\/exceltippek\/honnan-tudhatod-hogy-hova-kerul-beszurt-oszlop\/\" target=\"_blank\" rel=\"noopener\">besz\u00farni<\/a>, \u00e9s ott sz\u00e1molni a k\u00e9pletek seg\u00edts\u00e9g\u00e9vel.<\/p>\n<p><span style=\"line-height: 27.428571701049805px;\">Azonban sokszor el\u00e9g csak a megfelel\u0151 cell\u00e1kat, vagy a sz\u00e1mokat tartalmaz\u00f3 teljes oszlopot kijel\u00f6ln\u00f6d, \u00e9s m\u00e1ris megvan a keresett adat. Arra is kiv\u00e1l\u00f3, hogy gyorsan ellen\u0151rizd magad, ha m\u00e9gis k\u00e9pleteket haszn\u00e1lt\u00e1l az Excel t\u00e1bl\u00e1ban.<\/span><\/p>\n<figure id=\"attachment_987\" aria-describedby=\"caption-attachment-987\" style=\"width: 300px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-987 \" style=\"border: 1px solid grey;\" title=\"Excel t\u00e1bl\u00e1zat\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg\" alt=\"Gyors Excel \u00f6sszes\u00edt\u00e9s\" width=\"300\" height=\"252\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-240x202.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors.jpg 376w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-987\" class=\"wp-caption-text\">Rezsi \u00f6sszes\u00edt\u00e9s<\/figcaption><\/figure>\n<p><strong>\u00cdme egy p\u00e9lda:<\/strong> ebben a t\u00e1bl\u00e1zatban a havi kiad\u00e1sok szerepelnek. J\u00f3 lenne megtudni, hogy \u00f6sszesen mennyi a rezsi \u00f6sszege janu\u00e1rban.<\/p>\n<p>A megfelel\u0151 <a title=\"Turb\u00f3zd fel az egeret!\" href=\"https:\/\/sosexcel.com\/exceltippek\/turbozd-fel-az-egeret\/\" target=\"_blank\" rel=\"noopener\">cell\u00e1k Ctrl-lal t\u00f6rt\u00e9n\u0151 kijel\u00f6l\u00e9se<\/a> ut\u00e1n m\u00e1ris l\u00e1that\u00f3 az \u00f6sszeg.<\/p>\n<p>(Persze egy igazi kiad\u00e1s-bev\u00e9teli t\u00e1bl\u00e1zatnak nem \u00edgy kellene kin\u00e9znie)<\/p>\n<p><strong>Fontos!<\/strong> A gyors \u00e9rt\u00e9k csak akkor jelenik meg, ha legal\u00e1bb 2 nem \u00fcres cell\u00e1t tartalmaz a kijel\u00f6l\u00e9sed.<\/p>\n<pre>Szoktad haszn\u00e1lni a gyors \u00e9rt\u00e9ket?\n<strong>\u00cdrd meg a tapasztalataidat a hozz\u00e1sz\u00f3l\u00e1sok k\u00f6z\u00f6tt!<\/strong><\/pre>\n<p><strong><a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\" rel=\"noopener\">Tov\u00e1bbi hasznos tippek\u00e9rt rendeld meg a 111 Hasznos Excel Tipp kiadv\u00e1nyt<\/a>\u00a0vagy jelentkezz\u00a0<a title=\"Excel mag\u00e1n\u00f3r\u00e1k\" href=\"http:\/\/exceltitok.hu\/\" target=\"_blank\" rel=\"noopener\">Excel mag\u00e1n\u00f3r\u00e1ra!<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az Excel legfontosabb tulajdons\u00e1ga az okoss\u00e1ga mellett a gyorsas\u00e1g. Ha egyszer elk\u00e9sz\u00fcl egy t\u00e1bl\u00e1zat, benne a megfelel\u0151 f\u00fcggv\u00e9nyekkel \u00e9s \u00f6sszes\u00edt\u0151 sorokkal, m\u00e1r csak be kell \u00edrni az \u00faj adatokat, \u00e9s m\u00e1ris kisz\u00e1molta a k\u00edv\u00e1nt v\u00e9geredm\u00e9nyt ez az okos kis tal\u00e1lm\u00e1ny. Csak gondolj bele, mennyit nyomkodhatn\u00e1d a sz\u00e1mol\u00f3g\u00e9pet, ha nem l\u00e9tezne az Excel! Lehet a gyors [&hellip;]<\/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":"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":"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":[5,1],"tags":[18],"class_list":["post-986","post","type-post","status-publish","format-standard","hentry","category-erdekessegek","category-excel-tippek-gyakori-kerdesek","tag-sporolj-kattintast"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?\" \/>\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\/villamgyors-szamolas-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/\" \/>\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=\"2014-08-07T10:13:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-21T20:22:54+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.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=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben\",\"datePublished\":\"2014-08-07T10:13:48+00:00\",\"dateModified\":\"2020-01-21T20:22:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/\"},\"wordCount\":498,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/gyors-300x252.jpg\",\"keywords\":[\"sp\u00f3rolj kattint\u00e1st\"],\"articleSection\":[\"\u00c9rdekess\u00e9gek\",\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/\",\"name\":\"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/gyors-300x252.jpg\",\"datePublished\":\"2014-08-07T10:13:48+00:00\",\"dateModified\":\"2020-01-21T20:22:54+00:00\",\"description\":\"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/gyors-300x252.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/gyors-300x252.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/villamgyors-szamolas-excelben\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben\"}]},{\"@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":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?","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\/villamgyors-szamolas-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?","og_url":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2014-08-07T10:13:48+00:00","article_modified_time":"2020-01-21T20:22:54+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben","datePublished":"2014-08-07T10:13:48+00:00","dateModified":"2020-01-21T20:22:54+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/"},"wordCount":498,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg","keywords":["sp\u00f3rolj kattint\u00e1st"],"articleSection":["\u00c9rdekess\u00e9gek","Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/","name":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg","datePublished":"2014-08-07T10:13:48+00:00","dateModified":"2020-01-21T20:22:54+00:00","description":"Hogyan tudsz vill\u00e1mgyorsan r\u00e9sz\u00f6sszeget, \u00e1tlagot sz\u00e1molni Excelben?","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/02\/gyors-300x252.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/villamgyors-szamolas-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Vill\u00e1mgyors sz\u00e1mol\u00e1s Excelben"}]},{"@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\/986","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=986"}],"version-history":[{"count":15,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/986\/revisions"}],"predecessor-version":[{"id":8445,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/986\/revisions\/8445"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}