A lot of what Excel is used for (and it is still the best tool out there many things like this) is cleaning up and organizing data.
Excel recognizes certain lists:
- Days of the week
- Months of the year
You can define your own custom lists if you like (not covered here).
Go to Options → Advanced → Edit Custom Lists
Between the lists and the Fill command, you can get data laid out very quickly in a spreadsheet. Then the Flash Fill command can be a huge time saver when you are cleaning up data (eg) from a bank account download, where you are trying to get a pure list of Payees into a column.
Watch the video and post your questions below!