Vorlage:Video- Kontenberechnung einfügen-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 2: | Zeile 2: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <center> | ||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | <div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | ||
<div class="mw-collapsible-content"> | <div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | ||
<p align="left">How to insert an account calculation:<br><br> | <div class="mw-collapsible-content"> | ||
<p align="left">How to insert an account calculation:<br><br> | |||
<ol> | <ol> | ||
<li> <p align="left">Open the Excel workbook in which the account calculation should be inserted.</li> | |||
<li> <p align="left">Select the cell you require.</li> | |||
<li> <p align="left">In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button. | |||
<br> → A dialogue opens. </li> | |||
<li> <p align="left"> Click on "Master value". | |||
<br> → The task pane "Insert values" opens. </li> | |||
<li> <p align="left"> In the work area, select “Account calculation” as the data type and then the account group you require and the correct key date. | |||
<li> <p align="left">The stored [[Der_firesys-Videobereich#Kontenberechnung_erstellen | Account calculations]] appear in the list area. Select the desired Account calculation here. </li> | |||
<li> <p align="left">If you do not require a manual rounding value, you can click on the left-hand button in the “Actions” area to insert the account calculation. | |||
<br> → Account calculation is inserted in the selected cell</li> | |||
</ol> | |||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 21. September 2023, 08:30 Uhr
How to insert an account calculation:
-
Open the Excel workbook in which the account calculation should be inserted.
-
Select the cell you require.
-
In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
→ A dialogue opens. -
Click on "Master value".
→ The task pane "Insert values" opens. -
In the work area, select “Account calculation” as the data type and then the account group you require and the correct key date.
-
The stored Account calculations appear in the list area. Select the desired Account calculation here.
-
If you do not require a manual rounding value, you can click on the left-hand button in the “Actions” area to insert the account calculation.
→ Account calculation is inserted in the selected cell