Bookkeeping software produced on spreadsheets would normally be a series of spreadsheets with the columns preset and titled and formulae written into the sheet to automatically add up each column. In addition the columns used would normally be restricted to general headings to include a full analysis of all items. Small businesses that might produce their own spreadsheet would often do this on an annual basis. Bookkeeping software is much more likely to provide these bookkeeping spreadsheet templates on a monthly basis to enable a degree of financial control to be exercised by the small business. That is the second real value of bookkeeping spreadsheets, the ability to provide the business with financial information and through that data financial control over the business activities. The first value is of course the simplicity of listing with automated summation of the figures.
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?