Skip to content

Microsoft Excel

Spreadsheets from basics to analysis: interface, data entry and formatting; formulas, references and core functions; conditional and lookup functions (IF, SUMIFS, XLOOKUP); tables, sorting, filtering and PivotTables; charts and simple dashboards; data accuracy, printing and sharing; and a complete gradebook or budget project.

  • BeginnerNo prior experience needed
  • 24 hTotal content time
  • 15 lessonsOrdered from basics to practice
  • In ArabicWith technical terms in English

About this course

Spreadsheets from basics to analysis: interface, data entry and formatting; formulas, references and core functions; conditional and lookup functions (IF, SUMIFS, XLOOKUP); tables, sorting, filtering and PivotTables; charts and simple dashboards; data accuracy, printing and sharing; and a complete gradebook or budget project.

Academy-authored content.

Course highlights

  • Enter, organise and format data in worksheets
  • Write formulas with correct references and core functions
  • Use conditional and lookup functions to answer questions
  • Summarise and visualise data with tables, PivotTables and charts
  • Keep spreadsheets accurate, readable and shareable

The practical result

What you’ll build in this course

Spreadsheets from basics to analysis: interface, data entry and formatting; formulas, references and core functions; conditional and lookup functions (IF, SUMIFS, XLOOKUP); tables, sorting, filtering and PivotTables; charts and simple dashboards; data accuracy, printing and sharing; and a complete gradebook or budget project.

Final lesson: Lesson 5.3

Is this course for you?

Who it’s for

  • school and university students, office staff, small-business owners

Requirements

  • basic computer use and arithmetic

Course content

  • 7units
  • 15sessions
  • 6quizzes
Unit 13 sessions
  1. Lesson 1.1
  2. Lesson 1.2
  3. Lesson 1.3
Unit 23 sessions
  1. Lesson 2.1
  2. Lesson 2.2
  3. Lesson 2.3
Unit 33 sessions
  1. Lesson 3.1
  2. Lesson 3.2
  3. Lesson 3.3
Unit 43 sessions
  1. Lesson 4.1
  2. Lesson 4.2
  3. Lesson 4.3
Unit 53 sessions
  1. Lesson 5.1
  2. Lesson 5.2
  3. Lesson 5.3
Quizzes0 sessions · 6 quizzes
  1. Quiz 1
  2. Quiz 2
  3. Quiz 3
  4. Quiz 4
  5. Quiz 5
  6. Final exam
Projects and assignments0 sessions
  1. Assignment 1
  2. Assignment 2
  3. Assignment 3

The lecturer

Lecturer

Eng. Abdelmaksoud

Your next step

Courses close to this one

  • Physics – Secondary Grade 2

    Support for the developed 2026/27 S2 physics book: measurement, straight-line motion and Newton's laws, moving and static fluids, and the gas laws…

    • Level: All levels
    • Taught in Arabic · all content in Arabic
    • Based on the 2025/26 edition

    Coming soon

  • Mathematics – Secondary Grade 2

    Support for the 2026/27 S2 scientific pure-mathematics and applications books (term 1): real functions and curve sketching, exponents and logarithms, limits and…

    • Level: All levels
    • Taught in Arabic · all content in Arabic
    • Based on the 2025/26 edition

    Coming soon

  • General Mathematics – Secondary Grade 2

    Real functions, monotonicity, even and odd functions, transformations, absolute-value equations and inequalities; rational exponents, exponential functions and equations, logarithms and their properties;…

    • Level: All levels
    • Taught in Arabic · all content in Arabic
    • Based on the 2025/26 edition

    Coming soon