{"id":1764,"date":"2015-02-04T09:10:15","date_gmt":"2015-02-04T08:10:15","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=1764"},"modified":"2016-12-08T01:21:20","modified_gmt":"2016-12-08T00:21:20","slug":"munkaido-nyilvantartas-es-munkaido-szamitas-excellel","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/","title":{"rendered":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel"},"content":{"rendered":"<p>A munkaid\u0151 nyilv\u00e1ntart\u00e1s t\u00e1bl\u00e1zatot hogyan k\u00e9pletezzem, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat?<\/p>\n<p><strong style=\"font-size: 16px; line-height: 1.714285714;\">V\u00e1lasz: <\/strong>Ha az \u00e9rkez\u00e9si-t\u00e1voz\u00e1si id\u0151ket id\u0151pontk\u00e9nt form\u00e1zod \u00e9s r\u00f6gz\u00edted, akkor ugyan\u00fagy v\u00e9gezhetsz vel\u00fck <a style=\"font-size: 16px; line-height: 1.714285714;\" title=\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?\" href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\">egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal<\/a> vagy\u00a0m\u00e1s sz\u00e1mokkal.<!--more--><\/p>\n<p>A munkaid\u0151 nagys\u00e1g\u00e1t \u00edgy sz\u00e1mold: T\u00e1voz\u00e1s-\u00c9rkez\u00e9s-Eb\u00e9did\u0151 (ahol ez ut\u00f3bbit is sz\u00e1molni kell), azaz pl.:\u00a0=F2-C2-(E2-D2)<\/p>\n<figure id=\"attachment_1765\" aria-describedby=\"caption-attachment-1765\" style=\"width: 743px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\" wp-image-1765\" style=\"border: 1px solid grey;\" title=\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s Excelben\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\" alt=\"munkaido-nyilvantartas\" width=\"743\" height=\"180\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png 743w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas-300x72.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas-660x159.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas-240x58.png 240w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/a><figcaption id=\"caption-attachment-1765\" class=\"wp-caption-text\">Id\u0151pontokkal is v\u00e9gezhetsz sz\u00e1m\u00edt\u00e1sokat<\/figcaption><\/figure>\n<p>Amennyiben \u00f3ra:perc\u00a0m\u00f3don\u00a0vannak form\u00e1zva a cell\u00e1k, akkor a v\u00e9geredm\u00e9ny is sz\u00e9pen jelenik meg, pl. 8:00 vagy 8:30 lesz.<\/p>\n<p>Ha m\u00e9gis 0,34 vagy hasonl\u00f3, akkor viszont a sz\u00e1mform\u00e1tumot \u00e1t kell \u00e1ll\u00edtani Id\u0151re.<\/p>\n<p>Tov\u00e1bbi \u00e9rdekess\u00e9geket a d\u00e1tumokkal \u00e9s id\u0151pontokkal kapcsolatban itt olvashatsz:\u00a0<a title=\"Egy\u00e9b \u00e9rdekess\u00e9gek a d\u00e1tumokkal kapcsolatban\" href=\"https:\/\/sosexcel.com\/exceltippek\/egyeb-erdekessegek-datumokkal-kapcsolatban\/\" target=\"_blank\">\u00e9rdekessegek a d\u00e1tumokkal kapcsolatban<\/a>.<\/p>\n<p>Ez a p\u00e9lda els\u0151 l\u00e9p\u00e9snek \u00e9s gyakorl\u00e1snak j\u00f3, de szeretn\u00e9m ha tudn\u00e1d, hogy <strong>m\u00e9g sokat lehet csiszolni a folyamaton<\/strong>: l\u00e9tre lehet hozni egy olyan sablont, ami automatikusan legener\u00e1lja vagy \u00fajrasz\u00e1molja az elrendez\u00e9st, ak\u00e1r \u00e9veken kereszt\u00fcl.<\/p>\n<p><strong><a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">Tov\u00e1bbi hasznos tippek\u00e9rt \u00a0\u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg a 111 Hasznos Excel Tipp kiadv\u00e1nyt!<\/a><\/strong><\/p>\n<p><strong>Szeretn\u00e9d \u00f6sszetettebb folyamatokra is haszn\u00e1lni az Excelt? Szeretn\u00e9l szem\u00e9lyre szabott seg\u00edts\u00e9get? <a href=\"http:\/\/exceltitok.hu\/arak\/\">Jelentkezz mini-tanfolyamra!<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A munkaid\u0151 nyilv\u00e1ntart\u00e1s t\u00e1bl\u00e1zatot hogyan k\u00e9pletezzem, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat? V\u00e1lasz: Ha az \u00e9rkez\u00e9si-t\u00e1voz\u00e1si id\u0151ket id\u0151pontk\u00e9nt form\u00e1zod \u00e9s r\u00f6gz\u00edted, akkor ugyan\u00fagy v\u00e9gezhetsz vel\u00fck egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy\u00a0m\u00e1s sz\u00e1mokkal.<\/p>\n","protected":false},"author":1,"featured_media":1765,"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":[8,78],"class_list":["post-1764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-datum","tag-gyakorlo-feladat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.\" \/>\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\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\" \/>\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=\"2015-02-04T08:10:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-08T00:21:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"743\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\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=\"1 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel\",\"datePublished\":\"2015-02-04T08:10:15+00:00\",\"dateModified\":\"2016-12-08T00:21:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\"},\"wordCount\":257,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\",\"keywords\":[\"d\u00e1tum\",\"gyakorl\u00f3 feladat\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\",\"name\":\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\",\"datePublished\":\"2015-02-04T08:10:15+00:00\",\"dateModified\":\"2016-12-08T00:21:20+00:00\",\"description\":\"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png\",\"width\":743,\"height\":180},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel\"}]},{\"@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":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.","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\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/","og_locale":"hu_HU","og_type":"article","og_title":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.","og_url":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2015-02-04T08:10:15+00:00","article_modified_time":"2016-12-08T00:21:20+00:00","og_image":[{"width":743,"height":180,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"1 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel","datePublished":"2015-02-04T08:10:15+00:00","dateModified":"2016-12-08T00:21:20+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/"},"wordCount":257,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png","keywords":["d\u00e1tum","gyakorl\u00f3 feladat"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/","url":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/","name":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png","datePublished":"2015-02-04T08:10:15+00:00","dateModified":"2016-12-08T00:21:20+00:00","description":"A munkaid\u0151 nyilv\u00e1ntart\u00e1st is bek\u00e9pletezheted, hogy sz\u00e1molja a ledolgozott \u00f3r\u00e1kat. Id\u0151pontokkal is v\u00e9gezhetsz egyszer\u0171 matematikai m\u0171veleteket, mint a d\u00e1tumokkal vagy m\u00e1s sz\u00e1mokkal.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/02\/munkaido-nyilvantartas.png","width":743,"height":180},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel"}]},{"@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\/1764","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=1764"}],"version-history":[{"count":15,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1764\/revisions"}],"predecessor-version":[{"id":4556,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1764\/revisions\/4556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/1765"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=1764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=1764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=1764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}