Practical Project Planning Using Excel(r)

Know about the book -

Practical Project Planning Using Excel(r) is written by Galit Shmueli and published by . It's available with International Standard Book Number or ISBN identification 1466306823 (ISBN 10) and 9781466306820 (ISBN 13).

Projects are investments of resources for achieving a particular objective or set of objectives. Resources include time, money, manpower, and sometimes lives. Objectives include financial gain, social and health benefits, national goals, educational and scientific achievements, and reduction of suffering, among many others. Projects are undertaken by large and small organizations, by governments, non-profit organizations, private businesses, and by individuals. Determining whether to execute a project, or which project to execute among a set of possibilities is often a challenge with high stakes. Assessing the potential outcomes of a project can therefore be detrimental, leading to the importance of making informative decisions.Practical Risk Analysis for Project Planning is a hands-on introduction to integrating numerical data and domain knowledge into popular spreadsheet software such as Microsoft Excel or Google Docs, to arrive at informed project-planning decisions. The focus of the book is on formalizing domain expertise into numerical data, providing tools for assessing potential project performance, and evaluating performance under realistic uncertainty. The book introduces basic principles for assessing potential project performance and risk under different scenarios, by addressing uncertainty that arises at different levels. It describes measures of expected performance and risk, presents approaches such as scenario building and Monte Carlo simulation for addressing uncertainty, and introduces methods for comparing competing projects and reducing risk via project portfolios.No special software is required except Excel or another spreadsheet software. While the book assumes no knowledge of statistics, operations research, or management science, it does rely on basic familiarity with Excel. Chapter exercises and examples of real projects are aimed at hands-on learning.Galit Shmueli is SRITNE Chaired Professor of Data Analytics at the Indian School of Business (India), visiting faculty at Rigsum Institute of IT and Management (Bhutan), and Associate Professor of Statistics at University of Maryland's Smith School of Business (USA). She co-authors the popular textbook "Data Mining for Business Intelligence", among several other books. This book is based on Professor Shmueli's workshop "Decision Making Using Excel" offered in Bhutan since 2008. Also in this book series: "Practical Time Series Forecasting" and "Practical Acceptance Sampling".