{"id":4025,"date":"2022-04-19T12:09:35","date_gmt":"2022-04-19T12:09:35","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=4025"},"modified":"2022-04-19T18:36:18","modified_gmt":"2022-04-19T18:36:18","slug":"liste-derulante-in-excel-cursuri-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/liste-derulante-in-excel-cursuri-excel\/","title":{"rendered":"Liste derulante 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<p style=\"text-align: left;\"><strong>Liste derulante<\/strong><\/p>\n<p style=\"text-align: left;\">Drop down list<\/p>\n<p style=\"text-align: left;\">Cum se genereaza o lista derulanta in Excel?<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-2955 size-full\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list.png\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list.png 1920w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list-300x169.png 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list-768x432.png 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list-1024x576.png 1024w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list-700x394.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2021\/04\/Data-validation-list-539x303.png 539w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/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, 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-liste-derulante\">\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 derulante\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-derulante-in-care-poti-cauta-valori\">\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 derulante in care poti cauta valori\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-147\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>LISTE DERULANTE IN EXCEL, LISTE IN CARE POTI CAUTA VALORI.<\/h1>\n<p>&nbsp;<\/p>\n<p>In cadrul cursurilor Excel pe care le desfasuram atat pentru persoane fizice cat si pentru companii am intalnit foarte multi participanti care ne-au rugat sa-i invatam cum sa faca o lista derulanta in Excel. Erau curiosi cat de dificili sunt pasii ce trebuie parcursi pentru a genera o lista derulanta in Excel. Iti prezentam mai jos 2 subiecte foarte interesante despre liste derulante in Excel.<\/p>\n<ul>\n<li>Cum facem o lista derulanta simpla?<\/li>\n<li>Cum aplicam o cautare intr-o lista derulanta Excel?<\/li>\n<\/ul>\n<p>Pentru cursuri si tutoriale gratuite Excel, Power Query , Microsoft Power BI te asteptam si pe <a href=\"https:\/\/www.youtube.com\/channel\/UC0NIQwTqu8ZseYNDe8UZplQ\">Youtube.<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>In paginile alaturate vom detalia cele 2 teme propuse mai sus , vezi <strong>Liste derulante\u00a0<\/strong> si <strong>Liste derulante in care poti cauta valori<\/strong><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-liste-derulante-345\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]Pentru punctul 1 prezentat anterior o sa luam un calcul realizarea unei liste derulante in Excel ( Drop Down List), de la 0 (zero). Consider ca cel mai usor mod ar fi sa vezi video cum se poate face acest lucru.<\/p>\n<p>Pasii de baza ar fi sa mergi in meniul principal\u00a0 <strong>DATA, <\/strong><strong>si sa cauti butonul Data Validation si de aici sa selectezi LIST<\/strong><\/p>\n<p>In materialul de mai jos te invit sa urmaresti pas cu pas procesul de realizare al unei liste derulante in Excel.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/sloNlPaWP9k\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-liste-derulante-in-care-poti-cauta-valori-215\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h2><strong>Cum generam o lista derulanta in care sa putem cauta valori, sa putem da search?<\/strong><\/h2>\n<p>Pe langa pasii explicati in materialul anterior, in care te invatam cum poti genera o lista derulanta de la 0 in Excel, vom mai utiliza o serie de functii Excel ce ne vor ajuta sa putem integra si partea de cautare intr-o lista derulanta.<\/p>\n<p>Pasii de generare a unei liste derulante in Excel: <strong>Data &#8211; Data Validation &#8211; List<\/strong><\/p>\n<h2>Ce functii Excel se folosesc la generarea unor liste derulante in Excel, liste in care sa putem cauta informatii.<\/h2>\n<ul>\n<li>Functia SEARCH() &#8211; functie text din Excel, vom cauta anumite elemente<\/li>\n<li>Functia FILTER () &#8211; functie noua in Excel, disponibila Excel 365 , detalii la <a href=\"https:\/\/youtu.be\/12WiQs-pIHA\">aici<\/a><\/li>\n<li>Functia ISNUMBER () &#8211; vom verifica daca inregistrarile noastre sunt numerice sau nu<\/li>\n<li>FUnctia UNIQUE() &#8211; functie disponibila in Excel 365, e va ajuta sa extragem valorile unice dintr-o lista de selectie, detalii <a href=\"https:\/\/youtu.be\/zW9yDrEOmX4\">aici\u00a0<\/a><\/li>\n<\/ul>\n<p>La fel ca in cazul situatiei precedente, cosider ca cel mai usor de inteles ar fi sa urmareste materialul urmator:<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/7o_etGRe4p4\" 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 !<\/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] Liste derulante Drop down list Cum se genereaza o lista derulanta in Excel? Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, :). Vrei un curs personalizat&#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\/4025"}],"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=4025"}],"version-history":[{"count":4,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/4025\/revisions"}],"predecessor-version":[{"id":4030,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/4025\/revisions\/4030"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=4025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=4025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=4025"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=4025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}