Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes percentage , popularity rankings and perform actions such as creating the exact name of the movie.
Learn AVERAGE(), COUNTIF(), FIND(), IF(), LEFT(), MAX(), MID(), MIN(), SEARCH(), SUM(), SUMIF() Excel Functions
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Learn CONCAT(), CONCATENATE(), DAY(), LEN(), MONTH(), REPT(), TEXT(), TRIM(), UPPER(), YEAR() Excel Functions
Working on banking operations.
Learn FALSE(), LEFT(), LEN(), MID(), RIGHT(), SUBSTITUTE(), TRUE(), VLOOKUP() Excel Functions
Exchanging (import, export) data between Excel and other applications.
Replacing text in a cell based on its location or substitute one text string with another based on content.