{"id":8819,"date":"2023-10-17T12:54:52","date_gmt":"2023-10-17T10:54:52","guid":{"rendered":"https:\/\/www.value4you.it\/?p=8819"},"modified":"2023-10-18T14:27:17","modified_gmt":"2023-10-18T12:27:17","slug":"formule-tridimensionali-e-formattazioni-in-excel-per-creare-report","status":"publish","type":"post","link":"https:\/\/www.value4you.it\/en\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/","title":{"rendered":"Formule Tridimensionali e formattazioni in Excel per creare Report"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"8819\" class=\"elementor elementor-8819\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4989a6ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4989a6ef\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2aef9e18\" data-id=\"2aef9e18\" data-element_type=\"column\" data-settings=\"{&quot;avante_ext_is_scrollme&quot;:&quot;false&quot;,&quot;avante_ext_is_smoove&quot;:&quot;false&quot;,&quot;avante_ext_is_parallax_mouse&quot;:&quot;false&quot;,&quot;avante_ext_is_infinite&quot;:&quot;false&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f65be7 elementor-widget elementor-widget-text-editor\" data-id=\"1f65be7\" data-element_type=\"widget\" data-settings=\"{&quot;avante_ext_is_scrollme&quot;:&quot;false&quot;,&quot;avante_ext_is_smoove&quot;:&quot;false&quot;,&quot;avante_ext_is_parallax_mouse&quot;:&quot;false&quot;,&quot;avante_ext_is_infinite&quot;:&quot;false&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>of&nbsp;<a href=\"https:\/\/www.linkedin.com\/in\/lucavanzulli\/?locale=it_IT\">Luca Vanzulli<\/a><\/strong><br><strong>by\u00a0Luca Vanzulli Blogger, Planning &amp; Control Specialist, Content Marketer<\/strong><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400; letter-spacing: 0px;\">Quando si tratta di creare report aziendali, Excel sempre uno strumento evergreen. Tuttavia, spesso ci troviamo a dover gestire dati complessi provenienti da diverse fonti. In questo contesto, le formule tridimensionali di Excel possono fare la differenza, semplificando il processo di analisi e generazione di report e creando delle automazioni. L\u2019importante \u00e8 dedicare del tempo alla progettazione del template e alla normalizzazione dei dati da ricevere o da importare in modo tale da non perdere tempo in formattazioni.<\/span><\/p>\n<h2><b>Cos&#8217;\u00e8 una Formula Tridimensionale in Excel?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Una formula tridimensionale in Excel \u00e8 un potente strumento che consente di effettuare calcoli su dati disposti in fogli di lavoro multipli. Questo \u00e8 particolarmente utile quando hai dati correlati distribuiti in pi\u00f9 fogli Excel o in diverse sezioni di un unico foglio di lavoro.<\/span><\/p>\n<h2><b>Vantaggi delle Formule Tridimensionali<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">L&#8217;utilizzo delle formule tridimensionali in Excel offre vari vantaggi:<\/span><\/p>\n<ul>\n<li><b>Risparmio di tempo<\/b><span style=\"font-weight: 400;\">: Riduci il tempo necessario per effettuare calcoli complessi su grandi volumi di dati distribuiti.<\/span><\/li>\n<li><b>Precisione<\/b><span style=\"font-weight: 400;\">: Minimizza gli errori di calcolo, poich\u00e9 le formule tridimensionali considerano automaticamente dati da diverse fonti.<\/span><\/li>\n<li><b>Aggiornamenti semplici<\/b><span style=\"font-weight: 400;\">: Se i dati cambiano, le formule tridimensionali si aggiornano automaticamente.<\/span><\/li>\n<li><b>Analisi approfondite<\/b><span style=\"font-weight: 400;\">: Puoi esaminare i dati da diverse angolazioni, consentendoti di ottenere una visione pi\u00f9 completa.<\/span><\/li>\n<\/ul>\n<h2><b>Esempio pratico: Un Report delle Vendite Trimestrali<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Immaginiamo di dover creare un report delle vendite per una pmi operante prevalentemente sul mercato europeo e con uffici presenti in Italia, Irlanda, Polonia, Spagna e Francia. L\u2019azienda non \u00e8 ancora molto attrezzata a livello di sistemi informativi integrati. Pertanto occorre adottare una procedura molto snella per il monitoraggio delle vendite.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Le formule tridimensionali in Excel semplificano notevolmente la creazione di report consolidati quando hai dati distribuiti su diversi fogli di lavoro. Sono un ottimo strumento per risparmiare tempo ed evitare errori manuali durante il processo di consolidamento dei dati.<\/span><\/p>\n<h3><b>Passo 1: Preparare i fogli di lavoro<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Il primo passo \u00e8 quello di preparare una tabella standard per tutti i paesi, gi\u00e0 formattata in modo identico.&nbsp; In particolare \u00e8 stata realizzata una tabella standard a matrice con i mesi in in riga e i nomi dei prodotti in colonna. Al fine di monitorare i dati e analizzarli, si utilizza un semplice modello excel, che comprende 5 fogli di lavoro ognuno specifico per le vendite dei suddetti paesi.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nel nostro esempio si \u00e8 deciso di aggiungere tutti gli elementi richiesti dal management: grafici dei trend mensili per servizio, % incidenza mensile per servizi e per mese, media mese.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Qui sotto, viene riportato lo screenshot del template adottato:<\/span><\/p>\n<p><img data-dominant-color=\"edf6f2\" data-has-transparency=\"true\" style=\"--dominant-color: #edf6f2;\" decoding=\"async\" loading=\"lazy\" class=\"has-transparency wp-image-8820 aligncenter\" src=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-300x131.png\" alt=\"\" width=\"561\" height=\"245\" srcset=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-300x131.png 300w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-1024x446.png 1024w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-768x334.png 768w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-1536x669.png 1536w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-18x8.png 18w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11-440x192.png 440w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.33.11.png 1640w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Procedere a inserire i fogli di lavoro separati per i paesi (Italy, Ireland, Poland, Spain, France) e un foglio di lavoro di consolidamento che collegheremo agli altri fogli con la formula tridimensionale applicata alla somma.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ogni mese gli uffici inviano i riepiloghi delle vendite per ciascun paese e per tipologia di prodotto.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Avremo, pertanto le seguenti tabelle per i 5 paesi:<\/span><\/p>\n<p><img data-dominant-color=\"ecf4f1\" data-has-transparency=\"true\" style=\"--dominant-color: #ecf4f1;\" decoding=\"async\" loading=\"lazy\" class=\"has-transparency wp-image-8821 aligncenter\" src=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-300x199.png\" alt=\"\" width=\"570\" height=\"378\" srcset=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-300x199.png 300w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-1024x681.png 1024w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-768x510.png 768w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-1536x1021.png 1536w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-2048x1361.png 2048w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-18x12.png 18w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-700x466.png 700w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.34.16-440x292.png 440w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/p>\n<h3><b>Passo 2: Utilizzare la Formula Tridimensionale SUM<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Nel foglio di lavoro di consolidamento, posizionati nella cella in cui desideri visualizzare il totale consolidato delle vendite. Utilizzeremo la formula SUM tridimensionale per sommare le vendite da tutti i fogli dei paesi. La formula dovrebbe apparire cos\u00ec:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=SUM(&#8216;Italy:France&#8217;!C5).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In questa formula, &#8216;Italy:France&#8217;!C5 indica che stai sommando il valore della cella C5 in tutti i fogli dei paesi da Italy a France. Assicurati che i nomi dei fogli dei paesi siano scritti correttamente e che siano separati da due punti.<\/span><\/p>\n<h3><b>Passo 3: Applica la Formula<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Dopo aver inserito la formula nella cella di consolidamento, premi Invio. Excel sommer\u00e0 automaticamente i valori della cella C5 in tutti i fogli dei paesi specificati.<\/span><\/p>\n<h3><b>Passo 4: Ripeti per Altre Celle o Periodi<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Se desideri consolidare i totali di altre celle o per altri periodi, puoi semplicemente copiare e incollare la formula tridimensionale in altre celle del foglio di consolidamento. Modifica la cella di riferimento (ad esempio, da C5 a un&#8217;altra cella) se necessario.<\/span><\/p>\n<h3><b>Passo 5: Ottieni il Totale Consolidato<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Alla fine, otterrai il totale consolidato delle vendite da tutti i paesi per la cella specifica che hai selezionato nel foglio di consolidamento.<br><\/span><span style=\"font-weight: 400;\">Procedere poi ad creare dei grafici di sintesi per un migliore effetto visuale e un riepilogo per Nazione e servizio:<\/span><\/p>\n<p><img data-dominant-color=\"e7ece2\" data-has-transparency=\"true\" style=\"--dominant-color: #e7ece2;\" decoding=\"async\" loading=\"lazy\" class=\"has-transparency wp-image-8822 aligncenter\" src=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-300x249.png\" alt=\"\" width=\"608\" height=\"505\" srcset=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-300x249.png 300w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-1024x850.png 1024w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-768x638.png 768w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-1536x1276.png 1536w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-14x12.png 14w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13-440x365.png 440w, https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-17-at-12.36.13.png 1628w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/p>\n<h3><b>Conclusions<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In conclusione, come avete potuto constatare, l&#8217;uso delle formule tridimensionali in Excel pu\u00f2 semplificare notevolmente la creazione di report basati su dati aggregare. Questo semplice approccio permette di risparmiare tempo, migliorare la precisione e ottenere una visione pi\u00f9 chiara dei dati aziendali. La gestione di dati provenienti da diverse fonti, da aggregare in un output finale,&nbsp; pu\u00f2 decisamente considerare l&#8217;utilizzo di formule tridimensionali per migliorare la tua experience nella realizzazione di reporting in Excel.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-29a3b32 e-con-boxed e-flex e-con\" data-id=\"29a3b32\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-09f0951 elementor-widget elementor-widget-heading\" data-id=\"09f0951\" data-element_type=\"widget\" data-settings=\"{&quot;avante_ext_is_scrollme&quot;:&quot;false&quot;,&quot;avante_ext_is_smoove&quot;:&quot;false&quot;,&quot;avante_ext_is_parallax_mouse&quot;:&quot;false&quot;,&quot;avante_ext_is_infinite&quot;:&quot;false&quot;}\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-xl\">Get the free files now!<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f79cea elementor-widget elementor-widget-text-editor\" data-id=\"9f79cea\" data-element_type=\"widget\" data-settings=\"{&quot;avante_ext_is_scrollme&quot;:&quot;false&quot;,&quot;avante_ext_is_smoove&quot;:&quot;false&quot;,&quot;avante_ext_is_parallax_mouse&quot;:&quot;false&quot;,&quot;avante_ext_is_infinite&quot;:&quot;false&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We believe in the value generated by the mutual exchange of opportunities! For this reason, Value4You has decided to make available to its community a collection of materials and documents useful for carrying out work effectively and facilitating management for decision-making. Register your details and download\u00a0<b>for free<\/b>\u00a0our files and documents for you.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed00261 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"ed00261\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;button_width&quot;:&quot;100&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;,&quot;avante_ext_is_scrollme&quot;:&quot;false&quot;,&quot;avante_ext_is_smoove&quot;:&quot;false&quot;,&quot;avante_ext_is_parallax_mouse&quot;:&quot;false&quot;,&quot;avante_ext_is_infinite&quot;:&quot;false&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.13.2 - 22-05-2023 *\/\n.elementor-button.elementor-hidden,.elementor-hidden{display:none}.e-form__step{width:100%}.e-form__step:not(.elementor-hidden){display:flex;flex-wrap:wrap}.e-form__buttons{flex-wrap:wrap}.e-form__buttons,.e-form__buttons__wrapper{display:flex}.e-form__indicators{display:flex;justify-content:space-between;align-items:center;flex-wrap:nowrap;font-size:13px;margin-bottom:var(--e-form-steps-indicators-spacing)}.e-form__indicators__indicator{display:flex;flex-direction:column;align-items:center;justify-content:center;flex-basis:0;padding:0 var(--e-form-steps-divider-gap)}.e-form__indicators__indicator__progress{width:100%;position:relative;background-color:var(--e-form-steps-indicator-progress-background-color);border-radius:var(--e-form-steps-indicator-progress-border-radius);overflow:hidden}.e-form__indicators__indicator__progress__meter{width:var(--e-form-steps-indicator-progress-meter-width,0);height:var(--e-form-steps-indicator-progress-height);line-height:var(--e-form-steps-indicator-progress-height);padding-right:15px;border-radius:var(--e-form-steps-indicator-progress-border-radius);background-color:var(--e-form-steps-indicator-progress-color);color:var(--e-form-steps-indicator-progress-meter-color);text-align:right;transition:width .1s linear}.e-form__indicators__indicator:first-child{padding-left:0}.e-form__indicators__indicator:last-child{padding-right:0}.e-form__indicators__indicator--state-inactive{color:var(--e-form-steps-indicator-inactive-primary-color,#c2cbd2)}.e-form__indicators__indicator--state-inactive [class*=indicator--shape-]:not(.e-form__indicators__indicator--shape-none){background-color:var(--e-form-steps-indicator-inactive-secondary-color,#fff)}.e-form__indicators__indicator--state-inactive object,.e-form__indicators__indicator--state-inactive svg{fill:var(--e-form-steps-indicator-inactive-primary-color,#c2cbd2)}.e-form__indicators__indicator--state-active{color:var(--e-form-steps-indicator-active-primary-color,#39b54a);border-color:var(--e-form-steps-indicator-active-secondary-color,#fff)}.e-form__indicators__indicator--state-active [class*=indicator--shape-]:not(.e-form__indicators__indicator--shape-none){background-color:var(--e-form-steps-indicator-active-secondary-color,#fff)}.e-form__indicators__indicator--state-active object,.e-form__indicators__indicator--state-active svg{fill:var(--e-form-steps-indicator-active-primary-color,#39b54a)}.e-form__indicators__indicator--state-completed{color:var(--e-form-steps-indicator-completed-secondary-color,#fff)}.e-form__indicators__indicator--state-completed [class*=indicator--shape-]:not(.e-form__indicators__indicator--shape-none){background-color:var(--e-form-steps-indicator-completed-primary-color,#39b54a)}.e-form__indicators__indicator--state-completed .e-form__indicators__indicator__label{color:var(--e-form-steps-indicator-completed-primary-color,#39b54a)}.e-form__indicators__indicator--state-completed .e-form__indicators__indicator--shape-none{color:var(--e-form-steps-indicator-completed-primary-color,#39b54a);background-color:initial}.e-form__indicators__indicator--state-completed object,.e-form__indicators__indicator--state-completed svg{fill:var(--e-form-steps-indicator-completed-secondary-color,#fff)}.e-form__indicators__indicator__icon{width:var(--e-form-steps-indicator-padding,30px);height:var(--e-form-steps-indicator-padding,30px);font-size:var(--e-form-steps-indicator-icon-size);border-width:1px;border-style:solid;display:flex;justify-content:center;align-items:center;overflow:hidden;margin-bottom:10px}.e-form__indicators__indicator__icon img,.e-form__indicators__indicator__icon object,.e-form__indicators__indicator__icon svg{width:var(--e-form-steps-indicator-icon-size);height:auto}.e-form__indicators__indicator__icon .e-font-icon-svg{height:1em}.e-form__indicators__indicator__number{width:var(--e-form-steps-indicator-padding,30px);height:var(--e-form-steps-indicator-padding,30px);border-width:1px;border-style:solid;display:flex;justify-content:center;align-items:center;margin-bottom:10px}.e-form__indicators__indicator--shape-circle{border-radius:50%}.e-form__indicators__indicator--shape-square{border-radius:0}.e-form__indicators__indicator--shape-rounded{border-radius:5px}.e-form__indicators__indicator--shape-none{border:0}.e-form__indicators__indicator__label{text-align:center}.e-form__indicators__indicator__separator{width:100%;height:var(--e-form-steps-divider-width);background-color:#babfc5}.e-form__indicators--type-icon,.e-form__indicators--type-icon_text,.e-form__indicators--type-number,.e-form__indicators--type-number_text{align-items:flex-start}.e-form__indicators--type-icon .e-form__indicators__indicator__separator,.e-form__indicators--type-icon_text .e-form__indicators__indicator__separator,.e-form__indicators--type-number .e-form__indicators__indicator__separator,.e-form__indicators--type-number_text .e-form__indicators__indicator__separator{margin-top:calc(var(--e-form-steps-indicator-padding, 30px) \/ 2 - var(--e-form-steps-divider-width, 1px) \/ 2)}.elementor-field-type-hidden{display:none}.elementor-field-type-html{display:inline-block}.elementor-login .elementor-lost-password,.elementor-login .elementor-remember-me{font-size:.85em}.elementor-field-type-recaptcha_v3 .elementor-field-label{display:none}.elementor-field-type-recaptcha_v3 .grecaptcha-badge{z-index:1}.elementor-button .elementor-form-spinner{order:3}.elementor-form .elementor-button>span{display:flex;justify-content:center;align-items:center}.elementor-form .elementor-button .elementor-button-text{white-space:normal;flex-grow:0}.elementor-form .elementor-button svg{height:auto}.elementor-form .elementor-button .e-font-icon-svg{height:1em}.elementor-select-wrapper .select-caret-down-wrapper{position:absolute;top:50%;transform:translateY(-50%);inset-inline-end:10px;pointer-events:none;font-size:11px}.elementor-select-wrapper .select-caret-down-wrapper svg{display:unset;width:1em;aspect-ratio:unset;fill:currentColor}.elementor-select-wrapper .select-caret-down-wrapper i{font-size:19px;line-height:2}.elementor-select-wrapper.remove-before:before{content:\"\"!important}<\/style>\t\t<form class=\"elementor-form\" method=\"post\" name=\"Scarica file &quot;ESEMPIO&quot;, articolo Vanzulli\" action=\"\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"8819\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"ed00261\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Value4you\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-name elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[name]\" id=\"form-field-name\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"*Name and Surname\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"*Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-message elementor-col-100\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-message\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tMessage\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[message]\" id=\"form-field-message\" rows=\"4\" placeholder=\"Message\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-acceptance elementor-field-group elementor-column elementor-field-group-field_6af7637 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t<div class=\"elementor-field-subgroup\">\n\t\t\t<span class=\"elementor-field-option\">\n\t\t\t\t<input type=\"checkbox\" name=\"form_fields[field_6af7637]\" id=\"form-field-field_6af7637\" class=\"elementor-field elementor-size-sm  elementor-acceptance-field\" required=\"required\" aria-required=\"true\">\n\t\t\t\t<label for=\"form-field-field_6af7637\"><span style=\"font-size:10px;\">I declare that I have read the Privacy Policy and consent to the processing of my personal data for the purpose of providing the service. <a href=\"https:\/\/www.iubenda.com\/privacy-policy\/51809648\" class=\"iubenda-white no-brand iubenda-embed\" title=\"Privacy Policy \">Privacy Policy<\/a><script type=\"text\/javascript\">(function (w,d) {var loader = function () {var s = d.createElement(\"script\"), tag = d.getElementsByTagName(\"script\")[0]; s.src=\"https:\/\/cdn.iubenda.com\/iubenda.js\"; tag.parentNode.insertBefore(s,tag);}; if(w.addEventListener){w.addEventListener(\"load\", loader, false);}else if(w.attachEvent){w.attachEvent(\"onload\", loader);}else{w.onload = loader;}})(window, document);<\/script>.<\/span> <\/label>\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-acceptance elementor-field-group elementor-column elementor-field-group-field_b49504b elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t<div class=\"elementor-field-subgroup\">\n\t\t\t<span class=\"elementor-field-option\">\n\t\t\t\t<input type=\"checkbox\" name=\"form_fields[field_b49504b]\" id=\"form-field-field_b49504b\" class=\"elementor-field elementor-size-sm  elementor-acceptance-field\" required=\"required\" aria-required=\"true\">\n\t\t\t\t<label for=\"form-field-field_b49504b\"><span style=\"font-size:10px;\">I consent to the processing of my personal data for the purpose of receiving newsletters, informative, and promotional communications from Minerva S.r.l.s. regarding their own initiatives and\/or those of their partners, as described in the privacy policy.<\/span><\/label>\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">GET THE FILES<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<input type=\"hidden\" name=\"trp-form-language\" value=\"en\"\/><\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6c220c8 e-con-boxed e-flex e-con\" data-id=\"6c220c8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>di&nbsp;Luca VanzulliBlogger, Planning &amp; Control Specialist, Content Marketer Quando si tratta di creare report aziendali, Excel sempre uno strumento evergreen. Tuttavia, spesso ci troviamo a dover gestire dati complessi provenienti da diverse fonti. In questo contesto, le formule tridimensionali di [&hellip;]<\/p>","protected":false},"author":2,"featured_media":8824,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":""},"categories":[57,69],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.12 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.value4you.it\/en\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you\" \/>\n<meta property=\"og:description\" content=\"di&nbsp;Luca VanzulliBlogger, Planning &amp; Control Specialist, Content Marketer Quando si tratta di creare report aziendali, Excel sempre uno strumento evergreen. Tuttavia, spesso ci troviamo a dover gestire dati complessi provenienti da diverse fonti. In questo contesto, le formule tridimensionali di [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.value4you.it\/en\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Value4you\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-17T10:54:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-18T12:27:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Value4You-Luca-Vanzulli-Excel-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1660\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"VALUE4YOU\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"VALUE4YOU\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/\",\"url\":\"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/\",\"name\":\"Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you\",\"isPartOf\":{\"@id\":\"https:\/\/www.value4you.it\/#website\"},\"datePublished\":\"2023-10-17T10:54:52+00:00\",\"dateModified\":\"2023-10-18T12:27:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.value4you.it\/#\/schema\/person\/d47eab86edf30578234f2f90feeb447b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.value4you.it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formule Tridimensionali e formattazioni in Excel per creare Report\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.value4you.it\/#website\",\"url\":\"https:\/\/www.value4you.it\/\",\"name\":\"Value4you\",\"description\":\"Value4you\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.value4you.it\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.value4you.it\/en\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/","og_locale":"en_US","og_type":"article","og_title":"Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you","og_description":"di&nbsp;Luca VanzulliBlogger, Planning &amp; Control Specialist, Content Marketer Quando si tratta di creare report aziendali, Excel sempre uno strumento evergreen. Tuttavia, spesso ci troviamo a dover gestire dati complessi provenienti da diverse fonti. In questo contesto, le formule tridimensionali di [&hellip;]","og_url":"https:\/\/www.value4you.it\/en\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/","og_site_name":"Value4you","article_published_time":"2023-10-17T10:54:52+00:00","article_modified_time":"2023-10-18T12:27:17+00:00","og_image":[{"width":2560,"height":1660,"url":"https:\/\/www.value4you.it\/wp-content\/uploads\/2023\/10\/Value4You-Luca-Vanzulli-Excel-scaled.webp","type":"image\/jpeg"}],"author":"VALUE4YOU","twitter_card":"summary_large_image","twitter_misc":{"Written by":"VALUE4YOU","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/","url":"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/","name":"Formule Tridimensionali e formattazioni in Excel per creare Report - Value4you","isPartOf":{"@id":"https:\/\/www.value4you.it\/#website"},"datePublished":"2023-10-17T10:54:52+00:00","dateModified":"2023-10-18T12:27:17+00:00","author":{"@id":"https:\/\/www.value4you.it\/#\/schema\/person\/d47eab86edf30578234f2f90feeb447b"},"breadcrumb":{"@id":"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.value4you.it\/formule-tridimensionali-e-formattazioni-in-excel-per-creare-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.value4you.it\/"},{"@type":"ListItem","position":2,"name":"Formule Tridimensionali e formattazioni in Excel per creare Report"}]},{"@type":"WebSite","@id":"https:\/\/www.value4you.it\/#website","url":"https:\/\/www.value4you.it\/","name":"Value4you","description":"Value4you","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.value4you.it\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/posts\/8819"}],"collection":[{"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/comments?post=8819"}],"version-history":[{"count":0,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/posts\/8819\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/media\/8824"}],"wp:attachment":[{"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/media?parent=8819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/categories?post=8819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.value4you.it\/en\/wp-json\/wp\/v2\/tags?post=8819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}