{"id":1990,"date":"2020-02-25T06:50:15","date_gmt":"2020-02-25T06:50:15","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?p=1990"},"modified":"2021-04-15T17:09:56","modified_gmt":"2021-04-15T17:09:56","slug":"crestere-sau-scadere-procentuala-asupra-valorilor-in-excel","status":"publish","type":"post","link":"https:\/\/sky-it.ro\/clone\/crestere-sau-scadere-procentuala-asupra-valorilor-in-excel\/","title":{"rendered":"Crestere sau scadere procentuala asupra valorilor 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>Percentage<\/strong><\/p>\n<p style=\"text-align: left;\">Formatarea Percentage<\/p>\n<p style=\"text-align: left;\">Cum obtinem valori procentuale in Excel?<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft size-full wp-image-2971\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel.png\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel.png 1920w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel-300x169.png 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel-768x432.png 768w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel-1024x576.png 1024w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel-700x394.png 700w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Calcule-Procentuale-in-Excel-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-exemplul-1\">\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\tExemplul 1\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-exemplul-2\">\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\tExemplul 2\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-989\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h1>Crestere sau scadere procentuala in Excel.<\/h1>\n<p>&nbsp;<\/p>\n<p>In cazul in care jobul tau este acela de analist financiar sau te ocupati de partea de raportare cu siguranta te-ai lovit de cel putin una din situatiile de mai jos:<\/p>\n<ul>\n<li>Cum obtinem o valoare procentuala ca diferenta a unor valori numerice?<\/li>\n<li>Cum aplicam o crestere sau scadere procentuala asupra unei valori numerice, astfel incat sa obtinem un rezultat numeric?<\/li>\n<\/ul>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/UkUQh64XAx8\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>O sa detaliem practic aceste 2 probleme , vezi <strong>Exemplu 1<\/strong> si <strong>Exemplul 2<\/strong><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-1-64\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]Pentru punctul 1 prezentat anterior o sa luam un calcul un raport de vanzari, unde avem un buget si o situatie actuala. Cerinta noastra este sa aflam daca avem scadere sau crestere in functie de aceste 2 elemente, insa rezultatul sa fie afisat procentual.<\/p>\n<p>Cum vedem acest lucru, aplicam urmatoarea formula <strong>Actual (A) &#8211; Buget(B)\/Buget (B), <\/strong><strong>descompunem aceasta formula si vom avea\u00a0<\/strong><\/p>\n<p><strong> A &#8211; B\/B = A\/B &#8211; B\/B = A\/B &#8211; 1<\/strong><\/p>\n<p>In cazul exemplului nostru de mai jos, formula este aplicata in casuta <strong>D3<\/strong><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-1982 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky3.jpg\" alt=\"\" width=\"724\" height=\"468\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky3.jpg 724w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky3-300x194.jpg 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky3-400x260.jpg 400w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky3-700x452.jpg 700w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/p>\n<p>Glisam formula pana jos (dublu click in coltul primei celule), apasam semnul de procent (%) din zona de sus <img decoding=\"async\" class=\"wp-image-1983 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/ribon.jpg\" alt=\"\" width=\"105\" height=\"69\" \/>\u00a0si pumen si partea de zecimale daca este cazul.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1984 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky4.jpg\" alt=\"\" width=\"724\" height=\"468\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky4.jpg 724w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky4-300x194.jpg 300w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky4-400x260.jpg 400w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky4-700x452.jpg 700w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/p>\n<p>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-2-339\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<\/p>\n<h2><strong>Cum aflam pretul final dupa ce aplicam o creste procentuala asupra acestuia?<\/strong><\/h2>\n<p>Vom lua in calcul exemplul de mai jos unde avem o coloana cu preturile de pornire (initiale), o coloana in care va trebui sa trecem cresterea procentuala , iar pe coloana a 3-a va trebui sa calculam pretul final, valoare numerica prin raportare la cele 2 coloane anterioare.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1986 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky5-1.jpg\" alt=\"\" width=\"681\" height=\"266\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky5-1.jpg 681w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky5-1-300x117.jpg 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>\n<p>Formula noastra va fi de forma: <strong>PF=P + P * X% = P(1+X%)<\/strong><\/p>\n<ul>\n<li><strong>PF &#8211; pret final<\/strong><\/li>\n<li><strong>P &#8211; pret de pornire<\/strong><\/li>\n<li><strong>X% &#8211; Valoare crestere procentuala<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1987 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky6.jpg\" alt=\"\" width=\"683\" height=\"264\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky6.jpg 683w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky6-300x116.jpg 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<h2>Pentru aceasta problema un singur lucru este forte important &#8211; cum introducem corect partea procentuala.<\/h2>\n<ul>\n<li>putem introduce direct de la tastatura cifra urmata de semnul de procent (shift+tasta 5). Celula se va formata automat in percentage.<\/li>\n<li>introducem valoarea numerica, ex: <strong>0.05<\/strong> &#8211; echivalentul lui <strong>5%<\/strong>.\u00a0 0.05 il putem schimba in valoare procentuala prin schimbare de formatare de pe semnul <strong>%<\/strong> din zona de sus.<\/li>\n<li>inainte de a introduce valoarea in celula o formatam de tip <strong>percentage<\/strong>. Daca vom introduce mai intai valoarea si ulterior facem formatarea se va afisa o valoare gresita:<\/li>\n<\/ul>\n<p>Ex: introducem numarul <strong>20<\/strong> de la tastatura dupa care facem formatare (apasam semnul de procent), o sa observam ca numarul nostru se va schimba in <strong>2000%<\/strong><\/p>\n<p>Rezultatul final al exercitiului nostru va arata in felul urmator:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1988 alignnone\" src=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky7.jpg\" alt=\"\" width=\"685\" height=\"267\" srcset=\"https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky7.jpg 685w, https:\/\/sky-it.ro\/clone\/wp-content\/uploads\/2020\/02\/Sky7-300x117.jpg 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/>[\/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] Percentage Formatarea Percentage Cum obtinem valori procentuale in Excel? Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, :). Vrei un curs personalizat Excel, click aici. &#8222;Learn&#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\/1990"}],"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=1990"}],"version-history":[{"count":23,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1990\/revisions"}],"predecessor-version":[{"id":2973,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/posts\/1990\/revisions\/2973"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1990"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}