{"id":9706,"date":"2023-03-15T11:19:45","date_gmt":"2023-03-15T10:19:45","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=9706"},"modified":"2023-03-15T23:57:25","modified_gmt":"2023-03-15T22:57:25","slug":"jeles-napok-az-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/","title":{"rendered":"Jeles napok az Excelben"},"content":{"rendered":"\n

Jeles nap a mai (2023.03.15) az Excelben! \u00cdrd be egy Excel cell\u00e1ba a mai d\u00e1tumot, \u00e9s n\u00e9zz m\u00f6g\u00e9! Sz\u00e1mk\u00e9nt form\u00e1zva a 45000-t fogod l\u00e1tni. Haszn\u00e1lhatod a MA() f\u00fcggv\u00e9nyt, vagy magyar Windows g\u00e9peken a Ctrl 0 (nulla!) billenty\u0171kombin\u00e1ci\u00f3t. Ha k\u00e9s\u0151bb akarod kipr\u00f3b\u00e1lni, akkor \u00edgy tudsz gyorsan d\u00e1tumokat r\u00f6gz\u00edteni az Excelbe<\/a>.<\/p>\n\n\n\n

2023.\u00a0m\u00e1rcius 15-\u00e9n\u00a0\u00e9rte\u00a0el az Excel „d\u00e1tum-sz\u00e1ml\u00e1l\u00f3ja” a 45\u00a0ezret!\u00a0<\/strong>Vagyis 1900. janu\u00e1r 1-t\u0151l sz\u00e1molva 45 ezer nap telt el. (Illetve eg\u00e9szen pontosan holnap (m\u00e1rcius 16-\u00e1n lesz a 45 ezredik nap, mivel az Excel is hib\u00e1zott, \u00e9s van benne egy sz\u00f6k\u0151\u00e9v hiba<\/a>.)<\/p>\n\n\n\n

Sz\u00e1mok \u00e9s d\u00e1tumok<\/h2>\n\n\n\n

A kezd\u0151ket rendszeresen megt\u00e9veszti, hogy be\u00edrt sz\u00e1m d\u00e1tumk\u00e9nt jelenik meg az Excelben, vagy ford\u00edtva: egy d\u00e1tum sz\u00e1mk\u00e9nt. Pedig ez csak form\u00e1z\u00e1s k\u00e9rd\u00e9se, amit a Cellaform\u00e1z\u00e1s (Ctrl 1) men\u00fcben lehet be\u00e1ll\u00edtani. Az egys\u00e9ges kezel\u00e9s\u00e9rt, valamint a d\u00e1tumokkal val\u00f3 sz\u00e1mol\u00e1s miatt<\/strong> fontos volt bevezetni a sz\u00e1mrendszert is. <\/p>\n\n\n\n

A 44 ezredik nap kapcs\u00e1n (ami 2020. j\u00faniusban volt)<\/a> sok \u00e9rdekess\u00e9get szedtem \u00f6ssze a d\u00e1tumokr\u00f3l – sz\u00f6veges \u00e9s vide\u00f3s form\u00e1tumban is – \u00e9rdemes megn\u00e9zni:
\u2714\ufe0e\u00a0Hogyan sz\u00e1molj a d\u00e1tumokkal?
\u2714\ufe0e\u00a0Hogyan sz\u00e1mold ki, hogy h\u00e1ny napos vagy?
\u2714\ufe0e\u00a0Milyen speci\u00e1lis sz\u0171r\u00e9si lehet\u0151s\u00e9gek vannak a d\u00e1tumokra?<\/p>\n\n\n\n

A forradalom 175. \u00e9vfordul\u00f3ja<\/h2>\n\n\n\n

Avagy hogyan sz\u00e1molj az 1900 el\u0151tti \u00e9vekkel?<\/p>\n\n\n\n

Az 1900 el\u0151tti d\u00e1tumok<\/strong>at is be\u00edrhatod az Excelbe, csak azok sz\u00f6veges form\u00e1tum\u00faak lesznek<\/strong>, \u00e9s sz\u00e1mk\u00e9nt nem fogja \u00e9rteni az Excel.<\/p>\n\n\n\n

M\u00edg egy d\u00e1tumb\u00f3l az \u00c9V() f\u00fcggv\u00e9nnyel <\/strong>tudhatod meg az \u00e9vsz\u00e1mot – ez alak\u00edtja \u00e1t a 45.000-t 2023-m\u00e1 – addig egy sz\u00f6vegb\u0151l a BAL() f\u00fcggv\u00e9nnyel szedheted ki az \u00e9vsz\u00e1mot<\/strong> tartalmaz\u00f3 els\u0151 4 karaktert.<\/p>\n\n\n\n

Ha az A1 cell\u00e1ba be\u00edrod a 2023.03.15-t d\u00e1tumk\u00e9nt, al\u00e1 az A2-be pedig 1848.03.15-t sz\u00f6vegk\u00e9nt, akkor ezzel a k\u00e9plettel kapod meg az eltelt \u00e9veket: =\u00c9V(A1)-BAL(A2;4)<\/p>\n\n\n\n

(Ha el\u0151sz\u00f6r d\u00e1tum jelenik meg, ne ijedj meg, csak alak\u00edtsd sz\u00e1mm\u00e1! \ud83d\ude42 )<\/p>\n\n\n\n

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

<\/p>\n\n\n\n

M\u00e1s jeles napok az Excelben<\/h2>\n\n\n\n

Szeretn\u00e9d tudni, mikor voltak 5000 napos \u00e9vfordul\u00f3k az Excel szerint? K\u00e9sz\u00edts egy sorozatot a sz\u00e1mokb\u00f3l<\/a>, majd form\u00e1zd meg \u0151ket d\u00e1tumk\u00e9nt:<\/p>\n\n\n\n

\"\"<\/figure>
\n

Kb 13,5 \u00e9vente telik el 5000 nap, \u00edgy az 50.000 nap 2036 november\u00e9ben lesz. Szerinted akkor m\u00e9g fogjuk az Excelt haszn\u00e1lni? <\/p>\n\n\n\n

Szerencs\u00e9re az 1000 napos fordul\u00f3k 3 \u00e9ven bel\u00fcl vannak, \u00edgy 2025 v\u00e9g\u00e9n m\u00e1r ‘\u00fcnnepelhetj\u00fck’ a 46 ezredik Excel napot. 2025 elej\u00e9n pedig a 45.678-at, ami att\u00f3l ‘k\u00fcl\u00f6nleges’, hogy n\u00f6vekv\u0151 sorrendben vannak a sz\u00e1mjegyek.<\/p>\n\n\n\n

Van olyan sz\u00e1m\/d\u00e1tum, ami m\u00e9g \u00e9rdekes lehet?<\/p>\n\n\n\n

Tal\u00e1n izgalmasabb a t\u00e9ma, ha a saj\u00e1t ezredik\/t\u00edzezredik napfordul\u00f3idat is kisz\u00e1molod. <\/p>\n<\/div><\/div>\n\n\n\n

Ismerd meg jobban az Excelt<\/h2>\n\n\n\n

Rem\u00e9lem, hogy ez a r\u00f6vid bejegyz\u00e9s seg\u00edtett meg\u00e9rteni, hogy az Excel hogyan kezeli a d\u00e1tumokat, \u00e9s hogyan haszn\u00e1lhatod ezt a funkci\u00f3t a mindennapi munk\u00e1dban, \u00e9s hogy \u00e9rdemes az Excel tanul\u00e1ssal foglalkozni, mert sz\u00e1mtalan izgalmas kincset rejt.<\/p>\n\n\n\n

Ha szorgalmas vagy \u00e9s szeretsz \u00f6n\u00e1ll\u00f3an tanulni, szeretn\u00e9l hasznos tippeket, billenty\u0171kombin\u00e1ci\u00f3kat \u00e9s f\u00fcggv\u00e9nyeket tanulni, akkor rendeld meg az Excel Kezd\u0151 & Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>. A gyakorl\u00e1shoz aj\u00e1nlom a kimondottan kezd\u0151knek k\u00e9sz\u00fclt feladatsorokat<\/strong><\/a>.<\/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\u00a0csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>! Ha ink\u00e1bb egy\u00e9nileg tanuln\u00e1l, vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk\u00a0egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n\n\n\n

Vagy gyere a VIP Klubba, ahol hasonl\u00f3 \u00e9rdekes megold\u00e1sokat tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz \u2013 \u00edgy egy biztos h\u00e1tt\u00e9rrel a saj\u00e1t temp\u00f3dban haladhatsz: Excel VIP Klub<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Jeles nap a mai (2023.03.15) az Excelben! \u00cdrd be egy Excel cell\u00e1ba a mai d\u00e1tumot, \u00e9s n\u00e9zz m\u00f6g\u00e9! Sz\u00e1mk\u00e9nt form\u00e1zva a 45000-t fogod l\u00e1tni. Haszn\u00e1lhatod a MA() f\u00fcggv\u00e9nyt, vagy magyar Windows g\u00e9peken a Ctrl 0 (nulla!) billenty\u0171kombin\u00e1ci\u00f3t. Ha k\u00e9s\u0151bb akarod kipr\u00f3b\u00e1lni, akkor \u00edgy tudsz gyorsan d\u00e1tumokat r\u00f6gz\u00edteni az Excelbe. 2023.\u00a0m\u00e1rcius 15-\u00e9n\u00a0\u00e9rte\u00a0el az Excel „d\u00e1tum-sz\u00e1ml\u00e1l\u00f3ja” a […]<\/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-9706","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"\nJeles napok az Excelben - 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\/jeles-napok-az-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jeles napok az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Jeles nap a mai (2023.03.15) az Excelben! \u00cdrd be egy Excel cell\u00e1ba a mai d\u00e1tumot, \u00e9s n\u00e9zz m\u00f6g\u00e9! Sz\u00e1mk\u00e9nt form\u00e1zva a 45000-t fogod l\u00e1tni. Haszn\u00e1lhatod a MA() f\u00fcggv\u00e9nyt, vagy magyar Windows g\u00e9peken a Ctrl 0 (nulla!) billenty\u0171kombin\u00e1ci\u00f3t. Ha k\u00e9s\u0151bb akarod kipr\u00f3b\u00e1lni, akkor \u00edgy tudsz gyorsan d\u00e1tumokat r\u00f6gz\u00edteni az Excelbe. 2023.\u00a0m\u00e1rcius 15-\u00e9n\u00a0\u00e9rte\u00a0el az Excel „d\u00e1tum-sz\u00e1ml\u00e1l\u00f3ja” a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-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=\"2023-03-15T10:19:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-15T22:57:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.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=\"4 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Jeles napok az Excelben\",\"datePublished\":\"2023-03-15T10:19:45+00:00\",\"dateModified\":\"2023-03-15T22:57:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/\"},\"wordCount\":704,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/jeles-Excel-napok-175-evfordulo.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/\",\"name\":\"Jeles napok az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/jeles-Excel-napok-175-evfordulo.png\",\"datePublished\":\"2023-03-15T10:19:45+00:00\",\"dateModified\":\"2023-03-15T22:57:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/jeles-Excel-napok-175-evfordulo.png\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/jeles-Excel-napok-175-evfordulo.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jeles-napok-az-excelben\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jeles napok az 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":"Jeles napok az Excelben - 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\/jeles-napok-az-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"Jeles napok az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Jeles nap a mai (2023.03.15) az Excelben! \u00cdrd be egy Excel cell\u00e1ba a mai d\u00e1tumot, \u00e9s n\u00e9zz m\u00f6g\u00e9! Sz\u00e1mk\u00e9nt form\u00e1zva a 45000-t fogod l\u00e1tni. Haszn\u00e1lhatod a MA() f\u00fcggv\u00e9nyt, vagy magyar Windows g\u00e9peken a Ctrl 0 (nulla!) billenty\u0171kombin\u00e1ci\u00f3t. Ha k\u00e9s\u0151bb akarod kipr\u00f3b\u00e1lni, akkor \u00edgy tudsz gyorsan d\u00e1tumokat r\u00f6gz\u00edteni az Excelbe. 2023.\u00a0m\u00e1rcius 15-\u00e9n\u00a0\u00e9rte\u00a0el az Excel „d\u00e1tum-sz\u00e1ml\u00e1l\u00f3ja” a […]","og_url":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2023-03-15T10:19:45+00:00","article_modified_time":"2023-03-15T22:57:25+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.png","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"4 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Jeles napok az Excelben","datePublished":"2023-03-15T10:19:45+00:00","dateModified":"2023-03-15T22:57:25+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/"},"wordCount":704,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/","name":"Jeles napok az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.png","datePublished":"2023-03-15T10:19:45+00:00","dateModified":"2023-03-15T22:57:25+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/jeles-Excel-napok-175-evfordulo.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/jeles-napok-az-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Jeles napok az 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\/9706","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=9706"}],"version-history":[{"count":7,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9706\/revisions"}],"predecessor-version":[{"id":9719,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9706\/revisions\/9719"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}