Excel Mastery: Advanced Search, Analysis, and Forecasting Techniques

What Will You Learn?

• What-If modeling to solve business problems (and more)
• Selection of parameters for formulas (formulas work “from the opposite”: selection of values based on the result you need)
• Simulation of multiple scenarios (for example, realistic, pessimistic and optimistic scenarios for the project, budget, balance sheet, etc.)
• Using substitution tables: modeling calculation results for different values of 1 or 2 variables (for example, what will be the income for different % discount options and different volumes of purchased goods)
• Automatic search for the most optimal solution for business problems among hundreds and thousands of possible alternatives
• Optimization tasks by selecting the most optimal option from a variety (for example, delivery of materials from different warehouses/suppliers based on the distance from them to the production site)
• Drawing up forecast sheets with possible “corridors” of deviations; working with time series (days, months, quarters, years...)
• Data analysis for making management decisions using statistical methods (data-driven decisions) - can discovered patterns or differences in a group/sample of data be extended to the general population (all clients, employees, representatives of the profession, and other groups)
• Descriptive statistics (frequencies, means, medians, modes, percentiles, quartiles, measures of variability, etc.) etc.) and their visualization in the form of a histogram and a "box with a mustache"
• Finding hidden relationships between variables (correlations and covariances) - for example, is satisfaction with the range of products, price, service, etc. related? with a generalized assessment of customer satisfaction with a point of sale
• Regression analysis to predict the values of a specific variable based on the values of other variables (for example, how much customer loyalty will drop if the quality of service decreases by 5 points)
• Search for differences between groups/samples (group comparison) - for example, are there differences in the choice of goods of different colors between men and women, pensioners and youth, housewives and private entrepreneurs, etc.