This course has been discontinued
Microsft Excel is the world’s most popular spreadsheet application, with countless uses across all professions. This 3-hour interactive online course demonstrates how to use Microsoft Excel to evolve a Title I (design) cost proposal in order to exhibit common characteristics within proposal development and convey an ability to cost that data within Microsoft Excel. A complete (Excel 2003 format) file download is available with this course. Many of the topics in this course are advanced within the Excel application; however, the course is structured to guide and inform either beginner or expert Excel user. This course evolves a single file (download) to combine data gathering (field work), meetings and charrette activity, direct design time (sheet count), other direct costs, travel expenses, and subcontract costs.
The Excel tools incorporated within this class introduce VBA forms and controls, macro development, data validation, logic statements, and multiple functions to roll-up data under a summary of costs. Each tool within Excel is discussed and applies to the specific set of equations or raw data. In order to focus on the engineering management versus administration of Excel, the download file associated with this class is the populated end product.