The firesys functions in Excel: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 14: | Zeile 14: | ||
<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:RxtglbtnStyleGuide_32.png|link=Excel-Gestaltungs-Funktionen]] [[Design_an_Excel_document|Design an Excel document]]</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:RxtglbtnStyleGuide_32.png|link=Excel-Gestaltungs-Funktionen]] [[Design_an_Excel_document|Design an Excel document]]</div> | ||
[[Datei:Die-firesys-Funktionen-in-Excel Dokument-gestalten.jpg|left|175px|Design an Excel document|link=Design_an_Excel_document]] | <!--[[Datei:Die-firesys-Funktionen-in-Excel Dokument-gestalten.jpg|left|175px|Design an Excel document|link=Design_an_Excel_document]]--> | ||
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. <small>'''[[Design_an_Excel_document|more]]'''</small> | 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. <small>'''[[Design_an_Excel_document|more]]'''</small> | ||
---- | ---- | ||
| Zeile 21: | Zeile 20: | ||
|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | |<!-- 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:rxbtnSynopsisExtrasSynopsisDirect_32.png|link=Translations in Excel]] [[Translations in Excel|Define translations in Excel]]</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:rxbtnSynopsisExtrasSynopsisDirect_32.png|link=Translations in Excel]] [[Translations in Excel|Define translations in Excel]]</div> | ||
[[Datei:Die-firesys-Funktionen-in-Excel-Übersetzungen-festlegen.jpg|left|175px|Übersetzungen Excel|link=Translations in Excel]] | <!--[[Datei:Die-firesys-Funktionen-in-Excel-Übersetzungen-festlegen.jpg|left|175px|Übersetzungen Excel|link=Translations in Excel]]--> | ||
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. <small>'''[[Translations in Excel|more]]'''</small> | 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. <small>'''[[Translations in Excel|more]]'''</small> | ||
----- | ----- | ||
| Zeile 28: | Zeile 26: | ||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | | 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:rxbtnCellDirectStatus_32.png|link=The_worksheet_status_in_Excel]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]]</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:rxbtnCellDirectStatus_32.png|link=The_worksheet_status_in_Excel]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]]</div> | ||
[[Datei:Die-firesys-Funktionen-in-Excel Der-Blatt-Status.jpg|left|175px|Der Blatt-Status|link=The_worksheet_status_in_Excel]] | <!--[[Datei:Die-firesys-Funktionen-in-Excel Der-Blatt-Status.jpg|left|175px|Der Blatt-Status|link=The_worksheet_status_in_Excel]]--> | ||
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. <small>'''[[The_worksheet_status_in_Excel|more]]'''</small> | 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. <small>'''[[The_worksheet_status_in_Excel|more]]'''</small> | ||
----- | ----- | ||
| Zeile 39: | 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=Validations_in_Excel]] [[Validations_in_Excel|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:Validierung.png|link=Validations_in_Excel]] [[Validations_in_Excel|Validations]]</div> | ||
[[Datei:Die-firesys-Funktionen-in-Excel-Validierungen.jpg|left|175px|Validierungen|link=Validations_in_Excel]] | <!--[[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>'''[[Validations_in_Excel|more]]'''</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 12. Dezember 2019, 09:43 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