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.
Another commonly used function is the Minimum function. And what that will do is it will go through an array of numbers, and it will pick out the smallest value that it finds. If you scroll down to the bottom of your Inventory15 spreadsheet, you'll see that I've added a row for minimum cost. Again, we'll review how you work with functions. You select the cell where the function answer is going to be presented, you go up to your Function Library to find the function you want to work with, so you click on it, and you pick the function that you're looking. Now I knew that the Minimum function was underneath the AutoSum, so I select that, and it identifies for me, what array of cells is going to look through to find the minimum value. Now, in this case, what it's doing is it's defaulting directly above it, until it finds the next empty row, or the first empty cell. And so it's going to stop just two rows ahead of me. Now, I don't want the minimum between this particular value and an empty value. That's not what I'm looking for, so I want to change the range that I'm looking at here.
Now how do I do that? Well, there's two ways you can do it. You can go to into this area here and actually type in the number 2, down to the number 25, and you'll notice that as you do that, over on my screen in the worksheet, that the blue grab boxes have moved. It used to be that the grab boxes were indicating this area as my selection ray, but now that I've typed in my new ray, this is where I'm going to be sitting. So that's one way that I can do it. I'm just going to cancel this out to show you another way.
If I go back up to my AutoSum group, select Minimum, it defaults to the first two rows here, and you'll see that this is indicating that this is the area I'm going to grab. Well I prefer just to click and drag, because I like working with my mouse. So I'm going to pull this once I grab the handle, pull the array right up to the very top of the screen, and anchor it right at the very beginning of my list. I'm then going to grab a handle, so the little handles are the little squares around the selection area, and I'm going to click and I'm going to drag that down until I select the area over which I'd like that function to be applied.
So for those of you that like using the mouse, and have no problem manipulating it, that's a very easy way to see visually, the area that you're going have that function go through. If you are very confident with working with cell addresses, you also have the ability to type the actual range in here, in the formula bar. Either way, you want to indicate what range of values you want that function to be calculated over. Once you're happy you selected the correct range, you enter the value, and then you come down to your cell and you see that the minimum cost, as calculated by the application is $3.00.
Because we don't have very many to look through, let's just confirm that it's correct. So we can just easily scroll through each individual value in our spreadsheet. Oh, I do see $3 .00, and see just to confirm that there is no other smaller value. And there wasn't. So now you can see that using the functions contained in the Function Library, are easy ways for you to help to analyze your data very, very quickly.
Our next movie is going to show us yet one more easy function to use.
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.