الرئيسية كورسات

شرح دالة Sum Product في اكسل

1/01/2022 10:30:22 ص

شرح دالة Sum Product في اكسل

شرح دالة Sum Product في اكسل

هنتعلم في المقال ده

شرح دالة SUMPRODUCT
شرح دالة sum SUMIF SUMIFS
دالة PRODUCT
الفرق بين SUMIF و SUMIFS
SUMPRODUCT شرح

شرح دالة Sum Product في اكسل

شرح دالة Sum Product في اكسل

SUMIFS, SUMPRODUCT هما دالتان من دوال برنامج مايكروسوفت إكسيل المُميّزة التي نستخدمها لجمع مجموعة من الأرقام معًا، ولكن بشروط معينةٍ. وهي ما سنتعرف عليه من خلال مقالنا هذا، الذي يعد واحدًا من ضمن سلسلة مقالاتٍ عن كيفية التعامل مع برنامج الإكسيل. وقد تحدثنا في المقال السابق عن الفرق بين دالة SUM, SUMIF. وسنستكمل الحديث اليوم عن دالتيّ SUMIFS, SUMPRODUCT

دالة SUMPRODUCT
هي دالة تُستخدم لحساب إجمالي مبيعات مجموعة من المنتجات، وتتم عن طريق ضرب الكمية * السعر لكل منتج، ثم يتم جمع المنتجات كلها معًا.

ترجع الدالة SUMPRODUCT مجموع منتجات النطاقات أو الصفائف المطابقة. العملية الافتراضية هي الضرب، ولكن الإضافة والطرح والقسمة ممكنة أيضا

دالة SUMIFS
تتم عملية الجمع بُناءً عن عدة شروط مختلفة، ولا بُدّ أن تتحقق الشروط كلها معًا. وهي تختلف عن الدالة SUMIF، حيث أن الأخيرة تقوم بجمع الأرقام بناءً على شرط واحدٍ فقط، أما الدالة SUMIFS فإنها تقوم بجمع الأرقام بُناءً على أكثر من شرط، ولا بُدً أن يتحققا معًا.

هيكل دالة SUMIFS يكون كالتالي:

=SUMIFS (sum range; criteria_range1; criteria1; criteria_range2; criteria2..

مصطلح Sum Range: يعبّر عن نطاق الخلايا التي سيتم جمعها إذا تحقّقت جميع الشروط.
مصطلح criteria_range1: يعبّر عن نطاق الخلايا التي تحتوي على الشرط الأول.
مصطلح criteria1: يعبّر عن الشرط الذي يجب أن يتحقّق حتى تتم عملية الجمع.
مصطلح criteria_range2: يعبّر عن النطاق الذي يحتوي على المعيار الثاني أو الشرط الثاني.
مصطلح criteria2: يعبّر عن الشرط الثاني الذي يجب أن يتحقّق مع الشرط الأول حتى تتم عملية الجمع.

SUMIFS, SUMPRODUCT هما دالتان من دوال برنامج مايكروسوفت إكسيل المُميّزة التي نستخدمها لجمع مجموعة من الأرقام معًا، ولكن بشروط معينةٍ. وهي ما سنتعرف عليه من خلال مقالنا هذا، الذي يعد واحدًا من ضمن سلسلة مقالاتٍ عن كيفية التعامل مع برنامج الإكسيل. وقد تحدثنا في المقال السابق عن الفرق بين دالة SUM, SUMIF. وسنستكمل الحديث اليوم عن دالتيّ SUMIFS, SUMPRODUCT

شرح دالة Sum Product في اكسل

ودلوقتي اتفضلوا ده فيديو شرح دالة Sum Product في اكسل

https://www.youtube.com/watch?v=HXclTODJafY

شرح دالة Sum Product في اكسل

اتعلمنا في المقال ده

شرح دالة SUMPRODUCT
شرح دالة sum SUMIF SUMIFS
دالة PRODUCT
الفرق بين SUMIF و SUMIFS
SUMPRODUCT شرح

ولو عايز تعرف أكتر عن الجداول المحورية إضغط هنا

الأقسام كورسات كورسات أوفيس Excel

أخر المواضيع من قسم : كورسات

تعليقات

ليست هناك تعليقات

إرسال تعليق

إرسال تعليق

وضع القراءة :

حجم الخط

+

16

-

تباعد السطور

+

2

-

window['__wavt'] = 'AOuZoY47WorjF59qFK9TUiI36e_gFRVGVA:1714146891134';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2018626715377232845','//www.abdelrahman-academy.com/2021/12/SUM-PRODUCT-Formula-in%20Excel.html','2018626715377232845'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2018626715377232845', 'title': 'Abdelrahman Academy', 'url': 'https://www.abdelrahman-academy.com/2021/12/SUM-PRODUCT-Formula-in%20Excel.html', 'canonicalUrl': 'https://www.abdelrahman-academy.com/2021/12/SUM-PRODUCT-Formula-in%20Excel.html', 'homepageUrl': 'https://www.abdelrahman-academy.com/', 'searchUrl': 'https://www.abdelrahman-academy.com/search', 'canonicalHomepageUrl': 'https://www.abdelrahman-academy.com/', 'blogspotFaviconUrl': 'https://www.abdelrahman-academy.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-154672493-1', 'encoding': 'UTF-8', 'locale': 'ar', 'localeUnderscoreDelimited': 'ar', 'languageDirection': 'rtl', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Abdelrahman Academy - Atom\x22 href\x3d\x22https://www.abdelrahman-academy.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Abdelrahman Academy - RSS\x22 href\x3d\x22https://www.abdelrahman-academy.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Abdelrahman Academy - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2018626715377232845/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Abdelrahman Academy - Atom\x22 href\x3d\x22https://www.abdelrahman-academy.com/feeds/1952728113197350582/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-2687340445082171', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/16e657cb9c57b8a2', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0631\u0627\u0628\u0637', 'key': 'link', 'shareMessage': '\u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0631\u0627\u0628\u0637', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Facebook', 'target': 'facebook'}, {'name': '\u0643\u062a\u0627\u0628\u0629 \u0645\u062f\u0648\u0646\u0629 \u062d\u0648\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629', 'key': 'blogThis', 'shareMessage': '\u0643\u062a\u0627\u0628\u0629 \u0645\u062f\u0648\u0646\u0629 \u062d\u0648\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Pinterest', 'target': 'pinterest'}, {'name': '\u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a', 'key': 'email', 'shareMessage': '\u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ar\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': '\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u0632\u064a\u062f', 'pageType': 'item', 'postId': '1952728113197350582', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEgOpve_MxRA8xvnZ2fPmu5LFa95SLhtzhQbMcbdshzJiBZV9XQJZzta9RxyEmGDfPVI02N0ubpor5Mt3G0Zi2zZMMAxZe5k0EzkhLjuW0aalBs7FyJuwKi51ppwgG_QggF2szCnQdrZCKriU-jhGj0uTy4T-9zULXMMu5eBR6pZLpjuqbWT2wWBhGfM\x3ds72-c', 'postImageUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEgOpve_MxRA8xvnZ2fPmu5LFa95SLhtzhQbMcbdshzJiBZV9XQJZzta9RxyEmGDfPVI02N0ubpor5Mt3G0Zi2zZMMAxZe5k0EzkhLjuW0aalBs7FyJuwKi51ppwgG_QggF2szCnQdrZCKriU-jhGj0uTy4T-9zULXMMu5eBR6pZLpjuqbWT2wWBhGfM\x3ds320', 'pageName': '\u0634\u0631\u062d \u062f\u0627\u0644\u0629 Sum Product \u0641\u064a \u0627\u0643\u0633\u0644', 'pageTitle': 'Abdelrahman Academy: \u0634\u0631\u062d \u062f\u0627\u0644\u0629 Sum Product \u0641\u064a \u0627\u0643\u0633\u0644', 'metaDescription': '\u0634\u0631\u062d \u062f\u0627\u0644\u0629 SUMPRODUCT\n\u0634\u0631\u062d \u062f\u0627\u0644\u0629 sum SUMIF SUMIFS\n\u062f\u0627\u0644\u0629 PRODUCT\n\u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 SUMIF \u0648 SUMIFS\nSUMPRODUCT \u0634\u0631\u062d\n'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\u062a\u0639\u062f\u064a\u0644', 'linkCopiedToClipboard': '\u062a\u0645 \u0646\u0633\u062e \u0627\u0644\u0631\u0627\u0628\u0637 \u0625\u0644\u0649 \u0627\u0644\u062d\u0627\u0641\u0638\u0629', 'ok': '\u062d\u0633\u0646\u064b\u0627', 'postLink': '\u0631\u0627\u0628\u0637 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\u0645\u062e\u0635\u0635', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0634\u0631\u062d \u062f\u0627\u0644\u0629 Sum Product \u0641\u064a \u0627\u0643\u0633\u0644', 'description': '\u0634\u0631\u062d \u062f\u0627\u0644\u0629 SUMPRODUCT\n\u0634\u0631\u062d \u062f\u0627\u0644\u0629 sum SUMIF SUMIFS\n\u062f\u0627\u0644\u0629 PRODUCT\n\u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 SUMIF \u0648 SUMIFS\nSUMPRODUCT \u0634\u0631\u062d\n', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgOpve_MxRA8xvnZ2fPmu5LFa95SLhtzhQbMcbdshzJiBZV9XQJZzta9RxyEmGDfPVI02N0ubpor5Mt3G0Zi2zZMMAxZe5k0EzkhLjuW0aalBs7FyJuwKi51ppwgG_QggF2szCnQdrZCKriU-jhGj0uTy4T-9zULXMMu5eBR6pZLpjuqbWT2wWBhGfM\x3ds320', 'url': 'https://www.abdelrahman-academy.com/2021/12/SUM-PRODUCT-Formula-in%20Excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 1952728113197350582}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'BlogAuthors', 'type': 'Profile', 'sectionId': 'sitting', 'id': 'Profile400'}, {'title': '\u0627\u0644\u0635\u0641\u062d\u0627\u062a', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Abdelrahman Academy (\u0631\u0623\u0633 \u0627\u0644\u0635\u0641\u062d\u0629)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': '\u0642\u062f \u064a\u0639\u062c\u0628\u0643', 'type': 'HTML', 'sectionId': 'shreeta5bar', 'id': 'HTML300'}, {'title': '', 'type': 'HTML', 'sectionId': 'TopPost-sc', 'id': 'HTML23'}, {'title': '\u0627\u062d\u062f\u062b \u0627\u0644\u0645\u0642\u0627\u0644\u0627\u062a', 'type': 'HTML', 'sectionId': 'TopPost-sc', 'id': 'HTML5'}, {'title': '\u0643\u0648\u0631\u0633\u0627\u062a', 'type': 'HTML', 'sectionId': 'Postcs2', 'id': 'HTML6'}, {'title': '\u0627\u0644\u0645\u0642\u0627\u0644\u0627\u062a', 'type': 'HTML', 'sectionId': 'Postcs3', 'id': 'HTML7'}, {'title': '\u062a\u0639\u0644\u064a\u0645 \u0648\u0645\u0648\u0627\u062f \u062f\u0631\u0627\u0633\u064a\u0629', 'type': 'HTML', 'sectionId': 'Postcs4', 'id': 'HTML8'}, {'title': '\u0631\u0633\u0627\u0626\u0644 \u0627\u0644\u0645\u062f\u0648\u0646\u0629 \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a\u0629', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '1952728113197350582', 'title': '\u0634\u0631\u062d \u062f\u0627\u0644\u0629 Sum Product \u0641\u064a \u0627\u0643\u0633\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgOpve_MxRA8xvnZ2fPmu5LFa95SLhtzhQbMcbdshzJiBZV9XQJZzta9RxyEmGDfPVI02N0ubpor5Mt3G0Zi2zZMMAxZe5k0EzkhLjuW0aalBs7FyJuwKi51ppwgG_QggF2szCnQdrZCKriU-jhGj0uTy4T-9zULXMMu5eBR6pZLpjuqbWT2wWBhGfM\x3ds320', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'backlinks', 'label': 'Links to this post'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'backlinks', 'label': 'Links to this post'}, {'name': 'labels', 'label': ''}]}, {'title': '\u0639\u0631\u0636 \u062e\u0627\u0635 \u0627\u0648\u0644', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0645\u0646\u062a\u0635\u0641', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML202'}, {'title': '\u0639\u0631\u0636 \u0627\u062e\u0631', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML203'}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0645\u0642\u0627\u0644\u0627\u062a \u0630\u0627\u062a \u0635\u0644\u0647', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML204'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0641\u0627\u0635\u0644\u0629 \u0627\u0644\u0627\u0646\u062a\u0642\u0627\u0644', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML221'}, {'title': '\u062e\u0635\u0645 \u0627\u0648\u0644 \u0641\u0642\u0631\u0647', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML205'}, {'title': '\u062b\u0627\u0646\u064a \u0641\u0642\u0631\u0629', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML206'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0627\u0648\u0644 \u0627\u0642\u062a\u0628\u0627\u0633', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML218'}, {'title': '\u0623\u0639\u0644\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0642\u0627\u0644 \u0623\u0633\u0627\u0633\u064a', 'type': 'LinkList', 'sectionId': 'PostA3lan', 'id': 'LinkList005'}, {'title': '\u0645\u064a\u0632\u0629 \u062c\u062f\u0648\u0644 \u0627\u0644\u062a\u0646\u0642\u0644', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML1'}, {'title': '\u0645\u064a\u0632\u0629 \u0634\u0627\u0647\u062f \u0627\u064a\u0636\u0627', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML2'}, {'title': '\u0646\u0645\u0648\u0630\u062c \u0627\u0644\u0627\u062a\u0635\u0627\u0644', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '', 'type': 'HTML', 'sectionId': 'sidepar', 'id': 'HTML22'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '\u062a\u0628\u062d\u062b \u0639\u0646 \u0634\u0626 \u061f', 'type': 'BlogSearch', 'sectionId': 'sidepar', 'id': 'BlogSearch1'}, {'title': '\u0645\u0642\u0627\u0644\u0627\u062a \u0627\u0643\u062b\u0631 \u0632\u064a\u0627\u0631\u0629', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': [{'title': '\u0643\u0648\u0631\u0633 \u0627\u0643\u0633\u064a\u0644 \u0645\u062c\u0627\u0646\u0649 \u0645\u0646 \u0627\u0644\u0628\u062f\u0627\u064a\u0647 \u0644\u0644\u0627\u062d\u062a\u0631\u0627\u0641 \u0628\u0627\u0644\u0645\u0627\u062a\u064a\u0631\u064a\u0627\u0644 \u0648\u0627\u0644\u0634\u0647\u0627\u062f\u0647 \u0627\u0644\u0645\u062c\u0627\u0646\u064a\u0629', 'id': 871149218076842607}, {'title': '\u0643\u0644 \u0627\u0635\u062f\u0627\u0631\u0627\u062a \u0643\u062a\u0628 \u0643\u0627\u0645\u0628\u0631\u064a\u062f\u062c \u0641\u0649 \u0627\u0644\u0644\u063a\u0647 \u0627\u0644\u0627\u0646\u062c\u0644\u064a\u0632\u064a\u0629 \u0644\u0644\u0627\u064a\u0644\u062a\u0633 PDF', 'id': 1898762018410353721}, {'title': '\u0643\u0648\u0631\u0633 Power BI \u0645\u062c\u0627\u0646\u0649 \u0628\u0627\u0644\u0645\u0627\u062a\u064a\u0631\u064a\u0627\u0644', 'id': 1010452572905751865}, {'title': '\u0643\u064a\u0641\u064a\u0629 \u0648\u0636\u0639 \u0639\u0644\u0627\u0645\u0629 \u0635\u062d \u0623\u0648 \u062e\u0637\u0623 \u0641\u064a \u0627\u0643\u0633\u0644', 'id': 1136585061668866640}]}, {'title': '\u0627\u0642\u0633\u0627\u0645 \u0627\u0644\u0645\u062f\u0648\u0646\u0629', 'type': 'Label', 'sectionId': 'sidepar', 'id': 'Label1'}, {'title': '\u0628\u0627\u0642\u0649 \u0633\u0627\u0639\u062a\u064a\u0646 \u0641\u0642\u0637', 'type': 'HTML', 'sectionId': 'sidepar', 'id': 'HTML17'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'rtl', 'loadingMessage': '\u200f\u062c\u0627\u0631\u064d \u0627\u0644\u062a\u062d\u0645\u064a\u0644\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile400', 'sitting', document.getElementById('Profile400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': '\u0627\u0644\u0635\u0641\u062d\u0627\u062a', 'links': [{'isCurrentPage': false, 'href': '/p/blog-page_17.html', 'title': '\u0645\u0646 \u0646\u062d\u0646 \u061f'}, {'isCurrentPage': false, 'href': '/p/privacy-policy.html', 'title': '\u0633\u064a\u0627\u0633\u0629 \u0627\u0644\u062e\u0635\u0648\u0635\u064a\u0629'}, {'isCurrentPage': false, 'href': '/p/index.html', 'title': '\u0627\u0644\u0641\u0647\u0631\u0633'}, {'isCurrentPage': false, 'href': '/p/contact-us.html', 'title': '\u062a\u0648\u0627\u0635\u0644 \u0645\u0639\u0646\u0627'}, {'isCurrentPage': false, 'href': '/p/usage-agreement.html', 'title': '\u0627\u062a\u0641\u0627\u0642\u064a\u0629 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645'}, {'isCurrentPage': false, 'href': 'https://www.youtube.com/c/LearnWithDrAbdelrahman', 'title': '\u0642\u0646\u0627\u062a\u0646\u0627 \u0639\u0644\u0649 \u0627\u0644\u064a\u0648\u062a\u064a\u0648\u0628 \u0644\u0644\u0634\u0631\u0648\u062d\u0627\u062a \u0627\u0644\u0639\u0645\u0644\u064a\u0629'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML300', 'shreeta5bar', document.getElementById('HTML300'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'TopPost-sc', document.getElementById('HTML23'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML5', 'TopPost-sc', document.getElementById('HTML5'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML6', 'Postcs2', document.getElementById('HTML6'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML7', 'Postcs3', document.getElementById('HTML7'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML8', 'Postcs4', document.getElementById('HTML8'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1625436979-lbx__ar.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle_rtl.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML202', 'PostA3lan', document.getElementById('HTML202'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML203', 'PostA3lan', document.getElementById('HTML203'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML204', 'PostA3lan', document.getElementById('HTML204'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML221', 'PostA3lan', document.getElementById('HTML221'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML205', 'PostA3lan', document.getElementById('HTML205'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML206', 'PostA3lan', document.getElementById('HTML206'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML218', 'PostA3lan', document.getElementById('HTML218'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList005', 'PostA3lan', document.getElementById('LinkList005'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'AddOns', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'AddOns', document.getElementById('HTML2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': '\u062c\u0627\u0631\u064d \u0627\u0644\u0625\u0631\u0633\u0627\u0644...', 'contactFormMessageSentMsg': '\u062a\u0645 \u0625\u0631\u0633\u0627\u0644 \u0631\u0633\u0627\u0644\u062a\u0643.', 'contactFormMessageNotSentMsg': '\u062a\u0639\u0630\u0631 \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0631\u0633\u0627\u0644\u0629\u060c \u064a\u0631\u062c\u0649 \u0627\u0644\u0645\u062d\u0627\u0648\u0644\u0629 \u0645\u0631\u0629 \u0623\u062e\u0631\u0649 \u0641\u064a \u0648\u0642\u062a \u0644\u0627\u062d\u0642.', 'contactFormInvalidEmailMsg': '\u064a\u0644\u0632\u0645 \u0625\u062f\u062e\u0627\u0644 \u0639\u0646\u0648\u0627\u0646 \u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0635\u0627\u0644\u062d.', 'contactFormEmptyMessageMsg': '\u0644\u0627 \u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0643\u0648\u0646 \u062d\u0642\u0644 \u0627\u0644\u0631\u0633\u0627\u0644\u0629 \u0641\u0627\u0631\u063a\u064b\u0627.', 'title': '\u0646\u0645\u0648\u0630\u062c \u0627\u0644\u0627\u062a\u0635\u0627\u0644', 'blogId': '2018626715377232845', 'contactFormNameMsg': '\u0627\u0644\u0627\u0633\u0645', 'contactFormEmailMsg': '\u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a', 'contactFormMessageMsg': '\u0631\u0633\u0627\u0644\u0629', 'contactFormSendMsg': '\u0625\u0631\u0633\u0627\u0644', 'contactFormToken': 'AOuZoY5GHp4iqMx30N5McF1qY_ESTjFeIQ:1714146891135', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'sidepar', document.getElementById('HTML22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch1', 'sidepar', document.getElementById('BlogSearch1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'sidepar', document.getElementById('Label1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML17', 'sidepar', document.getElementById('HTML17'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));