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.
For the final movie in this chapter, please open up EatCake Inventory 15A, if your spreadsheet doesn't look quite like the one that you see on the screen. This function that I'm going to share with you right now, I've used numerous times in the past. And it's really good for creating things like acronyms, or if you have a large spreadsheet that you need to create usernames and passwords for, this is a real time saver, and it's called LEFT. I'm going to use it to create an acronym for the item types that I have.
So I'm going to again, start and select the cell were I want that information to appear. Actually, I think I'm going to move it over just ever so slightly, so it doesn't become part of that table by accident. I'm going to put it in cell I2. I then go up to pick out my function, and the function is LEFT as I mentioned. And what this function does, is it returns the specified number of characters from the start of a text stream. So I identify what texturing I'm interested in working with, so I collapse this dialog box, go over to my worksheet and select B2, because that's the item type.
I come back to my dialog box and open it up, and then I identify the number of characters I want to work with. So I want two characters in my acronym. So, as a preview of what I'm building, I see that I've selected the word Pastry, I've picked the first two characters, so that's going to give me the result Pa. Perfect. That's exactly what I want. I click OK. So I'm starting to build the acronym that I'm going to use within the spreadsheet.
Again, to copy this function down through my column, I click on the grab handle, I pull it all the way down through to the very final row I'm looking at, and I let go. And it's done the same thing all the way through. It's gone through each individual row in the column, and pick the first two letters of every single word that it finds there. In cases where there's no information, it just skips right over. Again, I would like to place in column J, not the function that I'm working with, but the actual values, the P and a.
So I right-click, select Copy, select the cell where I want the information to start to be pasted, right-click, select Paste Special, choose Values, Click OK, and in comes my values. In the next chapter we're going to look at a few more advanced functions from the Function Library. Stay tuned!
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.