Excel for analysis: cleaning, formulas and lookups

Module 03 / 5 · 70 min

Turn a raw extract into a clean, checked table and answer questions with summary formulas and lookups.

In this module you will learn to

Set up a raw extract as an Excel table and keep the original untouched
Clean text, numbers and dates with TRIM, SUBSTITUTE, VALUE and Remove Duplicates
Summarize data with SUMIFS, COUNTIFS, AVERAGEIFS and IF
Join tables with XLOOKUP or VLOOKUP and check the results
Apply a lookup table to compute loan provisions by classification

Built on

Erudite Africa course specification: 4.e Data Analytics and Digital Literacy, Level 1 (October 2026)
Erudite Africa: Training Module, Ethiopian Context, programme overview and regulatory register (October 2026)
NBE directives as listed in the lessons: SBB/87/2024, SBB/90/2024, SBB/95/2025; FCP/01/2020 and CRB/02/2019 (as reported)
Personal Data Protection Proclamation No. 1321/2024, Electronic Transaction Proclamation No. 1205/2020, Computer Crime Proclamation No. 958/2016 and National ID Proclamation No. 1284/2023 (as reported)
Course worked example: the fictional Hawassa Tabor branch data set

Examples and organizations are fictional. Apply your own organization's approved policies.