{"id":1866,"date":"2020-01-15T16:31:34","date_gmt":"2020-01-15T16:31:34","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=1866"},"modified":"2021-08-05T12:31:05","modified_gmt":"2021-08-05T12:31:05","slug":"flesh-fill-in-excel-completare-automata-a-datelor-in-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/flesh-fill-in-excel-completare-automata-a-datelor-in-excel\/","title":{"rendered":"Flash Fill 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;\"><a href=\"https:\/\/youtu.be\/w-SuVcUaGkI\"><strong>FLASH FILL<\/strong><\/a><\/h3>\n<h4 style=\"text-align: left;\">Windows shortcut: CTRL+E<\/h4>\n<p style=\"text-align: left;\"><strong>Flash Fill<\/strong> este o caracteristica noua adaugata in Excel 2013 (dar indisponibila, din pacate pentru MAC OS, chiar si in versiunea Excel 2016)<\/p>\n<h4 style=\"text-align: left;\">De unde activam optiunea?<\/h4>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;1860&#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 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-1 clearfix\">\n\t<ul class=\"qode-advanced-tabs-nav\">\n\t\t\t\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-exemplu-practic\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"qode-advanced-tab-text-after-icon\">\n\t\t\t\t\t\t\t\tExemplu practic\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n\t<div class=\"qode-advanced-tab-container\" id=\"tab-exemplu-practic-69\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]Cum extragem dintr-o adresa de email de forma (nume1.nume2@companie.com), fiecare componenta in parte?<\/p>\n<p>Sigur, vom utiliza <strong>FlashFill!<\/strong><\/p>\n<h1>Ce face optiunea Flesh Fill din Excel?<\/h1>\n<h2>Avem urmatoarea baza de date in Excel.<\/h2>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-1862 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/111.jpg\" alt=\"\" width=\"700\" height=\"312\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/111.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/111-300x134.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Incercam sa<a href=\"https:\/\/sky-it.ro\/clone\/calendar-cursuri\/\"> invatam<\/a> aplicatia Excel ce anume dorim sa extragem din adresele de email prezentate in acest exemplu. Cand spunem ca o sa-l invatam, practic o sa definim in celula Exel modelul dorit de catre noi. Cu ajutorul optiunii Flesh Fill din Excel vom reusi sa obtinem rezultatul dorit de catre noi fara prea mult efort. Acest lucru ne va ajuta sa castigam timp, practic vom rezolva task-ul nostru intr-un timp relativ scurt si fara multe batai de cap. Tot ce va trebui sa facem va fi sa apelam optiunea Flesh Fill in Excel. In cele ce urmeaza vreau sa-ti prezint in detaliu pasii necesare pentru a pune la lucru Flash Fill-ul printr-un exemplu practic.<\/p>\n<p>Prin urmare, in celula C8 vom introduce de la tastatura primul nume \u2013 Mihai, in celula D8-al 2-lea nume \u2013 Manea si in celula E8 numele companiei.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-1863 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/112.jpg\" alt=\"\" width=\"700\" height=\"312\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/112.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/112-300x134.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Click in celula B8-&gt;Data-&gt; optiunea FlashFill (CTRL+E)<\/p>\n<p>Click in celula D8-&gt;Data-&gt;optiunea FlashFill\u00a0(CTRL+E)<\/p>\n<p>Click in celula E8-&gt;Data-&gt;optiunea FlashFill\u00a0(CTRL+E)<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-1864 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/113.jpg\" alt=\"\" width=\"700\" height=\"312\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/113.jpg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/01\/113-300x134.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<h2>Pentru o detaliere a acestui articol iti recomand sa urmaresti urmatorul material video:<\/h2>\n<p>Am incercat sa sintetize si intr-un video cam tot ce poate face aceasta optiune. Daca vrei sa inveti sa lucrezi simplu si eficient in Excel iti recomand sa aloci aprox 10 minute din timpul tau si-ti garantez ca vor fi 10 minute investite nu pierdute :).\u00a0 M-as bucura tare mult daca o sa lasi si un like la acest video, evident daca iti va fi de folos si de asemenea mi-ar placea sa apesi si butonul de SUBSCRIBE. In felul acesta , daca esti pasional de Excel vei mai primi de la mine si alte materiale interesante.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/w-SuVcUaGkI\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>[\/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 !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] FLASH FILL Windows shortcut: CTRL+E Flash Fill este o caracteristica noua adaugata in Excel 2013 (dar indisponibila, din pacate pentru MAC OS, chiar si in versiunea Excel 2016) De unde activam optiunea? [\/vc_column_text][vc_separator&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1866"}],"collection":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/types\/post"}],"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=1866"}],"version-history":[{"count":6,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1866\/revisions"}],"predecessor-version":[{"id":3093,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1866\/revisions\/3093"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1866"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}