Reformatting columns, creating files, and totalling organized data

Hey guys. I am an IT tech at a company. Unfortunately I never had any experience with creating macros or visual basic, and as a result of both of our programming guys disappearing this week, I've had a lot of work dumped on my shoulders. One thing my boss has asked me to do is alter this file, creating a bunch of macros (I believe? It doesn't seem like I've been able to create substitute formulas to work for the first part dealing with LName FName MI). I was wondering if there was anyone out there who could help me with this. I've uploaded the xls file (It reads much better in .csv extension though) and I'll list what I've been asked to do. I'm not necessarily asking anyone to do this for me, but I have 2 other tasks I've been asked to complete, one in Java, one in SQL and learning them on top of macros has been rather intense. Any insight or redirection to a reliable source to quickly teach me would be greatly appreciated, thank you!

2) reformat the 'Name' column to have 'Last Name, First Name Middle Initial.'
3) reformat birthdays to be YYYYMMDD
4) output reformatted data to a file called : 'cleandata.<time stamp YYYYMMDD_HHMMSS>.csv'
5) have output sorted alphabetically by state, then by name
6) any duplicates account numbers should be rejected and noted
7) produce a secondary report named 'summaryreport.<time stamp YYYYMMDD_HHMMSS>.txt' with :
- total balances aggregated by state
- there is a column "Favorites". List the top five favorites and the number of times
they appear.