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.
Let's start with a quick reminder on how to put the print preview icon on the Quick Access toolbar. Go up to the Office button, go to down to the Excel Options button, go over to the Customize menu and make sure you get the Print Preview button on the right side of your screen, if it's not, search for it underneath the popular commands, select it, click the Add button, make sure that it appears and then click OK.
If you already had it up there, that was just a really quick reminder how to get information or icons onto your Quick Access toolbar. We're going to be using this Print Preview icon a lot, so we want to make sure it's handy for us. Let's explore some of the different things that we can do in Print Preview. So click on the Print Preview icon and we'll take a look at what we see. Right now I'm zoomed in on my spreadsheets. So I can read all the different lines that are presented to me. And this is good if I want to see what actually is going to be presented in one particular line.
If I'd like to see all the information that's going to be included on a page, I simply click the Zoom button again, and that removes the zooming and pushes it out. So I now get a whole page view of the information. SO now, I'm looking at what's on page 1 of my spreadsheet. I have two pages, how do I find out what I'm going to be printing on page 2? So I can just go up to the Print Preview tab and click Next Page, and that shows me what I've got on page 2 of my information.
And I can flip back and forth between the pages just by selecting either next page or the previous page. If I'd like to, I can show the margins on my screen. And if you are so inclined, you could adjust the information so that it fills up the whole page. I still have a lot of white space over here on the right hand side. And I could select and grab one of the handles and click and drag it, increasing the size of that particular column. This also affects the size of the column within your spreadsheet.
And you are working with all of the pages in your printed document as well. If I click Next Page, you'll notice that that size of the column is being retained. So I can play around with the size of columns if I want to decrease the amount of white space on my printed page. So let's remove the white space on our page by playing around with our margins just a little. So I'm going to click and drag, and you'll notice how the information is just pushed over, ever so slightly in the page. I'm starting from the left of my page moving across because I don't want to go too far and actually move the information right off the page. I'll show you what I mean by that in a moment.
See how I moved my margin identifier just a little bit too far, and I've lost my final cost. So I want to bring that back, just a bit. And the information is now presented for me. So when you are playing with your margins, just be very, very careful that you don't move your margins too much and lose your information. You can now also change the orientation of the page, but I find it's a lot easier to do that Working from the Page Layout tab, so let's go do that next.
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.