Quelltext der Seite Maintain Excel contents

[[Datei:EN_Menüband_Excel_Inhalt.jpg|1200px|center]]



{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
|-
|colspan="3"|
{| style="background:#FFFFFF; width:100%; border-collapse:collapse;"
|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%;">Maintain Excel contents</div>
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.<br/>
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=]]
|}
|-
| 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:ImportData.32.png|link=Data_import]] [[Data_import|Data import]]</div>

Use the Import options in firesys to integrate data from the upstream system quickly and efficiently in firesys. <small>'''[[Data_import| 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: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]]-->
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=Insert_values_in_Excel]] [[Insert_values_in_Excel|Insert values in Excel]]</div>
<!--[[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>'''[[Insert_values_in_Excel|more]]'''</small> 
-----
</div>
<br />
|-
| 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=The_validation_basic_functions]] [[The_validation_basic_functions|The validation basic functions]]</div>

<!--[[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>'''[[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=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]]-->
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 />
|-
<br />
|}
__NOTOC__
__NOEDITSECTION__
== See also  ==

[[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|Design an Excel document]] <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 in Excel]]   <br>

{{MoreContent}}

[[Kategorie:English-Excel Dokument-Validierungen ]]