Vorlage:Video-Vorrollen mit mehreren gleichen Stichtagen-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „ center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800…“) |
Keine Bearbeitungszusammenfassung |
||
(2 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
[[Datei:Vorrollen mit mehreren gleichen Stichtagen.webm|center|808px|border]] | [[Datei:Vorrollen mit mehreren gleichen Stichtagen.webm|center|808px|border]] | ||
<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 each step 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 each step in detail</div> | ||
<p align="left"How to prepare the roll forward of a table with several equal key dates: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left"> | <p align="left"> How to prepare the roll forward of a table with several equal key dates: <br><br> | ||
< | <p align="left"> | ||
<ol> | |||
<li> <p align="left">In Excel, click the "Configure" button in the "*Content" ribbon in the "Roll forwards" group. | |||
<br> → The "Roll forwards" task pane opens on the right-hand side.</li> | |||
<li> <p align="left">In the task pane, under "Account group", select the account group for which the values exist.</li> | |||
<li> <p align="left">Select one cell at a time in the columns you want to roll forward and click the green "Add" plus in the "Columns" group in the "Roll Forward" task pane. | |||
<br> → The selected columns will be displayed in the list area. A blue arrow indicates in which direction is rolled forward. </li> | |||
</ | <li> <p align="left">Assign the appropriate key date to each column in the list area on the right.</li> | ||
</ | |||
<li> <p align="left">To configure groups for roll forward, select the last element of the group you want to create and click the left icon "Create group" in the "Roll forward" task pane in the "Groups" group. | |||
<br> → A separation will now appear below the selected line so that the blue arrows are interrupted at this point.</li> | |||
<li> <p align="left">Click the "Save" icon in the "Changes" group in the "Roll forwards" task pane to save the defined groups and automatically close the task pane. | |||
<br> → The task pane is closed automatically.</li> | |||
</ol> | |||
</center> | </center> | ||
</div> | |||
</div></div> | </div> |
Aktuelle Version vom 20. September 2023, 14:28 Uhr
How to prepare the roll forward of a table with several equal key dates:
-
In Excel, click the "Configure" button in the "*Content" ribbon in the "Roll forwards" group.
→ The "Roll forwards" task pane opens on the right-hand side. -
In the task pane, under "Account group", select the account group for which the values exist.
-
Select one cell at a time in the columns you want to roll forward and click the green "Add" plus in the "Columns" group in the "Roll Forward" task pane.
→ The selected columns will be displayed in the list area. A blue arrow indicates in which direction is rolled forward. -
Assign the appropriate key date to each column in the list area on the right.
-
To configure groups for roll forward, select the last element of the group you want to create and click the left icon "Create group" in the "Roll forward" task pane in the "Groups" group.
→ A separation will now appear below the selected line so that the blue arrows are interrupted at this point. -
Click the "Save" icon in the "Changes" group in the "Roll forwards" task pane to save the defined groups and automatically close the task pane.
→ The task pane is closed automatically.