Learn absolute and relative referencing using a sample data which about oil production in Northern American countries.
Learned Excel Functions: SUM()
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() functions in this exercise.
Learned Excel Functions: FALSE(), HLOOKUP(), TRUE(), VLOOKUP()
Create some statistics to better understand the social media adoption
Learned Excel Functions: FALSE(), INDEX(), MATCH(), VLOOKUP()
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 various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order Amount" to start pivot tables.
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()
Using and testing some values.
Learned Excel Functions: INDEX(), MATCH(), OFFSET(), SUM()