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