{"id":2952,"date":"2021-04-12T13:28:22","date_gmt":"2021-04-12T13:28:22","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=2952"},"modified":"2021-08-06T13:12:36","modified_gmt":"2021-08-06T13:12:36","slug":"liste-derulante-in-excel-liste-in-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/liste-derulante-in-excel-liste-in-excel\/","title":{"rendered":"Liste derulante in Excel | Liste 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;\">Cursuri Excel<\/h4>\n<p style=\"text-align: left;\"><em>De-a lungul celor peste 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant.<\/em><\/p>\n<p><em>O lista de preturi pentru acestea regasiti <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">aici.<\/a><\/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-382\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Liste derulante in Excel<\/h1>\n<p>In acest tutorial te invat cum se construiesc de la zero astfel de liste. Nu de putine ori am avut nevoie sa ma misc mai repede in Excel cu introducerea datelor. Sunt situatii cand avem de executat task-uri recurente. Cel mai simplu mod este sa-ti construiesti liste derulante care sa contina valorile de care avem nevoie in celula.<\/p>\n<h2>La ce ne poate ajuta o lista derulanta in Excel?<\/h2>\n<p>Cu ajutorul optiunii <strong>List <\/strong>din Excel ( o regasiti in meniul <strong>Data<\/strong> \u2013 <strong>Data Validation<\/strong>) avem posibilitatea de a ne costrui liste derulante de valori. Putem complete date in celula prin selectie de valoare dintr-o lista predefinita, iar acest aspect ne ajuta sa automatize lucrul in Excel.<\/p>\n<h2>Unde pot invata mai multe despre liste derulante in Excel?<\/h2>\n<p>Daca ti-ai propus sa investesti mai mult in dezvoltarea ta personal ate asteptam la cursuri. Vei vrea ca pe viitor sa fii capabil\/capabila sa lucrezi mult mai eficient cu Excelul, noi te putem ajuta. Avem o serie de programe de training adaptate nevoilor tale. Te invit sa arunci o privire pe aceasta pagina <a href=\"https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/\">https:\/\/sky-it.ro\/clone\/pachete-preturi-cursuri-persoane-fizice-2\/<\/a> .<\/p>\n<p>Avem experienta in ceea ce priveste lucrul cu aplicatiile business Microsoft. In cadrul cursurilor Excel, pe care le organizam si online, avem inclus un capitol dedicate constructiei de liste derulante in Excel. Vorbim despre meniul optiunea Data Validation din Excel.<\/p>\n<h2>Functia INDIRECT<\/h2>\n<p>Tot in acest tutorial vei invata cum se pot adapta mesaje asupra zonelor de date. Nu in ultimul rand vei vedea un exemplu de utlizare al functiei INDIRECT() din Excel.<\/p>\n<p>Iti recoamd sa dai play materialului de mai jos. Te va ajuta sa intelegi mai bine cum pot fi automatizate task-urile 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<h2>Intrebari\/nelamuriri?<\/h2>\n<p>Daca ai intrebari legate de modul de utilizare al acestei optiuni, ne poti lasa un mesaj in sectiunea de comentarii. \u00a0In cazul in care ai\u00a0 intrebari despre un subiect Excel diferit fata de cel prezent, scrie-ne si iti vom raspunde in cel mult 48 ore!<\/p>\n<p>Speram ca va este util acest tutorial, ne puteti urmari si in zona de social media\/Facebook: <a href=\"https:\/\/www.facebook.com\/SkyITLearning\/\">facebook.com\/SkyITLearning<\/a><\/p>\n<p>De asemenea putem sa va ajutam si cu programe de training personalizate, adaptate nevoilor Dvs. Cursurile sunt destinate atat persoanelor fizice cat si pentru companii, nu ezitati sa ne contactati pentru mai multe detalii.<\/p>\n<p>Nu uita\u2026<\/p>\n<p>Invata astazi pentru maine![\/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 Cursuri Excel De-a lungul celor peste 5 ani de activitate ne-am dezvoltat tehnici facile de invatare, cursuri Microsoft adaptate in functie de nivelul fiecarui cursant. O lista de preturi pentru acestea&#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\/2952"}],"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=2952"}],"version-history":[{"count":2,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/2952\/revisions"}],"predecessor-version":[{"id":3295,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/2952\/revisions\/3295"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=2952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=2952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=2952"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=2952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}