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()

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()

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()

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.

Learned Excel Functions: CONCAT(), CONCATENATE(), DAY(), LEN(), MONTH(), REPT(), TEXT(), TRIM(), UPPER(), YEAR()

Learned Excel Functions: VLOOKUP()

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()

Revisit your sales data, calculate regional totals, conditional totals

Learned Excel Functions: COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT()

Using Nested IF.

Learned Excel Functions: FALSE(), IF(), INDEX(), MATCH(), MAX(), RANK(), SUM(), TRUE()