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.
Learn AVERAGE(), AVERAGEIF(), AVERAGEIFS(), COUNT(), COUNTBLANK(), COUNTIF(), COUNTIFS(), SUM(), SUMIF(), SUMIFS() Excel Functions
Calculate which country recieves the most tourists in each continent.
Learn AVERAGE(), COUNTIF(), FALSE(), IF(), RANK(), REPT(), SUM(), SUMIF(), TRUE() Excel Functions
Revisit your sales data, calculate regional totals, conditional totals
Learn COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT() Excel Functions
Understanding formulas with "Sales" operations.
Learn AVERAGE(), FALSE(), RANK(), SUM(), TRIMMEAN(), TRUE(), VLOOKUP() Excel Functions
Calculating a conditional average which involve some logic and some special functions.