{"id":9296,"date":"2021-11-18T09:04:00","date_gmt":"2021-11-18T08:04:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=9296"},"modified":"2021-11-18T17:20:18","modified_gmt":"2021-11-18T16:20:18","slug":"nem-szamolnak-a-kepletek","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/","title":{"rendered":"Nem sz\u00e1molnak a k\u00e9pletek – Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt"},"content":{"rendered":"\n

Veled t\u00f6rt\u00e9nt m\u00e1r olyan, hogy nem sz\u00e1molnak a k\u00e9pletek, \u00e9s az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke jelent meg? A duplakattos tr\u00fckk\u00f6ket<\/a><\/span> osztottam meg, mikor T\u00fcnde r\u00e1k\u00e9rdezett a k\u00f6vetkez\u0151re:<\/p>\n\n\n\n

K\u00e9rd\u00e9s<\/strong>: A duplakattot rendszeresen haszn\u00e1lom, de tegnap az egyik t\u00e1bl\u00e1mn\u00e1l olyat tapasztaltam, mint eddig soha: duplakattal lem\u00e1soltam a k\u00e9pletet a teljes oszlopra, a m\u0171velet siker\u00fclt, de az oszlop \u00f6sszes cell\u00e1j\u00e1ban az els\u0151 cella \u00e9rt\u00e9ke maradt<\/strong>. Ha F2-vel bel\u00e9ptem a cell\u00e1kba<\/a><\/span> \u00e9s Entert nyomtam, megjelent a helyes \u00e9rt\u00e9k. Ez vajon mi lehetett? \ud83d\ude14 van erre megold\u00e0s?<\/p>\n\n\n\n

V\u00e1lasz<\/strong>: Val\u00f3sz\u00edn\u0171leg a K\u00e9pletek f\u00fcl\u00f6n ki van kapcsolva az automatikus sz\u00e1mol\u00e1s. Akkor szoktak ilyet tenni, mikor sok k\u00e9plet van a t\u00e1bl\u00e1zatban, \u00e9s nagyon belassul t\u0151le a f\u00e1jl. A K\u00e9pletek\/Sz\u00e1mol\u00e1si be\u00e1ll\u00edt\u00e1sok parancsn\u00e1l \u00e1ll\u00edtsd vissza ‘Automatikus’-ra:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Szerencs\u00e9re val\u00f3ban ez volt a hiba oka, \u00edgy gyorsan meg is old\u00f3dott.<\/p>\n\n\n\n

\u00dajrasz\u00e1mol\u00e1s Manu\u00e1lis m\u00f3dban<\/h2>\n\n\n\n

Ha valami miatt az Automatikus sz\u00e1mol\u00e1si m\u00f3d helyett m\u00e9gis a Manu\u00e1lis m\u00f3dot v\u00e1lasztod, akkor a k\u00f6vetkez\u0151 3 lehet\u0151s\u00e9ged van a k\u00e9pletek kisz\u00e1moltat\u00e1s\u00e1ra:<\/p>\n\n\n\n

  1. A Sz\u00e1mol\u00e1si be\u00e1ll\u00edt\u00e1sok mellett 2 m\u00e1sik ikont is l\u00e1tsz. A fels\u0151 (sz\u00e1mol\u00f3g\u00e9p) a teljes munkaf\u00fczetet \u00fajrasz\u00e1molja, az als\u00f3 ikon csak az adott munkalapot.<\/li>
  2. Billenty\u0171kombin\u00e1ci\u00f3t is haszn\u00e1lhatsz, a teljes f\u00e1jlt az F9 funkci\u00f3gomb kalkul\u00e1lja \u00fajra, m\u00edg az adott f\u00fclet a Shift F9 kombin\u00e1ci\u00f3.<\/li>
  3. Ha v\u00e1ltoznak a k\u00e9pletek, vagy a hivatkozott cell\u00e1k tartalma, akkor a f\u00fclek alatt megjelenik a ‘Sz\u00e1mol\u00e1s’ felirat. Ha erre kattintasz, az is minden k\u00e9pletet \u00fajrasz\u00e1mol.<\/li><\/ol>\n\n\n\n
    \"\"<\/a><\/figure><\/div>\n\n\n\n

    Szeretn\u00e9l t\u00f6bbet tudni az Excelr\u0151l?<\/h2>\n\n\n\n

    Ha szorgalmas vagy \u00e9s szeretsz k\u00f6nyvb\u0151l tanulni, akkor rendeld meg az Excel Kezd\u0151 & Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong><\/span>.<\/p>\n\n\n\n

    Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/span><\/strong>!<\/p>\n\n\n\n

    Ha egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk egy\u00e9ni Excel oktat\u00e1sra<\/a><\/span><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Veled t\u00f6rt\u00e9nt m\u00e1r olyan, hogy nem sz\u00e1molnak a k\u00e9pletek, \u00e9s az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke jelent meg? A duplakattos tr\u00fckk\u00f6ket osztottam meg, mikor T\u00fcnde r\u00e1k\u00e9rdezett a k\u00f6vetkez\u0151re: K\u00e9rd\u00e9s: A duplakattot rendszeresen haszn\u00e1lom, de tegnap az egyik t\u00e1bl\u00e1mn\u00e1l olyat tapasztaltam, mint eddig soha: duplakattal lem\u00e1soltam a k\u00e9pletet a teljes oszlopra, a m\u0171velet siker\u00fclt, de az […]<\/p>\n","protected":false},"author":1,"featured_media":9308,"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":"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":[],"class_list":["post-9296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"\nNem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - 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\/nem-szamolnak-a-kepletek\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Veled t\u00f6rt\u00e9nt m\u00e1r olyan, hogy nem sz\u00e1molnak a k\u00e9pletek, \u00e9s az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke jelent meg? A duplakattos tr\u00fckk\u00f6ket osztottam meg, mikor T\u00fcnde r\u00e1k\u00e9rdezett a k\u00f6vetkez\u0151re: K\u00e9rd\u00e9s: A duplakattot rendszeresen haszn\u00e1lom, de tegnap az egyik t\u00e1bl\u00e1mn\u00e1l olyat tapasztaltam, mint eddig soha: duplakattal lem\u00e1soltam a k\u00e9pletet a teljes oszlopra, a m\u0171velet siker\u00fclt, de az […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/\" \/>\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=\"2021-11-18T08:04:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-18T16:20:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Nem sz\u00e1molnak a k\u00e9pletek – Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt\",\"datePublished\":\"2021-11-18T08:04:00+00:00\",\"dateModified\":\"2021-11-18T16:20:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/\"},\"wordCount\":423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/nem_szamolnak_a_kepletek.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/\",\"name\":\"Nem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/nem_szamolnak_a_kepletek.png\",\"datePublished\":\"2021-11-18T08:04:00+00:00\",\"dateModified\":\"2021-11-18T16:20:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/nem_szamolnak_a_kepletek.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/nem_szamolnak_a_kepletek.png\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/nem-szamolnak-a-kepletek\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nem sz\u00e1molnak a k\u00e9pletek – Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt\"}]},{\"@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":"Nem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - 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\/nem-szamolnak-a-kepletek\/","og_locale":"hu_HU","og_type":"article","og_title":"Nem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Veled t\u00f6rt\u00e9nt m\u00e1r olyan, hogy nem sz\u00e1molnak a k\u00e9pletek, \u00e9s az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke jelent meg? A duplakattos tr\u00fckk\u00f6ket osztottam meg, mikor T\u00fcnde r\u00e1k\u00e9rdezett a k\u00f6vetkez\u0151re: K\u00e9rd\u00e9s: A duplakattot rendszeresen haszn\u00e1lom, de tegnap az egyik t\u00e1bl\u00e1mn\u00e1l olyat tapasztaltam, mint eddig soha: duplakattal lem\u00e1soltam a k\u00e9pletet a teljes oszlopra, a m\u0171velet siker\u00fclt, de az […]","og_url":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2021-11-18T08:04:00+00:00","article_modified_time":"2021-11-18T16:20:18+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png","type":"image\/png"}],"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\/nem-szamolnak-a-kepletek\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Nem sz\u00e1molnak a k\u00e9pletek – Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt","datePublished":"2021-11-18T08:04:00+00:00","dateModified":"2021-11-18T16:20:18+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/"},"wordCount":423,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/","url":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/","name":"Nem sz\u00e1molnak a k\u00e9pletek - Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png","datePublished":"2021-11-18T08:04:00+00:00","dateModified":"2021-11-18T16:20:18+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/nem_szamolnak_a_kepletek.png","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/nem-szamolnak-a-kepletek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Nem sz\u00e1molnak a k\u00e9pletek – Az \u00f6sszes cell\u00e1ba az els\u0151 cella \u00e9rt\u00e9ke ker\u00fclt"}]},{"@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\/9296","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=9296"}],"version-history":[{"count":3,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9296\/revisions"}],"predecessor-version":[{"id":9307,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9296\/revisions\/9307"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9308"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}