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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(17 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=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 50: 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“