Overview

Is running or analyzing a business or individual jobs important for you? We will demonstrate tools to help you better calculate your business metrics, and examine business scenarios all through the use of Microsoft Excel.

Topics

1. Project Forms for Estimating, Costing
• Industry Best Practices for Creating Professional Forms
• Developing “what if” analysis for estimates and project plans
2. File Security
• Locking Cells
• Protecting Worksheets
• Protecting Data
3. Creating Forms (Estimate Sheets, Production Calculations)
4. • Data Validation
   • If Statements
   • Date Functions
   • LookUps (Vlookup, Match, Hlookup, Index)
5. Helping Users
• Comments
• Naming
6. Project Bidding
• Incorporating Excel spreadsheets in other documents
• Linking and Automatic Updates
• Precedents and dependents
• Auditing/Verifying information

Enrollment is limited to 6 persons to ensure that each participant receives individualized attention. This is a hands-on workshop. We will utilize screen sharing software and file sharing software to present the course and exercises. You may share your screen to get personalized assistance with your work.

Cost of this course is $314 + applicable taxes for Canadian Customers Only. Course runs from 1:00 p.m. to 4:15 p.m. Eastern Time

Schedule