Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Included in the Windows group in the View tab are even more commands that help you manage the information that you see in your screen. The one we're going to take a look at now is your Freeze Panes options. We've already viewed how this works in a larger spreadsheet, but let's take a look at how it works when we're in a paned environment. I'm going to select the very first pane here and I'm going to click on cell B2, the Chocolate, because that's where I want to freeze my information. As I select that cell, I go back up to Freeze Panes and I have three choices; I could freeze the pane that would freeze the top row and the first column, I could just freeze the top row, or I could freeze just the first column. I'm going to freeze both, the first column and the first row by selecting the very first choice here.
And you'll see that I have frozen it because there's a line now up underneath the first row as well as in the first column. And as I use my scrollbars, the information in that first row and first columns stay pinned. So there we go, that's how that works. It works exactly the same way as we've experience when we were working in the larger spreadsheet. But now, if I go into my second pane here into pane number two, and I move my scrollbar around, notice that this freezing is independent. It wasn't brought across. So I can freeze different areas of different panes so that I can explore different sections of the spreadsheets, all at the same time. To remove the freezing, I go back into the pane where I had nailed it, come back up to the Freeze Panes area and select the Unfreeze Panes command.
And that removes the freezing. Another nice option that you can work with in Window's and I find this a really cool feature, is the ability to look at two panes side- by-side, and compare the information. SO I'm going to select View Side by Side and that's the first command in the very middle of the window group. So I click on that, and it asks me which other pane would I like to compare the one that I'm sitting in with. So you know that you're in Store A:1 because you've got the cell indicator in that pane. And you're to compare that with one of your other options. You can look at any one of the four different screenshots that we see here, sub panes or you could go to StoreB.
So let's go to--oh, let's let--let's take a look at our whole other spreadsheet StoreB, and click OK. When we do that, I've got StoreA view number 1 above, and I've got Store B, that particular spreadsheet shown below. The really cool piece of this is that this feature here. This is called Synchronous Scrolling, and what this does is when you scroll in one pane in the top one because you got your scrollbars, the bottom scrolls at the same spot. So I'm looking at row 13 here and I'm grown looking at row 13 in StoreB.
This is really sweet, because this really allows you to match apples with apples. It's wonderful. You'll notice that there's a difference in my StoreA information because I have three extra rows. That is not included down here in my StoreB information. So I can see, oh OK, I've kept--Store A's increasing the types of inventory that it's tracking, StoreB hasn't quite gotten there yet. So I easily enable to analyze my data, just by using these particular commands up in my and Windows command.
To get back to where I was previously, I just click on the view of side by side command to deselect that functionality. Finally, we're going to take a look at saving the workspace. I've worked a lot in this particular view and now I've been called to a meeting, but I want to pick up where I left off when I get back. It would take quite a while for me to write down where I was, what cell I was looking at, what views I was working, and how many panes I had opened up. That would take far too long, and just leaving my machine open is hazardous, especially if I have to go away overnight.
How can I save where I'm at? You use the Save Workspace command here. Clicking on that allows you to save the information in a resume file. Notice I've already resumed it once before, so I'm going to resume it again and I'm going to call this resume2, and click save. If I close the screen, and I go back up to the Open button and click Open, and I select resume2, and say Open, look what comes up.
Now it's already telling me that there's a document with the StoreB already open, so it's not going to open a second version of that document, and that's fine with me. But the real beauty is the fact that the workspace that I had open, not only the panes, but the other StoreB spreadsheet is also open. So I can come back to exactly the same spot when I'm ready to resume my analysis. Isn't that a cool feature? One last thing before we leave this lesson, for those of you brand new to Excel, is the ability to switch windows completely. If I click on that command, it allows me to pull up any individual pane or the other window that houses StoreB's worksheet. So I could flip right back to StoreB and that brings that information for me to the top of my worksheet lists.
This is very similar to the Windows menu that was in previous versions of Excel. So just by clicking on the Switch Windows command, you can bring the window that you are interested in up to the top of the panes that you're working at. I'm just going to close these out now, and you can do the same, by clicking on the little X at the top of the button, in preparation for our next movie.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.