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

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

Combine text strings using TEXTJOIN() and CONCAT().

Learned Excel Functions: CONCAT(), CONCATENATE(), TEXTJOIN(), TRUE()

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

Learned Excel Functions: TRIM()

Learned Excel Functions: LEN(), TRIM()

Learned Excel Functions: N(), T(), VALUE()

Learned Excel Functions: REPT()

Learned Excel Functions: LEN(), REPT()

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: LEN(), LOWER(), PROPER(), SUBSTITUTE(), UPPER()

Practice your text functions skills.

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

Practice your text functions skills.

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

Practice your text functions skills.

Learned Excel Functions: LEFT(), SEARCH(), SUBSTITUTE(), TRIM(), VALUE()

Practice your text functions skills.

Learned Excel Functions: TEXT()

Practice your text functions skills.

Learned Excel Functions: CONCATENATE(), LEFT()

Practice your text functions skills.

Learned Excel Functions: CONCATENATE(), DOLLAR(), LEFT(), RANDBETWEEN(), REPLACE(), SUBSTITUTE(), UPPER()