An overview of the rolling forward function: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 20: | Zeile 20: | ||
|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=]] | ||
|} | |} |
Version vom 22. April 2020, 08:34 Uhr
<imagemap>Image:EN_Excel_Menüband_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>
| |||||
Find out about the “roll forward” function in firesys - a tool that helps you to prepare a business report which you can reuse in the next quarter/financial year. mehr
|
When you use the “roll forward” function, you can also “roll forward” the values that were stored centrally in the MeetingPoint - it’s important to note the difference between values that are dependent and not dependent on key dates. 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
The account workbook
The functions of the master value manager
Insert values in Excel
The validation basic functions