Introduction To Microsoft Office Excel 2003

Introduction To Microsoft Office Excel 2003

Microsoft Office Excel 2003 is application software classified under the spreadsheet programs. It was developed by Microsoft for Windows, Mac OS X, and iOS. A spreadsheet is a computer program that organizes data in a grid made of rows and columns; it can also be defined as a computer’s numerical data processor.

Using Microsoft Office Excel 2003 spreadsheet program, you can be able to do the following:-

  • Data entry
  • Mathematical manipulation of data
  • Graphical presentation of facts and findings by use of interactive charts
  • Elementary data-base management
  • Data analysis
  • Macro programming using Visual Basic for Applications
  • Research using for instance the what if analysis
  • You can create reports from data entered

Features of Ms Excel Window

The features of the excel window are the same as those in Ms-Word window except for the following:
The excel area is divided into rows and columns while the Ms Word working area is a plain one.
Other additional features in the Ms excel working area include:-

  • Workbook title (same as file name in word)
  • Worksheet tab (for selecting the worksheet you want to work on)
  • Row headers (1, 2, 3 …)
  • Column headers (A, B, C …)
  • Formula bar

Excel Workbook Overview

Excel Workbook
Excel Workbook | Source

Loading Microsoft Excel and Definition of Terms

  • Click on start, all programs
  • Locate Microsoft Office and click on it
  • Then click on Ms Excel

Definition of terms used in Excel

Workbook or book – This is the main file you open in Excel which can then comprise a number of worksheets.

Worksheet – This is a page within a workbook made up of columns and rows which you use to keep and manipulate data.

Columns – These are the vertical partitions labeled ABCD...

Rows – These are the horizontal partitions numbered 1234…

Cell – A cell is the intersection between a row and a column, it is where you enter your data. The cells are referred to using the column and the row labels/headers, for instance cell B2 will be the intersection between column B and row 2. A cell with a thick line around it (cell selector) is active, meaning you can type on it.

Worksheet Tabs

Worksheet Tabs
Worksheet Tabs | Source

Navigating (Moving through) the Worksheet

We can use:

Mouse Pointer – For clicking cells making them active and also for multiple selections of cells.

On the keyboard:

Arrow keys – Arrow keys can be used to move towards the direction of the arrow one cell at a time.

Ctrl + Home – Takes you to the 1st cell in the worksheet

Ctrl + End – This takes you to the last edited end in the range

Ctrl + Arrow right – Takes you to the last column in the worksheet

Ctrl + Arrow Down – Takes you to the last row in the worksheet

Ctrl + Page Down – Takes to the next worksheet

Making Selections

  1. Click and hold down the left mouse button and then drag the pointer over the range of cells.
  2. Click on the first cell in the range then hold down the shift key and click on the last cell in the range.
  3. Click on the first cell in the range then hold down the shift key and move through the range of cells using the arrow keys.
  4. Click on the row header to select the whole row or click on the column header to select the whole column.
  5. Click on the junction of row and column header to select the whole worksheet to make non-continuous selection.
  6. Hold down the Ctrl key then select each range by holding and dragging the cell pointer through it.

Your say

Are you familiar with any version of Excel?

See results without voting

Microsoft Excel Tutorial For Begginers

© 2012 Patrick Kamau

More by this Author


Comments 2 comments

Patkay profile image

Patkay 4 years ago from Nairobi, Kenya Author

Well, smartprincess, thanks for reading and commenting. I have seen your requests and I will try hard and work on them. I believe there is a lot people need to learn. Keep checking and thanks for your continued support.


smartprincess profile image

smartprincess 4 years ago from Nairobi, Kenya

Hi Patkay

Thanks for that information, could you write an article on how you can migrate a database into an excel worksheet and also how you can merge, manipulate and combine different excel reports with different headers into a series of unified reports. oh and first how to make an excel report. thanks

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working