• News

Excel for Construction (Basic)

By | articles, news, Tech, Uncategorized | No Comments

REGISTER HERE

OCTOBER 4, 2017  8AM TO 5PM

Excel for Construction (Basic)
(costs, tracking, lists, schedules, estimates, production rates)
CCA has accredited this course for 1 Gold Seal Special Industry Credit (SIC)
Excel is an excellent tool to calculate and track important information.
If tasks such as tracking expenses, jobs and equipment, or creating estimates are work that you do, then this
course will help save you time and money. If you have ever used a spreadsheet created by someone else and
struggled, then this course is for you.
Do you calculate production rates? keep track of costs or budgets? Excel makes these tasks easy and it gives
you a record of all your calculations (unlike your calculator). Excel makes it easy to verify your work and enter
changes.
Our one day workshop will show you how to use Excel to do all these things. Learn to create your own
spreadsheets, and change existing ones.
Objectives
The Construction Professional will be able to use Excel to create estimates, track expenses, calculate overruns,
track production rates, calculate materials usages.
1. Create better financial estimates of projects
2. Calculate and create records of production rates
3. Maintain better financial records of business expenses
4. Be able to do tracking of expenses and revenues by job
Prerequisites
Participants should have a basic understanding of how to use a computer (create a letter, create an
email, find files). For people who do not have these skills, we offer a course titled ‘In From the Site’
which is designed specifically for construction personnel unfamiliar with computer office technologies.
October 4th – 8am to 5pm
200 Brock St., Barrie
Cost: $299.00 + HST
Topics Covered
– Basic spreadsheets for simple estimates
o Numerical calculations using excel
o Incorporating financial information (estimates) into Word documents
o Creating simple estimates
o Using formulas
o Creating Budgets
o Charting
o Calculating Production Rates
– Tracking Expenses
o Simple calculations over time – expense tracking
o Record Keeping – jobs and equipment
o Subtotals – tracking by job or location
o Filters – analyzing results
o If Statements
o Multiple books and Links – job tracking
– Year over Year comparisons
– Reporting
o Formatting
o Linking
o Exporting
o Conditional Formatting
Enrollment is a minimum of 7 to a maximum of 12 persons to ensure that each participant receives
individualized attention. This is a hands-on workshop and laptops with software are provided for the
duration of the course.

 

In Memorium – John Eek

By | articles, news, Tech, Uncategorized | No Comments

John Eek of John Eek & Son Ltd passed away on Friday September 8, 2017.

John and his family have a long history in the construction industry in Simcoe County and have been long time members of the BCA.

Our condolences go to the family on the loss of their great Dad and Poppa.  John will be resting at the Skwarchuk Funeral Home in Bradford.  You can find the details at the link below.

http://skwarchukfuneralhome.com/tribute/details/5240/John-Eek/obituary.html#tribute-start

CanaData Conference presented by ConstructConnect

By | articles, news, Tech, Uncategorized | No Comments

Thought Leadership to help you plan ahead – at a 30% discount!

Uniting business leadership with high-profile speakers, CanaData is the premiere construction forecast event in Canada. For 32 years, this conference has provided expert analysis to help industry leaders plan ahead, making it a prime networking opportunity. Check out our list of past attendees to see who you might meet over coffee!

Canada’s must-attend event for leaders in construction

Held at the luxurious Liberty Grand in Toronto, this full day of analysis and forecasts from industry experts will help you get all the important and timely facts you need to make the right decisions for your business. Delegates walk away with meaningful and actionable insights to help guide their business.

Construction Association Members Save 30%
Contact the ConstructConnect sales team at salescanada@constructconnect.com or 1-800-959-0503 ext. 25534 and mention your Construction Association Membership!

Highlights of the day will include:

  • Carl Bernstein, Pulitzer Prize winning journalist/author and political analyst
    • Keynote Address: Applying Lessons from the Past to the Current Muddled Political Environment
  • Peter Hall, Vice-President and Chief Economist – Export Development Canada
    • Topic: The World US & Canadian Economic Outlooks
  • Alex Carrick, Chief Economist – CanaData, ConstructConnect
    • Topic: CanaData’s Overview Forecasts of Construction
  • Bern Grush, Autonomous Fleet Strategist at GrushNiles Strategic
    • Topic: The Challenges for Construction in a World of Unprecedented Technological Change
  • See full 2017 speaker lineup, or take a look at the 2016 conference recap.

For full event details, visit CanaData.com.