{"product_id":"microsoft-excel-data-analysis-and-business-modeling-office-2021-and-microsoft-365-paperback","title":"Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) - Paperback","description":"\u003cp\u003eMaster business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. \u003c\/p\u003e  \u003cb\u003eSolve real problems with Microsoft Excel--and build your competitive advantage \u003c\/b\u003e  \u003cul\u003e \u003cli\u003eQuickly transition from Excel basics to sophisticated analytics\u003c\/li\u003e \u003cli\u003eUse recent Power Query enhancements to connect, combine, and transform data sources more effectively\u003c\/li\u003e \u003cli\u003eUse the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA\u003c\/li\u003e \u003cli\u003eUse New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music\u003c\/li\u003e \u003cli\u003eBuild more sophisticated and compelling charts\u003c\/li\u003e \u003cli\u003eUse the new XLOOKUP function to revolutionize your lookup formulas\u003c\/li\u003e \u003cli\u003eMaster new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries\u003c\/li\u003e \u003cli\u003eIlluminate insights from geographic and temporal data with 3D Maps\u003c\/li\u003e \u003cli\u003eImprove decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios\u003c\/li\u003e \u003cli\u003eUse Excel trend curves, multiple regression, and exponential smoothing for predictive analytics\u003c\/li\u003e \u003cli\u003eUse Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":51319052927199,"sku":"9780137613663","price":59.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0813\/8958\/4607\/files\/H9ezxM9KtS9780137613663.webp?v=1788366126","url":"https:\/\/blackandbarhe.com\/products\/microsoft-excel-data-analysis-and-business-modeling-office-2021-and-microsoft-365-paperback","provider":"Black \u0026 Barhe Bookstore","version":"1.0","type":"link"}