When presenting your business plan to an angel investor you must understand that they will be very interested in your spreadsheets and proformas, but you must also realize that it is typically an entrepreneurial optimistic approach, which causes problems with proformas. Therefore, you should have dueling spreadsheets; that is to say the spreadsheets, which take your best guess and double the time, double the expenses to compete with your optimistic approach. You should be able to present both of these to your Angel Investor; who chances are is a retired business person with a little bit of financial savvy.
You can always go back and learn the rest of them as you need them or when you have mastered the various formulas you are using on a regular basis. There are many different formula used in Excel to create spreadsheets and manipulate the information you place within them. Over time and with a fair amount of studying, you will come to understand how to use them all. Technology has changed so much since last century and all of us who live in this competitive age are forced to use it. How exactly can you fully utilise technology so that gain the maximum benefits from them?