إنشاء المخططات و لوحات المعلومات باستخدام Microsoft Excel from Coursera

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

What's inside

Syllabus

ملخص المشروع

فى نهاية المشروع هتقدر تنفذ مخططات فى Microsoft excel, عشان تحلل بيانات الاكل بتاعة Starbucks. خلال المشروع هتقدر تعمل جداول pivots عشان تساعدنا اننا نوصل للمعلومات اسهل و اسرع و تظهر المعلومات من جداول ال pivot على هيئة مخططات line, bar و pie. و هتقدر تعمل المخططات وازاى تعمل format للمخططات دى عشان يبقوا سهلين و مناسبين للعرض فى التقارير. و اخر حاجة هتقدر تستعمل جدوال ال pivots و المخططات فى ال dashboard, عشان توصل لصورة كاملة لكل التحاليل بتاعة البيانات. المشروع مخصص للأشخاص المبتدئين اللى عندهم خبرة بسيطة في Microsoft excel. و اللى مهتمين بالخطوات الرئيسية لمحلل البيانات و طريقة عرضها تقارير بالمخططات و لوحات المعلومات. هناك أسباب كثيرة بتخلى استخدام جداول البيانات في مؤسسات الأعمال أمر مهم. جداول البيانات زى ال microsoft excel لا تقدر بثمن لحساب البيانات. تكتب البيانات و الأرقام ، و بتدخل الوظائف بطريقة صحيحة ، و بعد كده جدول البيانات بيقوم بحساب الأرقام بالنيابة عنك فى لحظات وكمان يقوم برسم التصور الأمثل لتقارير البيانات بطريقة أفضل و عمل المخططات و لوحة البيانات.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Taught by Abdelrahman Tarek Hafez, an expert in this field

Develops core skills in data analysis

Provides a strong foundation for beginners in data analysis

Covers essential data analysis tools and techniques that are highly relevant to industry

May require additional resources for learners with no prior experience in data analysis

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:

تمرين إنشاء مخططات من جدول pivot

Show steps

يساعد هذا التمرين على تعزيز فهمك لجداول pivot ومخططات Microsoft Excel، وهي مهارات أساسية لمحللي البيانات.

Browse courses on PivotTables

Show steps

تحديد مجموعة البيانات
إنشاء جدول pivot
اختيار حقول البيانات المناسبة لصفوف وأعمدة مخطط pivot
إنشاء المخططات من جدول pivot (خطي، عمودي، دائري)

مشاركة العمل والتعاون مع زملاء الدراسة

Show steps

يمكن أن يكون العمل الجماعي والتعاون مع الزملاء طريقة رائعة لتبادل الأفكار والحصول على ردود فعل على عملك.

Show steps

تكوين مجموعة دراسة أو الانضمام إليها
مشاركة مخططاتك ولوحات معلوماتك مع المجموعة
تقديم التعليقات وتلقيها على التحليلات والتصورات

تطبيق تنسيقات مختلفة على المخططات

Show steps

سيساعدك هذا التمرين على إتقان تنسيقات المخططات، وهي مهارة مهمة لعرض البيانات بشكل واضح وموجز.

Browse courses on Microsoft Excel

Show steps

تغيير ألوان الأعمدة والخطوط والنقاط
إضافة عناوين المحاور والتسميات
ضبط حجم الخط والنوع
حفظ المخطط بتنسيق مناسب للعرض

One other activity

Expand to see all activities and additional details

Show all four activities

استخدام لوحات المعلومات لتصور تحليلات البيانات

Show steps

ستزودك هذه التدريبات العملية بالمهارات اللازمة لإنشاء لوحات معلومات فعالة، وهي أداة قوية لتلخيص البيانات المعقدة وإيصال النتائج الرئيسية.

Browse courses on Microsoft Excel

Show steps

جمع وتنظيم البيانات من مصادر متعددة
إنشاء لوحة معلومات جديدة
إضافة عناصر لوحة المعلومات (مثل المخططات وجداول pivot)
تخصيص لوحة المعلومات وفقًا لمتطلبات العرض

Career center

Learners who complete إنشاء المخططات و لوحات المعلومات باستخدام Microsoft Excel will develop knowledge and skills that may be useful to these careers:

Market Researcher

Market Researchers use data to understand consumer behavior and trends. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in market research. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Market Researchers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Market Researcher

Data Scientist

Data Scientists use data to build predictive models and solve business problems. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in data science. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Data Scientists, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts help businesses improve their performance by analyzing data and identifying opportunities for improvement. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in business analysis. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Business Analysts, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts use data to solve business problems. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in data analysis. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Data Analysts, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use data to make investment decisions. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in financial analysis. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Financial Analysts, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Financial Analyst

Operations Manager

Operations Managers use data to improve the efficiency and effectiveness of operations. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in operations management. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Operations Managers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Operations Manager

Marketing Manager

Marketing Managers use data to develop and execute marketing campaigns. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in marketing management. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Marketing Managers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Marketing Manager

Project Manager

Project Managers use data to plan and track projects. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in project management. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Project Managers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Project Manager

Sales Manager

Sales Managers use data to track and improve sales performance. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in sales management. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Sales Managers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Sales Manager

Product Manager

Product Managers use data to develop and improve products. This course in creating charts and dashboards using Microsoft Excel can help build a foundation in product management. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data. These skills are essential for Product Managers, who need to be able to communicate data insights to stakeholders.

See salaries and explore the career path for Product Manager

Data Architect

Data Architects design and manage data systems. This course in creating charts and dashboards using Microsoft Excel may be useful for Data Architects who want to learn more about data visualization. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data.

See salaries and explore the career path for Data Architect

Software Engineer

Software Engineers design and develop software. This course in creating charts and dashboards using Microsoft Excel may be useful for Software Engineers who want to learn more about data visualization. Students will learn how to use pivot tables to summarize and analyze data, and how to create charts and graphs to visualize data.

See salaries and explore the career path for Software Engineer

Graphic designer

Graphic Designers create visual concepts. This course in creating charts and dashboards using Microsoft Excel may be useful for Graphic Designers who want to learn more about data visualization.

See salaries and explore the career path for Graphic designer

Database Administrator

Database Administrators manage and maintain databases. This course in creating charts and dashboards using Microsoft Excel may be useful for Database Administrators who want to learn more about data visualization.

See salaries and explore the career path for Database Administrator

Web Developer

Web Developers design and develop websites. This course in creating charts and dashboards using Microsoft Excel may be useful for Web Developers who want to learn more about data visualization.

See salaries and explore the career path for Web Developer