Excel for Cost Engineers

Abstract

Excel is a powerful tool with a plethora of largely unused capabilities that can make the life of an engineer cognizant of them a great deal easier. This paper offers tips, tricks and techniques for better worksheets. Including the use of data validation, conditional formatting, subtotals, text formulas, custom functions and much more. It is assumed that the reader will have a cursory understanding of Excel so the basics will not be covered, if you get hung up try Excel's built in help menus, or a good book.