From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Use Watch Window and other techniques to track changing cells

Use Watch Window and other techniques to track changing cells - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use Watch Window and other techniques to track changing cells

- [Instructor] In this workbook, 2 there are a number of different worksheets. 3 Some of them are interrelated, some are not. 4 The very first sheet, Budget2017, 5 has lots of numbers about a budget projection here, 6 and it's a bit overwhelming. 7 And I'm still experimenting with some of the numbers, 8 getting different information 9 from this department, that department, 10 and I want to keep an eye on that total 11 in the lower right hand corner, 12 that's our net profit for the year projected 450,288. 13 Now, as I work with the numbers, 14 and perhaps I'm making a presentation too, 15 I want to be able to zoom in, 16 talk about first quarter, second quarter, et cetera. 17 But as I make changes, 18 because there are many, many formulas in this worksheet, 19 and, by the way, if you don't know where formulas are, 20 you can easily by way of the Home tab 21 go to the far right button, Find & Select, choose Formulas. 22 And…

Contents