Print Page   |   Contact Us   |   Sign In   |   Register
Excel For Construction (Advanced)
View Registrations Tell a Friend About This EventTell a Friend
 

2017-06-20
When: June 20th 2017
8:30am-4:30pm
Where: GVCA Office
25 Sheldon Drive
Cambridge, Ontario  N1R 6R8
Canada
Contact: GVCA
(519) 622-4822 x 120


Online registration is closed.
« Go to Upcoming Event List  

Earn one (1) Gold Seal credit

 

Cost tracking, job tracking, production rates, schedules, estimates: If you would like to create spreadsheets to make this work easy and consistent, then this course is for you. Learn to create spreadsheets for cost tracking, calculating production rates and creating estimates. We will show you how to create spreadsheets that can be used by co-workers and that are robust and secure.

 

Is running or analyzing a business or individual jobs important for you? We will demonstrate tools to help you better calculate your business metrics, profitability of jobs, plan budgets and examine business scenarios all through the use of Microsoft Excel. This advanced level course will give you a better comprehension of how to analyze data to create what-if scenarios (what if conditions changes…. how will these affect the cost of the job).

 

- Learn how to create simple Gantt charts and timelines in Excel.

- We will show you how to use Excel with other programs to quickly and easily make presentation materials from spreadsheets containing estimates and schedules.

- Discover the capacity to manipulate and analyze information (via pivot tables) to create management analysis reports.

 

Course Topics

- Project Cost Estimation

 Industry Best Practices for Creating Professional Estimates

 Developing “what if” analysis for project plans

- Scheduling using Gantt Charts - File Security

 Locking Cells

 Protecting Worksheets

 Protecting Data

 Creation of estimating and job costing forms

- Analyzing Data

 Filters

 Pivot Tables

 Data Validation

 Analyze multiple scenarios using filters, pivot tables and data validation

- Project Bidding

 Incorporating Excel spreadsheets in other documents

 Linking and Automatic Updates

 Auditing information

- Expense Tracking

- Analyzing Budgets and Business Metrics 

more Latest News
more Calendar

2017-08-23
Construction Industry Ethics (In Class Portion)

Featured Members

Online Surveys
Membership Management Software Powered by YourMembership  ::  Legal