We may earn an affiliate commission when you visit our partners.
Reham Kamal
بنهاية هذا المشروع، هتكون خبير بكيفية استعمال دوال ال lookup, math, text ,reference فى برنامج ال Microsoft excel بشكل ممتاز لانجاز عدة مشاريع و مهمات. خلال المشروع هنقدر مع بعض ندخل او نعرض بيانات بشكل جدول منسق عشان يساعدنا فى تطبيق داله ال Lookup عشان ندور على قيمه او خليه معينه , هنقدر نستخدم الدوال الحسابيه عشان تساعدنا فى معظم العمليات الحسابيه اللى بنحتاجها , و هنقدر و نستعمل الدوال النصيه text functions ونعرف نستفيد منها ازاى و كمان هنقدر نعمل reference ل خليه معينه. برنامج Excel هو برنامج خدمي من إنتاج شركة Microsoft، بيساعد فى تنظيم وتنسيق وحساب البيانات و ده عن طريق صيغ مختلفة منها الجداول، يعتبر متميز جدا فى إجراء العمليات الحسابية الأساسية واستخدام أدوات الرسوم البيانية وإنشاء الجداول المحورية وإنشاء وحدات ماكرو.
Register for this course and see more details by visiting:
OpenCourser.com/course/rx4h0o/t`lym
Three deals to help you save
We found three deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until December 12
Annual Subscription Savings
Unlock programs from Google, Microsoft, and IBM and join 77% of learners who reported positive career outcomes.
Only $239!
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Syllabus
ملخص المشروع
بنهاية هذا المشروع، هتكون خبير بكيفية استعمال دوال ال lookup, math, text ,reference فى برنامج ال Microsoft excel بشكل ممتاز لانجاز عدة مشاريع و مهمات. خلال المشروع هنقدر مع بعض ندخل او نعرض بيانات بشكل جدول منسق عشان يساعدنا فى تطبيق داله ال Lookup عشان ندور على قيمه او خليه معينه , هنقدر نستخدم الدوال الحسابيه عشان تساعدنا فى معظم العمليات الحسابيه اللى بنحتاجها , و هنقدر و نستعمل الدوال النصيه text functions ونعرف نستفيد منها ازاى و كمان هنقدر نعمل reference ل خليه معينه. برنامج Excel هو برنامج خدمي من إنتاج شركة Microsoft، بيساعد فى تنظيم وتنسيق وحساب البيانات و ده عن طريق صيغ مختلفة منها الجداول، يعتبر متميز جدا فى إجراء العمليات الحسابية الأساسية واستخدام أدوات الرسوم البيانية وإنشاء الجداول المحورية وإنشاء وحدات ماكرو.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
تناسب الأشخاص الذين يتطلعون إلى إتقان وظائف البحث، والرياضيات، والنصوص، والمراجع في برنامج Excel بشكل ممتاز لإكمال مجموعة متنوعة من المهام والمشاريع
يدرس وظائف البحث الأساسية للبحث عن قيم أو خلايا معينة في جدول مُنسق، مما ي упроي إيجاد المعلومات المطلوبة بسهولة
يُزود المتعلمين بالمهارات الأساسية في معالجة البيانات من خلال تضمين وظائف حسابية تساعدهم على إجراء العمليات الحسابية الضرورية بكفاءة
يساعد المتعلمين على فهم واستخدام مجموعة كبيرة من وظائف النصوص، مما يتيح لهم معالجة وتنسيق البيانات النصية بمرونة
يُظهر كيفية إنشاء مراجع للخلايا، مما يسمح بإنشاء جداول بيانات مترابطة وإدارة البيانات بفعالية
يوضح كيفية استخدام Excel لتنظيم وتنسيق وحساب البيانات باستخدام الجداول والصيغ المختلفة، مما يجعله أداة قوية لتحليل البيانات
Save this course
Save تعليم lookup, math, text ,reference فى Excel to your list so you can find it easily later:
Save
Save
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 تعليم lookup, math, text ,reference فى Excel with these
activities:
Join a study group focused on Excel functions
Show steps
Encourages collaboration and peer-to-peer learning among students
Browse courses on
Math Functions
Show steps
-
Find classmates who are taking the course
-
Schedule regular study sessions
-
Review course material together
-
Practice using Excel functions
-
Share tips and strategies
Complete W3Schools Excel tutorials
Show steps
Helps orient the student to the features of Excel that will be used throughout the course
Browse courses on
Math Functions
Show steps
-
Create a new Excel workbook
-
Navigate to the W3Schools website
-
Locate and start the Excel tutorials
-
Complete the Lookup Functions tutorial
-
Complete the Math Functions tutorial
-
Complete the Text Functions tutorial
Practice using Excel lookup functions
Show steps
Provides targeted practice to build proficiency in using Excel lookup functions
Browse courses on
Math Functions
Show steps
-
Create a spreadsheet with sample data
-
Apply the VLOOKUP function to find specific data
-
Apply the HLOOKUP function to find specific data
-
Apply the INDEX function to find specific data
Four other activities
Expand to see all activities and additional details
Show all seven activities
Volunteer at a non-profit organization to use Excel skills
Show steps
Provides students with an opportunity to apply their skills while making a meaningful contribution
Browse courses on
Math Functions
Show steps
-
Identify a non-profit organization that aligns with your interests
-
Contact the organization to inquire about volunteer opportunities
-
Offer your Excel skills to assist with data management or analysis
-
Complete the volunteer assignment
-
Reflect on your experience and how it has enhanced your understanding of Excel functions
Analyze financial data using Excel
Show steps
Provides a real-world scenario to test students' understanding of Excel functions
Browse courses on
Math Functions
Show steps
-
Download financial data from a public source
-
Use lookup functions to extract relevant data
-
Perform calculations and analysis on the data
-
Create charts and graphs to present the findings
-
Write a report summarizing the analysis
Create a data analysis dashboard using Excel
Show steps
Challenges students to apply their skills in a practical way and showcase their learning
Browse courses on
Math Functions
Show steps
-
Gather data from multiple sources
-
Clean and prepare the data
-
Create charts and graphs to visualize the data
-
Use lookup functions to connect data from different sources
-
Present the dashboard to stakeholders
Contribute to an open-source Excel project
Show steps
Exposes students to real-world Excel applications and contributes to the open-source community
Browse courses on
Math Functions
Show steps
-
Identify an open-source Excel project
-
Review the project documentation and code
-
Identify an area where you can contribute
-
Implement and test your changes
-
Submit a pull request to the project
Join a study group focused on Excel functions
Show steps
Encourages collaboration and peer-to-peer learning among students
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Find classmates who are taking the course
- Schedule regular study sessions
- Review course material together
- Practice using Excel functions
- Share tips and strategies
Complete W3Schools Excel tutorials
Show steps
Helps orient the student to the features of Excel that will be used throughout the course
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Create a new Excel workbook
- Navigate to the W3Schools website
- Locate and start the Excel tutorials
- Complete the Lookup Functions tutorial
- Complete the Math Functions tutorial
- Complete the Text Functions tutorial
Practice using Excel lookup functions
Show steps
Provides targeted practice to build proficiency in using Excel lookup functions
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Create a spreadsheet with sample data
- Apply the VLOOKUP function to find specific data
- Apply the HLOOKUP function to find specific data
- Apply the INDEX function to find specific data
Four other activities
Expand to see all activities and additional details
Show all seven activities
Volunteer at a non-profit organization to use Excel skills
Show steps
Provides students with an opportunity to apply their skills while making a meaningful contribution
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Identify a non-profit organization that aligns with your interests
- Contact the organization to inquire about volunteer opportunities
- Offer your Excel skills to assist with data management or analysis
- Complete the volunteer assignment
- Reflect on your experience and how it has enhanced your understanding of Excel functions
Analyze financial data using Excel
Show steps
Provides a real-world scenario to test students' understanding of Excel functions
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Download financial data from a public source
- Use lookup functions to extract relevant data
- Perform calculations and analysis on the data
- Create charts and graphs to present the findings
- Write a report summarizing the analysis
Create a data analysis dashboard using Excel
Show steps
Challenges students to apply their skills in a practical way and showcase their learning
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Gather data from multiple sources
- Clean and prepare the data
- Create charts and graphs to visualize the data
- Use lookup functions to connect data from different sources
- Present the dashboard to stakeholders
Contribute to an open-source Excel project
Show steps
Exposes students to real-world Excel applications and contributes to the open-source community
Browse courses on
Math Functions
Show steps
Show steps
Show steps
- Identify an open-source Excel project
- Review the project documentation and code
- Identify an area where you can contribute
- Implement and test your changes
- Submit a pull request to the project
Career center
Learners who complete تعليم lookup, math, text ,reference فى Excel will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data Analysts use lookup and text functions in Excel to clean and organize data, and to identify trends and patterns. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Business Analyst
Business Analyst
Business Analysts use math and reference functions in Excel to create financial models and analyze data. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Financial Analyst
Financial Analyst
Financial Analysts use math and reference functions in Excel to analyze financial data and make investment recommendations. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Statistician
Statistician
Statisticians use math and reference functions in Excel to analyze data and draw conclusions. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Investment Analyst
Investment Analyst
Investment Analysts use math and reference functions in Excel to analyze investment opportunities and make recommendations to clients. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers use math and reference functions in Excel to develop and implement machine learning models. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use math and reference functions in Excel to optimize business processes and improve efficiency. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Data Scientist
Data Scientist
Data Scientists use math and reference functions in Excel to analyze data and develop machine learning models. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use math and reference functions in Excel to develop and implement trading strategies. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Actuary
Actuary
Actuaries use math and reference functions in Excel to assess risk and determine insurance premiums. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Portfolio Manager
Portfolio Manager
Portfolio Managers use math and reference functions in Excel to manage investment portfolios and make investment decisions. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Risk Manager
Risk Manager
Risk Managers use math and reference functions in Excel to assess and manage risk. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Financial Planner
Financial Planner
Financial Planners use math and reference functions in Excel to create and manage financial plans for clients. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Market Researcher
Market Researcher
Market Researchers use lookup and text functions in Excel to analyze market data and identify trends. This course can help build a foundation for success in this role by providing a strong understanding of how to use these functions effectively.
Software Engineer
Software Engineer
Software Engineers use math and reference functions in Excel to develop and implement software applications. This course may be useful for those who wish to enter this field, as it can help build a foundation for understanding how to use these functions effectively.
For more career information including salaries, visit:
OpenCourser.com/course/rx4h0o/t`lym
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
تعليم lookup, math, text ,reference فى Excel.
Save
Comprehensive guide to Microsoft Excel 2019. It covers a wide range of topics, including lookup, math, text, and reference functions. It is written in a clear and concise style, making it easy to understand.
Will be a useful reference tool for this course. This book covers a wide range of Excel functions and formulas, including lookup, math, text, and reference functions. It is written in a clear and concise style, making it easy to understand.
Save
Will be a useful reference tool for this course. It covers a wide range of data analysis and business modeling topics, including lookup, math, text, and reference functions. It is written in a clear and concise style, making it easy to understand.
Will teach you how to create dashboards and reports in Excel. This will be a useful skill for anyone who wants to communicate data effectively.
Teaches you how to use Excel for data analysis and visualization. It covers a wide range of topics, including lookup, math, text, and reference functions.
Quick reference to the formulas and functions available in Excel 2019. It is written in a clear and concise style, making it easy to find the information you need.
Will help you learn how to use VBA to automate tasks in Excel. This will be a useful skill for anyone who wants to use Excel more efficiently.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/rx4h0o/t`lym
Share
Similar courses
Here are nine courses similar to
تعليم lookup, math, text ,reference فى Excel.
Microsoft Excel حسابات البيانات في
OpenCourser.com/course/pg8ytu/microsoft
Microsoft Excel حسابات البيانات في
Most relevant
الترجيح الإحصائي أو Statistical Weighting فى Microsoft Excel
OpenCourser.com/course/3f5uke/ltrjyH
الترجيح الإحصائي أو Statistical Weighting فى Microsoft...
Most relevant
Microsoft Powerpoint انشاء خطة عمل ب
OpenCourser.com/course/2gei7r/microsoft
Microsoft Powerpoint انشاء خطة عمل ب
Most relevant
التصميم والتنسيق والعرض ب Microsoft PowerPoint
OpenCourser.com/course/imwl6b/ltSmym
التصميم والتنسيق والعرض ب Microsoft PowerPoint
Most relevant
البدء في استخدام Microsoft Word
OpenCourser.com/course/kz1w0a/lbd
البدء في استخدام Microsoft Word
Most relevant
Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال
OpenCourser.com/course/ykvsig/excel
Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات...
Most relevant
Microsoft Excel إنشاء تقرير المصروفات باستخدام
OpenCourser.com/course/ch6vs8/microsoft
Microsoft Excel إنشاء تقرير المصروفات باستخدام
Most relevant
عرض اقتراح المبيعات ب Microsoft PowerPoint.
OpenCourser.com/course/jfz615/`rD
عرض اقتراح المبيعات ب Microsoft PowerPoint.
Most relevant
bash shell و أساسيات ال scripting فى Linux
OpenCourser.com/course/ujevxx/bash
bash shell و أساسيات ال scripting فى Linux
Most relevant
Effort
1.33 Hours
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Reham Kamal
Language
العربية
Good to know
تناسب الأشخاص الذين يتطلعون إلى إتقان وظائف البحث، والرياضيات، والنصوص، والمراجع في برنامج Excel بشكل ممتاز لإكمال مجموعة متنوعة من المهام والمشاريع
يدرس وظائف البحث الأساسية للبحث عن قيم أو خلايا معينة في جدول مُنسق، مما ي упроي إيجاد المعلومات المطلوبة بسهولة
يُزود المتعلمين بالمهارات الأساسية في معالجة البيانات من خلال تضمين وظائف حسابية تساعدهم على إجراء العمليات الحسابية الضرورية بكفاءة
يساعد المتعلمين على فهم واستخدام مجموعة كبيرة من وظائف النصوص، مما يتيح لهم معالجة وتنسيق البيانات النصية بمرونة
يُظهر كيفية إنشاء مراجع للخلايا، مما يسمح بإنشاء جداول بيانات مترابطة وإدارة البيانات بفعالية
يوضح كيفية استخدام Excel لتنظيم وتنسيق وحساب البيانات باستخدام الجداول والصيغ المختلفة، مما يجعله أداة قوية لتحليل البيانات
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser