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.
The more you feel comfortable working in Excel, the more workbooks you're going to create. And it's very often that you're going to be wanting to see more than one workbook in your application at a time. In this movie, we're going to take a look at how we can move between the different workbooks as we're working in Excel. If you want to follow along, open up Store A and Store B workbooks in your exercise files. Make sure you've clicked on the View tab, and go over to the Workbook views. That's the first group of commands we're going to take a look at. This Workbook Views area will allow me to move between different views within the workbook that I'm looking at.
SO I'm looking now at store A's information, and I'm looking at the Normal view. This is the one that we're most familiar with looking at, in the previous movies. We've already taken a look at the Page Layout view when we were learning about printing and we can easily click on it here, to bring the page layout up. You're very familiar with this if you've taken a look at our printing movie. In that particular movie, I was looking at the little icon that's always available down at the bottom of the screen, so either by clicking on the one at the bottom of the screen, or the one up at the top in the View tab, I can move to the Page Layout view. And the Page Layout view is great if I want to see how the information is going to be printed off on the page, and work with it in that environment. For those of you that are very visual, this is the best view to be working in.
You can also take a look at the Page Break view, so I'm going to click on that, and this will tell me where I'm going to be breaking my pages with a big, blue line. You'll also see that you get a little message box the first time you open this up, that it tells you how you can work with this. So it's telling you that the page breaks can be moved around by clicking and dragging them with your mouse. You don't need to see that every time, so you can select the little don't show me this dialog box again, on any dialog box you don't want to see, and then click the OK button. So if I wanted to move my page break from the end of column E to the end of column D, I can just move my mouse until I get the crosshair, click, and then drag it in.
There we go, and now I've moved it over to this particular area and my page break is now going to be at the end of column D. If I want to go back, I simply hit my Undo button. That's a whole lot easier than trying to click and drag it back. The final view we're going to take a look at is the Full Screen view. I'm going to click on that and this brings up the whole screen so that I can see many, more rows and columns within my screen. To go back or to restore it back to normal, I click up on the top corner and I select the Restore button.
And I'm brought back to my overall screen. To expand this to my original view, I'm just going to hit my Maximize button here, and we're back to where we were. I'm going to go back to my Normal view by clicking on my normal button, and we're back to where we began.
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.