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 body mass index calculator using height and weight of a person
Learned Excel Functions: FALSE(), HLOOKUP(), IF(), IFERROR(), TRUE(), VLOOKUP()
Revisit your sales data, calculate regional totals, conditional totals
Learned Excel Functions: COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT()