Vorlage:Video-Arbeitsblatt automatisieren-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „ border|center|810px <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto…“) |
Keine Bearbeitungszusammenfassung |
||
| (5 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt) | |||
| Zeile 2: | Zeile 2: | ||
[[Datei:Arbeitsblatt automatisieren.webm|border|center|810px]] | [[Datei:Arbeitsblatt automatisieren.webm|border|center|810px]] | ||
<center> | |||
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | |||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | |||
<div class="mw-collapsible-content"> | |||
<p align="left">How to insert accounts and account calculations into an automated worksheet: | |||
<br></br> | |||
<p align="left"> | |||
<ol> | |||
</ | <li> <p align="left">Open the worksheet where you want to insert accounts and/or account calculations.</li> | ||
</ | |||
<li> <p align="left">In the master value column, select the row where the keydate should be inserted.</li> | |||
<li> <p align="left">Click on the <b>"Insert"</b> button in the <b>"*Content"</b> menu in the <b>"Master values"</b> group. | |||
<br> → Es öffnet sich ein Auswahldialog.</li> | |||
<li> <p align="left">A selection dialog opens in which you can now select <b>"Automate worksheet"</b>. | |||
<br> → Rechts erscheint der Arbeitsbereich „Arbeitsblatt automatisieren“.</li> | |||
<li> <p align="left">On the right hand side the task pane <b>"Automate Worksheet"</b> appears, in which you press the right button under <b>"Actions"</b> to have the keydate inserted automatically.</li> | |||
<li> <p align="left">To insert an account calculation, select <b>"Account calculation"</b> in the drop-down area under <b>"Data type"</b>. | |||
<br> → Nun sehen Sie die Auswahl an Kontenberechnungen unter „Werte“.</li> | |||
<li> <p align="left">Now you can see the selection of account calculations under <b>"Values"</b>. Select the account calculation to be inserted.</li> | |||
<li> <p align="left">Then click on the left button under <b>"Actions"</b> to insert the values in the table.</li> | |||
<li> <p align="left">Next, click on the row of the master value column where an account is to be inserted.</li> | |||
<li> <p align="left">Select <b>"Accounts"</b> in the task pane, under Data type.</li> | |||
<li> <p align="left">Under <b>"Values"</b>, you can now select the account to be inserted. To find a specific account in a large number of accounts, you can also search directly for a specific account in the search field.</li> | |||
<li> <p align="left">Under <b>"Actions"</b>, click on the left button to insert the value of the account in the selected row.</li> | |||
</ol> | |||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 08:33 Uhr
How to insert accounts and account calculations into an automated worksheet:
-
Open the worksheet where you want to insert accounts and/or account calculations.
-
In the master value column, select the row where the keydate should be inserted.
-
Click on the "Insert" button in the "*Content" menu in the "Master values" group.
→ Es öffnet sich ein Auswahldialog. -
A selection dialog opens in which you can now select "Automate worksheet".
→ Rechts erscheint der Arbeitsbereich „Arbeitsblatt automatisieren“. -
On the right hand side the task pane "Automate Worksheet" appears, in which you press the right button under "Actions" to have the keydate inserted automatically.
-
To insert an account calculation, select "Account calculation" in the drop-down area under "Data type".
→ Nun sehen Sie die Auswahl an Kontenberechnungen unter „Werte“. -
Now you can see the selection of account calculations under "Values". Select the account calculation to be inserted.
-
Then click on the left button under "Actions" to insert the values in the table.
-
Next, click on the row of the master value column where an account is to be inserted.
-
Select "Accounts" in the task pane, under Data type.
-
Under "Values", you can now select the account to be inserted. To find a specific account in a large number of accounts, you can also search directly for a specific account in the search field.
-
Under "Actions", click on the left button to insert the value of the account in the selected row.