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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(16 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center]]
rect 2 85 204 193 [[The_basic_functions_of_firesys]]
 
rect 211 82 515 192 [[The_account_workbook]]
 
rect 522 82 612 192 [[The_functions_of_the_master_value_manager]]
rect 614 81 698 191 [[Synchronise_and_detach]]
rect 884 82 1041 184 [[The_validation_basic_functions]]
rect 702 114 879 136 [[Synchronise_and_detach]]
rect 702 140 880 168 [[Insert_transmitter_values]]
rect 705 81 878 110 [[Insert_values_in_Excel]]
rect 1046 83 1181 190 [[An_overview_of_the_rolling_forward_function]]
desc none
</imagemap>




Zeile 20: 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 26: 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=General_information_about_the_roll_forward_function]] [[General_information_about_the_roll_forward_function|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=General_information_about_the_roll_forward_function]]-->
<!--[[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>'''[[General_information_about_the_roll_forward_function|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=Rolling_forward_values_from_the_MeetingPoint]] [[Rolling_forward_values_from_the_MeetingPoint|Rolling forward values from the MeetingPoint]]</div>
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Rolling_forward_values_from_the_MeetingPoint]]-->
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>'''[[Rolling_forward_values_from_the_MeetingPoint|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=Rolling_forward_case_studies]] [[Rolling_forward_case_studies|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=Rolling_forward_case_studies]]-->
<!--[[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>'''[[Rolling_forward_case_studies|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>  
Zeile 55: Zeile 39:


[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_account_workbook|The account workbook]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <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=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values 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=]] [[The_validation_basic_functions|The validation basic functions]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Zentralwerte-Ü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

Abgerufen von „https://hilfe.firesys.de/mediawiki/index.php?title=An_overview_of_the_rolling_forward_function&oldid=18288“