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!

Share this post
EmailFacebookFacebook MessengerTwitterPinterestLinkedInShare