Vorlage:Video-Arbeitsblatt automatisieren-English

A detailed explanation of the individual steps

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.

• A selection dialog opens in which you can now select "Automate worksheet".

• 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".

• 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.