{"id":381,"date":"2013-10-22T11:54:47","date_gmt":"2013-10-22T09:54:47","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=381"},"modified":"2021-04-20T02:38:55","modified_gmt":"2021-04-20T00:38:55","slug":"datumok-gyors-bevitele","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/","title":{"rendered":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?"},"content":{"rendered":"<p><strong>K\u00e9rd\u00e9s:<\/strong> Rengeteg d\u00e1tumot kell r\u00f6gz\u00edtenem az Excelbe, \u00e9s nagyon sok id\u0151t elvisz. Hogyan lehetne a d\u00e1tumok r\u00f6gz\u00edt\u00e9s\u00e9t egyszer\u0171s\u00edteni?<\/p>\n<p>Ha naponta r\u00f6gz\u00edtesz adatokat, akkor a d\u00e1tumok gyors bevitele jelent\u0151sen cs\u00f6kkentheti a munkaid\u0151det. Tanuld meg a tetsz\u0151leges d\u00e1tumok \u00e9s az aznapi d\u00e1tum gyors r\u00f6gz\u00edt\u00e9s\u00e9t.<\/p>\n<p><strong>V\u00e1lasz: <\/strong>3 karaktert is haszn\u00e1lhatsz a bevitelhez:\u00a0perjel (\/), k\u00f6t\u0151jel (-) \u00e9s pont (.). Valamint egy p\u00e1r (felesleges) sz\u00e1mjegyet el is hagyhatsz.<\/p>\n<h2>Tetsz\u0151leges d\u00e1tumok gyors bevitele<\/h2>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-3958 size-medium\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg\" alt=\"Ha naponta r\u00f6gz\u00edtesz adatokat, akkor a d\u00e1tumok gyors bevitele jelent\u0151sen cs\u00f6kkentheti a munkaid\u0151det. Tanuld meg a tetsz\u0151leges d\u00e1tumok \u00e9s az aznapi d\u00e1tum gyors r\u00f6gz\u00edt\u00e9s\u00e9t.\" width=\"300\" height=\"225\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-240x180.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar.jpg 534w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Amennyiben idei d\u00e1tumokr\u00f3l van sz\u00f3, el\u00e9g a h\u00f3napot \u00e9s a napot beg\u00e9pelned, p\u00e9ld\u00e1ul:\u00a08-31, 8\/31 \u00e9s\u00a08.31 mind 2013.08.31-t jelent (ez a cikk 2013-ban \u00edrodott!).<\/p>\n<p>Kor\u00e1bbi d\u00e1tumokn\u00e1l is el\u00e9g az \u00e9vsz\u00e1m utols\u00f3 egy vagy k\u00e9t karaktere, p\u00e9ld\u00e1ul: 7-8-31, 7\/8\/31 \u00e9s 7.8.31 ha 2007.08.31-t akarsz be\u00edrni.<\/p>\n<h2>Mai d\u00e1tum gyors bevitele<\/h2>\n<p>Ha az aktu\u00e1lis napot kell beg\u00e9pelned, haszn\u00e1ld a <strong>Ctrl 0 (nulla)<\/strong> billenty\u0171ket! Ez <span style=\"text-decoration: underline;\">csak magyar<\/span> nyelv\u0171 Excelen m\u0171k\u00f6dik!<\/p>\n<p>Angol g\u00e9peken, ha angol billenty\u0171zeted is van hozz\u00e1:<strong> Ctrl ; (pontosvessz\u0151)<\/strong> Ez csak akkor m\u0171k\u00f6dik, ha a pontosvessz\u0151 k\u00fcl\u00f6n billenty\u0171n van (a magyar billenty\u0171zeten AltGr , (vessz\u0151), de az AltGr mell\u00e9 m\u00e1r sajnos nem lehet a Ctrl-t pluszba megnyomni.)<\/p>\n<h2>D\u00e1tum form\u00e1tum be\u00e1ll\u00edt\u00e1sa<\/h2>\n<p>Ha biztosra akarsz menni a d\u00e1tumok gyors bevitele kapcs\u00e1n, akkor r\u00f6gz\u00edt\u00e9s el\u0151tt form\u00e1zd a cell\u00e1kat &#8216;D\u00e1tum&#8217; form\u00e1tumra. Erre 3 lehet\u0151s\u00e9ged is van:<\/p>\n<ul>\n<li>Jobbklikk Cellaform\u00e1z\u00e1s \/ D\u00e1tum,<\/li>\n<li>vagy Ctrl 1 kombin\u00e1ci\u00f3val is megnyithatod a Cellaform\u00e1z\u00e1s panelt.<\/li>\n<li>Vagy a Kezd\u0151lap men\u00fc &#8216;Sz\u00e1m&#8217; csoportj\u00e1ban v\u00e1laszd a leny\u00edl\u00f3 list\u00e1b\u00f3l a &#8216;R\u00f6vid d\u00e1tumform\u00e1tum&#8217; opci\u00f3t.<\/li>\n<\/ul>\n<h2>Tov\u00e1bbi \u00e9rdekess\u00e9gek a d\u00e1tumokr\u00f3l<\/h2>\n<p>Ne felejtsd el a d\u00e1tumok is sz\u00e1mok, csak\u00a0<span style=\"text-decoration: underline;\"><a title=\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?\" href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\" rel=\"noopener noreferrer\">d\u00e1tumk\u00e9nt kell form\u00e1zni<\/a><\/span>\u00a0\u0151ket!<\/p>\n<p>Melyik az els\u0151 vagy az utols\u00f3 d\u00e1tum az Excelben? Hogyan form\u00e1zd a napon bel\u00fcli id\u0151pontokat? Olvass tov\u00e1bbi <a title=\"Egy\u00e9b \u00e9rdekess\u00e9gek a d\u00e1tumokkal kapcsolatban\" href=\"https:\/\/sosexcel.com\/exceltippek\/egyeb-erdekessegek-datumokkal-kapcsolatban\/\"><span style=\"text-decoration: underline;\">\u00e9rdekess\u00e9geket a d\u00e1tumokkal kapcsolatban<\/span><\/a>, ehhez kattints a linkre!<\/p>\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:32% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" width=\"299\" height=\"488\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/datumszures_csoportositas.png\" alt=\"\" class=\"wp-image-9105 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/datumszures_csoportositas.png 299w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/datumszures_csoportositas-184x300.png 184w\" sizes=\"(max-width: 299px) 100vw, 299px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Ha nem tetszik az alap\u00e9rtelmezett megjelen\u00e9s, <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/egyeni-datumformatum\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">\u00edgy tudsz m\u00e1s d\u00e1tum form\u00e1tumot be\u00e1ll\u00edtani<\/span><\/a>, pl &#8216;szeptember 3, kedd&#8217; t\u00edpus\u00fat.<\/p>\n\n\n\n<p>Ha d\u00e1tumokkal dolgozol, akkor a sz\u0171r\u0151 is alapb\u00f3l becsoportos\u00edtja a napokat \u00e9vre, h\u00f3napra, \u00edgy k\u00f6nnyebben tudsz egy adott id\u0151szakot megadni (bepip\u00e1lni).&nbsp;<\/p>\n\n\n\n<p>Valamint extra lehet\u0151s\u00e9geket, \u2018D\u00e1tumsz\u0171r\u0151ket\u2019 is tal\u00e1lsz a sz\u0171r\u00e9sn\u00e9l, err\u0151l <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/excel-datum-44000-nap\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-datum-44000-nap\/\" target=\"_blank\" rel=\"noreferrer noopener\">itt olvashatsz t\u00f6bbet<\/a>.<\/span><\/p>\n<\/div><\/div>\n\n\n\n<p><strong>Tov\u00e1bbi hasznos tippek\u00e9rt \u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg <a rel=\"noreferrer noopener\" href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">a 111 Hasznos Excel Tipp<\/a> kiadv\u00e1nyt, vagy a <a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\">Kezd\u0151 &amp; Halad\u00f3 Excel Tank\u00f6nyvet<\/a>!<\/strong><\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/b3-TD_O5mRE\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><img decoding=\"async\" width=\"728\" height=\"90\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg\" alt=\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t?\" class=\"wp-image-7522\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg 728w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-300x37.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-660x82.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-240x30.jpg 240w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><figcaption><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><span style=\"text-decoration: underline;\">http:\/\/exceltitok.hu\/excel-feladatsorok\/<\/span><\/a><\/figcaption><\/figure><\/div>\n\n\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9rd\u00e9s: Rengeteg d\u00e1tumot kell r\u00f6gz\u00edtenem az Excelbe, \u00e9s nagyon sok id\u0151t elvisz. Hogyan lehetne a d\u00e1tumok r\u00f6gz\u00edt\u00e9s\u00e9t egyszer\u0171s\u00edteni? Ha naponta r\u00f6gz\u00edtesz adatokat, akkor a d\u00e1tumok gyors bevitele jelent\u0151sen cs\u00f6kkentheti a munkaid\u0151det. Tanuld meg a tetsz\u0151leges d\u00e1tumok \u00e9s az aznapi d\u00e1tum gyors r\u00f6gz\u00edt\u00e9s\u00e9t. V\u00e1lasz: 3 karaktert is haszn\u00e1lhatsz a bevitelhez:\u00a0perjel (\/), k\u00f6t\u0151jel (-) \u00e9s pont (.). [&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":[1],"tags":[27,8],"class_list":["post-381","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-billentyukombinacio","tag-datum"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok<\/title>\n<meta name=\"description\" content=\"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.\" \/>\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\/datumok-gyors-bevitele\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok\" \/>\n<meta property=\"og:description\" content=\"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-22T09:54:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-20T00:38:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"534\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/datumok-gyors-bevitele\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?\",\"datePublished\":\"2013-10-22T09:54:47+00:00\",\"dateModified\":\"2021-04-20T00:38:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\"},\"wordCount\":484,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg\",\"keywords\":[\"billenty\u0171kombin\u00e1ci\u00f3\",\"d\u00e1tum\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\",\"name\":\"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg\",\"datePublished\":\"2013-10-22T09:54:47+00:00\",\"dateModified\":\"2021-04-20T00:38:55+00:00\",\"description\":\"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage\",\"url\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg\",\"contentUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?\"}]},{\"@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":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok","description":"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.","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\/datumok-gyors-bevitele\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok","og_description":"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.","og_url":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-10-22T09:54:47+00:00","article_modified_time":"2021-04-20T00:38:55+00:00","og_image":[{"width":534,"height":401,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar.jpg","type":"image\/jpeg"}],"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\/datumok-gyors-bevitele\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?","datePublished":"2013-10-22T09:54:47+00:00","dateModified":"2021-04-20T00:38:55+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/"},"wordCount":484,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg","keywords":["billenty\u0171kombin\u00e1ci\u00f3","d\u00e1tum"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/","url":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/","name":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni? - ExcelTitok","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg","datePublished":"2013-10-22T09:54:47+00:00","dateModified":"2021-04-20T00:38:55+00:00","description":"A d\u00e1tumok gyors bevitele neked is menni fog, ha csak a sz\u00fcks\u00e9ges karaktereket g\u00e9peled be, vagy megtanulod a d\u00e1tum gyorsbillenty\u0171 kombin\u00e1ci\u00f3kat.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/10\/calendar-300x225.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?"}]},{"@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\/381","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=381"}],"version-history":[{"count":21,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/381\/revisions"}],"predecessor-version":[{"id":9110,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/381\/revisions\/9110"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}