{"product_id":"9781509304219","title":"Microsoft Excel Data Analysis and Business Modeling","description":"\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\u003c\/p\u003e\u003cp\u003e\u003cb\u003eSolve real business problems with Excel—and build your competitive advantage\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eQuickly transition from Excel basics to sophisticated analytics\u003c\/li\u003e \u003cli\u003eSummarize data by using PivotTables and Descriptive Statistics\u003c\/li\u003e \u003cli\u003eUse Excel trend curves, multiple regression, and exponential smoothing\u003c\/li\u003e \u003cli\u003eMaster advanced functions such as OFFSET and INDIRECT\u003c\/li\u003e \u003cli\u003eDelve into key financial, statistical, and time functions\u003c\/li\u003e \u003cli\u003eLeverage the new charts in Excel 2016 (including box and whisker and waterfall charts)\u003c\/li\u003e \u003cli\u003eMake charts more effective by using Power View\u003c\/li\u003e \u003cli\u003eTame complex optimizations by using Excel Solver\u003c\/li\u003e \u003cli\u003eRun Monte Carlo simulations on stock prices and bidding models\u003c\/li\u003e \u003cli\u003eWork with the AGGREGATE function and table slicers\u003c\/li\u003e \u003cli\u003eCreate PivotTables from data in different worksheets or workbooks\u003c\/li\u003e \u003cli\u003eLearn about basic probability and Bayes’ Theorem\u003c\/li\u003e \u003cli\u003eAutomate repetitive tasks by using macros\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e","brand":"Microsoft Press","offers":[{"title":"Default Title","offer_id":47039175327984,"sku":"9781509304219","price":49.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781509304219_p0.jpg?v=1763722683","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781509304219","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}