IT & SoftwareFree
4.7(289)
Computer Literacy (ICDL)
Windows, Word, Excel, PowerPoint, email and safe internet use — the full ICDL syllabus, free for every learner.
BH
Basira Hakimi
Beginner
3h 20m16 lessonsDari & Pashto
FreeView Details
IT & SoftwareBeginnerFree Course
Data Analysis with Excel
The Excel skills that appear in almost every office, NGO and government job advertisement in the country.
AW
Instructor
Ahmad Wali Sediqi
4.8(175 reviews)
2,930 learners
3 hours · 16 lessons
Course Overview
A short, dense course built from the tasks a junior analyst is actually given: clean a messy list, summarise it, chart it, and present it. Every lesson uses a real dataset — a school enrolment sheet, a distribution log, a monthly budget — that you download and work through with the instructor.
What you will be able to do
- Clean and structure messy data
- Use VLOOKUP, XLOOKUP, IF and the formulas employers ask about
- Build pivot tables and dashboards
- Produce a monthly report a manager can read
Curriculum
4 sections · 16 lessons · 3 hours
- 1. Cells, rows and rangesFree preview7 min
- 2. Formatting that stays readable14 min
- 3. Sorting and filtering11 min
- 4. Keyboard shortcuts worth learning16 min
- 1. SUM, AVERAGE and COUNTIFFree preview9 min
- 2. IF and nested conditions12 min
- 3. VLOOKUP and XLOOKUP15 min
- 4. Text and date functions8 min
- 1. Pivot tables from scratchFree preview13 min
- 2. Charts that communicate10 min
- 3. Conditional formatting7 min
- 4. Building a simple dashboard14 min
- 1. Structuring a monthly reportFree preview11 min
- 2. Common data mistakes16 min
- 3. Exporting and sharing9 min
- 4. A full report, start to finish8 min
Requirements
- Microsoft Excel, LibreOffice Calc or Google Sheets.
- Comfortable using a computer keyboard and mouse.
Your Teacher
AW
Ahmad Wali Sediqi
Data Analyst, Volunteer
Monitoring and evaluation analyst for humanitarian programmes. Spreadsheets are his first language.
- Jalalabad
- 3 courses
- 2,900 learners
Keep Going
Learners who took this also took
LanguagesFree
4.9(412)
English for Beginners
Start English from zero. Reading, writing, listening and speaking taught in Dari, with practice you can do on a phone.
NK
Najibullah Karimi
Beginner
5h 20m16 lessonsDari & English
FreeView Details
DevelopmentFree
4.8(236)
Web Development with JavaScript
HTML, CSS and JavaScript from the ground up, then React and Next.js — ending with a portfolio site you deploy live.
FS
Farhad Sadat
Intermediate
9 hours17 lessonsDari & English
FreeView Details
Start Today
Launch Yourself Into The Future
Pick one course, give it thirty minutes a day, and see where you are in three months. Every course is free — you can begin this evening, whoever you are and wherever you live.
- Always free
- Nothing to pay, ever
- Study offline