مهارات برنامج Excel للعمل: المبادئ الأساسية from Coursera

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

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

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

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

What's inside

Syllabus

الأساسيات المهمة لبرنامج Excel

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

إجراء العمليات الحسابية

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

التنسيق

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

العمل مع البيانات

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

الطباعة

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

المخططات

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

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Taught by Yvonne Breyer, who has significant experience and recognition within the Excel industry

Develops core Excel skills and knowledge, relevant to various workplaces globally

Provides structured learning with weekly challenges and assessments to reinforce concepts

Covers essential Excel functions, including formula writing, data manipulation, and visualization

Suitable for those seeking to enhance their Excel proficiency or gain a foundation in the software

May require prior basic computer literacy and familiarity with spreadsheet concepts

Reviews summary

Helpful excel fundamentals

This course is highly recommended for those looking to learn the basics of Microsoft Excel. With a focus on practical skills, it provides a solid foundation for further development in Excel. The course is well-organized and easy to follow, with clear explanations and examples. However, there have been some minor issues reported with the Arabic translation, so non-native speakers may want to take note of this.

Explains concepts clearly with helpful examples.

"دورة ممتازة لمن ليس لديه خبرة بالاكسل واشكر الاساتذة وكورسيرا على هذه الدورة"

"an amazing course with explanation and delivering the idea and the examples mentioned are just the right ones"

Provides a strong foundation in essential Excel skills for practical use.

"كورس منظم بسيط سهل التتبع مهارات أساسية كثيرة وعملية لمن ليس لديه خبرة بالاكسل وانصح به بقوة"

"شكرا لكل من اتاح لي حضور هذا التدريبك\nكان تدريب رائعا\nكتسبت مهارات جديدة بالنسبة الي ع\لى الرغم اني حضرت عدة تدريبات لان هذا التدريب اتارح لي اكتسباب معلومات جديدة لم على علم بها "

Some users reported issues with the Arabic translation, including errors and inconsistencies.

"the translation to Arabic have problems"

"i take the course with Arabic translation, but unfortunately there is a lot of mistake the lead the students to confuse between the question and the Excel sheet."

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 للعمل: المبادئ الأساسية with these activities:

Review Basis of Excel

Show steps

Reviewing the basic features of Microsoft Excel will help build a solid foundation for learning more advanced skills in this course.

Browse courses on Excel

Show steps

Revisit the basics of the Excel interface, including the ribbon, tabs, and cells.
Go over the different data types in Excel, such as numbers, text, and dates.
Review how to enter and edit data in Excel cells.

Excel Study Group

Show steps

Participating in a study group with peers will provide an opportunity to discuss concepts, share knowledge, and learn from others.

Browse courses on Excel

Show steps

Form a study group with other students taking the course.
Meet regularly to discuss course material, practice exercises together, and prepare for assessments.
Take turns leading the discussions and presenting your understanding of different Excel concepts.

Excel Practice Worksheets

Show steps

Completing practice worksheets will provide hands-on experience and reinforce the concepts learned in the course.

Browse courses on Excel

Show steps

Download practice worksheets that cover various Excel functions and techniques.
Practice using formulas and functions to perform calculations and analyze data.
Check your answers against provided solutions to identify areas for improvement.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Volunteer as an Excel Tutor

Show steps

Volunteering as an Excel tutor can help you solidify your understanding of Excel while also making a positive impact on others.

Browse courses on Excel

Show steps

Contact local schools, community centers, or non-profit organizations to offer your Excel tutoring services.
Prepare lesson plans and materials to teach Excel concepts to students or individuals in need.
Provide personalized guidance and support to help learners improve their Excel skills.

Attend Excel Industry Events

Show steps

Attending industry events focused on Excel can provide valuable networking opportunities and insights into the latest advancements in the field.

Browse courses on Excel

Show steps

Identify and attend industry conferences, workshops, or meetups related to Excel.
Connect with professionals working in your field who use Excel extensively.
Learn about new Excel tools, techniques, and best practices from industry experts.

Advanced Excel Tutorials

Show steps

Following guided tutorials will help you develop more advanced Excel skills, such as data analysis and visualization.

Browse courses on Excel

Show steps

Identify specific areas where you want to improve your Excel proficiency.
Search for online tutorials or courses that cover those specific topics.
Follow the tutorials step-by-step and practice the techniques explained in the tutorials.

Excel Workshop

Show steps

Attending an Excel workshop conducted by experienced professionals can provide in-depth training and hands-on practice in a structured environment.

Browse courses on Excel

Show steps

Research and find Excel workshops that align with your skill level and learning goals.
Register for a workshop and actively participate in the training sessions.
Practice the techniques learned during the workshop to reinforce your understanding.

Data Analysis Project

Show steps

Working on a data analysis project will allow you to apply your Excel skills to solve real-world problems and enhance your data analysis capabilities.

Browse courses on Excel

Show steps

Choose a dataset that interests you and is relevant to your field of study or work.
Use Excel to clean and prepare the data for analysis.
Apply appropriate Excel functions and techniques to analyze the data and draw meaningful conclusions.
Create visualizations, such as charts and graphs, to present your findings effectively.
Write a report or presentation to summarize your project and communicate your results.

Career center

Learners who complete مهارات برنامج Excel للعمل: المبادئ الأساسية will develop knowledge and skills that may be useful to these careers:

Management Consultant

Management Consultants help organizations improve their performance. They may work on projects such as developing new strategies, improving operations, or implementing new technologies. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Management Consultant

Business Analyst

Business Analysts use data and analysis to understand business needs and develop solutions. They may work for a variety of organizations, including consulting firms, technology companies, and financial institutions. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

Operations Research Analysts use mathematical and analytical techniques to solve complex business problems. They may work on projects such as improving efficiency, reducing costs, or optimizing supply chains. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Operations Research Analyst

Data Analyst

Data Analysts make up one of the fastest-growing career fields. Businesses are increasingly reliant on data to make decisions. These professionals are responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They may also develop data visualizations to communicate their findings. This course in Excel may be useful because it helps build a foundation in data management. You will learn how to work with data, including filtering, sorting, and using lookup functions. You will also learn how to create charts and graphs to visualize data.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use financial data to make investment recommendations and other financial decisions. They may work for investment firms, banks, or other financial institutions. This course in Excel may be useful because it helps build a foundation in financial modeling and analysis. You will learn how to use formulas and functions to perform financial calculations, and how to format and present financial data in a clear and concise way.

See salaries and explore the career path for Financial Analyst

Actuary

Actuaries use mathematical and statistical techniques to assess risk and uncertainty. They may work for insurance companies, pension funds, or other financial institutions. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Actuary

Software Engineer

Software Engineers design, develop, and maintain software applications. They may work for a variety of organizations, including technology companies, financial institutions, and healthcare organizations. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists use data to build predictive models and develop new insights. They may work for a variety of organizations, including technology companies, financial institutions, and healthcare organizations. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Data Scientist

Economist

Economists study the production, distribution, and consumption of goods and services. They may work for a variety of organizations, including government agencies, research institutions, and private companies. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Economist

Statistician

Statisticians use statistical methods to collect, analyze, and interpret data. They may work for a variety of organizations, including government agencies, research institutions, and private companies. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Statistician

Accountant

Accountants prepare and maintain financial records for businesses and individuals. They may also provide tax advice and other financial services. This course in Excel may be useful because it helps build a foundation in financial accounting and analysis. You will learn how to use formulas and functions to perform financial calculations, and how to format and present financial data in a clear and concise way.

See salaries and explore the career path for Accountant

Auditor

Auditors examine and verify financial records for accuracy and compliance with laws and regulations. They may work for a variety of organizations, including accounting firms, government agencies, and private companies. This course in Excel may be useful because it helps build a foundation in financial accounting and analysis. You will learn how to use formulas and functions to perform financial calculations, and how to format and present financial data in a clear and concise way.

See salaries and explore the career path for Auditor

Market Researcher

Market Researchers study consumer behavior and market trends. They may work for a variety of organizations, including marketing agencies, consulting firms, and product development companies. This course in Excel may be useful because it helps build a foundation in data analysis and modeling. You will learn how to use formulas and functions to perform calculations, and how to format and present data in a clear and concise way.

See salaries and explore the career path for Market Researcher

Tax Preparer

Tax Preparers help individuals and businesses prepare and file their tax returns. They may work for a variety of organizations, including accounting firms, tax preparation companies, and software companies. This course in Excel may be useful because it helps build a foundation in tax accounting. You will learn how to use formulas and functions to perform tax calculations, and how to format and present tax data in a clear and concise way.

See salaries and explore the career path for Tax Preparer

Financial Planner

Financial Planners help individuals and families plan for their financial future. They may work for a variety of organizations, including banks, investment firms, and insurance companies. This course in Excel may be useful because it helps build a foundation in financial modeling and analysis. You will learn how to use formulas and functions to perform financial calculations, and how to format and present financial data in a clear and concise way.

See salaries and explore the career path for Financial Planner