- VLookup Equation
- HLookup Equation
- IF Function
- Right - Left Functions
- Count If Function
- Draw S Curve for your project using Excel & Primavera P6
Welcome to "Microsoft Excel for Planning Engineers - S Curve Included"! This comprehensive Udemy course is designed to equip planning engineers with essential Excel skills to streamline their workflow and enhance project management efficiency.
Whether you're a beginner or an experienced professional, this course will take you on a journey through Excel's powerful functionalities tailored specifically for planning engineers. From basic formulas to advanced data analysis techniques, you'll master key concepts such as VLOOKUP, HLOOKUP, IF statements, COUNTIF, and more.
One of the highlights of this course is learning how to create S curves, a fundamental tool for project planning and monitoring. You'll delve into the intricacies of drawing S curves using data extracted from Primavera P6, a popular project management software.
Here's a sneak peek into what you'll learn:
Understanding the fundamentals of Excel for planning engineers
Mastering VLOOKUP and HLOOKUP functions to efficiently retrieve data
Utilizing IF statements to automate decision-making processes
Harnessing the power of COUNTIF for accurate data analysis
Exploring advanced Excel techniques such as RIGHT, LEFT functions, and more
Creating visually appealing and informative S curves for project monitoring
Integrating data from Primavera P6 to generate comprehensive project reports
Practical exercises and real-world examples to reinforce learning
By the end of this course, you'll have the skills and confidence to leverage Microsoft Excel effectively in your role as a planning engineer. Whether you're tracking project progress, analyzing data, or presenting reports, Excel will become your indispensable ally.
Don't miss out on this opportunity to elevate your Excel proficiency and excel in your career as a planning engineer. Enroll now and take the first step towards mastering Microsoft Excel for planning professionals!
Enjoy and appreciate the taste of summer vegetables. Serve more healthy food in the table.
How to create stories that capture readers and develop your skills as a writer
Double Or Triple Your Coaching Premiums While Living In The "Freedom Zone" And Still Helping Your Market Achieve Results
5 Steps to Discover Your Professional Passion
Learn key strategies for becoming a powerful grassroots organizer for social change in your own community.
Planning Engineer with experience over 6 years of diverse industry experience.
Certified Professional Project Manager from the American Project Management Institute PMI.
MSc. student in construction management from Ain Shams University.
Worked on more than 10 projects in 5 different countries.
Specialized in data analysis, business intelligence, and creating interactive dashboards.
Interested in 4D BIM, Business Intelligence, AI, and more.
Founder of PM Pro Guide, a blog that provides free resources for all the people interested in project management.