Anonymous wrote:With regard to Excel, the best thing you can know is the ability to think "huh, I bet I could do that in excel" + Google + "huh, that does not make sense as an answer, what if I change XYZ"
Literally anything you want to know is out there, but you need to have a brain that sees the shortcut/possibility and the tendency to google till you get it.
Very true. My attitude is, if I can think of it, someone else has already done it. The biggest challenge is to figure out what to call it - the correct name for the thing you want to do. Sort vs filter vs getting those automatic filters on the top row. Freeze panes - that took me forever to figure out what to call “I want to keep the top row on top as I scroll through a spreadsheet that goes beyond one page.