How to Calculate Weighted Average Using Excel To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells.