This is a past event. Registration is closed. View other Capital Contractors Institute events.


Virtual | 9:00 - 11:00 AM

The introduction of advanced formatting techniques and the analysis tools will enable users to become more efficient spreadsheet users. Topics will include spreadsheet formatting, absolute cell references, the Solver procedure, the Outline procedure which will allow users to hide detail rows in spreadsheets and designing graphs.

  • Creation of formulas that will copy the direct reference of a cell, rather than the relative reference
  • Calculating a formula backwards, users will learn how to change the value of a cell that is dependent on a formula
  • Modifying format of graphs 

Recommended Audience:

Service Managers & Technicians, Field Supervisors & Personnel, Project Managers, Foremen, Estimators and Clerical Roles


Registration open only to MCAMW & NECA Members.

Instructor