{"id":1857,"date":"2020-01-15T12:40:25","date_gmt":"2020-01-15T12:40:25","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?page_id=1857"},"modified":"2021-03-23T13:46:04","modified_gmt":"2021-03-23T13:46:04","slug":"blog-alex-flashfill","status":"publish","type":"page","link":"https:\/\/sky-it.ro\/clone\/blog-alex-flashfill\/","title":{"rendered":"Blog Alex FlashFill"},"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>FLASH FILL<\/strong><\/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_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_video link=&#8221;https:\/\/youtu.be\/w-SuVcUaGkI&#8221;][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][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-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-461\" 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<h4>Avem urmatoarea baza de date in Excel.<\/h4>\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>&nbsp;<\/p>\n<p>Incercam sa invatam aplicatia Excel ce anume dorim sa extragem din adresele de email prezentate in acest exemplu. 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>&nbsp;<\/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>&nbsp;<\/p>\n<p>Click in celula B8-&gt;Data-&gt;FlashFill (CTRL+E)<\/p>\n<p>Click in celula D8-&gt;Data-&gt;FlashFill\u00a0(CTRL+E)<\/p>\n<p>Click in celula E8-&gt;Data-&gt;FlashFill\u00a0(CTRL+E)<\/p>\n<p>&nbsp;<\/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\" \/>[\/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,"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\/1857"}],"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=1857"}],"version-history":[{"count":8,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/1857\/revisions"}],"predecessor-version":[{"id":2887,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/1857\/revisions\/2887"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1857"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}