Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

Learned Excel Functions: SUM()

Using simple text function to create a digital staff identity card. You will be more advanced in using the text functions.

Learned Excel Functions: CONCAT(), CONCATENATE(), IF(), LEFT(), LEN(), MID(), PROPER(), RIGHT(), UPPER()

Basic revenue calculation by implementing stays, discounts and tax.

Learned Excel Functions: PRODUCT(), SUM()

Using basic functions with more practices.

Using basic functions with more practices.

Learned Excel Functions: MAX(), MIN(), SUM()

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtime hours.

Learned Excel Functions: FALSE(), IF(), INT(), SUM(), TIME(), WEEKDAY(), WEEKNUM()

Create a "Travel Budget" sample.

Learned Excel Functions: REPT(), SUM(), SUMIF()

Create meaningful insights from internet users of top 25 countries between 2013-2015.

Learned Excel Functions: AVERAGE(), COUNTIF(), MAX(), RANK(), SUM(), SUMIF(), SUMIFS()

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional statisctics.

Learned Excel Functions: AVERAGE(), COUNTBLANK(), COUNTIF(), FALSE(), IF(), RANK(), ROUNDUP(), SUM(), SUMIF(), SUMIFS(), TRUE(), VLOOKUP()

Creating an invoice with base functions.

Learned Excel Functions: FALSE(), IF(), IFERROR(), SUM(), TRUE(), VLOOKUP()

Using basic functions with more practices.

Learned Excel Functions: SUM()

Using basic functions with more practices.

Learned Excel Functions: AVERAGE(), MAX(), SUM()

Using basic functions with more practices.

Learned Excel Functions: AVERAGE(), MAX(), MIN(), SUM()

Using basic functions with more practices.

Learned Excel Functions: COUNTA(), COUNTBLANK(), LARGE(), SMALL()

Using basic functions with more practices.

Learned Excel Functions: AVERAGE(), COUNTA(), LARGE(), MAX(), MIN(), SMALL(), SUM()