Translations in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(19 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Datei:Excel Übersetzung Imagemap.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Übersetzung.jpg|1200px|center]]
rect 3 79 85 198 [[Übersicht_Dashboard]]
 
rect 90 79 206 196 [[Die_firesys-Einstellungen]]
rect 217 79 324 198 [[Übersicht_Übersetzungs-Manager]]
rect 326 82 432 195 [[Grundfunktionen_Übersetzungen#Erstellen_.2F_Aktualisieren]]
rect 437 82 589 109 [[Grundfunktionen_Übersetzungen#Direkt_aufnehmen]]
rect 437 111 590 138 [[Grundfunktionen_Übersetzungen#Sprache_w.C3.A4hlen]]
rect 435 140 590 163 [[Grundfunktionen_Übersetzungen#Wortliste]]
rect 597 82 730 197 [[Das_Synopsen-Blatt_und_Fundstellen#Fundstellen]]
rect 737 83 889 197 [[Das_Synopsen-Blatt_und_Fundstellen#Synopsen-Blatt]]
rect 899 86 978 194 [[Übersetzungen_importieren_und_exportieren]]
rect 983 86 1076 198 [[Übersetzungen_importieren_und_exportieren#Import_des_.C3.BCbersetzten_W.C3.B6rterbuchs]]
rect 1079 84 1263 113 [[Die_Export-Optionen_in_Excel#Leseversion_erstellen]]
rect 1079 112 1265 138 [[Die_Export-Optionen_in_Excel#W.C3.B6rterbuch_exportieren]]
rect 1080 139 1265 164 [[Die_Export-Optionen_in_Excel#Version_ohne_Zahlen_erstellen]]
desc none
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
</imagemap>


{| 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 33: Zeile 17:
<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:rxbtnTransManagerDo_32.png|link=Übersicht_Übersetzungs-Manager]] [[The_translation_manager|The translation manager]]</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:rxbtnTransManagerDo_32.png|link=Übersicht_Übersetzungs-Manager]] [[The_translation_manager|The translation manager]]</div>


[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_translation_manager]]
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_translation_manager]]-->
 
The Excel data manager is the “control centre” for monitoring all translations that are saved in Excel. It is divided into an action area (in the menu ribbon) and a list area that displays all available translations. <small>'''[[The_translation_manager|more]]'''</small>
The Excel data manager is the “control centre” for monitoring all translations that are saved in Excel. It is divided into an action area (in the menu ribbon) and a list area that displays all available translations. <small>'''[[The_translation_manager|more]]'''</small>
----
----


| 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:Wörtebucher.png|link=Die_Wörterbücher_in_firesys]] [[Die_Wörterbücher_in_firesys|The dictionaries in firesys]]</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:Wörtebucher.png|link=The_dictionaries_in_firesys]] [[The_dictionaries_in_firesys|The dictionaries in firesys]]</div>
[[Datei:Dummybild.jpeg|left|175px|link=Die_Wörterbücher_in_firesys]]
<!--[[Datei:Dummybild.jpeg|left|175px|link=The_dictionaries_in_firesys]]-->
Terms and their translations are managed and updated with a master dictionary. This master resource can be accessed by any number of individual Excel files. All terms that have been entered can be used in all sub-dictionaries once they have been checked and translated. <small>'''[[Die_Wörterbücher_in_firesys|more]]'''</small>  
Terms and their translations are managed and updated with a master dictionary. This master resource can be accessed by any number of individual Excel files. All terms that have been entered can be used in all sub-dictionaries once they have been checked and translated. <small>'''[[The_dictionaries_in_firesys|more]]'''</small>  
-----
-----
</div>
</div>
| 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:Übersetzung-Grundfunktionen.png]] [[Grundfunktionen_Übersetzungen|The translation basic functions]]</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:Übersetzung-Grundfunktionen.png|link=The_translation_basic_functions]] [[The_translation_basic_functions|The translation basic functions]]</div>
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Grundfunktionen_Übersetzungen]]
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_translation_basic_functions]]-->
Working with translations is a central component of the firesys functions in Excel. These include functions for requesting terms, working with sub and master dictionaries and the AutoCorrect, and the view of the word list. <small>'''[[Grundfunktionen_Übersetzungen|more]]'''</small>  
Working with translations is a central component of the firesys functions in Excel. These include functions for requesting terms, working with sub and master dictionaries and the AutoCorrect, and the view of the word list. <small>'''[[The_translation_basic_functions|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 54: Zeile 37:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke 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:Synopsenblatt.png|link=Das_Synopsen-Blatt_und_Fundstellen|Das Synopsen-Blatt und Fundstellen]] [[Das_Synopsen-Blatt_und_Fundstellen|The synopses worksheet and hits]]</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:Synopsenblatt.png|link=The_synopses_worksheet_and_hits|Das Synopsen-Blatt und Fundstellen]] [[The_synopses_worksheet_and_hits|The synopses worksheet and hits]]</div>
 
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Das_Synopsen-Blatt_und_Fundstellen|Das Synopsen-Blatt und Fundstellen]]


The synopses worksheet is a worksheet which is set by firesys that contains the translated terms (including their translations). <small>'''[[Das_Synopsen-Blatt_und_Fundstellen|more]]'''</small>
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=The_synopses_worksheet_and_hits|Das Synopsen-Blatt und Fundstellen]]-->
The synopses worksheet is a worksheet which is set by firesys that contains the translated terms (including their translations). <small>'''[[The_synopses_worksheet_and_hits|more]]'''</small>
----
----


| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Mittlere 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:rxbtnExportImport_32.png|link=Übersetzungen_importieren_und_exportieren]] [[Übersetzungen_importieren_und_exportieren|Import and export translations]]</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:rxbtnExportImport_32.png|link=Import_and_export_translations]] [[Import_and_export_translations|Import and export translations]]</div>
 
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Übersetzungen_importieren_und_exportieren]]


You can provide your translator with the dictionary for editing. At the same time, you can continue working on your Excel file while the translator is using the dictionary and then import it again.  <small>'''[[Übersetzungen_importieren_und_exportieren|more]]'''</small>  
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Import_and_export_translations]]-->
You can provide your translator with the dictionary for editing. At the same time, you can continue working on your Excel file while the translator is using the dictionary and then import it again.  <small>'''[[Import_and_export_translations|more]]'''</small>  
-----
-----
| 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:rxbtnSynopsisExtrasPrintVersion_32.png|link=Die_Export-Optionen_in_Excel]] [[Die_Export-Optionen_in_Excel|Additional export functions]]</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:rxbtnSynopsisExtrasPrintVersion_32.png|link=Additional_export_functions]] [[Additional_export_functions|Additional export functions]]</div>
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Die_Export-Optionen_in_Excel]]
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Additional_export_functions]]-->
firesys provides additional export functions for translator exchange. You can use these to configure the contents that are exported according to your company specifications. <small>'''[[Die_Export-Optionen_in_Excel|more]]'''</small>  
firesys provides additional export functions for translator exchange. You can use these to configure the contents that are exported according to your company specifications. <small>'''[[Additional_export_functions|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 80: Zeile 61:


| 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:Wörtebuch_Einstellungen.png|link=Einstellungen in Excel - Wörterbuch]] [[Einstellungen in Excel - Wörterbuch|The dictionary settings 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:Wörtebuch_Einstellungen.png|link=Settings_in_Excel_–_dictionary]] [[Settings_in_Excel_–_dictionary|Settings in Excel dictionary]]</div>
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Einstellungen in Excel - Wörterbuch]]
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Settings_in_Excel_–_dictionary]]-->
Your direct access to the function-specific settings. You can always find the “Settings” menu option in the “firesys” group on the very left of the ribbon. <small>'''[[Einstellungen in Excel - Wörterbuch|more]]'''</small>  
Your direct access to the function-specific settings. You can always find the “firesys settings” menu option in the “firesys” group on the left side of the ribbon. <small>'''[[Settings_in_Excel_–_dictionary|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 90: Zeile 71:
== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]] [[Die_firesys-Funktionen_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel-Gestaltungs-Funktionen|The design functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document|Design an Excel document | The design functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Der_Blatt-Status_in_Excel|The worksheet status]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Validierungen_in_Excel|Validations in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Maintain Excel contents|Maintain Excel contents]]  <br>


{{MoreContents}}
{{MoreContent}}
[[Kategorie:Excel Dokument-Übersetzungen]]
[[Kategorie:English-Excel Dokument-Übersetzungen]]

Aktuelle Version vom 26. April 2023, 13:16 Uhr

EN Menüband Excel Übersetzung.jpg


Excel Funktionen 64.png
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(s) have been agreed, all further occurrences are also correct and consistent, even in the leading language.

Excel Funktionen 64.png

The Excel data manager is the “control centre” for monitoring all translations that are saved in Excel. It is divided into an action area (in the menu ribbon) and a list area that displays all available translations. more


Terms and their translations are managed and updated with a master dictionary. This master resource can be accessed by any number of individual Excel files. All terms that have been entered can be used in all sub-dictionaries once they have been checked and translated. more


Working with translations is a central component of the firesys functions in Excel. These include functions for requesting terms, working with sub and master dictionaries and the AutoCorrect, and the view of the word list. more



The synopses worksheet is a worksheet which is set by firesys that contains the translated terms (including their translations). more


You can provide your translator with the dictionary for editing. At the same time, you can continue working on your Excel file while the translator is using the dictionary and then import it again. more


firesys provides additional export functions for translator exchange. You can use these to configure the contents that are exported according to your company specifications. more



Your direct access to the function-specific settings. You can always find the “firesys settings” menu option in the “firesys” group on the left side of the ribbon. more



See also

Navigation hoch.svg The firesys functions in Excel
Navigation rechts.svg Design an Excel document | The design functions in Excel
Navigation rechts.svg The worksheet status in Excel
Navigation rechts.svg Maintain Excel contents

Further contents

firesys website
Customer area
YouTube