There are so many Tools in Microsoft Excel which most users never used.
I want to share my experience with others
It was at the office, I and other colleagues were given some tasks. The task involved working with some data of about 2000 entries with multiple information. Each row contains about 10 different information which must be broken down to make the Data usable.
The Data was given to us in an awkward format, as a result, we had to key in those information one after the others.
while cracking my brain on the short method of doing it without typing those 2000 entries, in the process i stumbled upon this:
With this, I was able to save myself and colleagues of unnecessary job which would have consumed our precious time.
I want to believe that every problem has a solution. If there is no solution it is because one has not found the right source or person.
Cheers.
