As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks. Summary How to use the average function in Excel 2010 Click inside the cell where you want to display the average. Calculate the average percentage in Excel Find a place where you want to count the average.
Enter the total to date in another cell.
To calculate the percentage of a total in Excel execute the following steps. How to Calculate Averages in Excel. For example to find the third largest number use the following LARGE function. Enter the total to date in another cell.