AI & Data
FreePython Programming Foundations
Learn Python from absolute zero — the language behind AI, data work, and automation.
Beginner · 14 lessons · 9 hours · English + Urdu
AI & Data
Spreadsheets for Data Analysis
Spreadsheets are where most data analysis jobs start, and most people only use a fraction of what they can do. This course teaches you to clean messy data, summarise it with formulas and pivot tables, and present it in charts that answer real questions. You will work with example sales and expense data throughout, so every skill is practised on realistic numbers. No statistics background is needed.
Beginner · 13 lessons · 7 hours · English + Urdu · Part of the Data Analyst Roadmap
What you will learn
- Clean messy data: duplicates, blanks, and inconsistent formats
- Use essential formulas: SUM, AVERAGE, IF, COUNTIF and VLOOKUP/XLOOKUP
- Sort, filter, and conditionally format large tables
- Summarise data in seconds with pivot tables
- Choose and build the right chart for a question
- Present a small analysis clearly in a one-page sheet
Curriculum
Module 1: Spreadsheet Essentials and Clean Data
- Rows, Columns and How Analysts Organise DataFree preview9 min
- Cleaning Data: Duplicates, Blanks and Bad Formats12 min
- Sorting, Filtering and Conditional Formatting11 min
- Module Quiz: Clean Data EssentialsQuiz
Module 2: Formulas that Do the Analysis
- Core Formulas: SUM, AVERAGE, COUNT and IF13 min
- SUMIF, COUNTIF and Working with Dates12 min
- Looking Up Values with VLOOKUP and XLOOKUP13 min
- Module Quiz: Analysis FormulasQuiz
Module 3: Pivot Tables and Charts
- Pivot Tables: Summaries Without Formulas13 min
- Choosing the Right Chart for Your Message11 min
- Building a Clean One-Page Summary12 min
- Reading: Spreadsheet Habits that Prevent Costly Errors6 min
- Module Quiz: Pivots and ChartsQuiz
Project: Analyse a Year of Shop Sales Data in a Spreadsheet — you finish this course by building it, not just by watching.
Requirements
- Basic computer use and simple arithmetic
- Access to Microsoft Excel or a free Google Sheets account
- No previous data experience required
Frequently asked questions
Is Spreadsheets for Data Analysis really free?
Yes. This course is free and open. Its lessons use public learning videos with FUTEAC summaries, tasks and quizzes. An optional verified certificate is available after completion.
Do I get a certificate?
You receive a completion record when you finish the course and pass its quizzes. A verifiable certificate with a public verification link is available as an optional upgrade.
What do I need before starting?
Check the Requirements section on this page. If a course builds on an earlier one, we say so there — and the roadmap shows you the right order.
Related courses
AI & Data
FreeAI & Machine Learning: First Steps
Understand what AI and machine learning actually are, and train your first models on real data with Python.
Beginner · 13 lessons · 10 hours · English