The validation basic functions: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(11 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Image:EN_Excel_Menüband_Inhalt_Validierungen.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt_Validierungen.jpg|1200px|center]]


desc none
</imagemap>




Zeile 34: Zeile 32:
</div>
</div>
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
| 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:Auto-Validierung.png|link=Auto-validations_in_firesys]] [[Auto-validations_in_firesys|Auto-validations]]</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:Auto-Validierung.png|link=Auto-validations_in_firesys]] [[Auto-validations_in_firesys|Auto-validations in firesys]]</div>
<!--<div style="text-align:center;"> -->
<!--<div style="text-align:center;"> -->


Zeile 44: Zeile 42:
| 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:rxbtnCellEditValidationEntry_32.png|link=Edit_validations]] [[Edit_validations|Edit and update validations]]</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:Validierungsblatt.png|link=The validation worksheet]] [[The_validation_worksheet|The validation worksheet]]</div>


<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Edit_validations]]-->
<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Edit_validations]]-->
When you process a validation, you can change the selected validation and also edit the comment or the designation. <small>'''[[Edit_validations|more]]'''</small>  
With the validation sheet you have the possibility to compare "pairs of numbers" with each other and thus check for validation and consistency. The pairs of numbers are clearly summarized on the validation sheet, deviations are additionally displayed. <small>'''[[The_validation_worksheet|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:rxbtnCellDeleteRow_32.png|link=Delete validations]] [[Delete validations|Delete validations]]</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:rxbtnCellEditValidationEntry_32.png|link=Edit_validations]][[Edit_validations|Edit]],[[Datei:rxbtnCellDeleteRow_32.png|link=Delete validations]] [[Delete validations|delete]] and [[Datei:RxbtnCellCreateUpdateCompare 32.png|link=Update_validations]] [[Update_validations|update validations]]</div>
<div style="text-align:center;">
<div style="text-align:center;">


<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Delete validations]]-->
<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Delete validations]]-->
You can delete validations that were created. Multiple selection is also possible here. <small>'''[[Delete validations|more]]'''</small>  
It is also possible to edit, update and delete created validations later. Here firesys offers you fast accessible tools. <small>'''[[Update_validations|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 74: Zeile 72:


[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_account_workbook|The account workbook]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[An_overview_of_the_rolling_forward_function|An overview of the roll forward functions]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[An_overview_of_the_rolling_forward_function|An overview of the rolling forward function]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]]
[[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]]

Aktuelle Version vom 19. November 2021, 13:10 Uhr

EN Menüband Excel Inhalt Validierungen.jpg




Excel Funktionen 64.png
The validation basic functions

You can (automatically) compare two or more numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.

Excel Funktionen 64.png

With the help of a single validation you can create a new validation whereby two individual values are related to each other. more



With the help of a multiple validation you can create a new validation whereby you can summarise several values in formulas. This enables you to validate related values in one step. more


With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. more


With the validation sheet you have the possibility to compare "pairs of numbers" with each other and thus check for validation and consistency. The pairs of numbers are clearly summarized on the validation sheet, deviations are additionally displayed. more



It is also possible to edit, update and delete created validations later. Here firesys offers you fast accessible tools. more



Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the validation sheet nor are they marked as errors in the Word tables. more


See also

Navigation hoch.svg Maintain Excel contents
Navigation rechts.svg Data import
Navigation rechts.svg The functions of the master value manager
Navigation rechts.svg Insert values in Excel
Navigation rechts.svg An overview of the rolling forward function
Navigation rechts.svg Automated worksheet

Further contents

firesys website
Customer area
YouTube