{"id":7054,"date":"2018-10-27T08:30:16","date_gmt":"2018-10-27T06:30:16","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=7054"},"modified":"2018-10-27T02:09:31","modified_gmt":"2018-10-27T00:09:31","slug":"mai-nap-pontos-ido","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/","title":{"rendered":"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe?"},"content":{"rendered":"<div id=\"id_5bd3884f102c52b10690483\" class=\"text_exposed_root text_exposed\">K\u00e9rd\u00e9s: Hogyan tudom aktu\u00e1lis d\u00e1tumot \u00e9s pontos id\u0151t be\u00edrni az Excelbe, hogy k\u00e9s\u00f6bb ne v\u00e1ltozzon. A\u00a0most() f\u00fcggv\u00e9ny billenty\u00fckombin\u00e1ci\u00f3j\u00e1t keresem, \u00e9s hogy az akkori pontos id\u00f6 k\u00e9s\u00f6bb se v\u00e1ltozzon.<\/div>\n<p><!--more--><br \/>\n<img fetchpriority=\"high\" decoding=\"async\" class=\"alignright size-medium wp-image-6290\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/02\/hourglass-time-hours-sand-39396-300x226.jpeg\" alt=\"\" width=\"300\" height=\"226\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/02\/hourglass-time-hours-sand-39396-300x226.jpeg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/02\/hourglass-time-hours-sand-39396-240x181.jpeg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/02\/hourglass-time-hours-sand-39396.jpeg 640w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>V\u00e1lasz: Val\u00f3ban lehet a <a href=\"https:\/\/sosexcel.com\/exceltippek\/mai-datum\/\" target=\"_blank\" rel=\"noopener\">MA()<\/a> \u00e9s a MOST() f\u00fcggv\u00e9nyt haszn\u00e1lni a nap \u00e9s az id\u0151pont bevitel\u00e9re, de &#8211; ahogy a k\u00e9rd\u00e9sben is benne volt -, az dinamikusan v\u00e1ltozik \u00e9s mindig a val\u00f3s id\u0151t mutatja.<\/p>\n<h2>A mai nap \u00e9s a pontos id\u0151 gyorsan<\/h2>\n<p>Nem kell a d\u00e1tumokon gondolkodnod, mert <strong>a magyar Excellel\u00a0Ctrl 0 (azaz nulla)<\/strong> billenty\u0171kombin\u00e1ci\u00f3 be\u00edrja az AZNAPI d\u00e1tumot &#8211; a rendszerid\u0151 szerint.<\/p>\n<ul>\n<li>Csak a fels\u0151 Null\u00e1val m\u0171k\u00f6dik, a numerikussal nem.<\/li>\n<li><strong>Ha angol a g\u00e9ped, vagy Mac-t haszn\u00e1lsz, akkor sajnos nem m\u0171k\u00f6dik<\/strong> (Ctrl pontosvessz\u0151 lenne, ami a magyar billenty\u0171zeten nem nyomhat\u00f3)<\/li>\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\" rel=\"noopener\">Ha els\u0151re egy sz\u00e1m jelenik meg<\/a> (p\u00e9ld\u00e1ul 42858), ne ijedj meg, hanem form\u00e1zd d\u00e1tumk\u00e9nt.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-medium wp-image-2285 alignleft\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-300x188.jpg\" alt=\"\" width=\"300\" height=\"188\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-300x188.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-660x413.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-240x150.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg 800w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Az Excel nemcsak az aznapi d\u00e1tumot, hanem a pontos id\u0151t is ki tudja t\u00f6lteni a rendszerid\u0151 szerint, <strong>magyar Excelben Ctrl Shift pont,\u00a0Mac-en Cmd Shift pont.<\/strong><\/p>\n<p>Angol g\u00e9peken ez sem m\u0171k\u00f6dik, mert Ctrl kett\u0151spont lenne, (ami a magyar billenty\u0171zeten sajnos nem nyomhat\u00f3).<\/p>\n<p>Persze itt is csak akkor fog helyesen megjelenni, ha a cellaform\u00e1z\u00e1sn\u00e1l be\u00e1ll\u00edtod az &#8222;Id\u0151&#8221; sz\u00e1mform\u00e1tumot.<\/p>\n<h2>Ha a d\u00e1tumot \u00e9s a pontos id\u0151t egy cell\u00e1ba szeretn\u00e9d<\/h2>\n<p>Ez is csak magyar (!) nyelv\u0171 g\u00e9peken m\u0171k\u00f6dik. Ha azt szeretn\u00e9d, hogy a nap-\u00f3ra egy cell\u00e1ban l\u00e1tsz\u00f3djon:<\/p>\n<ol>\n<li>A Cellaform\u00e1tum (Ctrl 1) egy\u00e9ni form\u00e1tumn\u00e1l adj meg egy olyan k\u00f3dot, amiben a d\u00e1tum \u00e9s az id\u0151 is szerepel, pl: \u00e9\u00e9\u00e9\u00e9.hh.nn \u00f3:pp<\/li>\n<li>A cell\u00e1ba pedig ezt \u00edrd:\u00a0Ctrl 0 &#8211; sz\u00f3k\u00f6z &#8211; Ctrl Shift . (pont) &#8211; Enter<\/li>\n<\/ol>\n<p>Azaz a 2 gyorsbillenty\u0171t egy cell\u00e1ban is haszn\u00e1lhatod, csak tegy\u00e9l k\u00f6z\u00e9 sz\u00f3k\u00f6zt &#8211; \u00e9s figyelj a form\u00e1z\u00e1sra!<\/p>\n<p>Az \u00f6tlet az <a href=\"http:\/\/exceltitok.hu\/55-excel-billentyukombinacio\/\" target=\"_blank\" rel=\"noopener\">55 napos billenty\u0171kombin\u00e1ci\u00f3 kih\u00edv\u00e1s<\/a> sor\u00e1n mer\u00fclt fel. N\u00e9zd v\u00e9gig a t\u00e9m\u00e1kat \u00e9s a hozz\u00e1sz\u00f3l\u00e1sokat, \u00e9s tanulj \u00faj tr\u00fckk\u00f6ket.<\/p>\n<h2>Szeretn\u00e9l t\u00f6bbet tudni a d\u00e1tumokr\u00f3l? Olvasd el ezt a 2 cikket:<\/h2>\n<blockquote class=\"wp-embedded-content\" data-secret=\"DYsWLlx3jF\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/\">Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/embed\/#?secret=QUMksEl2O1#?secret=DYsWLlx3jF\" data-secret=\"DYsWLlx3jF\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"jTJvHApXTI\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\">Hogyan tudsz napok szerint rendezni?<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Hogyan tudsz napok szerint rendezni?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/embed\/#?secret=k7DhkfVFKv#?secret=jTJvHApXTI\" data-secret=\"jTJvHApXTI\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9rd\u00e9s: Hogyan tudom aktu\u00e1lis d\u00e1tumot \u00e9s pontos id\u0151t be\u00edrni az Excelbe, hogy k\u00e9s\u00f6bb ne v\u00e1ltozzon. A\u00a0most() f\u00fcggv\u00e9ny billenty\u00fckombin\u00e1ci\u00f3j\u00e1t keresem, \u00e9s hogy az akkori pontos id\u00f6 k\u00e9s\u00f6bb se v\u00e1ltozzon.<\/p>\n","protected":false},"author":1,"featured_media":6044,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","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":"","adv-header-id-meta":"","stick-header-meta":"","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-7054","post","type-post","status-publish","format-standard","has-post-thumbnail","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 mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - 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\/mai-nap-pontos-ido\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"K\u00e9rd\u00e9s: Hogyan tudom aktu\u00e1lis d\u00e1tumot \u00e9s pontos id\u0151t be\u00edrni az Excelbe, hogy k\u00e9s\u00f6bb ne v\u00e1ltozzon. A\u00a0most() f\u00fcggv\u00e9ny billenty\u00fckombin\u00e1ci\u00f3j\u00e1t keresem, \u00e9s hogy az akkori pontos id\u00f6 k\u00e9s\u00f6bb se v\u00e1ltozzon.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\" \/>\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=\"2018-10-27T06:30:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"870\" \/>\n\t<meta property=\"og:image:height\" content=\"212\" \/>\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\/mai-nap-pontos-ido\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe?\",\"datePublished\":\"2018-10-27T06:30:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\"},\"wordCount\":440,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png\",\"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\/mai-nap-pontos-ido\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\",\"name\":\"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png\",\"datePublished\":\"2018-10-27T06:30:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png\",\"width\":870,\"height\":212},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe?\"}]},{\"@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 mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - 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\/mai-nap-pontos-ido\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"K\u00e9rd\u00e9s: Hogyan tudom aktu\u00e1lis d\u00e1tumot \u00e9s pontos id\u0151t be\u00edrni az Excelbe, hogy k\u00e9s\u00f6bb ne v\u00e1ltozzon. A\u00a0most() f\u00fcggv\u00e9ny billenty\u00fckombin\u00e1ci\u00f3j\u00e1t keresem, \u00e9s hogy az akkori pontos id\u00f6 k\u00e9s\u00f6bb se v\u00e1ltozzon.","og_url":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2018-10-27T06:30:16+00:00","og_image":[{"width":870,"height":212,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.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\/mai-nap-pontos-ido\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe?","datePublished":"2018-10-27T06:30:16+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/"},"wordCount":440,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png","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\/mai-nap-pontos-ido\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/","url":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/","name":"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png","datePublished":"2018-10-27T06:30:16+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/calendar-mai-nap-today-banner.png","width":870,"height":212},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/mai-nap-pontos-ido\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan lehet a mai napot \u00e9s a pontos id\u0151t gyorsan beg\u00e9pelni az Excelbe?"}]},{"@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\/7054","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=7054"}],"version-history":[{"count":4,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7054\/revisions"}],"predecessor-version":[{"id":7063,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7054\/revisions\/7063"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/6044"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=7054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=7054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=7054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}