Free Construction Cost Estimate Excel Template
Spreadsheets can be your most effective and powerful tool in your business arsenal if you take advantage of the multitude of options and features available. Learning how to appropriately use these features will not only make your presentation stronger but also provide you with a simple means of sorting and organizing data. The data is important but will mean nothing if it isn t presented in a palatable form. Spreadsheets are the king of project management support tools because they are the most convenient tool to use and the most frequently used tool.
Here are a few things to keep in mind while constructing your spreadsheet. Fit to Screen Fit to Page Although your wealth of information may warrant it don t make a spreadsheet that is a massive three to four screens long. A spreadsheet of this caliber is no fun for anyone especially on screen. Rolling around a spreadsheet that size especially one you aren t familiar with can become quite frustrating. Under the "Print Preview" option you can force the printer to fit the document to one page but then everything is decreased in size and makes it even harder to read the information.
Most Popular This Week
Here was a spreadsheet that had been created by someone with a good knowledge of formulas and functions. But... it was not obvious at first glance what to do with it. Do I click on one of these buttons? Do I need to enter some data? Where do I enter the data? On closer examination these were the problems that made it difficult to use: - There was no heading or title. - It was very dense in terms of the number of cells showing on screen. - Ranges of cells were formatted in five different colours. What did it all mean? - Help provided was limited to brief comments in some cells and some of these were in hidden columns. - The sections for data entry and the sections for results were not clearly separated. - Macro buttons were square in shape.
Yet there is no tool for project management that is more popular or widespread than the spreadsheet despite the fact that spreadsheets are not designed to be project support tools. Even in organizations with an established project management tool spreadsheets are used. There are obvious reasons for this. A spreadsheet program is on almost every computer in every organization people are familiar with spreadsheets and how to use them and people are pre-disposed to use these "office" types of software tools to solve problems. And I am right there with them. I love using spreadsheets to track all kinds of data.