Original content from | Corporate Services | Talent Partnerships
Pending
Your epoints

How To Use Excel 2007

How To Use Excel 2007

A tutorial video of Microsoft Excel that gives instructions on how to use Excel and the way Excel works. This particular video shows us how to navigate through rows and columns, enter data and organize our cells.

Hi, my name is Ghamza Jacobs, I'm here today just to show you a couple of little tips and tricks on Windows 7 and Office 2010.We're looking at how to use Excel right now, and basically Microsoft Excel is a very very popular spreadsheet application, used to create tables of data, used to create income statements, bank sheets, anything that you need to represent as a table. And standard to all versions of excel, of course, is you've got your columns and you've got your rows, so in your idea, I'll just select a colon over here, that's column A, column B, just some columns running from A,B,C,D all the way across.

Your rows run from 1 all the way down. And where a column and a row intercept, that's called a cell address, you can see the cell address at the top here. A1 that means column A, row 1.

Your columns and rows in Excel 2007 and 2010 have been extended greatly. In the earlier versions 2003 and prior, you only had 65.536 rows.

And now you're thinking 'Oh, how am I going to put all my data in there, it's only 65000 rows?' That's a pretty common problem and believe it or not, it's something I've encountered many times, many people ask me 'How do I get more rows? 65000 is just not enough for me'. In 2007 and 2010, Microsoft evolves at those questions, just to give you a quick idea, if I pull up to the bottom over here, I now have 1,048,576 rows. That should be enough for us, hopefully.

Our columns used to go from 'A' to 'I-B' that was 256 columns, they now go from A to X-F-D, that's over 16000 columns. So you have roughly about 17 billion cells per sheet, give or take a few million of course. So the really really big interface, the rally black book that your working on, all you need to know right now is, the way that column and the row intercept, that is a cell, an A1.

And I can move about using my analog cursor or keys on my keyboard to flip around. And you can see that little bold outline moves about, so you've got the selected or after cell. It's very important to keep an eye on that, it is where any action will take place.

For example, if I go back at A1 and type in something like month, I would normally always use the tab key to enter and that types in. Another way to navigate the bars is to use your mouse, and you know your mouse has got the white cross at the moment, that enables me to select cells. So I'll move to B1 real quick, typing sales, use the tab key again to enter that, to move across.

We'll type in expenses, now instead using the tab key, you saw that tab key moves me from left to right, I'm going to use the enter key, that takes me down to the bottom. So enter moves you to the bottom. Just below month, I'll very quickly enter Jan, Feb, March.

And now I have my column labels, and my row labels added in there, so that gives me the nice bases for my sheet. I could now go in and type in all the monumental values for that. So let's say that January sales were 5600, and we hit enter, now that's going to get me down in the bottom.

Next cell, February sales, let's say it was 4750, March sales 5200. What you will also notice as you're typing in, your text is always left aligned, your numbers are always right aligned. Excel will automatically reformat items as you enter them.

For example, if you enter text, it recognizes it as text and it gets aligned to the left, numbers get recognized as numbers and get aligned to the right. A very good idea when starting up an excel sheet is to enter your text labels first as I have done over there, and then that gives you a very nice foundation to enter your numerical values. Very very basic, how to enter data in excel. .