Budgets-Costs-Advances of Projects with Microsoft Excel
- 3 hours on-demand video
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- Define and control projects with Excel to deliver under Budget and on time.
- Excel at beginner level
This course will show you how to define Project Activities, resources and Cost. Also how to plan RISKS and how much money could be needed is something occurs during execution. All done with Pivot Tables of Excel. Every project has to have a defined SCOPE. SCOPE has activities , time and resources. The Gantt Chart will show what is the order of precedence of each activity. Resources cost will give the Budget for each Activity and for all the Project.The SCOPE definition using Break Down Structure of Activities is the input for Gantt Chart. The planned Cashflow is got from activities time and resources/cost.
- Persons responsibles to deliver projects.
The scenario modeling for situation a) can be shown on the Excel Worksheet of the Project. On the resources sheet, a new column of cost scenario for every resource can be added. The on the Project Sheet a new column for Modeling will show if we are working on the original budget