We may earn an affiliate commission when you visit our partners.
Abdelrahman Tarek Hafez
فى نهاية المشروع ده , هتقدر تستخدم التنسيق الشرطى و المخصص فى جدول بيانات excel باستخدام نسخة مجانية من Microsoft Excel.Excel هو جدول بيانات متشابه بجدول بيانات المحاسبة. بيكون فيه خلايا فردية ممكن نستخدمها لكتابة صيغ و وظائف. يعتبر التنسيق الشرطى أداة ملائمة لتحليل البيانات و التمثيل المرئي للنتائج. معرفة استخدام الاداه دى هتوفر عليك الكثير من الوقت والجهد. هتقدر تخليك تبص نظرة سريعة على الملف وهتبقى كافية للحصول على البيانات والمعلومات اللازمة.هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على الانترنت. و هتقدر تضبط عرض الاعمدة, و تغيير الوان الخلية, وإضافة الحدود. وهتقدر تستخدم التنسيق الرقمي ,واستخدام التنسيق الشرطي لتطبيق التنسيقات تلقائيا. زى مثلا إضافة الفواصل الاربع ارقام, و وضع علامة الأسعار. وضبط شكل التواريخ. واستخدام ال data bars, color scales و ال icon sets. و ازاى نخفى الاعمدة و الصفوف و الصفحات.
Read more
فى نهاية المشروع ده , هتقدر تستخدم التنسيق الشرطى و المخصص فى جدول بيانات excel باستخدام نسخة مجانية من Microsoft Excel.Excel هو جدول بيانات متشابه بجدول بيانات المحاسبة. بيكون فيه خلايا فردية ممكن نستخدمها لكتابة صيغ و وظائف. يعتبر التنسيق الشرطى أداة ملائمة لتحليل البيانات و التمثيل المرئي للنتائج. معرفة استخدام الاداه دى هتوفر عليك الكثير من الوقت والجهد. هتقدر تخليك تبص نظرة سريعة على الملف وهتبقى كافية للحصول على البيانات والمعلومات اللازمة.هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على الانترنت. و هتقدر تضبط عرض الاعمدة, و تغيير الوان الخلية, وإضافة الحدود. وهتقدر تستخدم التنسيق الرقمي ,واستخدام التنسيق الشرطي لتطبيق التنسيقات تلقائيا. زى مثلا إضافة الفواصل الاربع ارقام, و وضع علامة الأسعار. وضبط شكل التواريخ. واستخدام ال data bars, color scales و ال icon sets. و ازاى نخفى الاعمدة و الصفوف و الصفحات.
Read more
فى نهاية المشروع ده , هتقدر تستخدم التنسيق الشرطى و المخصص فى جدول بيانات excel باستخدام نسخة مجانية من Microsoft Excel.Excel هو جدول بيانات متشابه بجدول بيانات المحاسبة. بيكون فيه خلايا فردية ممكن نستخدمها لكتابة صيغ و وظائف. يعتبر التنسيق الشرطى أداة ملائمة لتحليل البيانات و التمثيل المرئي للنتائج. معرفة استخدام الاداه دى هتوفر عليك الكثير من الوقت والجهد. هتقدر تخليك تبص نظرة سريعة على الملف وهتبقى كافية للحصول على البيانات والمعلومات اللازمة.هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على الانترنت. و هتقدر تضبط عرض الاعمدة, و تغيير الوان الخلية, وإضافة الحدود. وهتقدر تستخدم التنسيق الرقمي ,واستخدام التنسيق الشرطي لتطبيق التنسيقات تلقائيا. زى مثلا إضافة الفواصل الاربع ارقام, و وضع علامة الأسعار. وضبط شكل التواريخ. واستخدام ال data bars, color scales و ال icon sets. و ازاى نخفى الاعمدة و الصفوف و الصفحات.
المشروع مخصص للأشخاص المبتدئين اللي مهتمين يبقى عندهم خبرة فى مميزات التنسيق زى adjusting column وتحليلها. ال excel هيعمل الحساب اوتوماتيكيا و تقدر تنسق البيانات بالطريقة الأسهل لعينيك او بالتنسيق الشرطي باستخدام excel. اكيد مظاهر البيانات و طريقة عرضها مهمة جدا . محتاجين نبقى عارفين اهم مميزات التنسيق البيانات في excel. زى تغيير الخلفية و اضافه حدود و من المهمم جدا انك تبقى عارف ميزة التنسيق الشرطى و الرقمي.
Register for this course and see more details by visiting:
OpenCourser.com/course/hgv5kj/microsoft
What's inside
Syllabus
ملخص المشروع
فى نهاية المشروع ده , هتقدر تستخدم التنسيق الشرطى و المخصص فى جدول بيانات excel باستخدام نسخة مجانية من Microsoft Excel.Excel هو جدول بيانات متشابه بجدول بيانات المحاسبة. بيكون فيه خلايا فردية ممكن نستخدمها لكتابة صيغ و وظائف. يعتبر التنسيق الشرطى أداة ملائمة لتحليل البيانات و التمثيل المرئي للنتائج. معرفة استخدام الاداه دى هتوفر عليك الكثير من الوقت والجهد. هتقدر تخليك تبص نظرة سريعة على الملف وهتبقى كافية للحصول على البيانات والمعلومات اللازمة.هتقدر تحمل البيانات على النسخة المجانية ل Microsoft excel على الانترنت. و هتقدر تضبط عرض الاعمدة, و تغيير الوان الخلية, وإضافة الحدود. وهتقدر تستخدم التنسيق الرقمي ,واستخدام التنسيق الشرطي لتطبيق التنسيقات تلقائيا. زى مثلا إضافة الفواصل الاربع ارقام, و وضع علامة الأسعار. وضبط شكل التواريخ. واستخدام ال data bars, color scales و ال icon sets. و ازاى نخفى الاعمدة و الصفوف و الصفحات.
المشروع مخصص للأشخاص المبتدئين اللي مهتمين يبقى عندهم خبرة فى مميزات التنسيق زى adjusting column وتحليلها. ال excel هيعمل الحساب اوتوماتيكيا و تقدر تنسق البيانات بالطريقة الأسهل لعينيك او بالتنسيق الشرطي باستخدام excel. اكيد مظاهر البيانات و طريقة عرضها مهمة جدا . محتاجين نبقى عارفين اهم مميزات التنسيق البيانات في excel. زى تغيير الخلفية و اضافه حدود و من المهمم جدا انك تبقى عارف ميزة التنسيق الشرطى و الرقمي.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Designed for learners who want to understand how to use conditional and custom formatting in Excel
Suitable for those with zero knowledge of Excel's conditional and custom formatting features
Taught by Abdelrahman Tarek Hafez, whose expertise is not immediately obvious
Save this course
Save Microsoft 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 Microsoft Excel التنسيق المخصص والشرطي في with these
activities:
Review basic Excel formulas
Show steps
Brush up on basic Excel formulas, such as SUM, AVERAGE, and IF, before starting the course.
Browse courses on
Excel Formulas
Show steps
-
Watch a video or read an article on basic Excel formulas.
-
Open a spreadsheet and try out some basic formulas.
Organize course materials
Show steps
Gather and organize all course materials, such as notes, assignments, and quizzes, in one place.
Show steps
-
Create a folder on your computer or in the cloud for course materials.
-
Download or print all course materials.
-
Label and organize the materials in a way that makes sense to you.
Connect with an experienced Excel user
Show steps
Reach out to an experienced Excel user who can provide guidance and support throughout the course.
Show steps
-
Ask your friends, family, or colleagues if they know any experienced Excel users.
-
Search for Excel user groups or forums online.
-
Attend Excel events or workshops.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
متابعة دورات تعليمية حول التنسيق الشرطي
Show steps
تساعدك متابعة الدورات التعليمية على تعلم كيفية استخدام التنسيق الشرطي بفعالية.
Show steps
-
ابحث عن دورات تعليمية حول التنسيق الشرطي.
-
اشترك في الدورات التعليمية واتبعها.
-
قم بالواجبات والتمارين المطلوبة.
إجراء تدريبات على التنسيق الشرطي
Show steps
يساعدك إجراء التدريبات على تحسين مهاراتك في التنسيق الشرطي.
Show steps
-
قم بإعداد جدول بيانات يحتوي على بيانات مختلفة.
-
قم بتطبيق التنسيق الشرطي على البيانات.
-
قم بتحليل نتائج التنسيق الشرطي.
Learn the basics of conditional formatting
Show steps
Walk through step-by-step instructions and videos on how to apply basic conditional formatting rules in Excel.
Browse courses on
Conditional Formatting
Show steps
-
Watch a video or read an article on the basics of conditional formatting.
-
Open a spreadsheet and try out some basic conditional formatting rules.
-
Experiment with different conditions and formatting options.
Solve Excel conditional formatting exercises
Show steps
Complete a set of Excel exercises to practice applying conditional formatting rules effectively.
Browse courses on
Conditional Formatting
Show steps
-
Find a set of Excel exercises online or in a workbook.
-
Solve the exercises and check your answers against the provided solutions.
-
Repeat the exercises until you are confident in your ability to apply conditional formatting rules.
Collaborate on a conditional formatting project
Show steps
Work with a peer to create a spreadsheet with conditional formatting rules that meet specific criteria.
Browse courses on
Conditional Formatting
Show steps
-
Find a partner who is also interested in learning about conditional formatting.
-
Choose a dataset to work with.
-
Decide on the conditional formatting rules that you want to apply.
-
Create the spreadsheet and apply the conditional formatting rules.
-
Share the spreadsheet with your partner and get feedback.
Create a conditional formatting guide
Show steps
Develop a comprehensive guide that explains the different types of conditional formatting rules and how to use them effectively.
Browse courses on
Conditional Formatting
Show steps
-
Research different types of conditional formatting rules.
-
Create a spreadsheet that demonstrates each type of rule.
-
Write a guide that explains how to use the rules and includes examples.
-
Share the guide with others.
Build a dashboard using conditional formatting
Show steps
Create an interactive dashboard that uses conditional formatting to highlight key insights and trends in data.
Browse courses on
Conditional Formatting
Show steps
-
Gather data from different sources.
-
Clean and prepare the data.
-
Create a dashboard layout.
-
Apply conditional formatting rules to highlight key insights and trends.
-
Share the dashboard with others.
Review basic Excel formulas
Show steps
Brush up on basic Excel formulas, such as SUM, AVERAGE, and IF, before starting the course.
Browse courses on
Excel Formulas
Show steps
Show steps
Show steps
- Watch a video or read an article on basic Excel formulas.
- Open a spreadsheet and try out some basic formulas.
Organize course materials
Show steps
Gather and organize all course materials, such as notes, assignments, and quizzes, in one place.
Show steps
Show steps
Show steps
- Create a folder on your computer or in the cloud for course materials.
- Download or print all course materials.
- Label and organize the materials in a way that makes sense to you.
Connect with an experienced Excel user
Show steps
Reach out to an experienced Excel user who can provide guidance and support throughout the course.
Show steps
Show steps
Show steps
- Ask your friends, family, or colleagues if they know any experienced Excel users.
- Search for Excel user groups or forums online.
- Attend Excel events or workshops.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
متابعة دورات تعليمية حول التنسيق الشرطي
Show steps
تساعدك متابعة الدورات التعليمية على تعلم كيفية استخدام التنسيق الشرطي بفعالية.
Show steps
Show steps
Show steps
- ابحث عن دورات تعليمية حول التنسيق الشرطي.
- اشترك في الدورات التعليمية واتبعها.
- قم بالواجبات والتمارين المطلوبة.
إجراء تدريبات على التنسيق الشرطي
Show steps
يساعدك إجراء التدريبات على تحسين مهاراتك في التنسيق الشرطي.
Show steps
Show steps
Show steps
- قم بإعداد جدول بيانات يحتوي على بيانات مختلفة.
- قم بتطبيق التنسيق الشرطي على البيانات.
- قم بتحليل نتائج التنسيق الشرطي.
Learn the basics of conditional formatting
Show steps
Walk through step-by-step instructions and videos on how to apply basic conditional formatting rules in Excel.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Watch a video or read an article on the basics of conditional formatting.
- Open a spreadsheet and try out some basic conditional formatting rules.
- Experiment with different conditions and formatting options.
Solve Excel conditional formatting exercises
Show steps
Complete a set of Excel exercises to practice applying conditional formatting rules effectively.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Find a set of Excel exercises online or in a workbook.
- Solve the exercises and check your answers against the provided solutions.
- Repeat the exercises until you are confident in your ability to apply conditional formatting rules.
Collaborate on a conditional formatting project
Show steps
Work with a peer to create a spreadsheet with conditional formatting rules that meet specific criteria.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Find a partner who is also interested in learning about conditional formatting.
- Choose a dataset to work with.
- Decide on the conditional formatting rules that you want to apply.
- Create the spreadsheet and apply the conditional formatting rules.
- Share the spreadsheet with your partner and get feedback.
Create a conditional formatting guide
Show steps
Develop a comprehensive guide that explains the different types of conditional formatting rules and how to use them effectively.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Research different types of conditional formatting rules.
- Create a spreadsheet that demonstrates each type of rule.
- Write a guide that explains how to use the rules and includes examples.
- Share the guide with others.
Build a dashboard using conditional formatting
Show steps
Create an interactive dashboard that uses conditional formatting to highlight key insights and trends in data.
Browse courses on
Conditional Formatting
Show steps
Show steps
Show steps
- Gather data from different sources.
- Clean and prepare the data.
- Create a dashboard layout.
- Apply conditional formatting rules to highlight key insights and trends.
- Share the dashboard with others.
Career center
Learners who complete Microsoft Excel التنسيق المخصص والشرطي في will develop knowledge and skills
that may be useful to these careers:
Statistician
Statistician
Statisticians use their knowledge of data formatting and analysis to help organizations understand and make use of data. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Financial Analyst
Financial Analyst
Financial Analysts use their knowledge of data formatting and analysis to help organizations make better financial decisions. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use their knowledge of data formatting and analysis to help organizations make better investment decisions. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Market Researcher
Market Researcher
Market Researchers use their knowledge of data formatting and analysis to help organizations better understand their customers and markets. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Data Scientist
Data Scientist
Data Scientists use their knowledge of data formatting and analysis to help organizations make better decisions. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Management Consultant
Management Consultant
Management Consultants use their knowledge of data formatting and analysis to help organizations improve their performance. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Data Analyst
Data Analyst
Data Analysts use their knowledge of data formatting and analysis to help organizations make better decisions. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Business Analyst
Business Analyst
Business Analysts use their knowledge of data formatting and analysis to help organizations improve their business processes. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use their knowledge of data formatting and analysis to help organizations improve their efficiency and effectiveness. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Computer Programmer
Computer Programmer
Computer Programmers use their knowledge of data formatting and analysis to help organizations develop and maintain computer programs. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Software Engineer
Software Engineer
Software Engineers use their knowledge of data formatting and analysis to help organizations develop and maintain software systems. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Database Administrator
Database Administrator
Database Administrators use their knowledge of data formatting and analysis to help organizations manage and maintain databases. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Web Developer
Web Developer
Web Developers use their knowledge of data formatting and analysis to help organizations design and develop websites. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Information Security Analyst
Information Security Analyst
Information Security Analysts use their knowledge of data formatting and analysis to help organizations protect their data from security breaches. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
Systems Analyst
Systems Analyst
Systems Analysts use their knowledge of data formatting and analysis to help organizations design and implement computer systems. Those who wish to enter this career field should take this course on Formatting and Conditional Formatting in Microsoft Excel to get the most out of the data analysis tools provided by Excel. This course will help you build a foundation in data analysis and provide you with the skills and knowledge necessary to succeed in this role.
For more career information including salaries, visit:
OpenCourser.com/course/hgv5kj/microsoft
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
Microsoft Excel التنسيق المخصص والشرطي في .
Combines data analysis and business modeling concepts in Excel, providing learners with a practical understanding of how to use Excel to solve real-world business problems. It valuable resource for learners who want to develop their analytical and problem-solving skills.
Teaches learners how to use VBA to automate repetitive tasks in Excel, such as data entry, formatting, and analysis. It practical guide for learners who want to improve their efficiency and productivity in Excel.
Provides a comprehensive guide to creating and customizing charts and graphs in Excel. It covers a wide range of chart types, including bar charts, line charts, and pie charts. It valuable resource for learners who want to improve their data visualization and presentation skills.
Provides a comprehensive guide to creating effective dashboards and reports in Excel. It covers topics such as data visualization, chart design, and interactive dashboards. It valuable resource for learners who want to improve their communication and presentation skills with data.
Save
Provides a beginner-friendly introduction to VBA programming in Excel. It covers the basics of VBA, including variables, loops, and functions. It good starting point for learners who want to learn how to automate tasks and enhance the functionality of their spreadsheets.
Beginner-friendly guide to using Microsoft Excel, covering the basics of creating and editing spreadsheets, using formulas and functions, and presenting data. It good starting point for learners who are new to Excel.
Provides a collection of tips and tricks for using Excel. It covers a wide range of topics, including keyboard shortcuts, formatting tricks, and data manipulation techniques. It valuable resource for learners who want to improve their productivity and efficiency in Excel.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/hgv5kj/microsoft
Share
Similar courses
Here are nine courses similar to
Microsoft Excel التنسيق المخصص والشرطي في .
Microsoft Excel إنشاء أداه تعقب لإدارة المشاريع باستخدام
OpenCourser.com/course/8zshud/microsoft
Microsoft Excel إنشاء أداه تعقب لإدارة المشاريع باستخدام
Most relevant
Microsoft Excel إنشاء متعقب جدولة المهام باستخدام
OpenCourser.com/course/ch9jxe/microsoft
Microsoft Excel إنشاء متعقب جدولة المهام باستخدام
Most relevant
Microsoft Excel إنشاء جدول اجتماع باستخدام
OpenCourser.com/course/3raqi5/microsoft
Microsoft Excel إنشاء جدول اجتماع باستخدام
Most relevant
Microsoft Excel مقدمة إلى تحليل البيانات باستخدام
OpenCourser.com/course/y30ji6/microsoft
Microsoft Excel مقدمة إلى تحليل البيانات باستخدام
Most relevant
Microsoft Excel إنشاء تقرير المصروفات باستخدام
OpenCourser.com/course/ch6vs8/microsoft
Microsoft Excel إنشاء تقرير المصروفات باستخدام
Most relevant
Microsoft Excel حسابات البيانات في
OpenCourser.com/course/pg8ytu/microsoft
Microsoft Excel حسابات البيانات في
Most relevant
Microsoft Excel إنشاء سجل دوام لموظف باستخدام
OpenCourser.com/course/3eblff/microsoft
Microsoft Excel إنشاء سجل دوام لموظف باستخدام
Most relevant
إنشاء المخططات و لوحات المعلومات باستخدام Microsoft Excel
OpenCourser.com/course/xau6cc/nsh
إنشاء المخططات و لوحات المعلومات باستخدام Microsoft Excel
Most relevant
Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال
OpenCourser.com/course/ykvsig/excel
Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات...
Most relevant
Effort
2 hours
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Abdelrahman Tarek Hafez
Language
العربية
Good to know
Designed for learners who want to understand how to use conditional and custom formatting in Excel
Suitable for those with zero knowledge of Excel's conditional and custom formatting features
Taught by Abdelrahman Tarek Hafez, whose expertise is not immediately obvious
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