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

What's inside

Syllabus

ملخص المشروع

فى نهاية المشروع ده هتقدر تحمل و تنظم بياناتك بطريقة سهلة و فعالة باستخدام Microsoft Excel. خلال المشروع هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على ال internet. نقدر نستخدم مميزات ال excel فى البحث و الترتيب و التصفية., هتقدر تعالج البيانات عشان تبقى مفيدة فى اتخاذ اى قرار فى ال business . باستخدام ميزة التصفية, هتقدر تظهر البيانات المطلوبة و تخفى الباقى. و بميزة الترتيب, هتقدر ترتب البيانات بتسلسل منطقي بحيث انك توصل لقرار فعال. و آخر ميزة و هي البحث, هتقدر تحدد موقع قيمة خلية معينة في جدول البيانات و تستبدلها تلقائيا بقيمة اخرى و كمان هنتعلم الوظائف اللى ممكن تساعدنا في البحث عن البيانات.هذا المشروع مخصص للأشخاص المبتدئين في excel والمهتمين بمجال البيانات وتحليلها باستخدام أدوات ووظائف EXCEL و ممكن الاشخاص اللى محتاجين excel فى شغلهم. لان كل المجالات تحتاج excel علشان تخلص شغلها بطريقه اسهل واسرع لإنجاز العمل .زي معالجة الكلمات والنصوص واستخدام المعادلات والوظائف والدالات.الأكسل EXCEL هو احد البرامج التي أنتجتها شركة مايكروسوفت العملاقة.وهو أداة عظيمة من أجل حفظ البيانات و التعامل مع الجداول والأرقام لأنك تستطيع من خلال البرنامج ده انك تنجز برنامج مهمات كثيرة بمجرد إتقانك للمعدلات وطريقة كتابتها حيث يحتوي البرنامج على عشرات الدوال الحسابية وتقدر تقدم كتابة مئات المعادلات يستطيع الباحث أن يحصل على معدلات حسابية وقيم المجموع و غيرها من القيم الأكثر تعقيدا بمجرد إدخال البيانات التي تحصل عليها.وبرضو تقدر تنجز عمليات الفرز و التصفية خلال لحظات قليلة.ويقدم لك الكسل خدمة جميلة بتحويل بياناتك على شكل شرائح مصورة وبمختلف الأشكال لدعم مشاريعك.و بالطبع فأن كل برنامج تنتجه شركة مايكروسوفت ويجب أن يكون له أهداف المحددة والواضحة والتي يستفيد منها مستخدمي الكمبيوتر.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

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

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 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

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

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

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

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

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

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 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

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

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

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

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

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

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

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

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

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses