Imprint this in your mind. If you are in the finance industry, Microsoft Excel will be your best analytical tool until the end of your career. Conduct of financial analysis in Excel is a given thing. You will be dealing with a lot of finance Excel spreadsheets from the first day of your career. Learn about the basic functions every finance professional use and know - NPV, XNPV, PMT, IMPT, EFFECT, RATE, Slope, FV and a lot more!