- Computers & Software»
- Computer Software»
- Office Software Suites»
- Microsoft Office
Introduction To Microsoft Office Excel 2003
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
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.
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
- 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 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.
Are you familiar with any version of Excel?
Microsoft Excel Tutorial For Begginers
© 2012 Patrick Kamau