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.
I really enjoy working with functions in Excel. So I set up EatCake Inventory15, so that we can explore some of the most commonly used ones. In each of the subsequent movies in this chapter, please open up the Inventory15 spreadsheet if you'd like, or just continue to work within that spreadsheet. The first function we're going to look at is the AutoSum function, and what that does is it adds up all of the numbers in a particular range. Usually it's a column, sometimes it's a row. And in this case, what I'm I want to do is I want to find the final cost for all of the items in this inventory.
So if you scroll down through the spreadsheet, you'll see that I've added a total cost column of the very bottom of column G. Now, the thing to remember when you're working with functions is you want to select the cell where the information's going to end up. so you kind of work backwards. You start at the place you want to end up. I want my answer to be in G27, so I click on that cell to say, "Here's where I want to put my answer." Then I go pick my function.
So in this case, I go up to my Function Library, which is on my formulas tab, and I look for AutoSum. Clicking on the downward arrow gives me an array of commands to choose from, and I'm going to just click the first one, which is Sum. And as I mouse over it, it tells me what it's going to do. It tells me it's going to display the Sum of the selected cells directly after all of the cells that are selected. So let's see what happens when I click on this in my spreadsheet. I click on it, and it puts in the Sum formula. Now that Sum formula, I know it's a formula because I have an equal sign at the very beginning of it, and it's already been programmed with a name, the name Sum, and then it's telling me it's going to Sum over this array. Now what an array is a group of cells that are contiguous, and that's a big word. But what contiguous means is they're right beside each other.
So an array is a group of cells that are right beside each other. It can span a couple of rows, it can span a few columns, but basically it's one large group of cells. So what this function is going to do, is it's going to take any value that's found in G2 right through to G26, and it's going to put that answer in here, in Cell G27. All I need to do now is to click the Enter key, and the answer is presented in G27.
So with two quick clicks, I've added all of the information in 25 rows and come up with the total cost. Let's explore the next function that we're going to work in.
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.