Maintain Excel contents: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(13 dazwischenliegende Versionen von 4 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Image:EN_Excel_Menüband_Status.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt.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>




Zeile 25: Zeile 15:
| 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|Using the account workbook]]</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:ImportData.32.png|link=Data_import]] [[Data_import|Data import]]</div>


<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=The_account_workbook]]-->
Use the Import options in firesys to integrate data from the upstream system quickly and efficiently in firesys. <small>'''[[Data_import| more]]'''</small>
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. <small>'''[[The_account_workbook| more]]'''</small>
----
----




| 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|Working with master values]]</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: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 &ldquo;master value&rdquo; 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>  
Here you will learn everything about the Master value manager, its functions and working with master values.<small>'''[[The_functions_of_the_master_value_manager|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 49: Zeile 38:
| 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|Validations in Excel]]</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: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 46:


| 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|The rolling forward function]]</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: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 &ldquo;automatic&rdquo; 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 &ldquo;automatic&rdquo; roll forward process. <small>'''[[An overview of the rolling forward function|more]]'''</small>  
-----
-----
</div>


| 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:Automatisiertes Arbeitsblatt.png|link=Automated_worksheet]] [[Automated_worksheet|Automated worksheet]]</div>
Use the automated worksheets to efficiently insert numerical values from the MeetingPoint into your Excel document.<small>'''[[Automated_worksheet|mehr]]'''</small>
-----
</div>
</div>
<br />
<br />
Zeile 72: Zeile 66:


[[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|The design functions in Excel]] <br>
[[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 ]]

Aktuelle Version vom 19. November 2021, 12:48 Uhr

EN Menüband Excel Inhalt.jpg



Excel Funktionen 64.png
Maintain Excel contents

Working with firesys in Excel provides you with various tools that you can use to maintain the contents of your workbook and to add contents from the MeetingPoint.

Excel Funktionen 64.png

Use the Import options in firesys to integrate data from the upstream system quickly and efficiently in firesys. more



Here you will learn everything about the Master value manager, its functions and working with master values.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


Use the automated worksheets to efficiently insert numerical values from the MeetingPoint into your Excel document.mehr




See also

Navigation hoch.svg The firesys functions in Excel
Navigation rechts.svg Design an Excel document
Navigation rechts.svg Translations in Excel
Navigation rechts.svg The worksheet status in Excel

Further contents

firesys website
Customer area
YouTube