How To Create Tables In Excel
How to create a table in Microsoft Excel 2010: This VideoJug film explains in detail how to use new tools to create and format a table in Microsoft Excel 2010.
Hi, my name is Ghamza Jacobs. I'm an IT trainer with New Horizons in London. I'm here today just to show you a couple of cool little tips and tricks on Windows 7 and Office 2010.
How to create easy tables in Excel 2010? Microsoft Excel 2007 and 2010 have introduced a brand new feature called format as table. What this does is it formats your data set as a complete unique table. What this allows you to do is it allows you to manipulate the data independently of anything else on your worksheet.
Let's have a look at this. I've got some data over here, notice name, vendor, unit price, quantity and stock, all of that yeah? I've got some data on the side here also but, I want to start manipulating this and tweaking and changing this without really affecting that too much. So what I'm going to do is go, select anywhere inside the data, just click on any cell inside the data set.
Under the home tab in both versions, 2010 and 2007, I go format as table, and look at all the pretty colors! I can pretty much choose any format. By the way, you can choose one of these or you can create your own table style. Many organizations choose to do this, to create the table style in their unique company format.
I'm just going to go for the blue, click onto it, the medium 9. Notice what's happened here, it's picked up my data set. 2010 and 2007 are really good at automatically selecting the data set.
My table has headers, that means my headings are there. Click OK. Look at that, pretty good.
Nice formatted, good looking table. I obviously now see table tools pop-up icon textual tab at the top. Now this allows me to drop this arrow down.
As you can see, live preview does this thing, as I move around, I can sort of play with it, now I can find perhaps one that suits my needs a little bit more. I'm going to leave it on that one, but part of the really good features in tables is the way you can extend it. For example, let's say I want to add a column down the side here saying total stock.
So I want to add up the quantity and stock plus the quantity on order. Click into G1, look if I type in total stock and hit enter, it extends the table automatically. Now I want to do a formula, go equals, we'll say that cell, plus, that cell.
I hit enter, it does the entire column in one go. Let's say I want to add in the total column down the bottom, or total row down the bottom. I already have a total column there, total row down the bottom.
I simply go to design on my table tools and hit total row. That pops a nice total at the bottom for my stock there. This is not just any old total, it's a subtotal.
Look, if I click onto it, I can now drop the arrow down and change the formula quite easily. I click, drop the arrow down, change the formula, make it average, anything I like there. Very good.
Another nice feature here, some of you may be aware of freeze panes. When you scroll down, you want to be able to see your headings at the top. What we used to have to do is freeze the headings.
If you have a table, you don't have to do that. Look, keep an eye on A,B,C, D. If I scroll down, look what happens, it changes to become my heading names.
It's really good, see? There's my headings, as I scroll down, my heading's get retained at the top, they actually become, and even my filter is part of that. So your filter and headings are always available as you're scrolling down. Another handy feature, and I'll zoom out slightly just to show you this.
Notice I've got data set on the side here, a data set on the side. Let's say I want to add a new row of data in here. Obviously, if we right click new row, it puts a row down the entire sheet and affects that as well.
If I simply right click and go, insert table row, click it, it inserts a new table row but leaves that data unaffected. Insert table row, leaves that data unaffected totally. I now have a very nice, uniquely formatted independent data set formatted as a table