ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

Introduction To Microsoft Office Excel 2003

Updated on October 21, 2017
Patkay profile image

Patrick is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Introduction To Microsoft Office Excel 2003

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. There are newer versions of Microsoft Office Excel for instance Excel 2007, 2010, 2013 and 2016. They keep on evolving as newer and improved versions are released. What is important to note is that when you have the basic skills of a certain version, you can be able to handle the others easily.

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 database 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

There are a number of ways you can start MS Excel and this one is the easiest.

  • Click on start, point to 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 labelled ABCD...

Rows – These are the horizontal partitions numbered 1234…

Cell – A cell is an 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

Tab Key - The tab key can also be sued to take you to the next cell.

Making Cell 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 a non-continuous selection.
  6. Hold down the Ctrl key then select each range by holding and dragging the cell pointer through it.

The MS Office Excel Active Cell

Generally, you first select the cell or cells you want to work with, and then you enter data or choose a command. Selected cells appear highlighted on your screen. The active cell is the cell in which data is entered when you start typing. Only one cell is active at a time.

Your say

Are you familiar with any version of Excel?

See results

Microsoft Excel Tutorial For Begginers

© 2012 Patrick Kamau

Comments

    0 of 8192 characters used
    Post Comment

    • Patkay profile image
      Author

      Patrick Kamau 5 years ago from Nairobi, Kenya

      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 5 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

    working