The reports I mainly use are Cust./Item Stat. by Salespers. and Outstanding Sales Order Status in Excel(data only). Both have over 50 columns and 90% of them are repeated or not useful.

For example, columns A-J and U-AN are all column titles, no actual information. Another example is that AO and BO are identical.

I use MS Access queries for the 7 out of 78 columns that I need. There are a lot of hidden columns too which really messed with me when I tried to keep it in Excel. The data only Excel reports have potential to be so much better.