Patrick, a computer technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.
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.
Uses of Microsoft Office Excel Spreadsheet Program
- Data entry
- Mathematical manipulation of data
- Graphical presentation of facts and findings by the 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 the Ms-Word window except for the following.
The excel area is divided into rows and columns while the Microsoft Word working area is a plain one.
Other Additional Features in the Ms Excel Working Area Include:-
- Workbook title (same as the file name in Microsoft 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
Loading Microsoft Excel and Definition of Terms
There are several 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 several 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 the point 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.
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 – This 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
- Click and hold down the left mouse button and then drag the pointer over the range of cells.
- Click on the first cell in the range then hold down the shift key and click on the last cell in the range.
- 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.
- Click on the row header to select the whole row or click on the column header to select the whole column.
- Click on the junction of the row and column header to select the whole worksheet to make a non-continuous selection.
- 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. The active cell is also indicated in the name box.
Microsoft Excel Tutorial For Begginers
This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.
© 2012 Patrick Kamau
Patrick Kamau (author) from Nairobi, Kenya on September 03, 2012:
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 from Nairobi, Kenya on September 03, 2012:
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