Data Management is the key success of construction projects reporting. This self-study course will teach you using a step by step case study how to create effective reports using Microsoft Excel by connecting data through Data Management. If you are using Excel to create reports, then this course is a MUST for you. This course is advanced and is very beneficial for planning engineers, construction managers, project managers, and site engineers.
Download Course Description and Contents: Data Management and Planning Reporting Skills – Course Description and Course Content
Note: This Course is part of Planning Advanced Package – 3 Professional Courses and Primavera 50 Tips where you can save 30%. Click here for more information
1- I will teach you why we need to manage the data.
2- What is the difference between excel sheet and excel database management.
3- How to convert any excel sheet to excel database.
4- I will give you my special excel sheets and Macros to distribute project values, Man hours, Quantities by week and month using dates from primavera.
5- How to create effective database for the project.
6- How to link different tables with relationships.
7- How to solve excel relationships issues.
8- How to create very powerful dashboard excel that showing planned and actual values based on EVM (Money) and Man hours.
9- How to create a detailed project report showing the planned value, earned value, planned %, actual %, Planned Quantity, Executed Quantity, by only updating our database with actual % completed.
10- How to find the activities which spent more working hours than your budget, how many hours your project lost and how many hours you saved (detailed data analysis).
11- Create project cash flow based on any level of your Work Breakdown Structure (WBS).
12- Create report for Man Hours required per month/week and per any WBS like (Stage, Zone, Area…etc).
13- How to create a report showing the project planned quantity per wee/month and per Division of work, Bill of Quantity (BOQ) item, BOQ unit, Specific time frame…etc.
14- We will have much fun in the support forums where we can discuss and create lot of reports and excel dashboard templates.
How This Course Works?
1- You purchase the course.
2- Start your study immediately.
3- Follow the step by step instructions and try to do same reports by your own.
4- Ask any questions in the support forums and you will get an answer within 2 working days.
5- I will create new video (step by step guide) for any report recommended by course trainees.
6- You keep learning and creating new reports in the support forums.
Common Questions and Answers:
Q: For how long i will have access to the course and support forums.
A: You will have lifetime access with no expiry date.
Q: Can i download the course videos and excel sheets?
A: You can download the excel sheets not the videos. Remember, you can revisit any lesson at anytime you want.
Q: What if i have a question or i did not understand a lesson?
A: You are welcome to post your question in the support forum and i will answer you within 2 working days.
Q: What If i need a specific report that not included in your lessons?
A: First try to do it yourself, the purpose of this course is to teach you how to develop your own reports. However, you are very welcome to post an idea for a report or excel dashboard and we can discuss all togethers and do it with a step by step instructions.
Q: Do you provide a certificate, and if yes is there any exam to get it?
A: Yes you will be able to download your completion certificate once you have completed the course, and there is no exam for this course.
Q: Why the course price is high comparing to the course length?
A: Actually, we in Planning Engineer Website did our best to shorten the course as possible because we know that most of the trainees will have jobs and other tasks to do. This makes us do additional efforts to deliver the information in the shortest duration we could. Furthermore, you will have lifetime access to the support forums where we will be always available for your help. Finally, the course is not just excel skills, it involves many planning tips and tricks and the know how to develop powerful reports.
Q: What if i found this course not useful for me after i purchased it?
A: Our money back guarantee policy gives you 30 days from the date you purchased the course to ask for refund. Our policy is full satisfaction or 100% refund.
Still have questions? Contact us now and we will answer all your questions:
Email: [email protected]
Mobile Phone: +201277767728
- Lectures 18
- Quizzes 0
- Duration 6 hours videos + 14 hours practice
- Skill level Advanced
- Language English
- Students 176
- Assessments Yes
Prepare Project DataBase 6
Completion Certificate 1
Excellent structured course, clear and easy to understand, professional presentation. Helpful guidance for all planning engineers. Highly recommend this course. Thanks a lot, Engr. Hany
Al Hassan Mohamed Amin Saleh
Valuable and smart Course
thanks so much for the beautiful one
Can't describe how important this course is! Huge amount of valuable information which is so useful while doing any kind of reports. Really, I want to thank you.
How to work Smart not hard by converting almost anything that you used to do manual into automatic using simple tips & steps..... very nice course