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