Budgets-Costs-Advances of Projects with Microsoft Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Budgets-Costs-Advances of Projects with Microsoft Excel to your Wishlist.

Add to Wishlist

Budgets-Costs-Advances of Projects with Microsoft Excel

Define Scope and Budget scenarios for effective execution control.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Last updated 5/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Define and control projects with Excel to deliver under Budget and on time.
View Curriculum
Requirements
  • Excel at beginner level
Description

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.

Who is the target audience?
  • Persons responsibles to deliver projects.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
02:55:05
+
Introduction to Project Activities and Resources definition
1 Lecture 16:02

Every project needs a SCOPE definition. The activities of the SCOPE will be defined in a Gantt Chart. The resources, time and cost of each activity gives the cashflow need of the project.

Preview 16:02
+
Introduction to Project Scope
1 Lecture 09:40

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.

Introduction to Project Scope
09:40
+
SCOPE
1 Lecture 14:34

The first task of every project is the SCOPE definition. All the involved parts:must agree with the Project Definition and SCOPE. The easiest way to explain the Project definition is with a diagram: The Work Breakdown Structure and the Gannt Chart.

SCOPE
14:34
+
Time, Resources, Quantity and Costs
1 Lecture 15:44

Each activity will demand resources and quantity. The sum of the budgets of all activities will give the general budget of the project.

Time, Resources, Quantity and Costs
15:44
+
Cashflow need along the Project
1 Lecture 14:39

The dates of Start and Finish of each activity and the cost for the resources, will give the cash flow need all over the project duration.

Cashflow need along the Project
14:39
+
Cost Escenarios Modeling
2 Lectures 27:39
Cost Escenarios Modeling
15:48

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

Cost Escenarios Modeling II
11:51
+
Risk Management
2 Lectures 30:11

After the Work Breakdown Structure design explained before, every activity must be analyzed to visualize if there could be not planned events that could affect the project. And if it is the case, what activities are needed to face the problem and delay. Alse what human & materials

Risk Management I
13:41

Risk Management makes possible to see the impact of the need for more cash flow, if the risk affects the project and provision and over costs have to be covered.

Risk Management II
16:30
+
Execution and Change Control
2 Lectures 33:11

Each bought of material resources and payments to human resources must be recorded on the Activity/Resource pair. This is key to see if the expenses are under budget and the requests for resources corresponds to the actual activity of the project.

Execution and Change Control I
16:26

New requirements has to be documented on Change Control. These requirements consumed human and material resources that were not on the Budget. So this Change Control must be charged to the client. Otherwise it will impact the Project Revenue.

Execution and Change Control II
16:45
+
Procurement
1 Lecture 05:23

The reason to keep the provider name on every purchase on execution is to have a historical log of costs. With this log, the Purchase Office can do an analysis of the providers that are giving best costs for the project.

Procurement
05:23
+
Lessons Learned
1 Lecture 08:02

After the project close, it is important to do an analysis on lesson learned, because the Project Documentation will be use for the next proposal to a new project. It can’t repeat the errors and missings.

Lessons Learned
08:02
About the Instructor
Fernando Roque SD Metrics
3.1 Average rating
11 Reviews
101 Students
6 Courses
Director SD Metrics

I do process and quality control using statistics.  The data entry for data analysis is done with mobile software developed by my company, SD METRICS.  
Expert in Geographical Information Systems, Logistics and data acquisition with mobile and using Google Maps API.
Cross platform development for Android, Windows Mobile and Iphone with HTML5 and JSONP with webservices and Database on the Cloud (PHP, MYSQL).