Excel makes it easy to calculate weighted averages by combining values with their corresponding weights. Using the SUMPRODUCT ...