Microsoft Excel Data Analysis and Business Modeling

Microsoft Excel Data Analysis and Business Modeling

<b> <i> <p>This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.</p> </i></b><p><b><i> </i> </b> </p> <p>Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.</p> <p> <br /> </p> <p> <b>Solve real business problems with Excel–and build your competitive advantage</b> </p> <ul> <li>Quickly transition from Excel basics to sophisticated analytics</li> <li>Summarize data by using PivotTables and Descriptive Statistics</li> <li>Use Excel trend curves, multiple regression, and exponential smoothing</li> <li>Master advanced functions such as OFFSET and INDIRECT</li> <li>Delve into key financial, statistical, and time functions</li> <li>Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)</li> <li>Make charts more effective by using Power View</li> <li>Tame complex optimizations by using Excel Solver</li> <li>Run Monte Carlo simulations on stock prices and bidding models</li> <li>Work with the AGGREGATE function and table slicers</li> <li>Create PivotTables from data in different worksheets or workbooks</li> <li>Learn about basic probability and Bayes’ Theorem</li> <li>Automate repetitive tasks by using macros</li> </ul>