Calculating a running balance in Excel
Calculating a running balance in Excel is useful when you wish to check your bank or credit card account. Let’s see how this is done practically. As you can observe the first calculation, where you need to add the opening balance in your account, is crucial. You can add numbers using the ‘+’ sign or by placing ‘,’ between the numbers.
- First use the Excel sum function in the first two rows as demonstrated.
- Next use the Excel autofill function to calculate the running balance.
- This Microsoft Excel training video describes how to calculate a running balance of a bank account.