Estimating and forecasting don’t have to be time-consuming or difficult. This course will teach you how to use Microsoft Excel and a freely licensed estimation technique called Statistical PERT to easily estimate your projects and products.
Have you ever had a difficult time creating a project schedule or budget or been unsure how to forecast when new features will be ready for your agile-developed product? If so, this is the perfect course for you. In this course, Easily Estimate Projects and Products, you will learn how to easily create estimates for any uncertainty that has common, bell-shaped risk characteristics, like how much a project will cost or how long it will take to develop features on your product backlog. First, you’ll learn the difference between estimates, predictions, and forecasts and why forecasts are superior to predictions. Next, you'll explore how to easily create probabilistic estimates using Statistical PERT. Finally, you’ll discover how Statistical PERT models your project and product uncertainties using the normal probability distribution curve. When you’re finished with this course, you'll not only know how to use Statistical PERT to confidently estimate your project and product uncertainties, but you'll know how to modify Statistical PERT to create even better forecasts in the future. Software required: Microsoft Excel 2010 or later.
Course Overview Hi everyone. My name is William W. Davis, and welcome to my course, Easily Estimate Projects and Products. I'm variously a project manager, Scrum Master, and Agilist living in South Florida. Estimating project budgets and schedules and forecasting release dates for Agile-developed products is challenging for project manager, product owners, and development team members. This course will introduce you to an easy probabilistic estimation technique called Statistical PERT. Even if you hate statistics, you'll find that Statistical PERT makes estimating project and product uncertainties easy to do. Some of the major topics that we will cover include learning the differences between estimates, predictions, and forecasts, understanding why we estimate anything, using Statistical PERT to easily estimate many uncertainties, discovering how Statistical PERT works, and modifying a Statistical PERT template. By the end of this course, you'll know how to create project and product forecasts using Microsoft Excel and the freely licensed estimate technique called Statistical PERT. Before beginning this course, you should be familiar with basic statistical terms and have a working knowledge of Microsoft Excel. I hope you'll join me on this journey to learn how to create estimates with the Easily Estimate Projects and Products course, right here at Pluralsight.
Why Do You Estimate Anything? Hi. I'm William W. Davis, and welcome to my Pluralsight course, Easily Estimate Projects and Products. Do you need to estimate a project's schedule or budget, or do you need to forecast a delivery data for an Agile-developed product? If so, Easily Estimate Projects and Products is the perfect course for you because you'll learn how to easily estimate project and product estimates using the built-in functions of Microsoft Excel and an estimation technique called Statistical PERT. This course will teach you how to easily estimate any uncertainty that has a normal bell-shaped risk property. This course has six modules. In this module, you'll learn the two key reasons why people estimate anything. Next, you'll learn the difference between predicting the future and forecasting the future and why forecasting is better than predicting. After that, you'll be introduced to the estimation technique called Statistical PERT. After you learn about Statistical PERT, then I'll show you a demonstration of the technique using the free Statistical PERT example workbook for Microsoft Excel. Once you've seen all the tabs of a Statistical PERT workbook, you'll know how Statistical PERT works and what its limitations are. Finally, I'll show you different ways of modifying a Statistical PERT spreadsheet so it better fits your customized needs. Once you finish this course, you'll begin creating project and product forecasts using Microsoft Excel and a freely licensed probabilistic estimation technique called Statistical PERT. Let's get started.