Validations in Excel: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (7 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
<imagemap>Datei: | <imagemap>Datei:EN_Menüband_Excel_Inhalt_Validierungen.jpg|1200px|center | ||
desc none | desc none | ||
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) --> | #<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) --> | ||
| Zeile 23: | Zeile 19: | ||
<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:Validierung.png|link=The validation basic functions]] [[The validation basic functions|Validations]]</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:Validierung.png|link=The validation basic functions]] [[The validation basic functions|Validations]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The validation basic functions]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=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. <small> '''[[The validation basic functions|more]]'''</small> | 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. <small> '''[[The validation basic functions|more]]'''</small> | ||
---- | ---- | ||
| Zeile 31: | Zeile 26: | ||
<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:rxbtnCellManagerDo_32.png|link=The_functions_of_the_master_value_manager]] [[The_functions_of_the_master_value_manager|The master value manager]]</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:rxbtnCellManagerDo_32.png|link=The_functions_of_the_master_value_manager]] [[The_functions_of_the_master_value_manager|The master value manager]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_functions_of_the_master_value_manager]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_functions_of_the_master_value_manager]]--> | ||
The “control centre” for all central values. Keep an overview of which central values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. <small>'''[[The_functions_of_the_master_value_manager|more]]'''</small> | The “control centre” for all central values. Keep an overview of which central values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. <small>'''[[The_functions_of_the_master_value_manager|more]]'''</small> | ||
---- | ---- | ||
| Zeile 38: | Zeile 32: | ||
<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:Kontenmappe.png|link=The_account_workbook]] [[The_account_workbook|The account workbook]]</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:Kontenmappe.png|link=The_account_workbook]] [[The_account_workbook|The account workbook]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_account_workbook]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_account_workbook]]--> | ||
The account workbook is a convenient way of making a large amount of data to be validated available to all firesys users in the MeetingPoint. Based on an Excel file, it is easy to link data from the consolidation system with the firesys world. <small>'''[[The_account_workbook|more]]'''</small> | The account workbook is a convenient way of making a large amount of data to be validated available to all firesys users in the MeetingPoint. Based on an Excel file, it is easy to link data from the consolidation system with the firesys world. <small>'''[[The_account_workbook|more]]'''</small> | ||
----- | ----- | ||
| Zeile 52: | Zeile 45: | ||
<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:Validierungsblatt.png|link=The_validation_worksheet]] [[The_validation_worksheet|The validation worksheet]]</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:Validierungsblatt.png|link=The_validation_worksheet]] [[The_validation_worksheet|The validation worksheet]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_validation_worksheet]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_validation_worksheet]]--> | ||
With the validation worksheet you can compare “number pairs” with each other and thereby review them for validation and consistency. The number pairs are listed clearly on the validation worksheet, deviations are also shown. <small>'''[[The_validation_worksheet|more]]'''</small> | With the validation worksheet you can compare “number pairs” with each other and thereby review them for validation and consistency. The number pairs are listed clearly on the validation worksheet, deviations are also shown. <small>'''[[The_validation_worksheet|more]]'''</small> | ||
----- | ----- | ||
| Zeile 61: | Zeile 53: | ||
== See also == | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[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 layout functions in Excel]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document|The layout functions in Excel]] <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> | ||
| Zeile 67: | Zeile 59: | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:Excel Dokument-Validierungen]] | [[Kategorie:English-Excel Dokument-Validierungen]] | ||
Aktuelle Version vom 25. März 2021, 12:30 Uhr
<imagemap>Datei:EN_Menüband_Excel_Inhalt_Validierungen.jpg|1200px|center
desc none
</imagemap>
| |||||
|
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. more |
The “control centre” for all central values. Keep an overview of which central values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. more |
The account workbook is a convenient way of making a large amount of data to be validated available to all firesys users in the MeetingPoint. Based on an Excel file, it is easy to link data from the consolidation system with the firesys world. more
| |||
|
|
With the validation worksheet you can compare “number pairs” with each other and thereby review them for validation and consistency. The number pairs are listed clearly on the validation worksheet, deviations are also shown. more | ||||
See also
The firesys functions in Excel
The layout functions in Excel
Translations in Excel
The worksheet status