Validations in Excel
<imagemap>Datei:EN Excel Validation Menüband Validierung.jpg|1200px|center rect 2 78 215 197 Validations_in_Excel rect 328 84 785 202 The_functions_of_the_master_value_manager rect 224 83 325 200 The_account_workbook rect 791 86 1063 199 The_validation_worksheet rect 1069 88 1387 200 The_master_value_manager 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