Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال from Coursera

هذا المشروع مخصص للأشخاص المتوسطين في excel والمهتمين بالبيانات و ازاي نعدلها ونحللها باستخدام جداول ال pivots. و بطريقة عرض تقارير بالمخططات. لان كل المجالات تحتاج excel علشان تخلص شغلها بطريقه اسهل واسرع لانجاز و عمل المخططات زى مخططات ال pie, و الline و ال radar و هكذا.

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

What's inside

Syllabus

ملخص المشروع

فى نهاية المشروع ده هتقدر تنشئ مخططات و جداول pivot و رسوم بيانية متقدمة لتحليل بياناتك بطريقة سهلة و فعالة باستخدام Microsoft Excel. خلال المشروع هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على الانترنت. و هتقدر تطبق جداول ال pivots على البيانات عشان تعمل ملخص و تحليل للبيانات سهل اننا نقراها بالعين. و هتقدر تعمل مخططات من جداول ال pivots. زى مخططات ال pie, column, و line. هتقدر كمان ترسم عمودين مختلفين فى نفس المخطط للمقارنة مابينهم. و تعمل تنسيق للمخططات, لعرض فى التقارير و لوحات المعلومات بصورة افضل و احسن. و اخيرا هتقدر تنفذ المخططات المتقدمة زى radar و multi category charts.هذا المشروع مخصص للأشخاص المتوسطين في excel والمهتمين بالبيانات و ازاي نعدلها ونحللها باستخدام جداول ال pivots و بطريقة عرض تقارير بالمخططات. لان كل المجالات تحتاج excel علشان تخلص شغلها بطريقه اسهل واسرع لانجاز و عمل المخططات زى مخططات ال pie, و الline و ال radar و هكذا.EXCEL هو احد البرامج التي أنتجتها شركة Microsoft العملاقة.وهو أداة عظيمة من أجل حفظ البيانات و التعامل مع الجداول والأرقام لأنك تستطيع من خلال البرنامج ده انك تنجز برنامج مهمات كثيرة بمجرد إتقانك للمعدلات وطريقة كتابتها حيث يحتوي البرنامج على عشرات الدوال الحسابية وتقدر تقدم كتابة مئات المعادلات يستطيع الباحث أن يحصل على معدلات حسابية وقيم المجموع و غيرها من القيم الأكثر تعقيدا بمجرد إدخال البيانات التي تحصل عليها.وبرضو تقدر تنجز عمليات الفرز و التصفية خلال لحظات قليلة.ويقدم لك الكسل خدمة جميلة بتحويل بياناتك على شكل شرائح مصورة وبمختلف الأشكال لدعم مشاريعك.و بالطبع فأن كل برنامج تنتجه شركة Microsoft ويجب أن يكون له أهداف المحددة والواضحة والتي يستفيد منها مستخدمي الكمبيوتر.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

يطور مهارات تحليل البيانات من خلال استخدام جداول Pivot

يقدم تنسيقات متعددة للمخططات، مما يجعلها أكثر فاعلية في إظهار البيانات

مناسب للمتعلمين المتوسطين في Excel، مما يجعله نقطة انطلاق جيدة لتحسين المهارات

يغطي تحليل البيانات، وهو مجال ضروري في مختلف الصناعات

يقدم أمثلة عملية لتطبيق جداول Pivot والمخططات على البيانات، مما يجعله أكثر قابلية للفهم

Activities

Coming soon We're preparing activities for Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال . These are activities you can do either before, during, or after a course.

Career center

Learners who complete Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال 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 identify patterns and trends. This data can be used to make informed decisions about products, services, and marketing campaigns. The course on Excel and PivotCharts can help Data Analysts develop the skills needed to clean and analyze data, which is essential for success in this role. Additionally, the course can help Data Analysts learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Data Analyst

Market Researcher

A Market Researcher is responsible for gathering and analyzing data about consumer behavior. This data can be used to develop marketing campaigns, products, and services that are tailored to the needs of the target audience. The course on Excel and PivotCharts can help Market Researchers develop the skills needed to collect and analyze data, which is essential for success in this role. Additionally, the course can help Market Researchers learn how to create visualizations that can be used to communicate research findings to stakeholders.

See salaries and explore the career path for Market Researcher

Financial Analyst

A Financial Analyst is responsible for analyzing financial data to make recommendations about investments. This data can be used to make decisions about which stocks to buy or sell, and how to allocate assets. The course on Excel and PivotCharts can help Financial Analysts develop the skills needed to analyze financial data, which is essential for success in this role. Additionally, the course can help Financial Analysts learn how to create visualizations that can be used to communicate financial insights to stakeholders.

See salaries and explore the career path for Financial Analyst

Business Analyst

A Business Analyst is responsible for analyzing business processes to identify areas for improvement. This data can be used to develop solutions that can improve efficiency and profitability. The course on Excel and PivotCharts can help Business Analysts develop the skills needed to analyze business processes, which is essential for success in this role. Additionally, the course can help Business Analysts learn how to create visualizations that can be used to communicate analysis findings to stakeholders.

See salaries and explore the career path for Business Analyst

Data Scientist

A Data Scientist is responsible for developing and implementing data-driven solutions to business problems. This data can be used to make predictions, identify trends, and develop new products and services. The course on Excel and PivotCharts can help Data Scientists develop the skills needed to analyze data and build predictive models, which is essential for success in this role. Additionally, the course can help Data Scientists learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Data Scientist

Operations Research Analyst

An Operations Research Analyst is responsible for using mathematical and analytical techniques to solve business problems. This data can be used to improve efficiency, productivity, and profitability. The course on Excel and PivotCharts can help Operations Research Analysts develop the skills needed to analyze data and build mathematical models, which is essential for success in this role. Additionally, the course can help Operations Research Analysts learn how to create visualizations that can be used to communicate analysis findings to stakeholders.

See salaries and explore the career path for Operations Research Analyst

Management Consultant

A Management Consultant is responsible for advising businesses on how to improve their performance. This data can be used to develop strategies for growth, efficiency, and profitability. The course on Excel and PivotCharts can help Management Consultants develop the skills needed to analyze data and make recommendations to clients, which is essential for success in this role. Additionally, the course can help Management Consultants learn how to create visualizations that can be used to communicate analysis findings to stakeholders.

See salaries and explore the career path for Management Consultant

Actuary

An Actuary is responsible for assessing the financial risks associated with insurance policies. This data can be used to set premiums and develop new insurance products. The course on Excel and PivotCharts can help Actuaries develop the skills needed to analyze data and build financial models, which is essential for success in this role. Additionally, the course can help Actuaries learn how to create visualizations that can be used to communicate analysis findings to stakeholders.

See salaries and explore the career path for Actuary

Statistician

A Statistician is responsible for collecting, analyzing, and interpreting data. This data can be used to make informed decisions about products, services, and marketing campaigns. The course on Excel and PivotCharts can help Statisticians develop the skills needed to clean and analyze data, which is essential for success in this role. Additionally, the course can help Statisticians learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Statistician

Quantitative Analyst

A Quantitative Analyst is responsible for developing and implementing mathematical and statistical models to solve business problems. This data can be used to make predictions, identify trends, and develop new products and services. The course on Excel and PivotCharts can help Quantitative Analysts develop the skills needed to analyze data and build predictive models, which is essential for success in this role. Additionally, the course can help Quantitative Analysts learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Quantitative Analyst

Data Engineer

A Data Engineer is responsible for designing, building, and maintaining data pipelines. This data can be used to support data analysis, machine learning, and other data-driven applications. The course on Excel and PivotCharts can help Data Engineers develop the skills needed to design and build data pipelines, which is essential for success in this role. Additionally, the course can help Data Engineers learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Data Engineer

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. This software can be used to support a variety of business needs, including data analysis, machine learning, and other data-driven applications. The course on Excel and PivotCharts can help Software Engineers develop the skills needed to design and develop software applications, which is essential for success in this role. Additionally, the course can help Software Engineers learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Software Engineer

Business Intelligence Analyst

A Business Intelligence Analyst is responsible for analyzing data to identify trends and make recommendations to improve business performance. This data can be used to support a variety of business decisions, including product development, marketing campaigns, and customer service. The course on Excel and PivotCharts can help Business Intelligence Analysts develop the skills needed to analyze data and make recommendations to stakeholders, which is essential for success in this role. Additionally, the course can help Business Intelligence Analysts learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Business Intelligence Analyst

Data Visualization Specialist

A Data Visualization Specialist is responsible for creating visualizations that communicate data insights to stakeholders. This data can be used to support a variety of business decisions, including product development, marketing campaigns, and customer service. The course on Excel and PivotCharts can help Data Visualization Specialists develop the skills needed to create effective visualizations, which is essential for success in this role. Additionally, the course can help Data Visualization Specialists learn how to use Excel and PivotCharts to create visualizations that are both visually appealing and informative.

See salaries and explore the career path for Data Visualization Specialist

Information Architect

An Information Architect is responsible for designing the structure and organization of information systems. This data can be used to support a variety of business needs, including data analysis, machine learning, and other data-driven applications. The course on Excel and PivotCharts can help Information Architects develop the skills needed to design and organize information systems, which is essential for success in this role. Additionally, the course can help Information Architects learn how to create visualizations that can be used to communicate data insights to stakeholders.

See salaries and explore the career path for Information Architect