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.
Something I really like in Microsoft Excel 2007 is the Page Layout tab. It presents all of the printing options on your ribbon and they're very easy to access. If you'd like to follow a long with the movie, open up EatCake Inventory list8A. What we're going to take a look at first is the orientation of the information on our screen. I mentioned that in a previous movie that you can change the way the information is presented on your page, so let's see what that does. When I click on the Orientation tab command.
I now have the ability to change it between Portrait and Landscape. It defaults to portrait, and if you watched the print preview movie, you'll notice that most of the information that we saw in there was shown in a Portrait orientation. I'm going to select Landscape and see how it's going to change the way my information is printed on my page. I'm going to go back up to my Print Preview icon and click, and you'll see now that my information is going sideways on my page. So I have more area to view. And if I had more columns to present, I'd get more information on a page.
It also allows me to print out more pages. So If I do a Landscape orientation, I'm going to get more pages printed out. But more data on the page. If I'm not too happy with this, I can change the orientation back to Portrait very easily by going to the Page Setup icon here on my Print Preview smart page, going over to the Page tab and selecting Portrait. I click OK, close by Print Preview, and then go back into it, you'll see that my information is now presented in a Portrait format.
So you can get to the orientation of a page either by going through the Page Setup icon here, or through the Orientation command on your ribbon. You can identify what size of paper you want to print off by just clicking the Size command here, and by selecting the appropriate size of your page. The print area identifies what information is going to be printed on your page. The default is to print everything on a worksheet. Let's go see what the default looks like by clicking on my Print Preview icon.
So here's my default, it's grabbing all of the information on my page. Let's say I just wanted to print two rows of information. I'm going to click on the Close Print Preview, and I'm going to go back to my table, and I'm going to select the information that I want to print. I'm going to say Print Area, and set the print area, and go back to my Print Preview icon to see what I've selected. Notice I've only got my two rows that I've selected printing on my page.
If that really wasn't what I wanted to do, I'm going to close my Print Preview button again, I'm going to go to my Print Area command and clear the print area. If I happen to sit on the cell A2, click Print Area, say Set Print Area, it's going to give me a warning to say that I've only selected a single cell for printing. So it's reminding you, and making sure that you really wanted to print what you selected.
If I say OK, go up to my Prick Preview icon. You'll notice that only that one cell is selected. So, if we go back to the main screen by clicking the Close Print preview area, you can see that you have a lot of control of the information that's printed on your page. Next we're going to learn how to put in page breaks and set print titles for our printing options.
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.