Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-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;">The explanation of the individual steps in detail</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;">The explanation of the individual steps in detail</div> | ||
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br> | |||
<ol> | <ol> | ||
<li> <p align="left">Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.</li> | |||
<li> <p align="left">Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group. </li> | |||
<li> <p align="left">In the selection dialogue that then appears, select the option “Master value”. | |||
<br> → The task pane “Insert values” opens on the right. </li> | |||
<li> <p align="left">Select “Account calculations and account aggregates” from the drop-down menu under “Data type”. </li> | |||
<li> <p align="left">Then assign the desired account group and the desired key date. </li> | |||
<li> <p align="left">Select an account calculation or account aggregate below.</li> | |||
<li> <p align="left">Click on the symbol “Open the rounding wizard” in the group “Actions”. | |||
<br> → The rounding wizard opens. </li> | |||
<li> <p align="left">Select manual rounding in the drop-down menu under “Rounding type”. </li> | |||
<li> <p align="left">Enter the desired value under “Manual rounding value”. </li> | |||
<li> <p align="left">Confirm your entry with “Ok”. </li> | |||
<li> <p align="left">Select the rounded account calculation/account aggregate in the task pane. </li> | |||
<li> <p align="left">Click on the button “Insert selected value” in the group “Actions”. | |||
<br> → The account calculation/account aggregate is inserted. </li> | |||
</ol> | </ol> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 13:02 Uhr
To create a manual rounding for an account calculation/aggregate of accounts:
-
Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.
-
Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group.
-
In the selection dialogue that then appears, select the option “Master value”.
→ The task pane “Insert values” opens on the right. -
Select “Account calculations and account aggregates” from the drop-down menu under “Data type”.
-
Then assign the desired account group and the desired key date.
-
Select an account calculation or account aggregate below.
-
Click on the symbol “Open the rounding wizard” in the group “Actions”.
→ The rounding wizard opens. -
Select manual rounding in the drop-down menu under “Rounding type”.
-
Enter the desired value under “Manual rounding value”.
-
Confirm your entry with “Ok”.
-
Select the rounded account calculation/account aggregate in the task pane.
-
Click on the button “Insert selected value” in the group “Actions”.
→ The account calculation/account aggregate is inserted.