Introduction to Microsoft Excel Lesson 

Lesson Overview

• Understanding Excel's Interface
• Getting Started with Excel
• Cell References: Relative, Absolute, and Mixed
• Using Basic Functions in Excel
• Logical Functions: IF Statement
• Working with COUNTIF and SUMIFS
• Formatting Tables and Using the Total Row
• Referencing Data Across Worksheets
• Creating and Customizing Charts
• Creating Charts with Two Axes
• Customizing Chart Data
• Using Templates in Excel
• Using Range Names
• Lookup Functions in Excel
• Key Takeaway:

Microsoft Excel is a powerful spreadsheet application that allows users to organize, analyze, and visualize data. For students, learning Excel can enhance mathematical skills, promote logical thinking, and provide a foundation for future data management tasks. This lesson introduces key Excel concepts and functions, preparing students to tackle various data-related challenges confidently.​

Understanding Excel's Interface

Before diving into specific functions, it's essential to familiarize yourself with Excel's interface:

• Workbook and Worksheets: An Excel file is called a workbook, containing multiple sheets known as worksheets. Each worksheet consists of a grid of cells organized into columns (labeled with letters) and rows (numbered).​
  
• Cells: The intersection of a column and a row forms a cell, identified by its cell reference (e.g., A1, B2). Cells are where data is entered and manipulated.

Getting Started with Excel

Excel organizes data into a grid of rows and columns. Each box in the grid is called a cell, and it is identified by a cell reference (e.g., A1 refers to column A, row 1).

Key Excel Components:

Element	Description
Cell	A single data point or value located by a column letter and row number.
Worksheet	A single page in an Excel file (workbook) where data is entered.
Formula Bar	Displays the formula used in the selected cell.
Ribbon Tabs	Tools and features (e.g., Home, Insert, Formulas, Data) found at the top.
Workbook	A file that contains one or more worksheets.

Cell References: Relative, Absolute, and Mixed

Relative References

When copying a formula from one cell to another, Excel automatically adjusts the cell references. This is known as a relative reference.

Example:
If cell B1 has the formula =A1+10 and you copy it to B2, it becomes =A2+10.

Absolute References

An absolute reference keeps a specific cell constant by using the dollar sign ($).

Example:
=A1/$A$2 always uses the value in cell A2 for division, no matter where the formula is copied. This ensures the denominator remains fixed.

Mixed References

Mixed references combine fixed and relative parts (e.g., A$2 or $A2), locking either the row or column.

Reference Type	Example	What's Locked?
Relative	A2	Nothing
Absolute	$A$2	Column and Row
Mixed	A$2 or $A2	Row or Column

Take This Quiz:

Using Basic Functions in Excel

Functions are built-in formulas used for calculations. Students need to understand how and when to use each.

SUM Function

Adds a range of numbers.

Example:
=SUM(A1:A5) adds all values from cell A1 to A5.

AVERAGE Function

Finds the mean of a range of numbers.

Formula:
=AVERAGE(B1:B5)
This calculates the total sum divided by the number of values.

Logical Functions: IF Statement

IF Function

Used for decision-making in formulas.

Syntax:

sql

CopyEdit

=IF(condition, value_if_true, value_if_false)

Example:
=IF(B2>60, "Pass", "Fail")
This checks if the value in B2 is greater than 60. If true, it displays "Pass"; otherwise, "Fail".

Real-World Use: Useful in report cards or automated feedback.

Working with COUNTIF and SUMIFS

COUNTIF Function

Counts the number of cells that meet a specific condition.

Example:
=COUNTIF(B2:B10, "Male")
Counts how many cells in B2 to B10 contain "Male".

Quiz Application: This applies to Question 4.

SUMIFS Function

Adds numbers based on multiple criteria.

Syntax:

CopyEdit

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

Example:

php

CopyEdit

=SUMIFS(C2:C10, A2:A10, "North", B2:B10, "Widget")

Sums all values in C2:C10 where A2:A10 = "North" and B2:B10 = "Widget".

Formatting Tables and Using the Total Row

When formatting data as a table, Excel provides advanced features including the Total Row.

Total Row in Excel Table

Steps:

1. Select data and choose Insert > Table.
   
2. Enable Total Row under Table Design.
   
3. Excel adds a summary row at the bottom.
   

Purpose: Quickly sums, counts, or averages data.

Referencing Data Across Worksheets

Summary from Other Sheets

You can create formulas that reference data from another worksheet.

Example:

CopyEdit

=Sheet2!A1 + Sheet2!B1

This adds the values in A1 and B1 from Sheet2 into the current sheet.

Creating and Customizing Charts

Inserting a Chart

1. Select data
   
2. Go to Insert > Chart
   
3. Choose from Column, Bar, Line, or Pie charts
   

Using F11 Key

The shortcut F11 creates a chart on a new worksheet instantly.

Creating Charts with Two Axes

You can compare different data sets by adding a secondary axis.

Steps to Add a Second Axis

1. Create a chart.
   
2. Right-click on the series you want to assign to the second axis.
   
3. Choose Format Data Series > Secondary Axis.
   

This is crucial when comparing values with different scales.

Customizing Chart Data

Use the Select Data option to control what appears in a chart.

Steps:

1. Click the chart.
   
2. Select Chart Tools > Select Data.
   
3. Add or remove series or change labels.
   

Using Templates in Excel

Templates are pre-formatted Excel files.

Use:

• Standardizes layout and formatting.
  
• Saves time on repeated tasks (e.g., gradebooks, budgets).
  

Using Range Names

What is a Range Name?

A range name is a custom name for a group of cells.

Example: Instead of =SUM(A1:A5), you could write:

sql

CopyEdit

=SUM(SalesData)

This improves readability and makes large spreadsheets easier to manage.

Lookup Functions in Excel

There are three main lookup functions in Excel:

Function	Use Case
VLOOKUP	Finds data in a vertical column
HLOOKUP	Finds data in a horizontal row
INDEX/MATCH	Advanced alternative for flexible lookups

Example VLOOKUP:

php

CopyEdit

=VLOOKUP("John", A2:B10, 2, FALSE)

Key Takeaway:

By understanding these core concepts - from formulas and references to charts and logical functions - students in grades 4 and 5 can become confident and capable Excel users. The quiz associated with this lesson evaluates these skills directly, making this self-study a critical learning tool.

Take This Quiz: