From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

View a worksheet through two windows

View a worksheet through two windows - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

View a worksheet through two windows

- [Instructor] We're planning an event, and somebody set up this great Excel workbook so that we can look at costs and look at people we're considering inviting. Right now, we are at $2,859, and our maximum budget is $3,000, but here's the issue. Let's go over to Friends and we say, okay, Kaitlin, Earl, all right, we got to get Louis and Maura, and then go to Details. And let's see, let's look at dinner three. Now we go back over here. We are over the budget, and it's hard to flip back and forth between all these pages and variables to see where we are in relation to our budget. So your help is needed here so that we can work easier. Open another window of this same workbook, arrange the windows on your monitor so that you can see both, and then adjust the invitations and options, and watch the changes in the summary. Pause the video, get those windows open, come back, and I'll show you how I do it. All right, here we…

Contents