Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Once you set up your worksheet so that you have the right page size, your headers and footers and all the other pre-printing activities, let's go and see what happens when we actually print. Well, you can go up to the File tab for Backstage view. Go down here to Print or you could press Ctrl+P, either way, and here we have our Print Preview and we have it centered on the page horizontally and vertically. We have our headers here and footers here, looks pretty nice. So let's take a look at some of their print settings. First of all, if you just want to print and all of the settings that are already in there are okay, all you have to do is click the Print button and how many copies do you want.
You can choose your printer from right over here and you click this and all of the printers that are configured in your computer are here. I'm just going to click off it and keep the current printer. If you want to get to printer specific properties, you could click this link. What's really nice about the screen is that you don't have to go spelunking through multiple levels of printer dialog boxes, like many applications or even older versions of Excel. Everything you need is right here. So which sheets do you want to print? You can click this. You can print the Active Sheet, that is whatever sheet you have currently selected, or the whole workbook or maybe if you have just a few cells selected in a worksheet, you can print just those cells.
Click off here and if you want a specific page range, maybe you have a very large worksheet of several dozen pages and you wanted to print maybe only page 5 to 10, you could do that here. And when you do that, if you're printing out here multiple copies, here you could choose whether they're collated or not. Now here's a really great feature. You might wonder well, what's the big deal. Landscape or portrait oriented? Well, many programs in older versions of Excel it would be very easy to set up let's say landscape orientation in the document, you go over to the Print dialog box and you choose portrait oriented, and then have the pages cut off or vice-versa.
Well in Excel 2010, the orientation in the Print dialog box and in the Page Layout are synchronized. So let's say we go over here and we make it portrait oriented. See it changes here? Now click the Page Layout tab and click Orientation and look at that. It's now Portrait and vice-versa. If we change this from Portrait back to Landscape, I'll just press Ctrl+P to go back in. You see it's back to Landscape, so I think that's really a great feature. Same for page size. You can choose different page sizes if you want. I'm going to keep it at Letter.
And if you want to change what your margins are or if you want to change custom margins you can click that over here. Now Scaling means let's say your worksheet is just a little too big for one page and you want to shrink it to 100% so it fits on the page, or maybe it's really tiny and you want it bigger to take up the page. Well that's what you could do here for scaling and you have the options here. Keep in mind if you scale the page, making it bigger or smaller, you are not changing the fonts. You're not changing the column widths or the row height. It's simply the image that comes out of the printer that you're changing.
Kind of like if you use a rescaling feature on a photocopier. I'm going to leave this here as No Scaling. Now if you like kind of an old-fashioned Page Setup dialog box the way Excel did it in previous versions, you have this Page Setup link and you can click that and that's going to bring you to Page Setup. I am just going to click Cancel. We don't really need that. Well, let's say we want to go and create an Adobe PDF so this will be readable in Adobe Reader. Now that's the default printer on this machine, so all you have to do is click Print, but that means Adobe Acrobat is installed.
What if your computer doesn't have Adobe Acrobat installed? You can still create a PDF. You don't need Adobe Acrobat. Click over here, Save & Send. We can choose to Create PDF or XPS document. XPS is kind of the Microsoft way of creating a format kind of like PDF, but don't worry about that too much. So just choose that and then click this button here and by default it will offer to create a PDF and I'm just going to leave this here in the Chapter 6 folder. Now if you want some options specific for how to create the PDF, you can click Options and you have all your options up here.
I'm just going to leave the defaults and click Cancel. And over here where it says Open file after publishing, you probably want to leave that selected just so you can view it in Adobe Reader to make sure you got what you are hoping to get, and then click Publish. And here we have this open in Adobe Acrobat or Adobe Reader depending upon what you have in your computer and this is exactly what we saw in Print Preview. I think this is a really great feature. Go and check it out.
There are currently no FAQs about Excel 2010 Essential Training.
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.