MS-EXCEL LECTURE NOTES - read online free

Sep 17, 2026

Uploaded by Mason

Microsoft Excel lecture notes for Oweri CBT Hi-Tech, Oweri Nigeria introduce Excel 2007 for computer novices with a focus on essential spreadsheet operations. The course covers navigating the Excel window, using core interface elements like the Office button, Quick Access Toolbar, Title Bar, Ribbon, Worksheets, Formula Bar, and Status bar. It also trains participants to enter text and numbers, use formulas, format data, select and move between cells efficiently, and prepare the foundation for later work with functions, charts, and advanced formulas.

LanguageEnglish

CategoryExam

FormatPDF

Pages45

Reading Time1 h 53 min

AccessFree to download

Preamble

Excel learning objectives

Section 1: Entering Text and Numbers

The Microsoft Excel Window

The Microsoft Office Button

The Quick Access Toolbar

The Title Bar

The Ribbon

Worksheets

The Formula Bar

The Status Bar

Move Around a Worksheet

Exercise 1

Go To Cells Quickly

Exercise 2

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 1.8 The Status Bar The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. 1.9 Move Around a Worksheet By using the arrow keys, you can move around your worksheet. You can use the down arrow key to move downward one cell at a time. You can use the up arrow key to move upward one cell at a time. You can use the Tab key to move across the page to the right, one cell at a time. You can hold down the Shift key and then press the Tab key t

FAQs

What is the purpose of these Excel lecture notes?

They teach Microsoft Excel basics to computer novices as a prerequisite for more complex statistical analysis using SAS software.

Which Excel 2007 window components are introduced in Section 1?

The notes cover the Microsoft Office button, Quick Access Toolbar, Title Bar, Ribbon, Worksheets, Formula Bar, and Status bar.

How do participants move quickly to a specific cell?

They can use shortcut methods such as Go To with F5 or Ctrl+G, and the Name box by typing the desired cell reference then pressing Enter.

Sep 17, 2026

Uploaded by Mason