From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Track variables using the Scenario Manager

Track variables using the Scenario Manager - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Track variables using the Scenario Manager

“

- [Instructor] Here's a worksheet 2 with tons of formulas in it. 3 But more important than that 4 is the idea that this is a budget worksheet, 5 and it's taken a lot of time to come up with it. 6 And what we'd like to be able to do 7 is have an alternate version of it, 8 and perhaps two or three alternate versions, 9 maybe even more. 10 And rather than creating separate worksheets 11 with those alternate versions, 12 let's embed them within this worksheet 13 using a feature called a Scenario Manager. 14 Now what I first want to do is expose all the formulas. 15 You can do this with a keystroke shortcut. 16 It's Control + Tilde. 17 Tilde is that key between escape and tab on most keyboards, 18 usually to the left of number 1. 19 It's the same as a feature on the Formulas tab 20 up in the ribbon, right here, called Show Formulas. 21 This doubles the width of columns too, 22 as it exposes all formulas. 23 If you…

Contents