مهارات Excel للأعمال: المستوى "المتوسط I" from Coursera

لا تزال برامج جداول البيانات واحدة من أكثر البرامج انتشارًا في أماكن العمل في جميع أنحاء العالم. إن تعلم تشغيل هذا البرنامج بثقة يعني إضافة أصول ذات قيمة عالية إلى مؤهلاتك الوظيفية. في الولايات المتحدة الأمريكية وحدها، يتم نشر الملايين من إعلانات الوظائف التي تتطلب مهارات Excel كل يوم. يُظهر البحث الذي تم إجراؤه من قبل Burning Glass Technologies وCapital One أن المهارات الرقمية تؤدي إلى دخل أعلى وفرص عمل أفضل، في وقت تنمو فيه وظائف المهارات الرقمية بشكل أسرع بكثير من الوظائف غير الرقمية.

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

مرة أخرى، لقد جمعنا فريق تدريس رائعًا سيكون معك في كل خطوة في طريقك. سيرشدك "براشان" و"نيكي" كل أسبوع (وسأحضر ضيفًا في الأسبوع الخامس لمساعدتك في التعرف على أداتي المفضلة في Excel- صمتًا، لتكن مفاجأة). اعمل خلال كل تحد جديد خطوة بخطوة، وستندهش في وقت قصير من مدى تقدمك. سنتابع هذه المرة محاولات "أوما" ومعاناتها لأنها تحاول أن تضع قدميها في منصب جديد في شركة وهمية هي PushPin. بالنسبة لمن أتم منكم دورة "الأساسيات"، فسيكون على دراية بالشركة بالفعل. سيساعدك العمل خلال تحدياتها الشائعة للغاية، والتي نواجهها كل يوم، على التواصل بسهولة أكبر مع المهارات والتقنيات التي يتم تعلمها في كل أسبوع، وتطبيقها في سياقات مألوفة وجديدة.

What's inside

Syllabus

العمل مع أوراق عمل وسجلات عمل متعددة

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

دالتا النص والتاريخ

بنهاية هذه الوحدة، ستكون خبيرًا في دوال Date and Text "التاريخ والنص". تناقش هذه الوحدة الطرق التي يمكنك من خلالها استخراج المعلومات ومعالجة البيانات لتلبية متطلبات العمل المحددة.

Named Ranges "النطاقات المسماة"

تعلم كيف يمكنك إنشاء، وإدارة، وتطبيق النطاقات المسماة لتعزيز عملياتك الحسابية.

تلخيص البيانات

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

الجداول

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

الجداول المحورية، والمخططات، وأدوات التقسيم

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

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teachers intermediate-level Excel skills, which are standard across most industries

Taught by instructors with expertise in the finance industry

Develops advanced Excel skills, which are core skills for data analysts and business intelligence professionals

Explores advanced Excel features, which may help learners enhance their work productivity and efficiency

Introduces learners to intermediate-level Excel techniques and technologies

May require learners to acquire prior knowledge of beginner-level Excel

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 مهارات Excel للأعمال: المستوى "المتوسط I" with these activities:

Review various Excel skills

Show steps

Brush up on Excel skills learned in the previous course to prepare for this course.

Show steps

Review how to create and format spreadsheets
Review how to use basic formulas and functions
Review how to create and format charts

Organize and review course materials

Show steps

Stay organized and improve your understanding by compiling and reviewing course materials regularly.

Show steps

Create a system for organizing notes, assignments, and other materials
Review materials regularly to reinforce concepts
Identify areas where further clarification or practice is needed

Follow tutorials on advanced Excel features

Show steps

Expand your Excel knowledge by following tutorials that cover advanced features and techniques.

Browse courses on Named Ranges

Show steps

Locate and select relevant tutorials
Follow the steps and instructions in the tutorials
Practice using the new features and techniques

Seven other activities

Expand to see all activities and additional details

Show all ten activities

Explore advanced Excel functions

Show steps

Walkthrough guided tutorials to explore advanced Excel functions, solidifying your understanding of data manipulation techniques.

Browse courses on Excel Functions

Show steps

Identify the available advanced functions in Excel.
Practice using these functions in practical scenarios.
Create custom formulas using advanced functions.

Complete Excel exercises and challenges

Show steps

Reinforce your understanding of Excel concepts by completing exercises and challenges that test your skills.

Browse courses on Data Analysis

Show steps

Find practice exercises and challenges online or in textbooks
Attempt to solve the exercises and challenges on your own
Review your solutions and identify areas for improvement

Collaborate with peers on Excel projects

Show steps

Enhance your learning by working with others on Excel projects.

Show steps

Identify a project or task to collaborate on
Divide responsibilities and set clear goals
Communicate regularly and provide feedback
Evaluate the outcomes of the collaboration

Develop an Excel dashboard to track project progress

Show steps

Apply your Excel skills to create a practical and useful tool that can help you track and manage your projects.

Browse courses on Data Visualization

Show steps

Determine the key metrics and data sources for your project
Design and create the dashboard layout
Import and connect the data sources
Create visualizations and charts to represent the data
Test and refine the dashboard to ensure accuracy and functionality

Attend Excel meetups or workshops

Show steps

Expand your professional network and learn from others in the Excel community.

Show steps

Identify relevant Excel meetups or workshops
Attend the events and actively participate
Connect with other professionals and exchange ideas

Assist other students with Excel tasks and questions

Show steps

Solidify your understanding of Excel by helping others learn and solve problems.

Show steps

Identify opportunities to assist other students
Patiently explain concepts and provide guidance
Encourage students to ask questions and seek clarification

Contribute to open-source Excel projects

Show steps

Gain practical experience and contribute to the Excel community by participating in open-source projects.

Show steps

Identify suitable open-source Excel projects
Review the project documentation and codebase
Contribute bug fixes, improvements, or new features
Collaborate with other contributors and maintain the project

Career center

Learners who complete مهارات Excel للأعمال: المستوى "المتوسط I" will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts analyze and interpret data to help businesses make informed decisions. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to clean, manage, and analyze data. You will also learn how to create visualizations and dashboards to communicate your findings effectively.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use financial data to make recommendations for investments and other financial decisions. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to model and analyze financial data. You will also learn how to create charts and graphs to communicate your findings effectively.

See salaries and explore the career path for Financial Analyst

Operations Analyst

Operations Analysts help businesses improve their efficiency and effectiveness by analyzing data and identifying opportunities for improvement. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to collect, analyze, and interpret data. You will also learn how to create presentations and reports to communicate your findings effectively.

See salaries and explore the career path for Operations Analyst

Business Analyst

Business Analysts help businesses improve their performance by analyzing data and identifying opportunities for improvement. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to collect, analyze, and interpret data. You will also learn how to create presentations and reports to communicate your findings effectively.

See salaries and explore the career path for Business Analyst

Sales Analyst

Sales Analysts help businesses understand their sales performance and identify opportunities for improvement. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to collect, analyze, and interpret data. You will also learn how to create presentations and reports to communicate your findings effectively.

See salaries and explore the career path for Sales Analyst

Marketing Analyst

Marketing Analysts help businesses understand their customers and develop effective marketing campaigns. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to collect, analyze, and interpret data. You will also learn how to create presentations and reports to communicate your findings effectively.

See salaries and explore the career path for Marketing Analyst

Business Development Manager

Business Development Managers are responsible for generating new business for their companies. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to track sales leads, manage customer relationships, and create business proposals.

See salaries and explore the career path for Business Development Manager

Project Manager

Project Managers plan and execute projects to achieve specific goals. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to track progress, manage budgets, and communicate with stakeholders. You will also learn how to use Excel to create project plans and schedules.

See salaries and explore the career path for Project Manager

Product Manager

Product Managers are responsible for the development and launch of new products. This course can help you develop the skills needed to succeed in this role by teaching you how to use Excel to analyze market data, track product performance, and create product roadmaps.

See salaries and explore the career path for Product Manager

Tax Preparer

Tax Preparers are responsible for preparing tax returns for individuals and businesses. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to calculate taxes and prepare tax returns.

See salaries and explore the career path for Tax Preparer

Auditor

Auditors are responsible for examining the financial records of businesses to ensure that they are accurate and compliant with regulations. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to analyze financial data and identify potential risks.

See salaries and explore the career path for Auditor

Accountant

Accountants are responsible for managing the financial records of businesses. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to track income and expenses, create financial statements, and prepare tax returns.

See salaries and explore the career path for Accountant

Web Developer

Web Developers design and develop websites. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to track projects, manage tasks, and create documentation.

See salaries and explore the career path for Web Developer

Data Scientist

Data Scientists use data to solve business problems. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to clean, manage, and analyze data. You will also learn how to use Excel to create visualizations and dashboards to communicate your findings effectively.

See salaries and explore the career path for Data Scientist

Software Engineer

Software Engineers design, develop, and maintain software applications. This course may help you develop the skills needed to succeed in this role by teaching you how to use Excel to manage projects, track bugs, and create documentation.

See salaries and explore the career path for Software Engineer