Excel is well known as a program that allows you to create complex tables of data. However, some people are less familiar ...

List projected costs and benefits in respective columns. Use Excel formulas to sum these columns for a total estimate. You can also utilize Excels financial functions to calculate project worthiness.

Then, in the new column B cell, calculate the total. In our case, we'll type the following formula into cell B12: =SUM(B2:B11) You might prefer to use Excel's built-in Total Row function to force ...