MS-EXCEL
LECTURE
NOTES
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 1
,PREAMBLE
Microsoft Excel is an electronic spreadsheet. You can use it to organize your data
into rows and columns. You can also use it to perform mathematical calculations
quickly. This course teaches Microsoft Excel basics as a prelude to the use of
Statistical Analysis System (SAS) software in carrying out more complex statistical
analysis. Although knowledge of how to navigate in a Windows environment is
helpful, this manual is created for the computer novice.
At the end of the course, participants are expected to know how to use Microsoft
Excel to:
Enter text and numbers in a spreadsheet
Enter Excel formulas
Format data
Create Excel functions
Fill cells automatically
Print results
Create Charts, and
Enter advanced Excel formulas
Accordingly, the course is divided into the following five (5) sections.
Section 1: Entering Text and Numbers
Section 2: Entering Excel Formulas and Formatting Data
Section 3: Creating Excel Functions, Filling Cells, and Printing
Section 4: Creating Charts
Section 5: More on Entering Excel Formulas
Section 1: Entering Text and Numbers
1.1 The Microsoft Excel Window
This Section will introduce you to the Excel window. To begin this Section, start
Microsoft Excel 2007 as follows:
1. Click on Microsoft Start Button
2. Point the mouse on All Programs
3. Click on Microsoft Office
4. Click on Microsoft Excel 2007
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 2
,The Microsoft Excel window appears and your screen looks similar to the one shown
here.
1.2 The Microsoft Office Button
In the upper-left corner of the Excel 2007 window is the Microsoft Office button.
When you click the button, a menu appears. You can use the menu to create a new
file, open an existing file, save a file, print and perform many other tasks.
1.3 The Quick Access Toolbar
Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access
toolbar gives you quick access to commands you frequently use.
1.4 The Title Bar
Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel
displays the name of the workbook you are currently using. At the top of the Excel
window, you should see "Book 1 - Microsoft Excel" or a similar name.
1.5 The Ribbon
In Microsoft Excel 2007, you use the Ribbon to issue commands. The Ribbon is
located near the top of the Excel window, below the Quick Access toolbar.
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 3
, 1.6 Worksheets
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows.
The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the
rows are numbered 1 to 1,048,576.
The combination of a column coordinate and a row coordinate make up a cell
address. For example, the cell located in the upper-left corner of the worksheet is
cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10.
You enter your data into the cells on the worksheet.
1.7 The Formula Bar
If the Formula bar is turned on, the cell address of the cell you are in displays in the
Name box which is located on the left side of the Formula bar. Cell entries display
on the right side of the Formula bar.
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 4
LECTURE
NOTES
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 1
,PREAMBLE
Microsoft Excel is an electronic spreadsheet. You can use it to organize your data
into rows and columns. You can also use it to perform mathematical calculations
quickly. This course teaches Microsoft Excel basics as a prelude to the use of
Statistical Analysis System (SAS) software in carrying out more complex statistical
analysis. Although knowledge of how to navigate in a Windows environment is
helpful, this manual is created for the computer novice.
At the end of the course, participants are expected to know how to use Microsoft
Excel to:
Enter text and numbers in a spreadsheet
Enter Excel formulas
Format data
Create Excel functions
Fill cells automatically
Print results
Create Charts, and
Enter advanced Excel formulas
Accordingly, the course is divided into the following five (5) sections.
Section 1: Entering Text and Numbers
Section 2: Entering Excel Formulas and Formatting Data
Section 3: Creating Excel Functions, Filling Cells, and Printing
Section 4: Creating Charts
Section 5: More on Entering Excel Formulas
Section 1: Entering Text and Numbers
1.1 The Microsoft Excel Window
This Section will introduce you to the Excel window. To begin this Section, start
Microsoft Excel 2007 as follows:
1. Click on Microsoft Start Button
2. Point the mouse on All Programs
3. Click on Microsoft Office
4. Click on Microsoft Excel 2007
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 2
,The Microsoft Excel window appears and your screen looks similar to the one shown
here.
1.2 The Microsoft Office Button
In the upper-left corner of the Excel 2007 window is the Microsoft Office button.
When you click the button, a menu appears. You can use the menu to create a new
file, open an existing file, save a file, print and perform many other tasks.
1.3 The Quick Access Toolbar
Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access
toolbar gives you quick access to commands you frequently use.
1.4 The Title Bar
Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel
displays the name of the workbook you are currently using. At the top of the Excel
window, you should see "Book 1 - Microsoft Excel" or a similar name.
1.5 The Ribbon
In Microsoft Excel 2007, you use the Ribbon to issue commands. The Ribbon is
located near the top of the Excel window, below the Quick Access toolbar.
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 3
, 1.6 Worksheets
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows.
The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the
rows are numbered 1 to 1,048,576.
The combination of a column coordinate and a row coordinate make up a cell
address. For example, the cell located in the upper-left corner of the worksheet is
cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10.
You enter your data into the cells on the worksheet.
1.7 The Formula Bar
If the Formula bar is turned on, the cell address of the cell you are in displays in the
Name box which is located on the left side of the Formula bar. Cell entries display
on the right side of the Formula bar.
MS-EXCEL LECTURE NOTES FOR OWERRI CBT HI-TECH, OWERRI NIGERIA Page 4
