EXCEL 2021 AND MICROSOFT 365. ANALYSIS AND MODELING OF BUSINESS DATA

Discover the power of business data analysis with the latest edition of Wayne Winston's book! Acquire practical skills in data modeling and analysis that will allow you to transform raw information into valuable insights. Learn to ask the right questions and get precise answers, leveraging the full potential of Microsoft Excel and Microsoft 365.

• Master business modeling techniques using Microsoft Excel.
• Transform data into actionable insights.
• Leverage new Power Query enhancements to retrieve and transform data.
• Build your own functions without using VBA with the LAMBDA function.
• Import data about stock prices, weather, geography, movies, and music.
• Create sophisticated charts and data visualizations.
• Improve decision-making through Bayesian analysis and Monte Carlo simulations.

Wayne Winston, a respected expert and winner of numerous academic awards, shares his rich experience, presenting practical applications of Excel in solving real business problems. This edition has been expanded more than any previous one, covering topics from one-click analysis to HISTORY.STOCK, from dynamic arrays to Power Query. You will find six new chapters here to help you master data analysis.

This book is not just a collection of theories, but above all a practical guide that will allow you to solve real business problems in Excel and gain a competitive advantage. You will quickly move from basic to advanced analysis, using the new Power Query enhancements to retrieve and transform data from many different sources. You will learn to use the LAMBDA function to build your own functions without using VBA, and to use new data types to import stock prices, weather data, geographic information, movie data and music.

With this book, you will learn to build sophisticated charts, use the new XLOOKUP function to revolutionize search formulas, and use new formulas based on dynamic arrays that allow you to sort and filter data and find unique values. You will improve decision-making through probability, Bayesian analysis and Monte Carlo simulations, and use trend lines, multiple regression and exponential smoothing in predictive analysis. You will use the data model and Power Pivot to effectively build and use relational data sources.

APN Promise is a renowned publishing house that has been providing high-quality publications in the fields of business and technology for years. Their books are valued by both professionals and students for their practical approach and topicality. By choosing this book, you are investing in proven knowledge and skills that will help you succeed in the business world.