Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes percentage, popularity rankings and perform actions such as getting name of the movie.

Learned Excel Functions: AVERAGE(), COUNTIF(), FIND(), IF(), LEFT(), MAX(), MID(), MIN(), SEARCH(), SUM(), SUMIF()

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

Working on banking operations.

Learned Excel Functions: FALSE(), LEFT(), LEN(), MID(), RIGHT(), SUBSTITUTE(), TRUE(), VLOOKUP()

Learned Excel Functions: EMONTH()

Learned Excel Functions: TRANSPOSE()

Learned Excel Functions: CONCATENATE()

Learned Excel Functions: LEFT(), RIGHT(), SEARCH()

Learned Excel Functions: LEFT(), RIGHT(), SEARCH()

Learned Excel Functions: LEN(), MID()

Learned Excel Functions: REPLACE(), SUBSTITUTE()

Practice your text functions skills.

Learned Excel Functions: LEFT(), LEN(), LOWER(), MID(), PROPER(), RIGHT(), SUBSTITUTE(), UPPER()

Practice your text functions skills.

Learned Excel Functions: FIND(), LEFT(), PROPER(), SUBSTITUTE(), TRIM()

Practice your text functions skills.

Learned Excel Functions: LEN(), LOWER(), PROPER(), SUBSTITUTE(), UPPER()

Practice your text functions skills.

Learned Excel Functions: CONCATENATE(), LEFT(), LEN(), MID(), SEARCH()