Excel is perhaps the most important computer software program used in the workplace today. Many business professionals use Excel to perform everyday functional tasks in the workplace, and an increasing number of employers rely on Excel for decision support. The beauty of Excel is that it can be used as a receiver of business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation.
You might be asking what is Decision Support. A Decision Support System (DSS) is a computer-based information system that supports business or organizational decision-making activities. A DSS serves management, operations, and planning levels of an organization and helps to make informed decisions. Excel is an excellent tool to be used in this way.
I’ve developed a basic tool to demonstrate how to set up a basic Income Statement and develop a projection of figures based on user input. Basically, you would enter sales figures, cost of goods sold, and expenses. Excel will automatically calculate the gross profit and net income. Additionally, the projected periods will reflect assumptions that you can configure to meet your particular needs. Try it out and let me know what you think. Depending on your screen resolution you may need to adjust the viewing size to fit your screen.
Technically Simplified 