| Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in "Master the business modeling and analytic techniques with Microsoft Excel 2013, and help transform your data into bottom-line results. With this hands-on, scenario-focused guide from Excel expert and bestselling author Wayne Winston, you'll learn how to use the new Data Model and Relationships features for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook.Gain the skills to solve real-world business problems with Excel 2013Model investment risks and returns Analyze your sales team's effectiveness Create best, worst, and most-likely case scenarios Compare lease vs. buy, and calculate loan terms See how price, advertising, and seasonality affect sales Manage inventory with precision Quantify the value of customer loyalty Calculate your break-even number and ROI Maximize scheduling efficiency |