The firesys functions in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(10 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<!--T:1-->
[[Kategorie:The firesys functions in Excel]]
[[Kategorie:The firesys functions in Excel]]
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
Zeile 12: Zeile 14:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<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=Design_an_Excel_document]] [[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]]


<!--T:2-->
<!--[[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>
----
----


<!--T:3-->
|<!-- 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|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 30:
| 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 37: Zeile 39:




<!--T:4-->
| 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:Excelinhalte-prflegen 01e.jpg|link=Maintain Excel contents]] [[Maintain Excel contents|Maintain Excel contents]]</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=Maintain Excel contents]]-->
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>  
With firesys, you can maintain the contents that occur in your Excel workbook locally and by using the connection to the MeetingPoint, so that you can manage them optimally for further processing. <small>'''[[Maintain Excel contents|more]]'''</small>  
-----
-----


Zeile 47: Zeile 50:
<br />
<br />
|}
|}
== See also ==
== See also == <!--T:5-->


[[Datei:Navigation_hoch.svg|link=]]  [[MainPage|Home page]] <br>
<!--T:6-->
[[Datei:Navigation_hoch.svg|link=]]  [[MainPage|Main page]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_firesys_functions_in_Word|The firesys functions in Word]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_firesys_functions_in_Word|The firesys functions in Word]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Overview_of_the_firesys_basic_functions|The firesys basic functions]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Overview_of_the_firesys_basic_functions|Overview of the firesys basic functions]]  <br>


<!--T:7-->
{{MoreContent}}
{{MoreContent}}

Aktuelle Version vom 20. April 2021, 12:02 Uhr


Excel Funktionen 64.png
The firesys functions in Excel

With firesys you continue working in your usual Excel environment. You don’t have to worry about the layout. You will find everything you need for creating your report on the firesys menu ribbons.

Excel Funktionen 64.png

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




With firesys, you can maintain the contents that occur in your Excel workbook locally and by using the connection to the MeetingPoint, so that you can manage them optimally for further processing. more



See also

Navigation hoch.svg Main page
Navigation rechts.svg The firesys functions in Word
Navigation rechts.svg Overview of the firesys basic functions

Further contents

firesys website
Customer area
YouTube