The firesys functions in Excel: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 37: | Zeile 37: | ||
| 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:Validierung.png|link= | <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:Validierung.png|link=Validations_in_Excel]] [[Validations_in_Excel|Validations]]</div> | ||
[[Datei:Die-firesys-Funktionen-in-Excel-Validierungen.jpg|left|175px|Validierungen|link= | [[Datei:Die-firesys-Funktionen-in-Excel-Validierungen.jpg|left|175px|Validierungen|link=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. <small>'''[[ | 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. <small>'''[[Validations_in_Excel|more]]'''</small> | ||
----- | ----- | ||
Version vom 4. Dezember 2019, 08:39 Uhr
| |||||
You can find everything you need for formatting your tables predefined in the “*Design” menu ribbon. Define ranges, row types (such as totals) and conditional formatting which should be transferred to Word. more |
The translation of the texts in your Excel tables can be automated in firesys by using a dictionary. Once a term and its translation has been agreed, all further occurrences are also correct and consistent. more |
The StatusCockpit and the worksheet inspector quickly provide an overview of your Excel documents, worksheets and ranges. To do this, use coloured highlighting to display the status quickly. more
| |||
|
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. more
|
See also
Home page
The firesys functions in Word
The firesys basic functions