From the course: Business Analytics: Forecasting with Exponential Smoothing
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solver
From the course: Business Analytics: Forecasting with Exponential Smoothing
Solver
- [Instructor] Usually when you're using a financial, or otherwise numeric analysis package, such as Excel, you want to know the result of a series of inputs. For example, your company might have four operating divisions, each of which returns a profit. To get the gross profit of all four divisions you can set up something very simple, such as the values in column C here. You supply the numbers and arrange C2 to C5 and the formula in C7 gives you their total. You supply the inputs and Excel supplies the result. It frequently happens though that you know the result that your after, and you want to know what inputs are needed to bring about that result. A very simple example of this situation appears in column H. At present three operating divisions are returning a total of nine shown in cell H7. Click the ribbons data tab, and then click what if analysis in the forecast group. Choose goal seek from the menu. Because you started by selecting cell H7, that's taken to be the set cell in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.