{"id":9832,"date":"2024-01-06T12:57:00","date_gmt":"2024-01-06T11:57:00","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=9832"},"modified":"2024-01-08T22:59:59","modified_gmt":"2024-01-08T21:59:59","slug":"2024-buek","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/","title":{"rendered":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">2024 egy k\u00fcl\u00f6nleges sz\u00e1m, nem csoda, hogy rengeteg vicces-\u00e9rdekes M\u00c9M jelenik meg \u00edgy \u00e9v elej\u00e9n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nekem ez a kedvencem, ugyanis az Excellel k\u00f6nnyen kisz\u00e1m\u00edthat\u00f3\/ellen\u0151rizhet\u0151:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=SZUM(HATV\u00c1NY(SORSZ\u00c1MLISTA(8;;2);3))<br>Angolul: =SUM(POWER(SEQUENCE(8,,2),3))<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1000\" height=\"1000\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png\" alt=\"\" class=\"wp-image-9835\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png 1000w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24-300x300.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24-150x150.png 150w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24-768x768.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24-75x75.png 75w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">L\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A <strong>SORSZ\u00c1MLISTA<\/strong>(8;;2) felsorolja a sz\u00e1mokat: 2-vel kezd\u0151d\u0151en 8 db-t. J\u00f6v\u0151re az 1-9 hez el\u00e9g lesz ennyi: SORSZ\u00c1MLISTA(9) ugyanis az az alap\u00e9rtelmezett, hogy 1-gyel kezd, \u00e9s 1-gyel n\u00f6vekszenek a sz\u00e1mok. (Ez egy viszonylag \u00faj f\u00fcggv\u00e9ny az Excelben. Haszn\u00e1lhatod, ha nincs kedved sorozatokat g\u00e9pelni.)<br><br>A <strong>HATV\u00c1NY<\/strong>(X;3) az X-t k\u00f6bre, vagyis a 3. hatv\u00e1nyra emeli. Ebben a k\u00e9pletben az el\u0151bb megadott 8 sz\u00e1mot k\u00fcl\u00f6n-k\u00fcl\u00f6n.<br><br>A <strong>SZUM<\/strong> pedig \u00f6sszeadja a tagokat.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ismerd meg jobban az Excelt<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Min\u00e9l t\u00f6bbet haszn\u00e1lod az Excelt saj\u00e1t c\u00e9lra, ann\u00e1l jobban megszereted. \u00cdme p\u00e1r \u00f6tlet:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>K\u00e9sz\u00edts 2024-es napt\u00e1rt saj\u00e1t magad az Excelben<\/li><li>Tartsd nyilv\u00e1n a <a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/3-tipp-az-excel-koltsegvetes-vezetesehez\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/3-tipp-az-excel-koltsegvetes-vezetesehez\/\" target=\"_blank\">kiad\u00e1sokat \u00e9s a p\u00e9nz\u00fcgyeidet Excelben<\/a><\/li><li>Vezesd a hobbiddal, \u00e9rdekl\u0151d\u00e9seddel kapcsolatos adatokat Excelben<\/li><li>Gondoltad volna, hogy <a href=\"https:\/\/sosexcel.com\/exceltippek\/hany-zeneszt-ihletett-meg-az-excel\/\" data-type=\"post\" data-id=\"3483\">a zen\u00e9szeket is megihleti az Excel<\/a>? <\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Legyen felfedez\u00e9sekkel \u00e9s tanul\u00e1ssal teli a 2024 \u00e9ved! B\u00da\u00c9K! \ud83c\udf7e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9rdekes p\u00e9ld\u00e1kon kereszt\u00fcl k\u00f6nnyen megbar\u00e1tkozhatsz az Excellel! \ud83d\ude42 Tanuljunk \u00e9l\u0151ben, k\u00f6z\u00f6sen &#8211; a Teamsen! <strong>Gyere csoportos tanfolyamainkra!<\/strong> Online, \u00e9l\u0151 csoportok, hogy val\u00f3ban testre-szabottan tudj haladni! Jelentkezz most, hogy 2024-ben ne okozzon fejf\u00e1j\u00e1st az Excel:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udc9a az 5 alkalmasra, ha stabil alaptud\u00e1s kell: <a href=\"https:\/\/exceltitok.hu\/stabil-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/stabil-excel\/<\/a><br>\ud83d\udc9a a 9 alkalmasra, ha eg\u00e9szen halad\u00f3 szintig szeretn\u00e9l jutni: <a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/kezdo-halado\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>FIGYELEM!<\/strong>\u00a0A 9 \u00e9s az 5 alkalmas\u00a0tanfolyamok \u00e1tfed\u00e9sben vannak egym\u00e1ssal. \u00cdgy ak\u00e1r a saj\u00e1t temp\u00f3dban k\u00fcl\u00f6n is v\u00e9gezheted a kezd\u0151 \u00e9s a halad\u00f3 r\u00e9szt.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ha \u00e1tfog\u00f3 tud\u00e1st szeretn\u00e9l, de nem tudod, hogyan kezdd a tanul\u00e1st<\/strong>, akkor az Excel Tank\u00f6nyvvel mindig k\u00e9zn\u00e9l lesz a seg\u00edts\u00e9g. Rendelj magadnak egyet ingyenes sz\u00e1ll\u00edt\u00e1ssal: <a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-tankonyv\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">M\u00e1r szem\u00e9lyesen is beszerezheted a 1126 Budapest, B\u00f6sz\u00f6rm\u00e9nyi \u00fat 5\/a. c\u00edmen tal\u00e1lhat\u00f3 Irodaszerszalonban. Nyitvatart\u00e1s: H-Cs: 8.30 \u2013 17.00 \u00e9s P: 8.30 \u2013 15.30 k\u00f6z\u00f6tt.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>2024 egy k\u00fcl\u00f6nleges sz\u00e1m, nem csoda, hogy rengeteg vicces-\u00e9rdekes M\u00c9M jelenik meg \u00edgy \u00e9v elej\u00e9n. Nekem ez a kedvencem, ugyanis az Excellel k\u00f6nnyen kisz\u00e1m\u00edthat\u00f3\/ellen\u0151rizhet\u0151: =SZUM(HATV\u00c1NY(SORSZ\u00c1MLISTA(8;;2);3))Angolul: =SUM(POWER(SEQUENCE(8,,2),3)) L\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre A SORSZ\u00c1MLISTA(8;;2) felsorolja a sz\u00e1mokat: 2-vel kezd\u0151d\u0151en 8 db-t. J\u00f6v\u0151re az 1-9 hez el\u00e9g lesz ennyi: SORSZ\u00c1MLISTA(9) ugyanis az az alap\u00e9rtelmezett, hogy 1-gyel kezd, \u00e9s 1-gyel n\u00f6vekszenek [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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-9832","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - 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\/2024-buek\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"2024 egy k\u00fcl\u00f6nleges sz\u00e1m, nem csoda, hogy rengeteg vicces-\u00e9rdekes M\u00c9M jelenik meg \u00edgy \u00e9v elej\u00e9n. Nekem ez a kedvencem, ugyanis az Excellel k\u00f6nnyen kisz\u00e1m\u00edthat\u00f3\/ellen\u0151rizhet\u0151: =SZUM(HATV\u00c1NY(SORSZ\u00c1MLISTA(8;;2);3))Angolul: =SUM(POWER(SEQUENCE(8,,2),3)) L\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre A SORSZ\u00c1MLISTA(8;;2) felsorolja a sz\u00e1mokat: 2-vel kezd\u0151d\u0151en 8 db-t. J\u00f6v\u0151re az 1-9 hez el\u00e9g lesz ennyi: SORSZ\u00c1MLISTA(9) ugyanis az az alap\u00e9rtelmezett, hogy 1-gyel kezd, \u00e9s 1-gyel n\u00f6vekszenek [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/\" \/>\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=\"2024-01-06T11:57:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-08T21:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.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\\\/2024-buek\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K!\",\"datePublished\":\"2024-01-06T11:57:00+00:00\",\"dateModified\":\"2024-01-08T21:59:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/\"},\"wordCount\":395,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/Buek24.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/\",\"name\":\"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/Buek24.png\",\"datePublished\":\"2024-01-06T11:57:00+00:00\",\"dateModified\":\"2024-01-08T21:59:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/Buek24.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/Buek24.png\",\"width\":1000,\"height\":1000},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/2024-buek\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K!\"}]},{\"@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":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - 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\/2024-buek\/","og_locale":"hu_HU","og_type":"article","og_title":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"2024 egy k\u00fcl\u00f6nleges sz\u00e1m, nem csoda, hogy rengeteg vicces-\u00e9rdekes M\u00c9M jelenik meg \u00edgy \u00e9v elej\u00e9n. Nekem ez a kedvencem, ugyanis az Excellel k\u00f6nnyen kisz\u00e1m\u00edthat\u00f3\/ellen\u0151rizhet\u0151: =SZUM(HATV\u00c1NY(SORSZ\u00c1MLISTA(8;;2);3))Angolul: =SUM(POWER(SEQUENCE(8,,2),3)) L\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre A SORSZ\u00c1MLISTA(8;;2) felsorolja a sz\u00e1mokat: 2-vel kezd\u0151d\u0151en 8 db-t. J\u00f6v\u0151re az 1-9 hez el\u00e9g lesz ennyi: SORSZ\u00c1MLISTA(9) ugyanis az az alap\u00e9rtelmezett, hogy 1-gyel kezd, \u00e9s 1-gyel n\u00f6vekszenek [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2024-01-06T11:57:00+00:00","article_modified_time":"2024-01-08T21:59:59+00:00","og_image":[{"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png","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\/2024-buek\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K!","datePublished":"2024-01-06T11:57:00+00:00","dateModified":"2024-01-08T21:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/"},"wordCount":395,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/","url":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/","name":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png","datePublished":"2024-01-06T11:57:00+00:00","dateModified":"2024-01-08T21:59:59+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/2024-buek\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2024\/01\/Buek24.png","width":1000,"height":1000},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/2024-buek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Ez\u00e9rt k\u00fcl\u00f6nleges \u00e9v a 2024 \ud83e\udd42 B\u00da\u00c9K!"}]},{"@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\/9832","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=9832"}],"version-history":[{"count":4,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9832\/revisions"}],"predecessor-version":[{"id":9839,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9832\/revisions\/9839"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}