Maintain Excel contents: Unterschied zwischen den Versionen

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

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.

Data import

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

The functions of the master value manager

Here you will learn everything about the Master value manager, its functions and working with master values.more

Insert values in Excel

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

The validation basic functions

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

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. more

Automated worksheet

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

Further contents

→ firesys website
→ Customer area
→ YouTube

@@ Zeile 1: / Zeile 1: @@
-<imagemap>Datei:EN_Excel Menüband Inhalt.jpg|center|1200px
+[[Datei:EN_Menüband_Excel_Inhalt.jpg|1200px|center]]
-rect 1 79 208 191 [[Die_Basisfunktionen_von_firesy]]
-rect 212 78 283 190 [[Die_Kontenmappe]]
-rect 287 77 365 189 [[Arbeit_mit_Zentralwerten]]
-rect 371 76 513 108 [[Die_Kontenmappe#Kontenmappen_sortieren]]
-rect 372 110 512 139 [[Die_Kontenmappe#Zeilen_l.C3.B6schen]]
-rect 373 140 510 171 [[Die_Kontenmappe#Der_Kontowert-Verlauf]]
-rect 535 83 623 190 [[Der_Zentralwert-Manager]]
-rect 626 82 731 191 [[Werte_synchronisieren_und_lösen]]
-rect 735 83 888 112 [[Werte_in_Excel_einfügen]]
-rect 733 112 888 135 [[Werte_synchronisieren_und_lösen#Werte_l.C3.B6sen]]
-rect 736 135 888 169 [[Senderwerte_einfügen]]
-rect 894 81 991 188 [[Das_Validierungsblatt]]
-rect 998 80 1122 110 [[Validierungen_erstellen]]
-rect 996 112 1118 137 [[Validierung_bearbeiten]]
-rect 995 141 1118 176 [[Validierung_löschen]]
-rect 1132 81 1287 190 [[Die_Vorrollen_Funktionen_in_der_Übersicht]]
-desc none
-</imagemap>
 {| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
@@ Zeile 31: / Zeile 15: @@
 | style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
 <!-- 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=Die_Kontenmappe]] [[Die_Kontenmappe|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=Die_Kontenmappe]]-->
+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>'''[[Die_Kontenmappe|mehr]]'''</small>
 ----
 | 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=Übersicht_Zentralwert-Manager]] [[Übersicht_Zentralwert-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=Übersicht_Zentralwert-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>'''[[Übersicht_Zentralwert-Manager|mehr]]'''</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>
 | 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:Werte einfügen 32.png|link=Werte_in_Excel_einfügen]] [[Werte_in_Excel_einfügen|Insert values 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:Werte einfügen 32.png|link=Insert_values_in_Excel]] [[Insert_values_in_Excel|Insert values in Excel]]</div>
-<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Werte_in_Excel_einfügen]]-->
+<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Insert_values_in_Excel]]-->
-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. <small>'''[[Werte_in_Excel_einfügen|mehr]]'''</small>
+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. <small>'''[[Insert_values_in_Excel|more]]'''</small>
 -----
 </div>
@@ Zeile 55: / Zeile 38: @@
 | style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
 <!-- 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=Übersicht_Validierungen]] [[Übersicht_Validierungen|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=Übersicht_Validierungen]]-->
+<!--[[Datei:BlattStatus.jpg|left|175px|Testbild|link=The_validation_basic_functions]]-->
-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.  <small>'''[[Übersicht_Validierungen|mehr]]'''</small>
+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.  <small>'''[[The_validation_basic_functions|more]]'''</small>
 ----
 | 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=Die_Vorrollen_Funktionen_in_der_Übersicht]] [[Die_Vorrollen_Funktionen_in_der_Übersicht|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=Die_Vorrollen_Funktionen_in_der_Übersicht]]-->
+<!--[[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>'''[[Die_Vorrollen_Funktionen_in_der_Übersicht|mehr]]'''</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>
 <br />
@@ Zeile 75: / Zeile 63: @@
 __NOTOC__
 __NOEDITSECTION__
-== Siehe auch  ==
+== See also  ==
-[[Datei:Navigation_hoch.svg|link=]]  [[Die_firesys-Funktionen_in_Excel|Die firesys-Funktionen in Excel]] <br>
+[[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br>
-[[Datei:Navigation_rechts.svg|link=]] [[Excel-Gestaltungs-Funktionen|Die Gestaltungs-Funktionen in Excel]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document|Design an Excel document]] <br>
-[[Datei:Navigation_rechts.svg|link=]] [[Übersetzungen_in_Excel|Übersetzungen in Excel]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br>
-[[Datei:Navigation_rechts.svg|link=]] [[Der_Blatt-Status_in_Excel|Der Blatt-Status]]   <br>
+[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]]   <br>
+{{MoreContent}}
-{{WeitereInhalte}}
+[[Kategorie:English-Excel Dokument-Validierungen ]]
-[[Kategorie:Excel Dokument-Blattstatus]]

Maintain Excel contents: Unterschied zwischen den Versionen

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

See also

Further contents

Navigationsmenü

Suche