{"id":2502,"date":"2020-06-25T17:07:00","date_gmt":"2020-06-25T17:07:00","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?page_id=2502"},"modified":"2021-04-07T13:36:15","modified_gmt":"2021-04-07T13:36:15","slug":"cum-introducem-timpul-si-data-curenta-in-excel","status":"publish","type":"page","link":"https:\/\/sky-it.ro\/clone\/cum-introducem-timpul-si-data-curenta-in-excel\/","title":{"rendered":"Cum introducem timpul si data curenta in Excel"},"content":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text]<\/p>\n<h3 style=\"text-align: left;\"><strong>Cursuri Office<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Functii Date &amp; Time<\/h4>\n<p style=\"text-align: left;\"><em>De-a lungul celor 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant.<\/em><\/p>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;996&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221; qode_css_animation=&#8221;&#8221;][vc_column_text]<\/p>\n<h5><\/h5>\n<h5 style=\"text-align: left;\">&#8222;Learn today for tomorrow!&#8221;<\/h5>\n<p>[\/vc_column_text][\/vc_column][vc_column width=&#8221;3\/4&#8243;]<div class=\"qode-advanced-tabs qode-advanced-tabs qode-advanced-horizontal-tab clearfix qode-advanced-tab-without-icon qode-advanced-tabs-column-0 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-tab-861\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h2>Cum introducem timpul si data curenta in Excel?<\/h2>\n<p>&nbsp;<\/p>\n<p>Fiecare avem propriile metode de a introduce o data ora curenta in Excel. In felul acesta reflectam momentul la care a fost facuta o actiune\/inregistrare in Excel.<\/p>\n<p>Am sa structurez in cele ce urmeaza cateva dintre metodele mai automatizate de a introduce o data sau o ora in Excel. Tehnicile acestea sunt prezentate si in <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">cursurile Excel online<\/a> pe care noi realizam periodic. Detalii despre calendarul cursurilor Excel programate regasiti pe tab-ul <a href=\"https:\/\/sky-it.ro\/clone\/catalog-cursuri\/\">Catalog Cursuri<\/a>\u00a0. Sigur, pentru detalii ne puteti contacta pe adresa de email de contact sau telefonic. Organizam atat sesiuni de grup cat si sesiuni private de cursuri dedicate tehnologiilor Microsoft.<\/p>\n<p>&nbsp;<\/p>\n<h2>Sintaxa functii date and time in Excel<\/h2>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-2503 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/Capture-mod.jpg\" alt=\"\" width=\"624\" height=\"269\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/Capture-mod.jpg 624w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/Capture-mod-300x129.jpg 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/JHDz2k1cJgk\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h2>Descriere functii Excel, TODAY() si NOW()<\/h2>\n<p>Atat functia NOW() cat si functia TODAY() sunt 2 functii dinamice in Excel. Isi vor schimba valorarea in functie de proprietatile fiecareia.<\/p>\n<p>&nbsp;<\/p>\n<h2>Functia TODAY() in Excel<\/h2>\n<p>Functia TODAY() returneaza numarul serial al datei curente. In format \u201eGeneral\u201d se poate vedea valoarea numerica a acestei date. Functia TODAY() este utila atunci cand doriti sa afisati data curenta intr-o celula Excel\/ foaie de lucru Excel\u00a0 indiferent de momentul cand ati deschis registrul de lucru. Fiind o functie dinamica se va actualiza automat. De asemenea o mai puteti folosi si in calcule, de exemplu aveti scadenta unei facturi la o anumita data si vreti sa aflati cate zile mai sunt pana la scadenta. Numarul de zile se va actualiza automat prin flosirea in formula de calcul Excel a functiei today().<\/p>\n<p>&nbsp;<\/p>\n<h2>Formula Excel din spate pentru aceasta situatie:<\/h2>\n<p>&nbsp;<\/p>\n<p><strong>=TODAY() \u2013 \u201edata scadenta\u201d<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2>Functia NOW() in Excel<\/h2>\n<p>&nbsp;<\/p>\n<p>Functia NOW() returneaza data si ora curenta. Functie utila cand dorim sa avem actualizata automat data si ora de fiecare data cand procesam modificari asupra foii de lucru.<\/p>\n<p>&nbsp;<\/p>\n<p>Pe langa cele 2 functii dinamice putem introduce automat cu ajutorul tastaturii atat data curenta ( CTRL+;) cat si ora curenta (CTRL+SHIFT+;). In ambele situatii avem elemente statice. Acestea nu vor fi actualizate in momentul in care redeschidem fisierul de lucru sau procesam modificari la momente diferite de timp in interiorul acestuia.<\/p>\n<p>&nbsp;<\/p>\n<p><em>Esti interesat de cursuri Excel interactive predate de catre specialistii nostri, nu ezita sa ne contactezi!<\/em>[\/vc_column_text]<\/div><\/div>[\/vc_column][\/vc_row][vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; css=&#8221;.vc_custom_1473086245677{padding-top: 13px !important;padding-bottom: 13px !<\/p>\n<p>important;background-color: #ffffff !important;}&#8221;][vc_column]<div class='qode_carousels_holder clearfix'><div class='qode_carousels' data-number-of-visible-items='4'><ul class='slides'><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel1-1.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel3.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel2-1.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel5.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel4.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel7.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel6.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel9.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel8.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel11.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel10.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel13.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel12.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><li class='item'><div class=\"carousel_item_holder\"><a itemprop='url' href='#' target='_self'><span class='first_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel15.png\" alt=\"carousel image\" \/><\/span><span class='second_image_holder has_hover_image'><img decoding=\"async\" itemprop=\"image\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/06\/cursuri-excel14.png\" alt=\"carousel image\" \/><\/span><\/a><\/div><\/li><\/ul><\/div><\/div>[\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row css_animation=&#8221;&#8221; row_type=&#8221;row&#8221; use_row_as_full_screen_section=&#8221;no&#8221; type=&#8221;grid&#8221; angled_section=&#8221;no&#8221; text_align=&#8221;left&#8221; background_image_as_pattern=&#8221;without_pattern&#8221; z_index=&#8221;&#8221; padding_top=&#8221;44&#8243; padding_bottom=&#8221;44&#8243;][vc_column width=&#8221;1\/4&#8243;][vc_column_text] Cursuri Office Functii Date &amp; Time De-a lungul celor 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant. [\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;996&#8243; img_size=&#8221;full&#8221;&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"full_width.php","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/2502"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/comments?post=2502"}],"version-history":[{"count":9,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/2502\/revisions"}],"predecessor-version":[{"id":2926,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/2502\/revisions\/2926"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=2502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=2502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=2502"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=2502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}