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.
If you're looking around for where you can insert headers and footers, you could find it here under the Insert tab and over here is Header & Footer. But don't click that because I think there's a better way to do this. Down here in the bottom, where you have those three view buttons. Right now we're in the Normal View. It's the first button. Click the second button, we're in Page Layout View, and look what we have at the top. It says Click to add header. Now before you click, just roll your mouse over and you see we have this center section and if you roll to the right, we have the right section and if you roll to the left we have the left section.
Anything you put in the left section will be left aligned, anything you put in the center section will be center aligned, and anything you put in the right section, well, that's going to be right aligned. So let's start with a left click in the left section and you see there it says header, and when you do you've the Header & Footer Tools section here with the Design tab. So click that Design tab. And the first thing we want to put in is what page we're on. So click right over here where it says Page Number. Well, maybe you wanted to be a little more specific rather than just Page 1 and Page 2. If you have a multiple page document, maybe you wanted to say something like Page 1 of 3, Page 2 of 3 and so on.
So just type a space, type of, type a space and click here Number of Pages. Now if you click outside the header area, there you can see it's showing us that's Page 1 of 2. Okay, let's put in the file name. So roll you mouse over here in the right section and click and you see that's right aligned, and up here we've File Path, File Name and the Sheet Name. Some people like to call it the tab name. Well, if you put in the File Name, it will just tell us right now that it's called headers and footers.xlsx. If you put in the File Path, it will tell us the whole path on the computer.
I don't think we really need to do that here. Let's just click File Name and press the Enter key and click Sheet Name and now when you click off here, this tells us headers and footers.xlsx and that it's Sheet1. Now Sheet1 isn't really much for the name, is it? So double-click over here where it says Sheet1 and let's call this First Quarter, press Enter, because after all this is the first quarter of expenses. Notice over here it immediately updates to say First Quarter. Let's put in a footer. You can just scroll down to the bottom and over here it says Click to add footer and again we have the left, center, and right sections.
So let's say we want to put the company logo in the lower-right corner. So click over here, go back to the Design tab, and let's put in a picture. So click Picture and in the Chapter 6 folder of the Exercise Files we have the Two Trees Olive Oil company logo, double-click it. Now you don't actually see the picture here until you click off it. Now this is kind of big, so we want to modify a little bit. Click back on here and make sure that this code &Picture is selected. By the way, you could type any of these codes in but I really don't advice it.
It's too easy to make an error. When you have it selected, go up here and choose Format Picture and we're in the Size tab and let's change the Height. Maybe instead of 100%, let's make that 40 and you don't have to type the percent. You can just type 40 and let's also make the Width 40%. Click OK and now the logo is smaller and unobtrusive. So let's put one more thing in the footer. Click in the lower-left corner here and you don't always have to put one of these items from the Header & Footer elements in the footer or header.
We'll click down here. Let's type in the web address of our fictitious olive oil company, www.twotreesoliveoil.com, and click off of it and now you have that there so that will be printed out. Let's take a look at our Print Preview. Go to the File menu and Print or you could press Ctrl+P, and here we've our page number, we have the file name, the tab, the logo, and the web address. So I think that's pretty cool!
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.