Validations in Excel

Aus firesys Hilfe
Version vom 3. Dezember 2019, 14:58 Uhr von O.wendt (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „<imagemap>Datei:Excel Validierung Menüband.jpg|1200px|center rect 2 78 215 197 Übersicht_Validierungen rect 328 84 785 202 Dateiübergreifende_Validier…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen

<imagemap>Datei:Excel Validierung Menüband.jpg|1200px|center rect 2 78 215 197 Übersicht_Validierungen 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 desc none

</imagemap>

Excel Funktionen 64.png
Validations in Excel

You can compare figures in an Excel file/database or across files and thereby validate and them and review them for consistency. The number pairs are provided in a clear overview on the validation sheet.

Excel Funktionen 64.png
Testbild

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


Testbild

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

Testbild

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




Testbild

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

Navigation hoch.svg The firesys functions in Excel
Navigation rechts.svg The layout functions in Excel
Navigation rechts.svg Translations in Excel
Navigation rechts.svg The worksheet status

Further contents

firesys website
Customer area
YouTube