← Erudite Africa Center of ExcellenceGeneral CoursesSchool of Professional SkillsFoundational
Data Analytics and Digital Literacy
Safe digital work, clean data, Excel pivot tables and a one-page branch dashboard within Ethiopia's data protection law
Build the everyday digital and data skills finance staff need: secure use of digital tools, cleaning and summarizing data in Excel, and handling customer data lawfully, ending with a branch dashboard you build yourself.
Start the course
0 of 5 modules completed
What you will be able to do
- Use core digital tools (email, office suites, collaboration tools and core banking screens) productively and securely
- Recognize and report phishing, social engineering and other cyber threats
- Assess and improve the quality of bank data before using it
- Clean, summarize and chart data in Excel using formulas, lookups and pivot tables
- Handle personal data in line with Ethiopia's data protection law
- Build and check a one-page dashboard of deposits, loans and digital activity
- For
- All staff in Ethiopian banks and microfinance institutions who use digital tools at work, and analysts and officers who prepare or read branch and unit reports. Prerequisite: basic computer use. A laptop with Excel is needed for the practical work.
- Study time
- About 5 hours online, in 5 modules (16 hours in the classroom version)
- Each module
- Short lessons, animated visuals, Ethiopian examples, decisions to make, the laws and directives that apply and worked calculations, then a quiz
- Assessment
- A 20-question final exam; pass mark 70%
- Certificate
- Erudite Africa Center of Excellence certificate of completion
- Access
- Module 1 free for registered users; the full course, exam and certificate for subscribers
The 5 modules
- Module 01Free previewDigital essentials and cyber hygieneWork productively with files, email, meetings and core banking screens, and protect yourself and the bank from the most common cyber attacks.6 lessons · 60 min · quiz
- Module 02Data basics: data in a bank and data qualityUnderstand the kinds of data a bank holds, where they come from, and how to judge whether a data set is good enough for a decision or a report.6 lessons · 55 min · quiz
- Module 03Excel for analysis: cleaning, formulas and lookupsTurn a raw extract into a clean, checked table and answer questions with summary formulas and lookups.6 lessons · 70 min · quiz
- Module 04Pivot tables, charts and the one-page dashboardSummarize the clean data with pivot tables, choose honest charts and lay out a one-page branch dashboard that has been checked against the books.6 lessons · 65 min · quiz
- Module 05Data protection and the capstone dashboardHandle customer data within Ethiopia's data protection law, share only what is needed, and complete the branch dashboard capstone.6 lessons · 65 min · quiz
- Officer simulationA month-end week as data analyst at Bank A, head office business intelligence unitWork as data analyst: 12 real-life items, decisions with consequences and a hand-over note. Pass with 70% to qualify for the certificate.
- Final examFinal exam and certificate20 applied questions across all 5 modules. Pass with 70% to download your certificate.
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.