{"title":"Microsoft Business","description":"","products":[{"product_id":"microsoft-excel-data-analysis-and-business-modeling-office-2021-and-microsoft-365-business-skills","title":"Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)","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\u003cp\u003eSolve real problems with Microsoft Excel―and build your competitive advantage\u003c\/p\u003e\u003cp\u003e * Quickly transition from Excel basics to sophisticated analytics\u003cbr\u003e * Use recent Power Query enhancements to connect, combine, and transform data sources more effectively\u003cbr\u003e * Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA\u003cbr\u003e * Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music\u003cbr\u003e * Build more sophisticated and compelling charts\u003cbr\u003e * Use the new XLOOKUP function to revolutionize your lookup formulas\u003cbr\u003e * Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries\u003cbr\u003e * Illuminate insights from geographic and temporal data with 3D Maps\u003cbr\u003e * Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios\u003cbr\u003e * Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics\u003cbr\u003e * Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook\u003c\/p\u003e","brand":"Pearson Higher Education","offers":[{"title":"Default Title","offer_id":43865896747184,"sku":"9780137613663","price":1170.0,"currency_code":"ZAR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0632\/9181\/8160\/files\/9780137613663.jpg?v=1724396795"}],"url":"https:\/\/www.mzansibooks.co.za\/collections\/microsoft.oembed","provider":"Mzansi Books","version":"1.0","type":"link"}