Anyone have any advice on how to learn to use excel well? I've only ever down simple column operations before, but I've seen spreadsheets that do crazy complicated things.
Yes, check out the two books by John Walkenbach, Excel 2013 Formulas and Excel 2013 Power Programming with VBA. Not too much has changed since those versions-- I originally read the 2007 versions of them and it all transfers over because Microsoft is incredibly good about maintaining backwards compatibility.
