I recently attended a NACUBO conference in Georgia discussing various topics around planning and budgeting. One of the sessions which I found particularly interesting was called Strategic Budgeting and Financial Forecasting. During this session an Excel based tool created by Public Financial Management (PFM) was demonstrated. This dynamic tool gave those involved in planning the ability to project profit and loss statements years in advanced. A tool such as this helps the administration plug possible gaps and capitalize on surpluses. This same concept and tool is what we bring to small business owners. The power of Excel to organize data and its interrelationships in one place to give a picture of how an organization works. This is referred to as a financial model. This tool is then used to support decisions and test different scenarios. How are you using Excel in your organization? Does it help you make business decisions?
From time to time I see people manually numbering rows in Microsoft Excel. As always there is a quicker way. In this case it is a tool called Fill. This tool gives users the ability to quickly populate cells with the same or sequential values. Here is a quick video showing you how.