AQB differs for various banks and various accounts. It is used to calculate the arithmetic mean of a given set of arguments in Excel. Step 3 Type AVERAGE.
Launch Excel and open a spreadsheet with your daily earnings in one column.
Revenue Quantity Price. Now you will get all averages of each month in the Pivot Table see below screenshots. How to Create the Average Function to Calculate Average Projected Revenue in Excel 1. Click the Formulas menu at the top of Excel.