An overview of the rolling forward function: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (22 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center]] | |||
| 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= | <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= | <!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=General_information_about_the_roll_forward_function]]--> | ||
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: 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= | <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= | <!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Rolling_forward_case_studies]]--> | ||
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. <small>'''[[ | 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. <small>'''[[Rolling_forward_case_studies|mehr]]'''</small> | ||
----- | ----- | ||
</div> | </div> | ||
| Zeile 47: | Zeile 36: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
== | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[Maintain_Excel_contents|Maintain Excel contents]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[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=]] [[ | [[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> | |||
{{ | {{MoreContent}} | ||
[[Kategorie:Excel Dokument- | [[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]] | ||
Aktuelle Version vom 19. November 2021, 13:20 Uhr
| |||||
|
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
Maintain Excel contents
Data import
The functions of the master value manager
Insert values in Excel
The validation basic functions
Automated worksheet