Look at the some of richest people in the world. A table of these people age, earnings, the company owned by those companies and countries to which they are located. Getting the required information by a variety of comparison and filtering criteria from the table.
Learned Excel Functions: AVERAGE(), AVERAGEIF(), AVERAGEIFS(), COUNT(), COUNTBLANK(), COUNTIF(), COUNTIFS(), SUM(), SUMIF(), SUMIFS()
Create a summary of salesperson sales stats with the help of range lookup.
Learned Excel Functions: AVERAGEIF(), COUNTIF(), FALSE(), IF(), LEN(), SUMIF(), TRUE(), VLOOKUP()
Revisit your sales data, calculate regional totals, conditional totals
Learned Excel Functions: COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT()