Tutorial Microsoft Excel 2007 to 2010 : Excel Rows and Columns

Tutorial Microsoft Excel 2007 to 2010 : Excel Rows and Columns

Microsoft Microsoft Office tutorial

Spreadsheets are displayed in a grid layout. The letters across are the top are Column headings. To highlight an entire Column, click on any of the letters. The image below shows the B Column highlighted:

If you look down the left side of the grid, you'll see numbers, which start at number 1 at the very top and go down to over a million. (The exact number of rows and columns are 1,048,576 rows and 16,384 columns. You've never going to need this many!) You can click a number to highlight an entire Row. If you look at the image below, you'll see that Row 5 has been highlighted.

Spreadsheets are all about individual Cells. A Cell is a letter combined with a number. So if you combine the B column with Row 5, you get Cell B5. Combine Column D with Row 5 and you get Cell D5.

To see this for yourself, click inside any of the cells on your spreadsheet. In the Images below, we have clicked inside cell A1 and cell C3.

   

The first picture is Column A, Row 1 (A1), and the second picture is Column C Row 3 (C3). Notice that the cells we clicked on have a black border around them. This tells you the cell is active. The cell that is active will have its Column letter and Row number displayed in the top left, just above the letters A and B in the pictures. When you click into a cell, you can then type text and numbers.

To move around the spreadsheet, and make other cells active, you can either just click inside a Cell, or press the arrow keys on your keyboard. Try it now. Click inside a Cell and notice the Cell reference appear above the letters A and B. Press your arrow keys and notice how the active cells moves.
Before going any further, make sure you understand how the spreadsheet grid works. If you are asked to locate Cell H2, you should be able to do so.

Tutorial Microsoft Excel 2007 to 2010 : A first look at Excel

Tutorial Microsoft Excel 2007 to 2010 : A first look at Excel

Microsoft Microsoft Office tutorial

If you've ever used a previous version of Excel then you'll notice that the new version looks quite different! Even if you have never used Excel, the software looks quite intimidating. But we'll make a gentle start, so that you can get used to the way everything works.
The first thing to notice is the Ribbon running right across the top. The Ribbon is supposed to be more intuitive than drop-down menus. Emphasis is placed on the tools and options appropriate to what you're doing. Here's a closer look at the Ribbon when Excel first starts (it's split in half, here):

Left Side of the Ribbon in Excel 2007

Right Side of the Ribbon in Excel 2007

Left Side of the Ribbon in Excel 2010

Right Side of the Ribbon in Excel 2010

Notice that in both versions the Home tab is the one that is selected. Other tabs are: Insert, Page Layout, Formulas, Data, Review and View. (In the image above, there's also a Developer tab. If you don't do any programming then you don't have to worry about this tab.)

In the top left of the Ribbon in Excel 2007 there's a big circle. This one:

Click this, and you'll see all the file operations: New, Open, Save, Exit, etc.

To see the same menu in Excel 2010, you have to click on the File tab, which is on the far left. (It looks as though it's already selected, but it's not.):

We'll go through all these menu options later, along with the various options on the Ribbon tabs. But the best place to start with Excel is getting to grips with all those numbers and letters. These are the Grid Coordinates. We'll do that in the next part.

Free Office Productivity Suite Software

Free Office Productivity Suite Software

download Microsoft Microsoft Office

Three major office tools on KingSoft Office Suite 2012:

Kingsoft Office (KSOffice) Writer 2012
Kingsoft Writer 2012 is definitely your greatest tool to create professional looking documents. It can open Microsoft Word files or save your documents as Word files. It enables you to open, view and edit your documents to various file formats as well as the latest Word (.DOCX) file.
Familiar Style, Layout & Functionality with Office, that means you can easily transfer Office environment between Writer and Kingsoft Writer. Moreover, kingsoft office 2012 provides powerful functions such as built-in PDF conversion, Document Tab Switching, Diverse Printing Choices, Cross Reference and integrated Google Search toolbar.
Kingsoft Office (KSOffice) Presentation 2012
Kingsoft Presentation 2012 helps you to quickly create your multimedia presentation in creative ways to meet your customers’ needs. It can open, edit and save as *.ppt, *pps , *pot files (Template) and support *.pptx file (Office 2007). Its fully compatibility function enable your presentation to be saved in Power Point formats as well as PDF format effortlessly. Kingsoft Presentation offers a unique function in Double-Screen Extended Mode- the users can show speaker’s view and playing view on different monitors.
Kingsoft Office (KSOffice) Spreadsheets 2012
Kingsoft Spreadsheets 2012 can open edit and save *.xls, *.xlt (Template), *.dbf, *.txt, *.csv , and compatible with *. xlsx file (Office 2007). It gives you more efficiency and flexibility to achieve your target. It contains a lot of functions and array formulas that help you manage, analyze and calculate data easier and faster. It provides eight types of RC4 encryption, which are very difficult to be decoded. Therefore, Spreadsheets can prevent your document from being copied, modified, or printed to a great extent.

Besides that, KingSoft office suite user interface is similar like Microsoft Office 2003. For those user hates office ribbon style interface. Then Kingsoft Office suite will be the one. Whenever  multiple document files are opened on Kingsoft Office suite, a tab bar appears above the editable area allows you to switch between documents quickly and conveniently. Plus more, Kingsoft office suite also built-in e-mailing function makes it easy to share documents via Email.
Kingsoft office suite also comes with automatice spell check, a office features will automatically proofread the text you enter as you create your documents. It will mark the incorrect words in red underlines when typing and provide some recommended words to help in improving your document. On document security, Kingsoft Office suite provides document encryption function, which can set a password to office document files.
The Kingsoft Office Suite 2012 download size is around 70MB, which is extremely small file size compare to Microsoft office around (700mb) or openoffice (150mb).  Plus more, this can save a lot of time when you downloading and installing. After installation is occupies less than 250 MB of hard disk space.

Download Kingsoft Office Suite 2012