Advanced Features in Excel
الخصائص المتقدمة في برنامج الجداول الالكترونية اكسل

by Mr. Esam Al-Sawi

Excel is considered one of the main tools for calculations and data manipulation. It can be used for simple data entry. Yet, it is so flexible and powerful to the extent that it can be used for complex data analyses and reporting. The number of different ways it can used is beyond counting. Having knowledge in Excel is a key for success in today’s engineering and business world.


  1. Use common Excel functions
  2. Work with logical functions: “if” statements
  3. Understand and use absolute and relative references of cells and ranges
  4. automatically format cells using Conditional Formatting
  5. use lookup functions (VLOOKUP, HLOOKUP, INDEX)
  6. merge different tables using lookup functions
  7. Create graphs from your data
  8. Efficiently use Excel with shortcuts 
  9. Create documents automatically using Mail Merge feature

  Submitting your request... Please wait.

Eligibility to this course?

المؤهلين للإلتحاق بالدورة

Students of third and fourth year (Junior & Senior) having a cumulative average (GPA > 2) or higher.
طــلاب السنــة الثالثـة والرابـعـــة والحـــاصلين على معدّل تراكمي جيّد أو أعلى

Dates and Timing

المكان و الموعد

From 6:00 PM to 9:00PM with a 30-minute break

Building 63, Room 331
بعد صلاة المغرب من الساعة 6:00 مساءً إلى الساعة 9:00 مساء

مبنى 63, قاعة 331

Certificate Requirements

شروط الحصول على شهادة الدورة

  1. active participation
  2. access to PASS mark at the end of the session.
  3. To participate in the evaluation session.
  1. المشاركة الفاعلة
  2. الحصول على علامة PASS في ختام الدورة
  3. المشاركة في تقييم الدورة