

Our Courses

الجداول والرسوم التوضيحية في مايكروسوفت إكسل
برنامج (Microsoft Excel) هو برنامج تم ابتكاره ليصبح أداة قوية وفعالة لتجميع وتحليل البيانات من قبل العديد من الفئات العاملة في المجالات المالية وغيرها، مثل العاملين في مجال الموارد البشرية والمخازن وغيرهم. يتطلب تجميع البيانات ترتيبَها بشكل منظم ليتمكن المستخدم من إجراء التحليل المطلوب لها والوصول إلى النتائج الصحيحة التي تساعد مجلس إدارة المنشأة في اتخاذ القرارات المالية والتشغيلية المستقبلية.
-
Course by
-
Self Paced
-
2 hours
-
Arabic

Business Statistics and Analysis
The Business Statistics and Analysis Specialization is designed to equip you with a basic understanding of business data analysis tools and techniques. Informed by our world-class Data Science master's and PhD course material, you’ll master essential spreadsheet functions, build descriptive business data measures, and develop your aptitude for data modeling. You’ll also explore basic probability concepts, including measuring and modeling uncertainty, and you’ll use various data distributions, along with the Linear Regression Model, to analyze and inform business decisions.
-
Course by
-
Self Paced
-
English

Microsoft Excel التنسيق المخصص والشرطي في
فى نهاية المشروع ده , هتقدر تستخدم التنسيق الشرطى و المخصص فى جدول بيانات excel باستخدام نسخة مجانية من Microsoft Excel.
-
Course by
-
Self Paced
-
3 hours
-
Arabic

Microsoft Excel بحث و ترتيب وتصفية البيانات فى
فى نهاية الفيديو 5 ، ستكون قادرًا على استخدام وظيفة vlookup عشان نحدد قيمة عمود من خلال عمود اخر.
-
Course by
-
Self Paced
-
2 hours
-
Arabic

Microsoft Excel إنشاء جدول اجتماع باستخدام
فى نهاية المشروع ده , هتقدر تنشئ جدول اجتماعات بطريقة منظمة و سهلة التتبع باستخدام Microsoft Excel.
-
Course by
-
Self Paced
-
3 hours
-
Arabic

Microsoft Excel إنشاء متعقب جدولة المهام باستخدام
في نهاية المشروع ده هتقدر تنشىء تعقب جدولة المهام اللى بيساعد على مراقبة المواعيد النهائية المهمة و الالتزام بها بطريقة سهلة و سريعة باستخدام Microsoft Excel.
-
Course by
-
Self Paced
-
3 hours
-
Arabic

Microsoft Excel مقدمة إلى تحليل البيانات باستخدام
فى نهاية المشروع ده , هتقدر تحدد و تستخدم أساسيات تحليل البيانات باستخدام Microsoft excel.
-
Course by
-
Self Paced
-
2 hours
-
Arabic

Microsoft Excel إنشاء أداه تعقب لإدارة المشاريع باستخدام
فى نهاية المشروع ده هتقدر تنشئ صفحة لتعقب و تتبع ادارة المشاريع البسيطة,و تقدر تستخدمها للعرض التقديمى لاى مشروع خاص بك او بالشركة باستخدام Microsoft Excel. خلال المشروع هتقدر تدخل على النسخة المجانية ل Microsoft Excel على الانترنت و تعمل رابط مشاركة مع زمايلك فى العمل او مع مديرك. و هتقدر تنظم و ترتب المهام و الاقسام لتعقب ادارة المشروع. هتقدر كمان تستخدم مهارات ادارة المشروع لتطوير جدول بيانات تعقب ادارة المشروع.
-
Course by
-
Self Paced
-
2 hours
-
Arabic

موضوعات متقدمة في برنامج مايكروسوفت وورد
يمتاز برنامج (Microsoft Word) بالعديد من تنسيقات النصوص المختلفة مثل الاختيار بين أنواع الخطوط والألوان بالإضافة إلى إمكانية إضافة الصور والأشكال، إضافة إلى ذلك يُمكنّك البرنامج أيضاً من الدمج بينه وبين البرنامج الشهير (Microsoft Excel) إضافة إلى العديد من المزايا الأخرى التي تعلمناها على مدار الدورات الماضية، إذ توجد إمكانيات إضافية أخرى متقدمة يمكن الاعتماد عليها في مجال الأعمال مثل ربط النص بنصوص أخرى وبمصادر معلومات خارجية إضافة إلى القدرة على حماية النص بالعديد من الأشكال كي لا يتم اختراقه أو التغيير في محتواه بالإضافة إلى إمكانيات التصحيح اللغوي التلقائي. هذه الدورة هي دورة تمهيدية؛ فه
-
Course by
-
Self Paced
-
1 hour
-
Arabic

Excel والمخططات المتقدمة فى Pivotاستخدام جداول و مخططات ال
فى نهاية المشروع ده هتقدر تنشئ مخططات و جداول pivot و رسوم بيانية متقدمة لتحليل بياناتك بطريقة سهلة و فعالة باستخدام Microsoft Excel.
-
Course by
-
Self Paced
-
3 hours
-
Arabic

كيف تبدأ بتعلم Microsoft Excel
في نهاية المشروع ده هتقدر تنظم و تقدم اى بيانات بشكل مرتب و عملى و احترافى باستخدام Microsoft Excel.. خلال المشروع، هتقدر تعمل صيغ أو " تسهل علينا و توفر علينا الوقت. و هتقدر تعمل تصفيه و فرز او "FILTER AND SORT" للبيانات الي في ال SHEET و كمان تستعمل خاصية ال FLASH FILL. هتعمل جدول من خلال البيانات المتاحة في الsheet و اخيرا هتقدر تنشئ رسم بياني من خلال الجداول.
-
Course by
-
Self Paced
-
4 hours
-
Arabic

الترجيح الإحصائي أو Statistical Weighting فى Microsoft Excel
فى نهاية المشروع ده هتقدر تحسب اساسيات الترجيح الاحصائى بطريقة سهلة باستخدام Microsoft Excel.
-
Course by
-
Self Paced
-
2 hours
-
Arabic

IBM Data Analytics with Excel and R
Prepare for the in-demand field of data analytics. In this program, you’ll learn high valued skills like Excel, Cognos Analytics, and R programming language to get job-ready in less than 3 months. Data analytics is a strategy-based science where data is analyzed to find trends, answer questions, shape business processes, and aid decision-making. This Professional Certificate focuses on data analysis using Microsoft Excel and R programming language.
-
Course by
-
Self Paced
-
English

Microsoft 365 Fundamentals
This Specialization is intended to help all novice computer users get up to speed with Microsoft 365 quickly. It covers different features of the interface, shows you how to perform basic tasks, and introduces you to the most important tools in Word, PowerPoint, and Excel. This program will help you to become familiar with the apps and services included in a Microsoft 365 subscription. You will improve your word processing, spreadsheet, and presentation skills to take your productivity to the next level.
-
Course by
-
Self Paced
-
English

Computational Reasoning with Microsoft Excel
Learn how to critically evaluate solutions and make well-informed decisions based on data by merging Microsoft Excel skills with philosophical critical reasoning. No prior experience with Microsoft Excel required.
-
Course by
-
Self Paced
-
13
-
English

Everyday Excel
This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.
-
Course by
-
English

Creating a Budget with Microsoft Excel
By the end of this project, you will learn how to create a budget template in an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that is similar in layout as accounting spreadsheets. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. While a budget helps you stay within estimated costs and expenses for either a business or a family. We will learn to create a budget both automatically and manually, step by step.
-
Course by
-
Self Paced
-
3 hours
-
English

Interweaving Tables, References, and Links in Excel
Microsoft Excel has a wide array of versatility and application across countless industries. However, it can be very particular in how the formulas need to be written to reference images, cells, sheets, and even other files. In this project, we discuss navigating the web of connections Excel is capable of, in hopes of making your life just a little bit easier.
-
Course by
-
Self Paced
-
3 hours
-
English

Introduction to Financial Accounting: The Accounting Cycle
In this hands-on Specialization you will practice completing each step of the accounting cycle within Microsoft Excel, from analyzing and recording the first financial transactions of the year all the way through starting the new fiscal year. The skills covered in this course include recording in the journal, posting in the ledgers, preparing financial statements, recording and posting closing entries, as well as preparing trial balances.
-
Course by
-
Self Paced
-
English

Spreadsheets for Beginners using Google Sheets
This 2-hour long project-based course is an introduction to spreadsheets. We’ll be using Google Sheets in this project, which is the free spreadsheet program offered by Google. With that said, most of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as Microsoft Excel.
-
Course by
-
Self Paced
-
3 hours
-
English

Conditional Formatting, Tables and Charts in Microsoft Excel
In this project, you will learn how to analyze data and identify trends using a variety of tools in Microsoft Excel. Conditional formatting and charts are two tools that focus on highlighting and representing data in a visual form. With conditional formatting, you can define rules to highlight cells using a range of color scales and icons and to help you analyze data and identify trends or outliers. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart.
-
Course by
-
Self Paced
-
3 hours
-
English

Create Charts and Dashboards Using Microsoft Excel
In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.
-
Course by
-
Self Paced
-
3 hours
-
English

Create a Financial Statement using Microsoft Excel
By the end of this project, you will be able to complete a financial statement with Microsoft Excel, composed of a transactions page, profit and loss statement, and balance sheet. You will learn how to enter your business transactions and interpret the data presented in the profit and loss statement. You will also learn about the components of a balance sheet and will have a better understanding of how a financial statement can be used to help track and present financial information for your company.
-
Course by
-
Self Paced
-
3 hours
-
English

Create a Simple Gantt Chart using Microsoft Excel
By the end of this project, you will be able to create a simple Gantt chart to manage your next project. You will utilize the free online version of Microsoft Excel to create a Gantt chart from scratch. This Gantt chart will give you a better idea of how bar charts and conditional formatting work. This guide will incorporate some Excel functions to teach you how to use conditional formatting to make your chart and data interactive.
-
Course by
-
Self Paced
-
3 hours
-
English

Building Candlestick Charts with Microsoft Excel
By the end of this project, you will create a candlestick chart with open, high, low, and close data from the stock market, and you will also set up an auto-refresh function to get the live data.
-
Course by
-
Self Paced
-
1 hour
-
English