Introduction to Microsoft Excel

.

---

LESSON NOTE

Subject: ICT / Digital Skills

Module: Microsoft Office

Week: 1

Topic: Introduction to Microsoft Excel

Duration: 2 hours

Instructor: Osemwengie Victor Odion 

---

1. Learning Objectives

By the end of the lesson, learners should be able to:

• Define Microsoft Excel and identify its uses.

• Explain key components of the Excel interface (Rows, Columns, Cells, Formula Bar).

• Enter and edit data into cells.

• Perform basic formulas and calculations (SUM, AVERAGE, MULTIPLICATION).

• Save, format and print worksheets.

---

2. Teaching Aids

• Computers with MS Excel installed

• Projector

• Whiteboard/Marker

• Sample spreadsheet (scores or budget)

---

3. Introduction (10 minutes)

Teacher explains:

• Microsoft Excel is a spreadsheet application used for:

  • Calculations

  • Record keeping

  • Budgeting

  • Data analysis

  • Inventory control

  • Preparing score sheets

Ask learners:

• Have you seen Excel before?

• What type of records do businesses keep?

---

4. Content / Presentation (60 minutes)

A. Excel Interface

Component	Description
Workbook	Entire Excel file
Worksheet	Single sheet within the workbook
Cell	Intersection of row & column (e.g. A1)
Row	Horizontal lines numbered 1, 2, 3
Column	Vertical lines lettered A, B, C
Formula Bar	Displays entered data or formula
Sheet Tabs	Bottom tabs (Sheet1, Sheet2)

---

B. Data Entry

• Click a cell and type (e.g. A1 → type "Name")

• Press Enter to move down, Tab to move to the right

• Use Delete to clear content

---

C. Basic Calculations

Formulas start with an equal sign (=)

Calculation	Example Formula
Addition	=A1 + B1
Subtraction	=A1 - B1
Multiplication	=A1 * B1
Division	=A1 / B1
Sum of range	=SUM(A1:A5)
Average of range	=AVERAGE(A1:A5)

---

D. Formatting in Excel

Tool	Function
Bold	Make text thicker
Cell Borders	Outline cells or table
Number Format	Currency, Percentage, Date
Cell Color	Highlight cells
Alignment	Left, Center, Right
Merge & Center	Combine cells and center text

---

E. Page Setup & Printing

Task	Procedure
Page Orientation	Page Layout → Orientation → Portrait/Landscape
Paper Size	Page Layout → Size → A4
Print	File → Print → Select printer → Print

---

5. Teacher Activities

• Demonstrate entering data into rows and columns.

• Show learners formulas for addition, average and multiplication.

• Display how to format a table with borders and font styles.

---

6. Learner Activities

• Enter data into a table for 5 students with 3 subjects each.

• Calculate:

  • Total score using =SUM()

  • Average score using =AVERAGE()

• Format the table (borders, bold headings, center alignment).

---

7. Evaluation / Assessment

1. What is Microsoft Excel?

2. Define a cell in Excel.

3. Which symbol begins every formula?

4. Write the formula used to calculate average in Excel.

5. What is the function of the Formula Bar?

---

8. Conclusion

Teacher summarizes:

• Excel is used for data entry, storage, calculation and analysis.

• Rows, columns and cells form the structure.

• Formulas help automate calculations.

Encourage students to practice at home or in the lab.

---

9. Assignment

1. Create a budget table containing 5 items and their prices.

2. Use SUM to calculate total cost.

3. Format the table using:

   • Borders

   • Bold headings

   • Currency (₦)

---