مهارات الإكسل الخاصة التجارية: المستوى المتوسط الثاني 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

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in مهارات الإكسل الخاصة التجارية: المستوى المتوسط الثاني with these activities:

Review basic Excel concepts

Show steps

Refresh your understanding of essential Excel concepts to ensure a strong foundation for advanced topics.

Browse courses on Excel Basics

Show steps

Review online tutorials or articles on core Excel functions
Create a practice spreadsheet to apply basic concepts

Compile course materials

Show steps

Organize lecture notes, assignments, quizzes, and other materials to facilitate effective review and recall.

Show steps

Gather and organize all relevant course materials
Create a system for filing and retrieving materials

Participate in peer learning sessions

Show steps

Engage with peers to discuss course concepts, share knowledge, and learn from different perspectives.

Show steps

Join or create a study group with classmates
Share resources, notes, and ideas with your group
Lead discussions on specific topics

Five other activities

Expand to see all activities and additional details

Show all eight activities

Practice data validation and format checks

Show steps

Practice data validation and format checks to improve your proficiency in ensuring data accuracy and consistency.

Browse courses on Data Validation

Show steps

Create a worksheet with sample data containing errors
Apply data validation rules to validate specific cell ranges
Implement conditional formatting to highlight invalid or erroneous data

Learn advanced formula techniques

Show steps

Expand your knowledge of Excel by exploring advanced formula techniques and functions to enhance your problem-solving capabilities.

Browse courses on Advanced Formulas

Show steps

Identify opportunities to use advanced formulas in your work
Watch tutorials or read articles on complex Excel functions
Practice implementing these techniques using real-world data

Create Excel templates for common tasks

Show steps

Develop reusable and efficient Excel templates to streamline your workflow and save time on repetitive tasks.

Show steps

Identify common tasks that can be automated with templates
Design and develop customized templates using appropriate formulas and macros
Test and refine templates to ensure accuracy and functionality

Create a dashboard to visualize data

Show steps

Apply your Excel skills to create interactive and informative dashboards to present data in a meaningful way.

Browse courses on Data Visualization

Show steps

Gather relevant data and identify key insights
Design and structure your dashboard using appropriate charts and visualizations
Implement calculations and formulas to derive meaningful metrics
Format and customize your dashboard for clarity and aesthetics

Volunteer at a non-profit organization using Excel skills

Show steps

Apply your Excel skills to make a positive impact while gaining valuable hands-on experience.

Browse courses on Community Involvement

Show steps

Identify non-profit organizations that could benefit from Excel expertise
Contact organizations and offer your services
Use Excel to assist with data analysis, financial modeling, or other tasks

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