Analyze data faster and better with these 5 amazing Excel tricks.

They are:
1) Quick Analysis (CTRL Q)
2) Date cleanup
3) Deriving user id from name column
4) Duplicate check
5) Extracting unpaid students

Timestamps:

0:00 Intro and first tip (Quick analysis)
1:45 Date cleaning (with text to columns)
3:40 Date cleaning with formulas
6:00 User ID creation
7:25 Duplicate check
8:19 Filtering unpaid students

Example dataset:

Practice this with the sample data here

https://chandoo.org/wp/wpcontent/upl...

Happy learning

#Excel #ExcelinTelugu