Count me in as a SUMIF fan. Vlookups break if you accidentally have a double up in your source table.
Finance degrees work if you can beat off the 1000's of other applicants into a job. Then you make the most of your time before inevitably the restructure knife is wielded.
So many specialisations to choose from. Accounting (corporate, business services, audit), Banking (risk, lending, treasury, markets, dealing), Finance (broking, funds management, investment banking, FX and derivatives trading), Financial Planning, Tax Law etc etc.
I'm a corporate accountant at the moment. I say at the moment, because in 10 years time I expect that my job will either be automated by a machine, or will be different due to the pace of change in the industry. Universities are churning out grads for the jobs of today. Nobody really knows what jobs there'll be in 10 years time. Passage of time will tell as always, but those with foresight will do well indeed.
Got asked the question today whether I have gotten bored doing 60 straight month ends without a break. Replied that because of M&A activities (well, sales of large chunks of our business) I haven't had a standard month-end in over a year now. Sure there are times where I wish I was somewhere else, but you gotta be able to earn money to save for FI before you are FI.