Skip to content

Excel for Accounting

Organised, reliable accounting books in Excel: a structured journal with drop-downs, VAT calculation and rounding; ledgers and trial balance with SUMIFS and error flags; aging from dates and bank reconciliation; depreciation with SLN, DDB and DB; loan schedules with PMT; the NPV() pitfall; and pivot reports, charts and workbook protection.

  • IntermediateBest if you know the basics
  • 20 hTotal content time
  • 15 lessonsOrdered from basics to practice
  • In ArabicWith technical terms in English

About this course

Organised, reliable accounting books in Excel: a structured journal with drop-downs, VAT calculation and rounding; ledgers and trial balance with SUMIFS and error flags; aging from dates and bank reconciliation; depreciation with SLN, DDB and DB; loan schedules with PMT; the NPV() pitfall; and pivot reports, charts and workbook protection.

Academy-authored content.

Course highlights

  • Build a structured, validated journal with correct VAT and rounding
  • Produce ledgers and a self-checking trial balance with formulas
  • Automate receivables aging and bank reconciliation
  • Build depreciation and loan schedules and use financial functions correctly
  • Report with pivot tables and charts and protect and document the workbook

Is this course for you?

Who it’s for

  • business-track secondary learners, commerce students, bookkeepers and small-business owners

Requirements

  • CRS-GEN-ACC-FUNDAMENTALS; basic spreadsheet use (CRS-GEN-MS-EXCEL helps)

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

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