{"product_id":"microsoft-excel-2019-data-analysis-and-business-modeling-9781509305889","title":"Microsoft Excel 2019 Data Analysis and Business Modeling","description":"Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query\/Get \u0026amp; Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.  Solve real business problems with Excel--and build your competitive advantage:   \u003cul\u003e \u003cli\u003eQuickly transition from Excel basics to sophisticated analytics \u003c\/li\u003e \u003cli\u003eUse PowerQuery or Get \u0026amp; Transform to connect, combine, and refine data sources \u003c\/li\u003e \u003cli\u003eLeverage Office 365's new Geography and Stock data types and six new functions \u003c\/li\u003e \u003cli\u003e Illuminate insights from geographic and temporal data with 3D Maps \u003c\/li\u003e \u003cli\u003eSummarize data with pivot tables, descriptive statistics, histograms, and Pareto charts \u003c\/li\u003e \u003cli\u003eUse Excel trend curves, multiple regression, and exponential smoothing \u003c\/li\u003e \u003cli\u003eDelve into key financial, statistical, and time functions \u003c\/li\u003e \u003cli\u003eMaster all of Excel's great charts \u003c\/li\u003e \u003cli\u003eQuickly create forecasts from historical time-based data \u003c\/li\u003e \u003cli\u003eUse Solver to optimize product mix, logistics, work schedules, and investments--and even rate sports teams \u003c\/li\u003e \u003cli\u003eRun Monte Carlo simulations on stock prices and bidding models \u003c\/li\u003e \u003cli\u003eLearn about basic probability and Bayes' Theorem \u003c\/li\u003e \u003cli\u003eUse the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook \u003c\/li\u003e \u003cli\u003eAutomate repetitive analytics tasks by using macros\u003c\/li\u003e \u003c\/ul\u003e       \u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Microsoft Press\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 04\/15\/2019\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781509305889\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 880\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 3.15lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.10h x 7.30w x 1.70d","brand":"Wayne Winston","offers":[{"title":"Default Title","offer_id":36655581429916,"sku":"9781509305889","price":42.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_45b39363-93bb-4fc8-9a80-6da377c5ff59.jpg?v=1603886029","url":"https:\/\/pastforward.org\/products\/microsoft-excel-2019-data-analysis-and-business-modeling-9781509305889","provider":"Past Forward","version":"1.0","type":"link"}