From the course: Learning Excel What-If Analysis
Join today to access over 24,700 courses taught by industry experts.
Manipulate your model - Microsoft Excel Tutorial
From the course: Learning Excel What-If Analysis
Manipulate your model
- [Instructor] After you add summary formulas and it controls to a model, you can manipulate these assumptions to see how different settings affect its results. In this movie, I will work with the purchase model that we've created earlier in this chapter to show you how that might work in an actual situation. My sample file is 03_04_Manipulate, and you can find it in the chapter three folder of the exercise files collection. This is a copy of the workbook that we had at the end of the previous movie, but you might notice that my headers for servers included, desktops included, and so on, appear to be missing from column G along with the true or false values in column H. In fact, they are there. I just changed their text to white so they don't show up against the background. So if I click cell G4, you'll see that it actually does say Servers included. And in H4 it says True. I did the same thing for the scroll bar value and…
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.
