Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365): Edition 7

Solve real problems with Microsoft Excel—and build your competitive advantage

• Quickly transition from Excel basics to sophisticated analytics
• Use recent Power Query enhancements to connect, combine, and transform data sources more effectively
• Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA
• Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music
• Build more sophisticated and compelling charts
• Use the new XLOOKUP function to revolutionize your lookup formulas
• Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries
• Illuminate insights from geographic and temporal data with 3D Maps
• Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios
• Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics
• Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook