Microsoft Excel 2013 Data Analysis and Business Modeling

Microsoft Excel 2013 Data Analysis and Business Modeling

<p>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. <p> <b>Solve real business problems with Excel€"and sharpen your edge</b> <ul> <li>Summarize data with PivotTables and Descriptive Statistics <li>Explore new trends in predictive and prescriptive analytics <li>Use Excel Trend Curves, multiple regression, and exponential smoothing <li>Master advanced Excel functions such as OFFSET and INDIRECT <li>Delve into key financial, statistical, and time functions <li>Make your charts more effective with the Power View tool <li>Tame complex optimization problems with Excel Solver <li>Run Monte Carlo simulations on stock prices and bidding models <li>Apply important modeling tools such as the Inquire add-in </ul>