{"id":1972,"date":"2020-02-24T15:18:14","date_gmt":"2020-02-24T15:18:14","guid":{"rendered":"https:\/\/sky-it.ro\/clone\/?page_id=1972"},"modified":"2020-02-24T16:08:35","modified_gmt":"2020-02-24T16:08:35","slug":"cum-aplicam-o-crestere-scadere-procentuala-asupra-unei-valori-numerice-in-excel","status":"publish","type":"page","link":"https:\/\/sky-it.ro\/clone\/cum-aplicam-o-crestere-scadere-procentuala-asupra-unei-valori-numerice-in-excel\/","title":{"rendered":"Cum aplicam o crestere\/scadere procentuala asupra unei valori numerice 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>Percentage<\/strong><\/h3>\n<h4 style=\"text-align: left;\">Formatarea Percentage<\/h4>\n<p style=\"text-align: left;\">Cum obtinem valori procentuale in Excel?<\/p>\n<p>[\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;1962&#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<p style=\"text-align: left;\">Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, scaneaza ecusonul de mai sus.<\/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-206\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]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\/scadere procentuala asupra unei valori numerice, astfel incat sa obtinem un rezultat numeric?<\/li>\n<\/ul>\n<p>O sa detaliem practic aceste 2 probleme , vezi Exemplu 1 si Exemplul 2[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-1-823\" 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), descompunem aceasta formula A &#8211; B\/B = A\/B &#8211; B\/B = A\/B &#8211; 1<\/strong><\/p>\n<p><img fetchpriority=\"high\" 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 decoding=\"async\" class=\"alignleft size-full wp-image-1984\" 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\" \/>[\/vc_column_text]<\/div><div class=\"qode-advanced-tab-container\" id=\"tab-exemplul-2-61\" data-icon-pack=\"\" data-icon-html=\"\">[vc_column_text]<strong>Cum aflam pretul final dupa ce aplicam o creste procentuala asupra acestuia?<\/strong><\/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<p><strong>PF &#8211; pret final<\/strong><\/p>\n<p><strong>P &#8211; pret de pornire<\/strong><\/p>\n<p><strong>X% &#8211; Valoare crestere procentuala<\/strong><\/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<p>Pentru aceasta problema un singur lucru este forte important &#8211; cum introducem corect partea procentuala.<\/p>\n<ul>\n<li>putem introduce direct de la tastatura cifra urmata de semnul de procent (shift+tasta 5) &#8211; 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 20 de la tastatura dupa care facem formatare (apasam semnul de procent), o sa observam ca numarul nostru se va schimba in 2000%<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1988\" 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? [\/vc_column_text][vc_separator type=&#8221;transparent&#8221; up=&#8221;10&#8243;][vc_single_image image=&#8221;1962&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221; qode_css_animation=&#8221;&#8221;][vc_column_text] Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, scaneaza&#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\/1972"}],"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=1972"}],"version-history":[{"count":6,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/1972\/revisions"}],"predecessor-version":[{"id":1989,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/pages\/1972\/revisions\/1989"}],"wp:attachment":[{"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/media?parent=1972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/categories?post=1972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/tags?post=1972"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/sky-it.ro\/clone\/wp-json\/wp\/v2\/yst_prominent_words?post=1972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}