Microsoft Excel حسابات البيانات في from Coursera

هذا المشروع مخصص للأشخاص المبتدئين في excel والمهتمين بالبيانات والتعامل مع البيانات سواء رقمية او نصية و ازاى نطبق الحسابات على البيانات باستخدام وظائف ومعادلات اساسيه.

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

What's inside

Syllabus

ملخص المشروع

فى نهاية المشروع ده هتقدر تكتب المعادلات و الوظائف فى Microsoft excel عشان نقدر نستخدمه فى تحليل البيانات. هتقدر تعمل الصيغة العامة لكتابة المعادلات و الوظائف. هتقدر تحمل ملف بيانات من على جهازك للنسخة المجانية لMicrosoft excel على الانترنت. هتقدر تفرق ما بين الدالات و الوظائف و ازاى تتعامل مع البيانت الرقمية و ازاى نستخدم الوظائف مع البيانات الرقمية زى average و count و max. هنتعلم التعامل مع البيانات النصية. و هنستخدم شوية وظائف مختلفة زى find و next و concatenate. هتقدر كمان تستخدم الوظائف الحسابية الشرطية و اجراء العمليات الحسابة باستخدام ادخال معايير او شروط مناسبة فى Microsoft excel. و اخيرا هنتعلم استخدام وظائف ال networkdays و ال percentage فى Microsoft excel. هيساعدك المشروع ده على تعلم مهارات جديدة فى معالجة البيانات بكفاءة و العمل باستخدام الصيغ اللى ممكن تساعدك فى اتخاذ قرارات ادارية اكتر كفاءة فى المستقبل. هذا المشروع مخصص للأشخاص المبتدئين في excel والمهتمين بالبيانات والتعامل مع البيانات سواء رقمية او نصية و ازاى نطبق الحسابات على البيانات باستخدام وظائف ومعادلات اساسيه. EXCEL هو احد البرامج التي أنتجتها شركة Microsoft العملاقة.وهو أداة عظيمة من أجل حفظ البيانات و التعامل مع الجداول والأرقام لأنك تستطيع من خلال البرنامج ده انك تنجز برنامج مهمات كثيرة بمجرد إتقانك للمعدلات وطريقة كتابتها حيث يحتوي البرنامج على عشرات الدوال الحسابية وتقدر تقدم كتابة مئات المعادلات يستطيع الباحث أن يحصل على معدلات حسابية وقيم المجموع و غيرها من القيم الأكثر تعقيدا بمجرد إدخال البيانات التي تحصل عليها.وبرضو تقدر تنجز عمليات الفرز و التصفية خلال لحظات قليلة.ويقدم لك الاكسل خدمة جميلة بتحويل بياناتك على شكل شرائح مصورة وبمختلف الأشكال

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores how to write equations and functions in Microsoft Excel for data analysis

Provides step-by-step examples of how to apply formulas to data

Covers functions and operations for different data types, including numeric and text

Suitable for beginners with no prior Excel experience

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:

التطوع لمساعدة الآخرين على تعلم Excel

Show steps

ستساعدك مشاركة معرفتك ومهاراتك في Excel مع الآخرين على تعزيز فهمك للمفاهيم الأساسية.

Show steps

ابحث عن فرص تطوعية في منطقتك
اختر فرصة تطوع تناسب مهاراتك واهتماماتك
شارك معرفتك ومهاراتك مع الآخرين

حضور اجتماع لمستخدمي Excel

Show steps

ستمنحك المشاركة في اجتماع لمستخدمي Excel الفرصة للتواصل مع أشخاص آخرين مهتمين باستخدام Excel وتحسين مهاراتك.

Show steps

ابحث عن اجتماع لمستخدمي Excel بالقرب منك
حضر الاجتماع
تفاعل مع الآخرين وتعلم من خبراتهم

المساهمة في مشروع Excel مفتوح المصدر

Show steps

ستمنحك المساهمة في مشروع Excel مفتوح المصدر فرصة لتطبيق مهاراتك ودعم مجتمع المستخدمين.

Show steps

ابحث عن مشروع Excel مفتوح المصدر
اقرأ وثائق المشروع
اقترح تغييرات على المشروع
ساهم في تقديم التغييرات

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

The Data Analyst is responsible for collecting, cleaning, and analyzing data to help organizations make better decisions. As a Data Analyst, you must be able to work with large datasets and use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and create meaningful insights. Furthermore, Data Analysts often need to be able to visualize data in a way that is easy to understand. This course may be helpful in this area, as some of the functions you will learn can be used to transform data into charts and other visuals.

See salaries and explore the career path for Data Analyst

Business Analyst

A Business Analyst is responsible for identifying, analyzing, and solving business problems. Business Analysts must be able to understand the needs of the business and translate them into technical requirements. This course can help Business Analysts develop the skills necessary to analyze data and make recommendations. Furthermore, Business Analysts often need to be able to communicate their findings to non-technical stakeholders. This course may be helpful in this area, as it teaches students how to use Excel functions to create clear and concise reports.

See salaries and explore the career path for Business Analyst

Financial Analyst

The Financial Analyst is responsible for building and refining financial models to make key business decisions. These models depend on accurate data as well as the ability to analyze data and draw conclusions. By learning how to write equations and functions in Microsoft Excel, you will be able to analyze data more efficiently. This will allow you to easily build and update financial models, which can lead to more informed decision-making. Thus, the course 'Microsoft Excel: Data Analysis Using Formulas and Functions' can be useful for those who wish to pursue a career as a Financial Analyst.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

Operations Research Analysts are responsible for using mathematical and analytical techniques to solve business problems. Operations Research Analysts must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help organizations improve their operations.

See salaries and explore the career path for Operations Research Analyst

Statistician

Statisticians are responsible for collecting, analyzing, and interpreting data. Statisticians must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help organizations make better decisions.

See salaries and explore the career path for Statistician

Software Engineer

Software Engineers are responsible for designing, developing, and maintaining software applications. Software Engineers must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and build software applications that can help organizations improve their performance.

See salaries and explore the career path for Software Engineer

Risk Analyst

Risk Analysts are responsible for identifying and assessing risks to organizations. Risk Analysts must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help organizations mitigate risk.

See salaries and explore the career path for Risk Analyst

Data Engineer

Data Engineers are responsible for building and maintaining the infrastructure that stores and processes data. Data Engineers must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and build data infrastructure that can help organizations make better decisions.

See salaries and explore the career path for Data Engineer

Quantitative Analyst

Quantitative Analysts are responsible for using mathematical and statistical models to analyze data and make investment decisions. Quantitative Analysts must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help investors make better decisions.

See salaries and explore the career path for Quantitative Analyst

Auditor

Auditors are responsible for examining and verifying financial records to ensure that they are accurate and compliant. Auditors must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make sure that the company's financial records are accurate.

See salaries and explore the career path for Auditor

Accountant

Accountants are responsible for preparing and maintaining financial records. Accountants must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make sure that the company's financial records are accurate.

See salaries and explore the career path for Accountant

Management Consultant

Management Consultants are responsible for helping organizations improve their performance. Management Consultants must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help organizations improve their performance.

See salaries and explore the career path for Management Consultant

Budget Analyst

Budget Analysts are responsible for developing and managing budgets. Budget Analysts must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make sure that the company's budget is accurate and efficient.

See salaries and explore the career path for Budget Analyst

Data Scientist

Data Scientists are responsible for using data to solve business problems. Data Scientists must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and make recommendations that can help organizations make better decisions. While this course does not cover all of the skills and knowledge required to become a Data Scientist, it does provide a solid foundation.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

Machine Learning Engineers are responsible for building and deploying machine learning models. Machine Learning Engineers must be able to use Excel functions to perform calculations and analysis. This course will help you develop the skills necessary to effectively work with data and build machine learning models that can help organizations make better decisions.

See salaries and explore the career path for Machine Learning Engineer