Working with Synergy, I frequently download information such as Accounts, Contacts, Items, Requests, Projects, etc. and need to manipulate the data in Excel. The help files in Excel sometimes does not provide the answer that I wish.
I have found two excellent sources of Information for Excel from the following:
www.mrexcel.com Many good tips on this site
www.TheExcelAddict.com He publishes a weekly newsletter that I subscribe to. He is in the process of building a new website.