{"product_id":"9780137613663-microsoft-excel-365-data-analysis-busi","title":"Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)","description":"\u003cmeta content=\"text\/html; charset=utf-8\" http-equiv=\"Content-Type\"\u003e\u003cp\u003e\u003cspan\u003e\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 \u003cp\u003e        \u003c\/p\u003e \u003cp\u003e\u003cb\u003eSolve real problems with Microsoft Excel—and build your competitive advantage   \u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cul\u003e\n\u003cli\u003eQuickly transition from Excel basics to sophisticated analytics\u003c\/li\u003e\n\u003cli\u003eUse recent Power Query enhancements to connect, combine, and transform data sources more effectively\u003c\/li\u003e\n\u003cli\u003eUse the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA\u003c\/li\u003e\n\u003cli\u003eUse New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music\u003c\/li\u003e\n\u003cli\u003eBuild more sophisticated and compelling charts\u003c\/li\u003e\n\u003cli\u003eUse the new XLOOKUP function to revolutionize your lookup formulas\u003c\/li\u003e\n\u003cli\u003eMaster new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries\u003c\/li\u003e\n\u003cli\u003eIlluminate insights from geographic and temporal data with 3D Maps\u003c\/li\u003e\n\u003cli\u003eImprove decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios\u003c\/li\u003e\n\u003cli\u003eUse Excel trend curves, multiple regression, and exponential smoothing for predictive analytics\u003c\/li\u003e\n\u003cli\u003eUse Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook\u003c\/li\u003e\n\u003c\/ul\u003e  \u003cp\u003e\u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e \u003cp\u003e  \u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\u003c\/span\u003e\u003c\/p\u003e","brand":"Rarewaves","offers":[{"title":"Default Title","offer_id":40759605002337,"sku":"9780137613663","price":45.57,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0092\/7504\/8033\/files\/stand_31098272.jpg?v=1730449868","url":"https:\/\/www.rarewaves.com\/products\/9780137613663-microsoft-excel-365-data-analysis-busi","provider":"Rarewaves.com","version":"1.0","type":"link"}