{"product_id":"microsoft-excel-data-analysis-and-business-modeling-9781509304219","title":"Microsoft Excel Data Analysis and Business Modeling","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eMaster 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.\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eSolve real business problems with Excel—and build your competitive advantage\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e\n\u003cli\u003eQuickly transition from Excel basics to sophisticated analytics\u003c\/li\u003e\n\u003cli\u003eSummarize data by using PivotTables and Descriptive Statistics\u003c\/li\u003e\n\u003cli\u003eUse Excel trend curves, multiple regression, and exponential smoothing\u003c\/li\u003e\n\u003cli\u003eMaster advanced functions such as OFFSET and INDIRECT\u003c\/li\u003e\n\u003cli\u003eDelve into key financial, statistical, and time functions\u003c\/li\u003e\n\u003cli\u003eLeverage the new charts in Excel 2016 (including box and whisker and waterfall charts)\u003c\/li\u003e\n\u003cli\u003eMake charts more effective by using Power View\u003c\/li\u003e\n\u003cli\u003eTame complex optimizations by using Excel Solver\u003c\/li\u003e\n\u003cli\u003eRun Monte Carlo simulations on stock prices and bidding models\u003c\/li\u003e\n\u003cli\u003eWork with the AGGREGATE function and table slicers\u003c\/li\u003e\n\u003cli\u003eCreate PivotTables from data in different worksheets or workbooks\u003c\/li\u003e\n\u003cli\u003eLearn about basic probability and Bayes’ Theorem\u003c\/li\u003e\n\u003cli\u003eAutomate repetitive tasks by using macros\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e \u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003e    Chapter 1 Basic spreadsheet modeling                                      \u003c\/li\u003e\n\u003cli\u003e    Chapter 2 Range names                                                          \u003c\/li\u003e\n\u003cli\u003e    Chapter 3 Lookup functions                                                     \u003c\/li\u003e\n\u003cli\u003eChapter 4 The INDEX function \u003c\/li\u003e\n\u003cli\u003e    Chapter 5 The MATCH function                                               \u003c\/li\u003e\n\u003cli\u003e    Chapter 6 Text functions                                                        \u003c\/li\u003e\n\u003cli\u003eChapter 7 Dates and date functions \u003c\/li\u003e\n\u003cli\u003e    Chapter 8 Evaluating investment by using net present value criteria         \u003c\/li\u003e\n\u003cli\u003e    Chapter 9 Internal rate of return                                             \u003c\/li\u003e\n\u003cli\u003e    Chapter 10 More Excel financial functions                                 \u003c\/li\u003e\n\u003cli\u003e    Chapter 11 Circular references                                               \u003c\/li\u003e\n\u003cli\u003e    Chapter 12 IF statements                                                       \u003c\/li\u003e\n\u003cli\u003e    Chapter 13 Time and time functions                                        \u003c\/li\u003e\n\u003cli\u003e    Chapter 14 The Paste Special command                     \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press,U.S.","offers":[{"title":"Default Title","offer_id":52195307848023,"sku":"9781509304219","price":29.59,"currency_code":"GBP","in_stock":false}],"url":"https:\/\/bookcurl.com\/products\/microsoft-excel-data-analysis-and-business-modeling-9781509304219","provider":"Book Curl","version":"1.0","type":"link"}