The validation basic functions: Unterschied zwischen den Versionen

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

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.

Create validations

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

Create multiple validations

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

Auto-validations in firesys

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

The validation worksheet

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

Edit,

delete and

update validations

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

Approve deviations

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

Further contents

→ firesys website
→ Customer area
→ YouTube

@@ Zeile 1: / Zeile 1: @@
-<imagemap>Datei:Excel-Validierung-Menüband-Grundfunktionen.jpg|center
+[[Datei:EN_Menüband_Excel_Inhalt_Validierungen.jpg|1200px|center]]
-rect 2 78 215 197 [[Die_Basisfunktionen_von_firesys]]
-rect 328 84 785 202 [[Dateiübergreifende_Validierungen]]
-rect 224 83 325 200 [[Die_Kontenmappe]]
-rect 791 86 1063 199 [[Das_Validierungsblatt]]
-rect 1069 88 1387 200 [[Der_Zentralwert-Manager]]
-rect 215 81 317 194 [[Validierung_bearbeiten]]
-rect 323 80 403 195 [[Validierungen_erstellen]]
-rect 409 80 484 192 [[Validierung_bearbeiten]]
-rect 488 82 565 190 [[Validierung_löschen]]
-rect 574 81 757 110 [[Abweichungen_freigeben]]
-rect 580 116 755 144 [[Abweichungen_freigeben]]
-desc none
-#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
-</imagemap>
@@ Zeile 33: / Zeile 20: @@
 <!--[[Datei:Dummybild.jpeg|left|175px|Testbild]]-->
 With the help of a single validation you can create a new validation whereby two individual values are related to each other. <small>'''[[Create_validations|more]]'''</small>
 ----
@@ Zeile 39: / Zeile 25: @@
 | 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:Mehrfach_Validierung.png|link=Mehrfach-Validierung]] [[Mehrfach-Validierung|Create multiple 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:Mehrfach_Validierung.png|link=Create_multiple_validations]] [[Create_multiple_validations|Create multiple validations]]</div>
-[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Mehrfach-Validierung]]
+<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Create_multiple_validations]]-->
+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. <small>'''[[Create_multiple_validations|more]]'''</small>
-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. <small>'''[[Mehrfach-Validierung|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:Auto-Validierung.png|link=Auto-Validierungen]] [[Auto-validations|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;"> -->
-[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Auto-Validierungen]]
+<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Auto-validations_in_firesys]]-->
+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.  <small>'''[[Auto-validations_in_firesys|more]]'''</small>
-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.  <small>'''[[Auto-Validierungen|more]]'''</small>
 -----
 </div>
@@ Zeile 58: / Zeile 42: @@
 | 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:rxbtnCellEditValidationEntry_32.png|link=Validierung_bearbeiten]] [[Validierung_bearbeiten|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=Validierung_bearbeiten]]
+<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Edit_validations]]-->
+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>
-When you process a validation, you can change the selected validation and also edit the comment or the designation. <small>'''[[Validierung_bearbeiten|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:rxbtnCellDeleteRow_32.png|link=Validierung_löschen]] [[Validierung_löschen|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;">
-[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Validierung_löschen]]
+<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Delete validations]]-->
+It is also possible to edit, update and delete created validations later. Here firesys offers you fast accessible tools. <small>'''[[Update_validations|more]]'''</small>
-You can delete validations that were created. Multiple selection is also possible here. <small>'''[[Validierung_löschen|more]]'''</small>
 -----
 </div>
 <br />
 | style="width: 30%"|<!-- ABS.1: Rechte 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:rxbtnCellReleaseDeviation_32.png|link=Abweichungen_freigeben]] [[Abweichungen_freigeben|Release deviations]]</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:rxbtnCellReleaseDeviation_32.png|link=Approve_deviation]] [[Approve_deviation|Approve deviations]]</div>
 <!--<div style="text-align:center;"> -->
-[[Datei:Dummybild.jpeg|left|175px|link=Abweichungen_freigeben]]
+<!-- [[Datei:Dummybild.jpeg|left|175px|link=Approve_deviation]]-->
+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. <small>'''[[Approve_deviation|more]]'''</small>
-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. <small>'''[[Abweichungen_freigeben|more]]'''</small>
 ----
@@ Zeile 88: / Zeile 69: @@
 |}
+== See also ==
-== See also ==
+[[Datei:Navigation_hoch.svg|link=]]  [[Maintain_Excel_contents|Maintain Excel contents]] <br>
-[[Datei:Navigation_hoch.svg|link=]]  [[Validierungen_in_Excel|An overview of all validation functions in Excel]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br>
-[[Datei:Navigation_rechts.svg|link=]]  [[Dateiübergreifende_Validierungen|Create a cross-file validation]] <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=]]  [[Die_Kontenmappe|The firesys account workbook]]   <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values in Excel]] <br>
-[[Datei:Navigation_rechts.svg|link=]]  [[Das_Validierungsblatt|The firesys validation worksheet]]   <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=]]  [[Der_Zentralwert-Manager|The master value manager]]   <br>
+[[Datei:Navigation_rechts.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>
 {{MoreContent}}
-[[Kategorie:Excel Dokument-Validierungen-Übersicht]]
+[[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]]

The validation basic functions: Unterschied zwischen den Versionen

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

See also

Further contents

Navigationsmenü

Suche