Microsoft Office Excel 2007: Data Analysis and Business Modeling (Paperback)

Description

Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide - updated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You'll learn how to create best, worst, and most-likely scenarios for sales, estimate a product's demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. You'll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty. You get all the book's problem-and-solution files on CD - for all the practice you need to solve complex problems and work smarter with Excel.

描述

掌握領先公司的業務分析師使用的技巧，將數據轉化為底線結果。十多年來，知名顧問和商學教授韋恩·溫斯頓一直在教授企業客戶和MBA學生如何在數據分析、建模和決策方面最有效地使用Microsoft Office Excel。現在，這位屢獲殊榮的教育家在這本實用的、以業務為重點的指南中分享了他在課堂上的最佳經驗，並對Excel 2007進行了更新和擴展。每一章都使用實際案例和學以致用的練習來提升您的數據分析和建模能力。您將學習如何為銷售創建最佳、最差和最可能的情景，估計產品的需求曲線，使用趨勢和季節性進行預測，並確定哪種產品組合將產生最大利潤。您甚至還將了解價格和廣告對銷售的影響如何解讀，以及如何為客戶忠誠度賦予一個金額價值。您可以在CD上獲得本書的所有問題和解決方案文件，以解決複雜問題並更加智能地使用Excel。