An overview of the rolling forward function: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(23 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Datei:Excel Menüband Inhalt.jpg|center
[[Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center]]
rect 0 80 199 183 [[Funktionen_in_Excel]]
 
rect 203 82 504 182 [[Funktionen_in_Excel]]
 
rect 509 82 844 183 [[Funktionen_in_Excel]]
 
rect 851 83 1071 183 [[Funktionen_in_Excel]]
rect 1073 82 1249 182 [[Funktionen_in_Excel]]
desc none
</imagemap>




Zeile 15: Zeile 11:
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=]]
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=]]
|style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">An overview of the roll forward functions</div>
|style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">An overview of the roll forward functions</div>
.<br/>
Use the rolling forward function in Excel to prepare your report for the next quarter or financial year. After the setup process, you will now benefit from the “automatic” roll forward process.<br/>
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=]]
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=]]
|}
|}
Zeile 21: Zeile 17:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:Infoportal Vorrollen Allgemeine Informationen 32 B.png|link=Allgemeines zur Vorrollen-Funktion]] [[Allgemeines zur Vorrollen-Funktion|General information]]</div>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:Infoportal Vorrollen Allgemeine Informationen 32 B.png|link=General_information_about_the_roll_forward_function]] [[Configure_roll_forward|Configure_roll_forward]]</div>


<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Allgemeines zur Vorrollen-Funktion]]-->
<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=General_information_about_the_roll_forward_function]]-->
Find out about the &ldquo;roll forward&rdquo; function in firesys - a tool that helps you to prepare a business report which you can reuse in the next quarter/financial year.<small>'''[[Allgemeines zur Vorrollen-Funktion|mehr]]'''</small>
The "roll forward" function of firesys offers you the possibility to work sustainably on your business reports and to prepare your report for the next quarter or fiscal year. Values or master values that are in one column of an Excel workbook can be automatically transferred to another column after the set-up process.<small>'''[[Configure_roll_forward|mehr]]'''</small>
----
----


| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Infoportal Vorrollen aus MP Werten A.png|link=Vorrollen von MeetingPoint Inhalten]] [[Vorrollen von MeetingPoint Inhalten|Rolling forward values from the MeetingPoint]]</div>
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Vorrollen von MeetingPoint Inhalten]]-->
When you use the &ldquo;roll forward&rdquo; function, you can also &ldquo;roll forward&rdquo; the values that were stored centrally in the MeetingPoint - it&rsquo;s important to note the difference between values that are dependent and not dependent on key dates. <small>'''[[Vorrollen von MeetingPoint Inhalten|mehr]]'''</small>
-----
</div>


| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Infoportal Vorrollen in Praxis C.png|link=Anwendungsbeispiele_Vorrollen]] [[Anwendungsbeispiele_Vorrollen|Rolling forward table columns in practice]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Infoportal Vorrollen in Praxis C.png|link=Rolling_forward_case_studies]] [[Rolling_forward_case_studies|Rolling forward case studies]]</div>
<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Anwendungsbeispiele_Vorrollen]]-->
<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Rolling_forward_case_studies]]-->
The &ldquo;roll forward&rdquo; function must be initialised and set up first of all to ensure that you can work with your worksheet in the long term. Of course, you can change any &ldquo;roll forward&rdquo; processes that were already set up. <small>'''[[Anwendungsbeispiele_Vorrollen|mehr]]'''</small>  
The &ldquo;roll forward&rdquo; function must be initialised and set up first of all to ensure that you can work with your worksheet in the long term. Of course, you can change any &ldquo;roll forward&rdquo; processes that were already set up. <small>'''[[Rolling_forward_case_studies|mehr]]'''</small>  
-----
-----
</div>
</div>
Zeile 47: Zeile 36:
__NOEDITSECTION__
__NOEDITSECTION__


== Siehe auch  ==
== See also ==


[[Datei:Navigation_hoch.svg|link=]]  [[Die_firesys-Funktionen_in_Excel|Die firesys-Funktionen in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel-Gestaltungs-Funktionen|Die Gestaltungs-Funktionen in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Übersetzungen_in_Excel|Übersetzungen in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Validierungen_in_Excel|Validierungen in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_validation_basic_functions|The validation basic functions]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>


{{WeitereInhalte}}
{{MoreContent}}
[[Kategorie:Excel Dokument-Werteeinfügen-Übersicht]]
[[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]]

Aktuelle Version vom 19. November 2021, 13:20 Uhr

EN Menüband Excel Inhalt Vorrollen.jpg



Excel Funktionen 64.png
An overview of the roll forward functions

Use the rolling forward function in Excel to prepare your report for the next quarter or financial year. After the setup process, you will now benefit from the “automatic” roll forward process.

Excel Funktionen 64.png

The "roll forward" function of firesys offers you the possibility to work sustainably on your business reports and to prepare your report for the next quarter or fiscal year. Values or master values that are in one column of an Excel workbook can be automatically transferred to another column after the set-up process.mehr



The “roll forward” function must be initialised and set up first of all to ensure that you can work with your worksheet in the long term. Of course, you can change any “roll forward” processes that were already set up. mehr





See also

Navigation hoch.svg Maintain Excel contents
Navigation rechts.svg Data import
Navigation rechts.svg The functions of the master value manager
Navigation rechts.svg Insert values in Excel
Navigation rechts.svg The validation basic functions
Navigation rechts.svg Automated worksheet

Further contents

firesys website
Customer area
YouTube