Microsoft Excel for Construction (Advanced)
1 Full day broken into 2 instructor led sessions from 1:00 PM - 4:00 PM
Description
If you have ever had to make a decision based on manually tracked data, you will greatly benefit from this workshop! You will learn, by using Electronic forms you can save hours of time, giving you a better scope for decision making and improve communications between departments.
Discover how to capture and link data from different files, track changes and create simple macros. Become educated in auditing and tracking data and data validation. Understand about file security. These features save hours of manual effort and help keep numbers confidential.
Gain a better comprehension of consolidating data from disparate reports, master the ability to create, analyze and compare budget scenarios electronically. Discover the capacity to manipulate and analyze databases via pivot tables and to create management analysis reports. Microsoft Excel is an essential tool to learn for anyone tracking data.
Topics
Learn how to use Microsoft Excel spreadsheets to model
- Project Cost estimation
- Scheduling (using Gantt Charts)
- Project bidding
- Expense tracking
This course is worth 2 Gold Seal Credits
Related Info
With this course people in the Construction Industry will learn the advanced features of Microsoft Excel which will allow you consolidate data in minutes, perform audits, present and share complex workgroup information, as well as analyze, share, and manage data enabling you to make better informed decisions, become more accessible, and boost your profitability.