Excel Formula List (40+ Useful Formulas to Master Excel)
Case 6.1 – Calculate the Average. We have the following dataset with some employees and their sales in 3 different months.We want to get the average sales of each employee in average sales column.. Steps: Insert the following formula in cell F6 to get the average sales of the first employee and then use the Fill Handle icon for all the …