Maintain Excel contents: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
<imagemap>Image:EN_Excel_Menüband_Inhalt.jpg|1200px|center | <imagemap>Image:EN_Excel_Menüband_Inhalt.jpg|1200px|center | ||
desc none | desc none | ||
</imagemap> | </imagemap> | ||
| Zeile 25: | 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:Kontenmappe.png|link=The_account_workbook]] [[The_account_workbook| | <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:Kontenmappe.png|link=The_account_workbook]] [[The_account_workbook|The account workbook]]</div> | ||
<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=The_account_workbook]]--> | <!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=The_account_workbook]]--> | ||
| Zeile 33: | Zeile 25: | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | 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:Arbeit-mit-zentralwerten 09.png|link=The_functions_of_the_master_value_manager]] [[The_functions_of_the_master_value_manager| | <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:Arbeit-mit-zentralwerten 09.png|link=The_functions_of_the_master_value_manager]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]]</div> | ||
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=The_functions_of_the_master_value_manager]]--> | <!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=The_functions_of_the_master_value_manager]]--> | ||
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. <small>'''[[The_functions_of_the_master_value_manager|more]]'''</small> | 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. <small>'''[[The_functions_of_the_master_value_manager|more]]'''</small> | ||
| Zeile 49: | Zeile 41: | ||
| style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | | style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | ||
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | <!-- ABS.1: Linke 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:Validierung.png|link=The_validation_basic_functions]] [[The_validation_basic_functions| | <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:Validierung.png|link=The_validation_basic_functions]] [[The_validation_basic_functions|The validation basic functions]]</div> | ||
<!--[[Datei:BlattStatus.jpg|left|175px|Testbild|link=The_validation_basic_functions]]--> | <!--[[Datei:BlattStatus.jpg|left|175px|Testbild|link=The_validation_basic_functions]]--> | ||
| Zeile 57: | Zeile 49: | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | 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:rxbtnCellRollForward_32.png|link=An overview of the rolling forward function]] [[An overview of the rolling forward function| | <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:rxbtnCellRollForward_32.png|link=An overview of the rolling forward function]] [[An overview of the rolling forward function|An overview of the rolling forward function]]</div> | ||
<!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=An overview of the rolling forward function]]--> | <!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=An overview of the rolling forward function]]--> | ||
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. <small>'''[[An overview of the rolling forward function|more]]'''</small> | 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. <small>'''[[An overview of the rolling forward function|more]]'''</small> | ||
| Zeile 72: | Zeile 64: | ||
[[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br> | [[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document| | [[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document|Design an Excel document]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]] <br> | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:English-Excel Dokument-Validierungen ]] | [[Kategorie:English-Excel Dokument-Validierungen ]] | ||
Version vom 23. Juli 2020, 07:43 Uhr
<imagemap>Image:EN_Excel_Menüband_Inhalt.jpg|1200px|center
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
Design an Excel document
Translations in Excel
The worksheet status in Excel