Quelltext der Seite The firesys video zone

All videos on the firesys software are displayed here. 

==Word==

=== firesys group===

==== Reconnecting MeetingPoint ====

Attach a new MeetingPoint to one or more documents.
{{Vorlage:Video-Word-firesys-MeetingPoint neu anbinden-English}}

===Layout menu ribbon===
====Design texts with the StyleGuide====

The StyleGuide makes the text formats that were developed especially for your publication according to the StyleGuide available in a separate task area. 


{{Video-StyleGuideWord-English}}


==== Create a new table in Word ====

The firesys table assistant helps with with creating, formatting and changing tables. 


{{Vorlage:Video-Tabellenassistent - Eine leere Tabelle neu erstellen-English}}


==== Manually change a table ====

Change the table and column widths from the specified values or define manual values. 


{{Vorlage:Video-Tabellenassistent-English}}


==== Table assistant – change table height ====

Change the height of the individual rows in your table by using the context-sensitive table menu in firesys. 


{{Vorlage:Video-Tabellenassistent-Höhe-English}}


==== Table assistant – insert a row ====

Use firesys to add a new row to an existing table. 


{{Vorlage:Video-Tabellenassistent - Einfügen einer zusätzlichen Spalte und Zeile-English}}


==== Page layout ====

Select the type area for the current section or the entire document.


{{Vorlage:Video-Seitenlayout-Englisch}}



===firesys-Layout menu ribbon===
====Apply colour scheme====

Use this function to apply a previously created color scheme to your document so that it conforms to your design guidelines.

{{Vorlage:Video-firesys-Layout-Farbschema anwenden-English}}


==== Create a new colour scheme ====

Here you can create a new colour scheme and then apply it to your document. 

{{Vorlage:Video-firesys-Layout-Ein neues Farbschema erstellen-English}}


==== Edit diagrams ====

Design your diagrams in the corporate design by adjusting the colour scheme and font.

{{Vorlage:Video-firesys-Layout-Diagramme bearbeiten-English}}


==== Edit tables ====

Design your tables in the corporate design by adapting the colour scheme to your wishes.

{{Vorlage:Video-Layout-Manager-Tabellen bearbeiten-English}}


==== Edit texts ====

Design your texts in the corporate design by adapting the layout of the texts according to your wishes.

{{Vorlage:Video-firesys-Layout Texte bearbeiten-English}}

==== Edit page colour ====
Customise the page colour of your document in the Layout manager.

{{Vorlage:Edit_pages}}


==== Customize bullets ====

Customize bullets in the Layout manager according to your individual preferences.

{{Vorlage:Video-Layout-Manager-Aufzählungen anpassen-English}}

==== Create Table of Contents ==== 
Clicking the "Table of Contents" button inserts a table of contents at the location of the insertion point.

{{Vorlage:Video-Word Premiumlayout Inhaltsverzeichnis erstellen-Englisch}}



===Menu ribbon contents===
====Highlight data in text====

This highlights in green all linked Excel objects in the body text, or else it removes the highlighting. 


{{Vorlage:Video-Status-Markierungen-English}}


====Insert data in text from file====

Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document. 


{{Vorlage:Video-Daten im Text aus Datei einfügen-English}}


====Insert data in text directly from the selected Excel cell====

Use this function to insert the content of a single cell that you have just selected in Excel directly as a linked firesys object in the body text of your Word document. 


{{Vorlage:Video-Daten im Text direkt aus markierter Zelle einfügen-English}}


====Insert data in text directly from the selected Excel cell with options====

Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document. 


{{Vorlage:Video-Daten im Text mit Optionen einfügen-English}}


====Insert a table from a file====

Use this function to insert a table from an Excel file as a linked firesys table object in Word. 


{{Vorlage:Video-Tabelle aus Datei einfügen-English}}


====Insert table directly from the selected Excel range====

With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. 


{{Vorlage:Video-Tabelle direkt aus markiertem Excel-Bereich einfügen-English}}


==== Update Excel contents ====

You can use these functions to update your linked Excel data with one click. This means that your business report always contains correctly maintained values. 


{{Vorlage:Video-Excel-Inhalte_aktualisieren-English}}


==== Insert a graphic into body text ====

Inserts any graphics file (such as JPG, BMP, EMF, GIF, PNG, TIF) as a linked firesys graphics object in the existing format in your Word document. 


{{Vorlage:Video-Grafik im Fließtext einfügen-English}}


==== Insert a graphic directly from PowerPoint ====

Inserts a diagram created in Excel or PowerPoint as a linked graphic in EMF format. The source program can remain closed and you do not have to manually save the diagram as a graphic beforehand. 


{{Vorlage:Video-Grafik_aus_PowerPoint-English}}


==== Insert a graphic directly from Excel (into body text) ====

Inserts a selected graphic into the currently opened Excel document directly as a linked graphic. 


{{Vorlage:Video-Grafik_aus_Excel_einfügen-English}}


==== Create a story ====

Select the text you require in your master. This is saved as a new story and integrated into the master. 


{{Vorlage:Video-Partikel_erstellen-English}}


==== Create a version ====

You can manually create a new version of the current Word document (if desired with all Word, Excel, PowerPoint and graphics files) and assign a status to a version. 


{{Vorlage:Video-Versionierung-English}}


==== The Help and Search Function in the Managers====
Use the help and search function in the firesys managers to get information about and filter individual items.


{{Vorlage:Video-Word-Inhalt-Excel-Daten-Excel-Daten-Manager-Hilfe und Suche-Funktion in den Managern-English}}


===Publish menu ribbon===

====The AutoCorrect function====

You can use the firesys AutoCorrect function to define terms which can then be converted automatically into a different spelling, meaning that undesirable abbreviations can be avoided, for example. 


{{Vorlage:Video-Autokorrektur-English}}


====The layout check====

The “Layout check” function checks your files for formal design problems and detects such problems faster and in more detail than the human eye ever could. It also immediately provides assistance with their correction. 


{{Vorlage:Video-Layout Check-English}}


====The coupler====

Use the coupler to join certain terms together so they are never separated through line breaks. Rules can be defined by using regular expressions. 


{{Vorlage:Video-Koppler-English}}


====Hyphenation====

Here you can determine where certain words can be hyphenated. You can also determine hyphenation suggestions on how certain words are to be hyphenated in Word. 


{{Vorlage:Video-Silbentrennung-English}}


====Never hyphenate word====

With the “Never hyphenate word” function you can define words that must always be kept together in your document and must not be separated with line breaks. This enables you to better adhere to your corporate identity, for example. 


{{Vorlage:Video-Wort-nie-trennen-English}}


====Execute the typography functions====

All typography functions are executed at a click. This sets couplers, excludes words from hyphenation and applies separations to specific words. 


{{Vorlage:Video-Typografie-Funktionen-English}}


====Reduce letter and word spacing====

You can reduce your text quickly by a line with just one click. 


{{Vorlage:Video-Laufweite-Wortabstand-English}}


==== Prepare web version ====

With the Prepare web version function, you can automatically generate an HTML document of your annual report at the touch of a button. If you wish, all your tables can be output in one complete file or in a single file.

{{Vorlage:Video-Word-Veröffentlichen-Web-Export Web-Version vorbereiten-English}}


==== Prepare translation ====

With the help of the “Prepare translation” function, you can prepare your document(s) for export to a translator. All language-specific changes, such as run-length adjustments, change tracking or manual line breaks, are removed from the document.

{{Vorlage:Video-Word-Veröffentlichen-Sprache und Zahlenformat-Übersetzung vorbereiten-English}}


==== Prepare Text-Tagging ====

You can use this feature to create content controls.

{{Vorlage:Video-Texttagging TaskPane-Englisch}}


==Excel==

=== Design menu ribbon ===

====Design a table with the StyleGuide====

Design your contents in Excel with the StyleGuide 


{{Vorlage:Video-StyleGuide-Excel-English}}


====Prepare a table for import into Word====

Use the following steps to prepare the table so it can be linked with your Word document. 


{{Vorlage:Video-Tabelle formatieren-English}}


==== Remove styles from the Excel workbook ====

Remove all unnecessary or duplicate styles from your Excel workbook. 


{{Vorlage:Video-Formatvorlagen_entfernen-English}}


==== Format cells in color with the function “Highlight” ====

Colours cells in Excel yellow or removes this highlighting so that this can be transferred to Word. This way, numbers or texts in tables, that have not been defined yet, can be highlighted sustainably. 


{{Vorlage:Video-HervorhebungHervorheben-English}}


==== Format cells in color with the function “Hide numbers” ====

Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator. 


{{Vorlage:Video-HervorhebungZahlenverbergen-English}}


==== Format cells in color using the “Ignore number format” function ====

Highlights the selected cells in green or deselects them so that when you transfer them to Word, the number format specified in Word is ignored. 


{{Vorlage:Video-HervorhebungZahlenformatIgnorieren-English}}



==== Format cells in color with the function “Import brackets” ====

Selects or deselects the selected cells in blue so that the brackets are displayed when the table is transferred to Word. 


{{Vorlage:Video-Hervohebungen-Klammern einlesen-English}}


==== Format cells in color with the function “Strikethrough” ====

Highlights the selected cells in light blue or removes this highlight again. With cells that are highlighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard. 


{{Vorlage:Video-HervorhebungDurchkreuzen-English}}


==== Account calculation on automated worksheet ====
The “Sum” function allows you to create account calculations directly on the Automated Data Sheet. 

{{Vorlage:Video-Kontenberechnung auf automatisiertem Arbeitsblatt-English}}


==== Delete Empty Ranges from Excel spreadsheet ====

You can use the Empty Ranges function to delete empty columns and rows from your Excel spreadsheet. 

{{Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English}} 


==== Hide columns and rows in Excel spreadsheet ====
Hide columns and rows that you do not need using the "X/Y Ranges" function. 

{{{{Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English}}


====Configure row types ====
Configure different row types for your Excel spreadsheets.

{{Vorlage:Video-Excel-Gestaltung-Formatierung-Styleguide-Zeilentypen konfigurieren-English}} 


=== Premium Layout ribbon ===

==== Adjust grafic width ====
In firesys it is possible to adjust the width of the graphics in Excel to the type area in Word.

{{Vorlage:Video-StyleGuideWord-English}}


==== Formatting cells in color using conditional formatting ====

In firesys it is possible to use the functionality of conditional formatting known from Excel. With this you can quickly visualize your data sets in color or with symbols - which helps you to recognize trends quickly. 


{{Vorlage:Video-BedingteFormatierungFarbskala-English}}



{{Vorlage:Video-BedingteFormatierungRichtungen-English}}



{{Vorlage:Video-BedingteFormatierungSchriftfarbe-English}}


===Translation menu ribbon===


====Create a dictionary====


If the texts of the master language are in the first column and those of the secondary language are in the second column of the print area, you can create a dictionary with just one click. 


{{Vorlage:Video-Wörterbuch erstellen-English}}




====Propose translations for tables====

The translation manager automatically proposes translations from the firesys dictionary. 


{{Vorlage:Video-Übersetzung vorschlagen-English}}


==== Select language in Excel ====


Change the language in the Excel file and transfer the change to Word. 

{{Vorlage:Video-Excel-Übersetzung Wörterbuch-Sprache wählen-English}}


==== Use word list ====

Use the word list to add terms to your Excel file and include them in the dictionary. 

{{Vorlage:Video-Excel Übersetzung Wörterbuch Wortliste benutzen-English}}



=== Content menu ribbon ===


====Create a validation====

The validation function provides support with defining the required number pairs for the validation. 


{{Vorlage:Video-Validierung erstellen-English}}


{{Vorlage:Video-Validierung erstellen Mehrfach-English}}


==== Create a Autovalidation ====

The autovalidation is a tool from firesys which quickly creates a validation by selecting a cell. 


{{Vorlage:Video-Autovalidierung erstellen-English}}


==== Approve a deviation ====

When using the validation function in firesys, you can additionally release deviations, which you want to release manually for further use, with one of the tools from firesys according to your requirements.


{{Vorlage:Video-ValidierungAbweichung-English}}


==== Create a manual value ====

A manual value is one of the different value types in firesys, with which you can use the MeetingPoint to use numbers across files. 


{{Vorlage:Video- ManuellerWert erstellen-English}}


==== Insert a manual value ====

You can insert a manual value in Excel at any time in a cell of your choice (this cell must not contain another master value). 


{{Vorlage:Video- ManuellerWert einfügen-English}}


==== Creating a transmitter value ====

A sender value is one of the different types of values in firesys, with which you can use the MeetingPoint to use numbers across files. Here the distinction between the sender and the receiver value is important.


{{Vorlage:Video- Senderwert erstellen-English}}


==== Insert a transmitter value ====

You can insert a sender value in Excel at any time in a cell of your choice (this cell must not contain another master value).  


{{Vorlage:Video- Senderwert einfügen-English}}


==== Create an Import definition ====

Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys. 


{{Vorlage:Video-Import-Definition_erstellen-English}}


==== Create an account value ====

You can use the account workbook to quickly transfer a large number of individual account values to the MeetingPoint and then use those account values across files, for example, for an account calculation. In addition, account values stored in the MeetingPoint can also be inserted into Excel worksheets. 


{{Vorlage:Video- Kontowerte erstellen-English}}


==== Insert an account value ====

The insertion of an account value is shown in the “Insert values” work area. Here you can insert an account value in Excel at any time in a cell of your choice (this cell must not contain any other master value).  


{{Vorlage:Video-Tabellenassistent - Kontowerte einfügen-English}}


==== Insert automated worksheet ====

Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint.

{{Vorlage:Video-Automatisiertes Arbeitsblatt einfügen-English}}


==== Automate worksheet ====

Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column.

{{Vorlage:Video-Arbeitsblatt automatisieren-English}}


==== Edit automated worksheet ====

Text and number columns and other master value columns can be added to the automated worksheet. The definition of the columns can also be adjusted. 

{{Vorlage:Video-Automatisiertes Arbeitsblatt bearbeiten-English}}


==== Create account calculation ====

You can create an account calculation from individual account values, which allows you to add/subtract several items.


{{Vorlage:Video- Kontenberechnung erstellen-English}}
 

==== Insert account calculation ====

The insertion of an account calculation is shown in the “Insert values” task pane. Here you can insert an account calculation in Excel at any time in a cell of your choice (this cell must not contain any other master value).  


{{Vorlage:Video- Kontenberechnung einfügen-English}}


==== Edit account calculation ====

In firesys it is always possible to edit defined “account calculation” configurations afterwards.


{{Vorlage:Video- Kontenberechnung bearbeiten-English}}


==== Create an account aggregate ====

You can create and edit account aggregates using the Account Calculation/Create Account Aggregate feature in the Master value manager. 

{{Vorlage:Video-Kontenaggregat erstellen-English}}


==== The Rounding Wizard-Create a manual rounding ====


You can use firesys to round the results of your account calculations and account aggregates retrospectively using the rounding wizard.



{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English}}



==== The Rounding Wizard-Create a Manual Rounding with Delta ====


Using the Manual rounding value function in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a delta.  



{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung mit Delta erstellen-English}}


==== The Rounding Wizard-Create a Fixed Value with Delta ==== 


Using the Manual rounding value feature in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a fixed value delta. 


{{Vorlage:Video-Rundungs-Assistent-Festwert mit Delta erstellen-English}}


==== Synchronize values ====

You can quickly check the integrity and validity of your central values with the “Synchronize values” function and restore them if necessary. 


{{Vorlage:Video-Werte synchronisieren-English}}


==== Highlight master values ====

When working with firesys you can always quickly see which cells of your workbook are currently interacting with the MeetingPoint as a master value using the sheet inspector. 


{{Vorlage:Video-Zentralwerte_hervorheben-English}}


==== Display central value history ====

In the Central Value Manager you can display the central value history for manual, transmitter and master values.

{{Vorlage:Video- Zentralwert-Verlauf-English}}


==== Copy Key date ====
In the Central Value Manager, you can copy an existing key date plus the associated values and assign a new date to it.

{{Vorlage:Video-Zentralwert-Manager Stichtag kopieren-English}}


====  Preparing a new or existing table for roll forward ====

You can prepare tables for your next reporting cycle using the “roll forward” function.


{{Vorlage:Video-Tabellen_vorrollen}}


==== Prepare a new or existing table containing key date-dependent values for roll forward ====


You can prepare tables containing master values and key date dependent values for your next reporting cycle using the “roll forward function”.


{{Vorlage:Video-Tabellen vorrollen-English}}


==== Roll forward with several identical key dates ====
The “Group” function allows you to create a group for roll forward at the selected position. This is advantageous if the table has several identical key dates.

{{Vorlage:Video-Vorrollen mit mehreren gleichen Stichtagen-English}}


==== Edit an already rolled forward table ====

In firesys it is always possible to edit defined “roll forward” configurations of tables afterwards.


{{Vorlage:Video-Vorgerollte Tabelle bearbeiten-English}}


== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[MainPage|Home 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_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Overview_of_the_firesys_basic_functions|The firesys basic functions]]   <br>

{{MoreContent}}
[[Kategorie:The firesys basic functions]]