Microsoft Excel Data Analysis and Business Modeling
Wayne L. Winston•Create best, worst, and most-likely scenarios for sales •Calculate how long it would take to recoup a project's startup costs •Plan personal finances, such as computing loan terms or saving for retirement •Estimate a product's demand curve •Simulate stock performance over a year •Determine which product mix will yield the greatest profits •Interpret the effects of price and advertising on sales •Assign a dollar value to customer loyalty •Manage inventory and order quantities with precision •Create customer service queues with short wait times •Estimate the probabilities of equipment failure •Model business uncertainties •Get new perspectives on data with PivotTable dynamic views •Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more!