Video Training
Â
In today's competitive construction climate you can no longer afford to prepare construction bids on paper. A single mathematical error can cost your business thousands of dollars.
In 2010, there are more professional construction estimators using Microsoft Excel than all other estimating software programs combined. The reason is simple; using Excel you have the ability to estimate your way, using the same approach and methodology that you use today. But when you use Excel, the computer handles all of the math for you, perfectly accurate every time.
Combine the power of the Excel spreadsheet with one of our easy to use screen-takeoff solutions and you have a complete estimating package, for a fraction of the cost of the 'canned' estimating programs you see at the trade shows.
Many of you have told us that you don't know how to use Excel or that you will need help building a construction estimating template using Excel. So we've created a series of videos showing you precisely how to use Excel including all of the formulas and functions you will need to build your own Excel based solution.
For a one time fee of just $99, you can access all of the videos online and watch and listen from any computer with access to the Internet. The videos are designed to be viewed in sequence, and they are geared towards a construction estimator with little to no experience using Excel.
Beginners Video Guide to Estimating with Excel - $99
Buy Now! 
Click Add to Cart to buy now. You will receive an email with a link to access each of the videos as often as you like. This video series may be viewed online using Microsoft Media Player or may be downloaded and saved on a DVD.
Benefits Include:
- Learn Excel 2007 from a construction professional in just a few hours
- Learn by watching, completely video based no books to read
- Ideal for beginners, easy to follow videos that offer visual clarity
- Learn all that you need to build your own estimating template, for a fraction of the cost of classroom based training
- Learn from your own desk at a speed that suits you
- You control the pace, training can be stopped, rewound, fast forwarded or re-played as often as required
The Beginners Guide to Estimating with Excel 2007 includes:
Â
|
Video #1 - The Basics Run time 8:53 |
Video #2 - Learn to Enter Data Run time 11:35 |
Video #3 - Learn to use Formulas Run time 19:00 |
Video #4 - Lean to use Functions Run time 17:04 |
Video #5 - More Advanced Excel Features Run time 14:08 |
| Review of the parts of the Excel 2007 screen | Copy/paste/paste special | Basic formulas - +,-,*,/ | Estimating functions | Create drop down lists of items |
| Workbooks & worksheets explained | Move data from one cell to another | Build a construction assembly | Auto-sum, sum() | Lookup functions, Hlookup / Vlookup |
| How to open an existing workbook | Insert rows/columns, resize | Cell references, fixed & floating | Roundup() | Auto-filter lists of data |
| Save or Save As | Delete rows / columns | Create and use range names | Date() | |
| Controlling the Zoom Level | Auto-fill feature | Logical incl if then else | ||
| Sorting data | ||||
| Printing |
|
Video #6 - Change the Appearance of Your Worksheet Run time: 7:29 |
Video #7 - Format your worksheet Run time 6:51 |
| Freeze panes | Number formatting |
| Split windows | Changing cell colors |
| Rename tabs, change tab color | Adding text formatting |
| Formatting cells and ranges of cells | Font type, size,color, bold,italics, alignment |
| Format painter | |
| Page Layout - apply themes | |
| Display headings and gridlines |
