Spreadsheets are among the most versatile tools used across different fields, from research and education to business and everyday problem-solving. They help organize information, perform calculations, and generate insights from raw data. Learning how to use spreadsheets effectively builds a strong foundation for working with data, and it enables decision-making based on evidence rather than guesswork.

Let’s explore some core skills that help to navigate spreadsheets with confidence.

Sorting and Filtering Data

Sorting helps arrange data in a specific order, such as alphabetically (A–Z or Z–A) or numerically (smallest to largest or vice versa).
Filtering allows users to display only rows that meet certain criteria (e.g., show only "Female" respondents, or only sales above N10,000).

Together, sorting and filtering are critical for cleaning data and identifying patterns quickly.

Using Formulas

Formulas are the engine of spreadsheets. Some essential ones include:

SUM: Adds values in a range.
AVERAGE: Calculates the mean of selected values.
IF: Returns results based on logical conditions (e.g., pass/fail depending on a score).
VLOOKUP: Finds information in a dataset by searching a column and returning a related value.
COUNTIF: Counts the number of cells that meet a specific condition.

Example: “How many students scored above 70?” → =COUNTIF(B2:B20,">70").

Conditional Formatting for Quick Insights

This tool highlights cells automatically based on rules, such as coloring scores above 90 green or sales below target red.
It provides a visual way to spot trends, outliers, or areas that need attention without manually scanning through numbers.

Creating Pivot Tables for Summarizing Data

Pivot tables allow for quick summarization of large datasets.
Users can group, categorize, and calculate totals or averages across categories (e.g., average score per subject, total sales per region).
This tool is especially valuable when comparing multiple dimensions of data.

Mini Activity

Dataset (Example: Regional Sales & GDP Data)

Region	Sector	Quarter	Revenue (N’000,000)	GDP Growth (%)
North	Agriculture	Q1	320	2.1
South	Manufacturing	Q1	540	3.4
East	Services	Q1	410	2.8
West	Agriculture	Q1	280	1.9
North	Services	Q2	390	2.5
South	Agriculture	Q2	450	3.0
East	Manufacturing	Q2	620	3.6
West	Services	Q2	310	2.2

Tasks

Sort

Arrange regions by highest-to-lowest revenue.
Arrange quarters by GDP growth rate.

Filter

Show only regions/sectors with Revenue > N400,000,000.
Show only quarters where GDP Growth > 3%.

Formulas

Use SUM to calculate total revenue across all regions.
Use AVERAGE to find the average GDP growth.
Use IF to categorize performance: “High” if GDP growth ≥ 3%, otherwise “Low”.
Use COUNTIF to count how many regions had GDP growth above 2.5%.

Conditional Formatting

Highlight all revenues below N350,000,000 in red.
Highlight GDP growth above 3% in green.

M7:S1 - Foundation in Spreadsheet Tools

PREVIOUS STEP

Data Visualization

NEXT STEP