We may earn an affiliate commission when you visit our partners.

Microsoft Excel بحث و ترتيب وتصفية البيانات فى

Omnya Khaled

فى نهاية الفيديو 5 ، ستكون قادرًا على استخدام وظيفة vlookup عشان نحدد قيمة عمود من خلال عمود اخر.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Two deals to help you save

Save money when you learn. Here are two deals and offers that may be relevant to this course.

All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid until July 14

Coursera Plus Annual

Work toward what's next for your career with access to 10,000+ programs. Discover emerging skills and save.

Valid until August 30

Google AI App Builder

Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind

What's inside

Syllabus

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Teaches VLOOKUP functions, which helps learners find specific data in a spreadsheet

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

دورة إكسل عملية للمبتدئين في تحليل البيانات

وفقاً للمتعلمين، تقدم هذه الدورة مقدمة عملية ومفيدة للغاية في استخدام Microsoft Excel لفرز البيانات وتصفيتها والبحث فيها. يجد العديد من الطلاب أن المحتوى واضح ومباشر، مما يجعله مثالياً للمبتدئين الذين يسعون لتطوير مهاراتهم في تحليل البيانات. تُبرز المراجعات بشكل متكرر أن الدورة توفر أساساً قوياً للاستخدام العملي في المهام اليومية والبيئة المهنية. على الرغم من أن بعض المراجعات تشير إلى أن الدورة قد تكون بسيطة جداً للمستخدمين ذوي الخبرة، إلا أن الإجماع العام يؤكد على فعاليتها في تدريس وظائف Excel الأساسية مثل الفلترة والفرز بطريقة سهلة الفهم والتطبيق. كما أُشيد بالتمارين التطبيقية لكونها تساعد على ترسيخ الفهم.

أسلوب شرح هادئ ومريح للمتابعة.

"صوت المحاضر هادئ وواضح، الشرح سلس وغير ممل، مما يجعل تجربة التعلم ممتعة."

"أعجبني أسلوب المحاضر في تبسيط المعلومات المعقدة، لم أشعر بالملل أبداً أثناء متابعة الدروس."

"المحاضر ممتاز ويقدم المعلومات بطريقة مفهومة للغاية للمبتدئين، وهذا ما جعلني أستوعب بسرعة."

توفر مهارات Excel قابلة للتطبيق مباشرة في العمل.

"استفدت كثيراً من الدورة وطبقت ما تعلمته في عملي مباشرة، خصوصاً في تنظيم البيانات."

"المحتوى عملي جداً ويساعدني في إنجاز مهامي اليومية بكفاءة أكبر، وهو ما كنت أبحث عنه بالضبط."

"لقد وجدت أدوات الفرز والتصفية مفيدة بشكل لا يصدق لعملي، فقد اختصرت عليّ الكثير من الوقت والجهد."

شرح واضح ومناسب جداً للمبتدئين في Excel.

"الدورة ممتازة جداً للمبتدئين، كل شيء مشروح بوضوح تام، وقد ساعدني ذلك على فهم الأساسيات بسهولة."

"أرى أن هذه الدورة هي الأنسب تمامًا للمبتدئين الذين يحتاجون إلى فهم Excel من الأساس، الشرح كان مبسطاً للغاية."

"الشرح مبسط وسهل المتابعة، يساعدني كثيرًا في فهم أدوات Excel الأساسية بسرعة وبدون تعقيد."

جزء VLOOKUP قد يكون بحاجة لمزيد من التفصيل.

"شعرت أن جزء الـ VLOOKUP كان سريعاً قليلاً، أردت المزيد من الأمثلة والتطبيقات المتنوعة."

"أتمنى لو تم تخصيص وقت أكبر لشرح دالة VLOOKUP، لأنها دالة مهمة جداً وتحتاج لشرح أعمق."

"فهمت الأساسيات، لكن لتطبيق VLOOKUP بكفاءة أحتاج لمصادر إضافية أو شرح أكثر تفصيلاً."

قد تكون أساسية جداً لمن لديهم معرفة مسبقة بـ Excel.

"الدورة كانت بسيطة جداً بالنسبة لي، لم أجد فيها جديداً يذكر، كنت أتوقع تغطية أعمق للمواضيع."

"تمنيت لو كان هناك المزيد من العمق أو مواضيع متقدمة، خصوصاً في التعامل مع البيانات المعقدة."

"إذا كنت مستخدماً متمرساً لبرنامج Excel، فقد تجد هذه الدورة مجرد مراجعة سريعة للمبادئ الأساسية لا أكثر."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel بحث و ترتيب وتصفية البيانات فى with these activities:

Complete Excel Practice Drills

Show steps

Practice using Excel formulas and functions to solidify your understanding of the material covered in this course.

Browse courses on Microsoft Excel

Show steps

Open a new Excel workbook and practice using the VLOOKUP function to retrieve data from a table.
Practice using the INDEX and MATCH functions to find and extract specific data from a table.
Use the SUMIF function to calculate the total sales for a specific product category.

Create a Visual Guide to Excel Functions

Show steps

Create a visual guide that summarizes the key Excel functions covered in this course.

Browse courses on Excel Functions

Show steps

Choose a specific topic related to Excel functions, such as lookup functions or statistical functions.
Research and gather information about the chosen topic.
Create a visually appealing guide that includes clear explanations, examples, and screenshots.
Share your guide with others to help them learn about Excel functions.

Develop an Excel-Based Budgeting Tool

Show steps

Create an Excel-based budgeting tool that you can use to manage your personal finances.

Browse courses on Excel

Show steps

Define your budgeting goals and objectives.
Identify the income and expense categories that you want to track.
Design the layout and structure of your budgeting tool in Excel.
Enter your financial data and use Excel formulas to calculate your budget.
Analyze your budget and make adjustments as needed.

Show all three activities

Career center

Learners who complete Microsoft Excel بحث و ترتيب وتصفية البيانات فى will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data to help businesses make better decisions. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Data Analyst

Business Analyst

A Business Analyst helps businesses to improve their performance by analyzing data and identifying opportunities for improvement. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Business Analyst

Market Researcher

A Market Researcher conducts research to help businesses understand their customers and make better decisions. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Market Researcher

Financial Analyst

A Financial Analyst helps businesses to make sound financial decisions. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

An Operations Research Analyst uses data to help businesses improve their operations. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Operations Research Analyst

Data Scientist

A Data Scientist uses data to help businesses make better decisions. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Data Scientist

Statistician

A Statistician collects, analyzes, and interprets data to help businesses make better decisions. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Statistician

Database Administrator

A Database Administrator is responsible for managing and maintaining databases. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Database Administrator

Information Systems Manager

An Information Systems Manager is responsible for managing and maintaining an organization's information systems. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Information Systems Manager

Chief Technology Officer

A Chief Technology Officer is responsible for leading an organization's technology strategy. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Chief Technology Officer

Software Engineer

A Software Engineer designs, develops, and maintains software applications. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Software Engineer

Data Engineer

A Data Engineer builds and maintains data pipelines. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Data Engineer

Machine Learning Engineer

A Machine Learning Engineer builds and maintains machine learning models. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Machine Learning Engineer

Artificial Intelligence Engineer

An Artificial Intelligence Engineer builds and maintains artificial intelligence systems. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Artificial Intelligence Engineer

Data Architect

A Data Architect designs and builds data architectures. This course may be useful in preparing for this role, as it will provide you with the skills necessary to work with data, including how to use functions to search for data, sort data, and filter data.

See salaries and explore the career path for Data Architect

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Microsoft Excel بحث و ترتيب وتصفية البيانات فى.