Module 2 · Spreadsheets: Excel and Sheets essentials

Spreadsheets: Excel and Sheets essentials

Rows, columns, totals, filters and clean data.

Reading ~12 minLesson 2 of 12

DOI-native

One row per record, one column per field, a header row at the top.
Use SUM, AVERAGE and COUNT for totals.
Use filters and sorting instead of deleting rows.
Freeze the header row; never merge cells in data.

=SUMIF(C:C, "Lagos", D:D) totals column D only where column C says Lagos.

Key takeaways

One row per record
Filter, don't delete
No merged cells in data

Preview · Sample data — Demo course content authored by DOI for this prototype. Signed in, progress is saved to your DOI account; otherwise it stays on this device. Finishing lessons records learning; it does not prove competence — that comes from reviewed practical evidence and DOI assessment. DOI claims no accreditation for this course.