How To Use Excel 2010

How To Use Excel 2010

This videojug video aims to help better understand the use of Microsoft Excel 2010. The video explains how to use the new features that Excel 2010 offers. Follow the simple guide to excel in the use to Excel 2010.

Hi, my name is Ghamza Jacobs, I am 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 Widows 7 and Office 2010. How to use Excel 2010? Excel 2010 is the latest version of Microsoft's very very popular productivity package called Microsoft Office.

Excel 2010 extends on the Excel 2007 look and feel where you have the ribbon at the top for navigation, and how this basically works is you just have multiple tabs. As you select a tab, you notice that this entire area at the top here, will just flip around like a ribbon folding over itself to reveal features. You see as I move through, that will just give you a good idea as to what the ribbon looks like.

So that's pretty standard as far as the new applications within the Microsoft sweep goes. One nice addition in Excel 2010 and Office 2010 generally is, hey look file's back, so what we can do is click on file and that opens up something called backstage view. Backstage view simply gives you an entire full screen view that enables you to work with things like your protection, you've got your versioning available over there, creating new documents, our templates available of Office.

com, many of our recent files, printing options. One of the nice things about this have a quick look here you can actually print and sit all of your printing options directly over here without having to go into the printer properties which is very good so you can adjust your margins, sit up your scalings, do everything straight over there. Right, so that's just a very quick look at file, we'll go to file, save, open, launch up new templates, anything like that, so just clicking to it takes us straight back there.

Good stuff, so we are looking at how to use Excel right now and basically Microsoft Excel is a very very popular spreadsheet application, now used to create tables of data, used to create income statements, balance sheets, anything that you need to represent as a table. Standard to all versions of Excel, of course, is you've got your columns and you've got your rows, so to give you an idea, I will just select the column over here that's column A, column B and you'll notice the columns run 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 intersect, that's called the cell address and 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 65536 rows, I know you are thinking, oh how am I going to put all my data in there it is only 65000 rows, that's a very common problem and believe it or not, something that I as a trainer have counted many times, many people ask me how do I get more rows, 65000 is just not enough for me. In 2007 and 2010, Microsoft has answered those questions, just to give you a quick idea if I flip 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 IV that was 256 columns, they now go from A to XFD, that's over 16000 columns, it's roughly about 17 billion cells per sheet, people take a few million of course. So a really really big interface, really big platform that you are working on, you need to know right now is the way that column and row intersect that is a cell A1 and I can move about using my error or cursor keys on my keyboard to flip around and you can see that little bold outline moves about, so you've got the selective or active cell. It's very important to keep an eye on that, that is where action will take place.

For example, if I go back to A1, I will type in something like months, I would normally always use the tap key to enter and that types in. Another way to navigate about is to use your mouse and you'll notice my mouse has got that white cross at the moment that enables me to select cells, so I move to