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.
This next thing I'm going to show you gets "ooh's" and "aah's" any time I've demonstrated it before. And it's called the concatenation feature in the Function Library. And what's going to do, is it's going to take information from two separate cells, and incorporate them to create one new value in a new cell. I'm going to start with the abbreviation that I created in the previous movie. So if you'd like to open up EatCake Inventory 16 in your Exercise Files, you'll see that I've already started us off. So, I want to create the acronym that includes the first two letters of my Item Type, a hyphen, and the Item Category.
So, how do I do that very simply? Alright, first things first. You go to the cell where you want that information to reside. So I'm going to select cell J2. I then go up to the text category again in my Function Library group, and this time I pick CONCATENATE. And what concatenate does, is it brings together several strings of text to create one new string. So I select that function, and I'm just going to move over this window ever so slightly, because I want to pick the abbreviation that I created, as the very first piece of my string.
So I select I2 has my cell. Notice it pops in Pa because it's identified and that's the value that's in there. So it's going to start to build it for me, just as all the other functions did, I'm going to see what I'm creating as I do it. I mentioned I wanted a hyphen in between this piece and the other piece of my text that I'm creating. So I go to my next Text2 box, and I click on that, and I type in my hyphen.
Notice when I clicked on Text2, it automatically creates a Text3 box because I can create as many boxes as I have pieces of information for. So this is always going to be dynamic when it's being created. Next I go down to Text3. I have one more piece of text I want to include, so I'm going to move my screen over one more time so that I see my Item Category column, and I select cell A2, because that's the category that I want to include. So if you take a look down here, you'll see that I've got Pa-Flour.
That's exactly how I want it to work. If there was any changes that I would want to do, I would just go back to the text box where I've put in my information, and I would make the adjustments, perhaps we order things, put in more spaces, or pick a completely different text box to work with. But for me, I'm happy with what I've created. I click on OK to solidify that particular function, and you'll see here that it's popped it into the spot J2. As I did with the other functions, I grab the handle bar, pull it down through my rows, release, and I've created my abbreviations for each of the different sections that I have here.
In order to solidify these yet one more time, I high it, select Copy, move over to my new column, select Paste Special, select Values, and click OK. And I now have my information placed for me here. Now, in this case, because I didn't have anything under the Sprinkles or Toppings area, I may have to go in and adjust those ever so slightly, by removing the hyphen in this case, and in this case.
But making those two little adjustments to my overall column is a whole lot easier then going row by row to create these manually. Next we're going to do some analysis on our overall table, so 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.