{"product_id":"9781509304226","title":"Microsoft Excel Data Analysis and Business Modeling","description":"\u003cb\u003e \u003ci\u003e  \u003c\/i\u003e\u003c\/b\u003e\u003cp\u003eThis 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.\u003c\/p\u003e  \u003cp\u003e   \u003c\/p\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  \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","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47108639523056,"sku":"9781509304226","price":37.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781509304226_p0.jpg?v=1763721440","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781509304226","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}