مهارات الإكسل الخاصة التجارية: المستوى المتوسط الثاني from Coursera

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

التحقق من الأخطاء ومنع حدوثها في جداول البيانات;

وإنشاء أتمتة قوية في جداول البيانات;

وتطبيق الصيغ المتقدمة والمنطق الشرطي للمساعدة في اتخاذ قرارات عمل مدروسة; و

وإنشاء جداول بيانات تساعد في توقع البيانات وقولبتها.

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

What's inside

Syllabus

التحقق من صحة البيانات

نبدأ هذا المساق بالتحقق من صحة البيانات والتنسيق الشرطي. تأخذك هذه الوحدة خلال إنشاء التحقق من صحة البيانات وتطبيقه، بالإضافة إلى التعامل مع الصيغ في التحقق من صحة البيانات. ويتبع ذلك التنسيق الشرطي الأساسي والمتقدم.

المنطق الشرطي

يحتوي برنامج الإكسل على العديد من الدوال المنطقية وتستكشف هذه الوحدة بعضها. بدء تعلم مفهوم المنطق الشرطي في الصيغ، متبوعًا بكيفية إجراء اختبارات المنطق واستخدام المعاملات الشرطية لصالحك. سنتطلع إلى دالات IF المتداخلة لتقييم البيانات.

عمليات البحث الآلية

كيف يمكن إيجاد المعلومات من أجزاء أخرى في المصنفات؟ يقدم لك هذا النموذج بعض الدوال مثل دالة CHOOSE ودالة VLOOKUP ودالة INDEX وmatch وغيرها من محركات وعمليات البحث الديناميكية لإيجاد وعرض البيانات من مصادر متعددة.

تعديل الصيغ وحمايتها

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

قولبة البيانات

تتمحور هذه الوحدة حول قولبة البيانات. تعرف على كيفية تصميم نماذج لسيناريوهات مختلفة استنادًا إلى المدخلات، الافتراضات و/أو النتائج. تعرّف أيضًا على استخدام مهام مثل بحث الهدف وجداول البيانات وسيناريو Manager لكي تكون النماذج الخاصة بك أكثر فعالية.

سجل ماكرو

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

التقييم النهائي

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Designed for beginners, this course builds a strong foundation in advanced spreadsheet skills

Taught by instructors recognized for their expertise in Excel

Covers topics highly relevant to business and data analysis

Develops skills in data validation and automation for increased efficiency

Utilizes case studies to demonstrate practical applications in various business scenarios

Provides comprehensive coverage of advanced Excel features and techniques

Activities

Coming soon We're preparing activities for مهارات الإكسل الخاصة التجارية: المستوى المتوسط الثاني. These are activities you can do either before, during, or after a course.

Career center

Learners who complete مهارات الإكسل الخاصة التجارية: المستوى المتوسط الثاني will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts that effectively leverage the capabilities of spreadsheet software, such as Microsoft Excel, are highly valued by employers, and this course can help you do just that. You will not only learn how to verify and validate data, but you will also gain experience performing more advanced skills in excel, such as creating automated spreadsheets that are essential for streamlining data management and analysis.

See salaries and explore the career path for Data Analyst

Financial Analyst

This course teaches students how to perform a variety of tasks using Microsoft Excel, which is one of the most popular spreadsheet programs used by Financial Analysts. From the basics of data validation to more advanced techniques, such as using macros, this course will provide you with the tools to be an effective Financial Analyst.

See salaries and explore the career path for Financial Analyst

Business Analyst

Microsoft Excel is a powerful tool that is used by many Business Analysts to perform data analysis, modeling, and forecasting. This course will help you to master the skills needed to be an effective Business Analyst, including how to create dashboards, perform data analysis, and create data visualizations.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

Operations Research Analysts use a variety of techniques to improve the efficiency of systems, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve optimization problems, which are all essential skills for Operations Research Analysts.

See salaries and explore the career path for Operations Research Analyst

Management Consultant

Management Consultants use a variety of tools and techniques to help organizations improve their performance, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Management Consultants.

See salaries and explore the career path for Management Consultant

Actuary

Actuaries use a variety of mathematical and statistical techniques to assess risk, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Actuaries.

See salaries and explore the career path for Actuary

Data Scientist

Data Scientists use a variety of tools and techniques to extract insights from data, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Data Scientists.

See salaries and explore the career path for Data Scientist

Operations Manager

Operations Managers use a variety of tools and techniques to improve the efficiency of operations, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Operations Managers.

See salaries and explore the career path for Operations Manager

Product Manager

Product Managers use a variety of tools and techniques to develop and manage products, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Product Managers.

See salaries and explore the career path for Product Manager

Market Research Analyst

Market Research Analysts use a variety of tools and techniques to collect and analyze data about markets and consumers and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Market Research Analysts.

See salaries and explore the career path for Market Research Analyst

Financial Planner

Financial Planners use a variety of tools and techniques to help clients achieve their financial goals, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Financial Planners.

See salaries and explore the career path for Financial Planner

Statistician

Statisticians use a variety of tools and techniques to collect and analyze data, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Statisticians.

See salaries and explore the career path for Statistician

Auditor

Auditors use a variety of tools and techniques to examine and evaluate financial records, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Auditors.

See salaries and explore the career path for Auditor

Tax Accountant

Tax Accountants use a variety of tools and techniques to prepare and file tax returns, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Tax Accountants.

See salaries and explore the career path for Tax Accountant

Budget Analyst

Budget Analysts use a variety of tools and techniques to develop and manage budgets, and Microsoft Excel is one of the most important tools they use. This course will teach you how to use Excel to perform data analysis, create models, and solve problems, which are all essential skills for Budget Analysts.

See salaries and explore the career path for Budget Analyst

مهارات الإكسل الخاصة التجارية

المستوى المتوسط الثاني

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses