Maintain Excel contents: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 1: | Zeile 1: | ||
<imagemap> | <imagemap>Image:EN_Excel_Menüband_Status.jpg|1200px|center | ||
rect | rect 2 85 204 193 [[The_basic_functions_of_firesys]] | ||
rect | rect 211 82 515 192 [[The_account_workbook]] | ||
rect | rect 522 82 612 192 [[The_functions_of_the_master_value_manager]] | ||
rect | rect 614 81 698 191 [[Synchronise_and_detach]] | ||
rect | 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 | rect 1046 83 1181 190 [[An_overview_of_the_rolling_forward_function]] | ||
rect | |||
rect | |||
rect | |||
desc none | desc none | ||
</imagemap> | </imagemap> | ||
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" | {| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" |
Version vom 22. April 2020, 07:18 Uhr
<imagemap>Image:EN_Excel_Menüband_Status.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>
| |||||
You use the account workbook in firesys as a tool for creating, viewing and changing the account values that are maintained in the master value manager. more
|
The term “master value” describes different types of values with numerical values that are saved in the firesys MeetingPoint. These master values can be used for cross-file functions in all of your firesys documents. more |
The master values that are saved in the MeetingPoint can be used in all of your firesys documents by inserting the value type that is required for each at the designated position in the workbook. more
| |||
You can compare figures in an Excel file/database or across files and thus validate and review them for consistency. The number pairs are provided in a clear overview on the validation sheet. more
|
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. more
|
See also
The firesys functions in Excel
The design functions in Excel
Translations in Excel
The worksheet status