IBM 3202 Market Analysis and Control

Learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Discover capabilities in the newest versions of Excel, including dark mode and accessibility features. Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis

Learn to create spreadsheets and workbooks and navigate the user interface. If you're ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations. Guidance on how to import, manage, and analyze large amounts of data Advice on how to craft predictions and "What-If Analyses" based on data you already have.

Master business modeling and analysis techniques with over 900 problems, many based on real-life challenges. Use Power Query to connect, combine, and transform data sources. Use LAMBDA and helper functions to create Custom Functions. Use New Data Types to import data including stock prices, weather, and information on geographic areas. 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 trend curves, multiple regression, and exponential smoothing for predictive analytics. Use Data Model and Power Pivot to effectively build and use relational data sources.