{"id":4501,"date":"2024-02-12T07:39:00","date_gmt":"2024-02-12T07:39:00","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=4501"},"modified":"2024-02-12T07:45:10","modified_gmt":"2024-02-12T07:45:10","slug":"secrete-in-sau-din-excel-automatizari-excel-sortari-autocompletare-date-scurtaturi-taste-ctrl-enter","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/secrete-in-sau-din-excel-automatizari-excel-sortari-autocompletare-date-scurtaturi-taste-ctrl-enter\/","title":{"rendered":"Secrete in sau din Excel, automatizari Excel, sortari, autocompletare date, scurtaturi taste CTRL ENTER"},"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<p style=\"text-align: left;\"><strong>Secrete din \/ in Excel<\/strong><\/p>\n<p style=\"text-align: left;\">Microsoft Excel<\/p>\n<p style=\"text-align: left;\">Cum invat usor Excel?<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-4505 size-medium\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-300x300.jpeg\" alt=\"\" width=\"300\" height=\"300\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-300x300.jpeg 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-150x150.jpeg 150w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-768x768.jpeg 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-570x570.jpeg 570w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-500x500.jpeg 500w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-1000x1000.jpeg 1000w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer-700x700.jpeg 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2024\/02\/Designer.jpeg 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\">Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, :).<\/p>\n<p>Vrei un curs personalizat Excel, Power BI, etc click <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">aici.<\/a><\/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-3 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-general\">\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\tGeneral\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\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-automatizari-in-excel\">\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\tAutomatizari in Excel\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\t\t<li>\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"#tab-liste-custom-sort\">\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\tListe Custom, SORT\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-general-387\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Intro<\/h1>\n<p>Salut,<br \/>\n12 Feb 2024, ora 08:00AM, Romania \ud83d\ude0a, data si ora la care am inceput editarea acestui articol. Vreau sa vin cu o abordare noua a acestora, scurt jurnal in prima parte. Poate tu, cel care esti al 2-lea cititor al meu ( m-am pus si pe mine, am citit si eu o data articolul) te intrebi ce-i cu acest intro. Am simtit sa dau o explicatie!<\/p>\n<p>O zi mohorata de Februarie, inca cald, erau 10 grade la ora 7:00 AM, o zi in care am scris despre cateva automatizari pe care le poti face si tu daca folosesti zi de zi Excel-ul.<\/p>\n<p><em>Pentru cursuri si tutoriale gratuite Excel, Power Query , Microsoft Power BI te asteptam si pe <strong><a href=\"https:\/\/www.youtube.com\/channel\/UC0NIQwTqu8ZseYNDe8UZplQ\">Youtube.<\/a><\/strong><\/em><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-automatizari-in-excel-904\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Autocompletarea datelor<\/h1>\n<p>&nbsp;<\/p>\n<p>Ai de facut inregistrari cu un continut ridicat de caractere in Excel? Solutia nu este sa faci editare manuala, ci ai fi mult mai productiv daca ai aplica o tehnica de autocompletare a datelor. Functioneaza in situatia in care ai nevoie sa faci o replicare a unui nume intr-o alta celula fara sa gresesti. Este utila in aceasta situatie optiunea de AutoCorect din Excel.<\/p>\n<p>In materialul de mai jos vei gasi metoda de activare explicata pas cu pas.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/-k3Fk14ByzY?si=bb794IDq3dxiUOho\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h1>CTRL + ENTER<\/h1>\n<p>&nbsp;<\/p>\n<p>Combinatia acestor 2 taste, adica tasta CTRL combinata cu tasta ENTER (CTRL + ENTER) genereaza una dintre cele mai utile automatizari din Excel. Nu de putine ori mi s-a intamplat sa am nevoie sa completez aceeasi informatie intr-o zona de celule selectata. Dura o eternitate sa pun acelasi lucru manual, trecand prin fiecare celula, dar dupa ce am descoperit combinatia aceasta de taste, adica CTRL + ENTER, activitatea mea in Excel a devenit mult mai productiva. Iti las mai jos un material video in care-ti explic pas cu pas cum functioneaza combinatia aceasta de taste, CTRL + ENTER.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/9pude_rCeNI?si=0DlieKM5uBEXwR_-\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-liste-custom-sort-906\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<p><a href=\"https:\/\/sky-it.ro\/clone\/calendar-cursuri-excel-power-bi-transact-sql-power-query-power-point-word-excel-365\/\">CALENDAR CURSURI<\/a><\/p>\n<h1>Sortarea datelor in Excel \u2013 Liste Custom Peronalizate<\/h1>\n<p>&nbsp;<\/p>\n<p>Sortarea datelor in Excel este un subiect pe care-l abordez si in cadrul cursurilor Excel pe care le desfasor, iar aici am descoperit nevoia de a genera principii de sortare a datelor intr-un format custom, personalizat. Probabil ca ai observant si tu ca sortarea in Excel se poate realiza pe cateva criterii predefinite.<br \/>\nExemplu: crescator sau descrescator, alfabetic sau non-alfabetic, etc..<\/p>\n<p>Vezi aici un material in care am prezentat pas cu pas cum se poate face o lista custom care sa functioneze pe zona de sortare.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/w6jQ10bY-OY?si=GDx3SrBaeLyxleMY\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Vrei sa vezi programul cursurilor Excel pe care le organizam, <a href=\"https:\/\/sky-it.ro\/clone\/calendar-cursuri-excel-power-bi-transact-sql-power-query-power-point-word-excel-365\/\" target=\"_blank\" rel=\"noopener\">click aici.<\/a><\/p>\n<p>Nu ne potrivim pe disponibilitatea ta, nu ezita sa ne contactezi si incercam sa gasim o solutie in acest sens, cu siguranta avem cursul Excel potrivit pentru tine si cu siguranta gasim si disponibilitate de organizare.<\/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 !<\/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] Secrete din \/ in Excel Microsoft Excel Cum invat usor Excel? &nbsp; Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, :). Vrei un curs personalizat Excel,&#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\/4501"}],"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=4501"}],"version-history":[{"count":5,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/4501\/revisions"}],"predecessor-version":[{"id":4507,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/4501\/revisions\/4507"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=4501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=4501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=4501"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=4501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}