Microsoft Excel

Learn to Create Tables and Charts

4.8(75)3h 31m11 lectures1 sections

What you'll learn

  • Understand Excel interface and settings
  • Master data entry and table creation
  • Use functions to handle data efficiently
  • Create charts for data analysis
  • Design pivot tables for data insights
  • Apply calculations using Excel

About this course

Excel is one of the most important programs available, specializing in designing tables, performing calculations, and preparing various types of reports. It is an essential tool for every computer user, despite being classified as accounting software. This course is your pathway to learning how to use its core features step by step without complications. You will explore the worksheet, learn how to create tables, write formulas, perform calculations, and discover how to extract reports and create charts.

Expected outcomes

  • Ability to create professional spreadsheets using Excel.
  • Format data and use functions and formulas efficiently.
  • Analyze data using charts and pivot tables.
  • Prepare documents for printing and format pages meticulously.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.8
★★★★★
75 reviews
5★
62
4★
10
3★
3
2★
0
1★
0
  • ★★★★★Khaled A.·منذ 1 أسبوعشاهد 64٪
  • ★★★★★Mohammed·منذ 3 أسبوعشاهد 100٪

    شرح ممتاز يغطي الأساسيات والوظائف المتقدمة في إكسل بأسلوب عملي جداً يسهل عليك إدارة بياناتك

  • ★★★★★أحمد ع.·منذ 4 أسبوعشاهد 55٪

    دورة ممتازة جداً وفيها أساسيات اكسل بشكل مبسط وجميل جداً أستاذ احمد حسن خميس عامل مجهود جبار بصراحه وشكراً بجد لمنصة ايزيتي

  • ★★★★★محمد ا.·منذ 1 شهرشاهد 100٪

    كورس ممتاز كاساس قوي يصلح لاي نوع من اصدرات اكسيل

تم عرض كل التقييمات (4)

Course content

1

Learning Microsoft Excel

11 lectures
  1. Getting to Know the Program Interface and Adjusting the Viewport33:17
  2. Data Entry and Creating Your First Table15:17
  3. Basics of Writing Equations14:47
  4. Advanced Skills for Writing Equations11:18
  5. Working with Functions31:39
  6. Basic Formatting Skills19:49
  7. Conditional Formatting and Automatic Formatting14:53
  8. Sorting and Filtering Data21:35
  9. Data Protection and Validation Rules16:44
  10. Charts and Pivot Tables16:02
  11. Printing and Page Formatting16:19

Instructor

Ahmed Hassan Khamis

Ahmed Hassan Khamis

He has developed computer science curricula for various Arab universities and taught at Alexandria University. He has authored over 120 educational books in computer science.
102.7K students39 courses