|
via Udemy |
Go to Course: https://www.udemy.com/course/excelbasic/
Certainly! Here's a detailed review and recommendation for the "excelbasic" course on Coursera: --- **Course Review: ExcelBasic on Coursera** **Overview:** "ExcelBasic" is an introductory course designed to teach the fundamentals of Microsoft Excel 2016. The course covers a wide range of essential skills, making it suitable for beginners who want to develop a solid understanding of Excel. The course content is delivered primarily in Arabic, catering to learners who prefer to learn in their native language, which enhances comprehension and engagement. **Course Content:** The course begins with the basics, including opening the program, customizing the Quick Access Toolbar, saving workbooks, and protecting sheets. It then progresses to more advanced topics such as creating, renaming, and coloring sheet tabs, copying and moving worksheets, and working with cell content through cut, copy, and paste functions. Practical skills like adjusting column widths and row heights, showing or hiding sheets, and saving in different formats (PDF, XPS) are thoroughly covered. The course also emphasizes data editing, text formatting—such as font style, size, color, and text wrapping—and applying styles and alignment. Further, learners explore searching and replacing data, freezing panes, and understanding absolute vs. relative cell references. The course introduces formatting cells into numbers, dates, times, and currency, along with spell check and conditional formatting features. In addition to basic data handling, the course delves into formulas and functions like sum, average, max, min, as well as arithmetic and logical operations using AND and OR functions. Handling data from other sheets through cell references, creating and formatting charts, and exporting charts are also covered. The course emphasizes practical applications, with explanations in Arabic, accompanied by relevant examples and practice files available via a link provided in the lessons. There is a final exam to assess understanding and mastery of the material. **Review:** This course is highly suitable for beginners seeking to build a strong foundation in Excel. Its comprehensive coverage of core functionalities combined with clear instruction in Arabic makes it accessible and user-friendly. The inclusion of real-life applications and practice files enhances hands-on learning, which is crucial for mastering Excel skills. The course's structure, moving from basic navigation to more complex features like formulas and charting, allows learners to gradually build confidence and competence. The final assessment ensures learners can consolidate their knowledge and apply what they have learned. **Recommendation:** I highly recommend the "ExcelBasic" course for anyone starting out with Excel, especially Arabic-speaking learners. It provides thorough, practical instruction that can significantly improve your data management and analysis skills. Whether you need Excel for academic, professional, or personal purposes, this course offers the essential tools and confidence to navigate Excel effectively. **Final Verdict:** A well-designed, accessible, and comprehensive beginner course that will serve as a strong foundation for further advanced Excel studies. --- If you have any further questions or need assistance with enrolling or how to maximize your learning from this course, feel free to ask!
تعلم أساسيات برنامج اكسل 2016.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***فتح البرنامج و تغيير الأوامر على شريط أدوات الوصول السريع. حفظ المصنفات و حماية أوراق العمل و المصنفات.انشاء و اعادة تسمية و تغيير لون تبويب ورقة العملنسخ و نقل ورقة المعملنسخ قص لصق الخلية.نقل ونسخ الخلايا بالسحب.تغيير عرض الأعمدة.تغيير ارتفاع الصفوف.اظهار أو اخفاء اوراق العمل..PDF XPS حفظ المصنفات بتنسيقات أخرى مثل .*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***تحرير البيانات و تنسيق النصوص من لون وتعبئة و نوع خط و حجم والتفاف.تطبيق الأنماط و المحاذاة يمين يسار و توسيط ، اعلى اسفل و منتصف.البحث و الاستبدال.تثبيت أو تجميد الخلية.الخلية المطلقة و الخلية النسبية.تنسيق الخلية إلى رقم تاريخ وقت أو عملة.تطبيق التدقيق الاملائي على المحتوى و التنسيق الشرطي.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***التعامل مع الدوال مثل الجمع و المتوسط الحسابي و اعلى قيمة و ادنى قيمة،.العمليات الحسابية الجمع و الطرح و القسمة و الضرب.العمليات المنطقية اكبر من و اكبر ، اصغر من و اصغر، مساوي و غير مساوي.AND و OR. التعامل مع الدالة المنطقية*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***التأشير إلى خلية في ورقة عمل أخرى.تحويل المحتوى الى مخططات و كيفية التعامل مع عناصر المخطط.التعامل من أنماط المخططات.نقل المخطط كعنصر.التعامل مع خطوط المؤشر و تنسيقها و تطبيق الأنماط عليها.طباعة المصنفات أو أوراق العمل و مشاركة أو ارسالها كمرفقات.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***شرح مع بعض التطبيات للمواضيع المهمه.الشرح باللغة العربية.وجهة الاكسل باللغة العربية.للتطبيق مع المدربة يتوفر ملفات مساعدة في الرابط المرفق اسفل الدرس.ليست كل التطبيقات متوفرة كملفات.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***بالنهاية اختبار نهائي وكل التوفيق