الرئيسية البرامج المكتبية

كتاب الدالات الأساسية في برنامج الإكسل PDF

يناير 24, 2023

كتاب الدالات الأساسية في برنامج الإكسل PDF

اليوم سوف نقدم لكم كتاب تعلم الدالات الأساسية في برنامج الإكسل بصيغة PDF مجاناً، يشرح لك الكتاب أهم الدالات الموجودة داخل البرنامج وبالأمثلة وشروحات متقدمة باللغة العربية.

الدالات الأساسية في برنامج الإكسل

ما يغطيه كتاب تعلم الإكسل

شرح ما يزيد عن 100 دالة في برنامج الإكسل Microsoft Excel، تم تجميعهم وكتابتهم بشكل مفهوم ومبسط بحيث تحتوي كل دالة على مثال واحد على الأقل، وكذلك شرح بعض خفايا تلك الدالات والاستخدام الأنسب لها.

تم ترتيب هذا الدوال حسب الأهمية والأكثر استخداماً، مع الأخذ بعين الاعتبار الفئات وأنواع الدوال كالدالات الحسابية والنصية والمالية ودالات التاريخ والوقت... إلخ

تفاصيل الكتاب

عدد الصفحات: 62

التقييم: 4.7

لغة الكتاب: العربية

صيغة الكتاب: PDF

تحميل الكتاب بصيغة PDF

الأقسام البرامج المكتبية

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

تعليقات

تعليقان (2)

إرسال تعليق

Unknown 17 يوليو 2020 في 1:23 ص

الرابط
إرسال ردحذف
Unknown 1 يناير 2023 في 10:52 م

جميل ومفيد جدا شكرا لكم
إرسال ردحذف

إرسال تعليق

وضع القراءة :

حجم الخط

+

16

-

تباعد السطور

+

2

-

window['__wavt'] = 'AOuZoY4ohNNlvK5z8d0Zn1ekwGD4qd6WCA:1674985771515';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4723376279498582676','//www.kabbani-books.com/2020/05/excel-formulas.html','4723376279498582676'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4723376279498582676', 'title': 'kabbani books', 'url': 'https://www.kabbani-books.com/2020/05/excel-formulas.html', 'canonicalUrl': 'https://www.kabbani-books.com/2020/05/excel-formulas.html', 'homepageUrl': 'https://www.kabbani-books.com/', 'searchUrl': 'https://www.kabbani-books.com/search', 'canonicalHomepageUrl': 'https://www.kabbani-books.com/', 'blogspotFaviconUrl': 'https://www.kabbani-books.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-169618019-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\x22kabbani books - Atom\x22 href\x3d\x22https://www.kabbani-books.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22kabbani books - RSS\x22 href\x3d\x22https://www.kabbani-books.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22kabbani books - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4723376279498582676/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22kabbani books - Atom\x22 href\x3d\x22https://www.kabbani-books.com/feeds/5982951728774432430/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-3139707629987609', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/c8e2c1adf27eab47', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, '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': '5982951728774432430', 'postImageThumbnailUrl': 'https://1.bp.blogspot.com/-QniNMER8GiA/Xq6g5KXDW7I/AAAAAAAAAR0/R0aKqAJ2QK8mPFTKneDAh-fidjQymTpQACLcBGAsYHQ/s72-c/ezgif.com-gif-maker%2B%25281%2529.webp', 'postImageUrl': 'https://1.bp.blogspot.com/-QniNMER8GiA/Xq6g5KXDW7I/AAAAAAAAAR0/R0aKqAJ2QK8mPFTKneDAh-fidjQymTpQACLcBGAsYHQ/s640/ezgif.com-gif-maker%2B%25281%2529.webp', 'pageName': '\u0643\u062a\u0627\u0628 \u0627\u0644\u062f\u0627\u0644\u0627\u062a \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u0644 PDF', 'pageTitle': 'kabbani books: \u0643\u062a\u0627\u0628 \u0627\u0644\u062f\u0627\u0644\u0627\u062a \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u0644 PDF', 'metaDescription': ''}}, {'name': 'features', 'data': {'sharing_get_link_dialog': 'true', 'sharing_native': 'false'}}, {'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': '\u0643\u062a\u0627\u0628 \u0627\u0644\u062f\u0627\u0644\u0627\u062a \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u0644 PDF', 'description': '', 'featuredImage': 'https://1.bp.blogspot.com/-QniNMER8GiA/Xq6g5KXDW7I/AAAAAAAAAR0/R0aKqAJ2QK8mPFTKneDAh-fidjQymTpQACLcBGAsYHQ/s640/ezgif.com-gif-maker%2B%25281%2529.webp', 'url': 'https://www.kabbani-books.com/2020/05/excel-formulas.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 5982951728774432430}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'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': 'kabbani books (\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': '\u0627\u0644\u0643\u062a\u0628 \u0627\u0644\u0645\u0636\u0627\u0641\u0629 \u062d\u062f\u064a\u062b\u0627\u064b', 'type': 'HTML', 'sectionId': 'Postcs1', 'id': 'HTML3'}, {'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': '5982951728774432430', 'title': '\u0643\u062a\u0627\u0628 \u0627\u0644\u062f\u0627\u0644\u0627\u062a \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u0644 PDF', 'featuredImage': 'https://1.bp.blogspot.com/-QniNMER8GiA/Xq6g5KXDW7I/AAAAAAAAAR0/R0aKqAJ2QK8mPFTKneDAh-fidjQymTpQACLcBGAsYHQ/s640/ezgif.com-gif-maker%2B%25281%2529.webp', 'showInlineAds': true}], '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': ''}]}, {'regionName': 'footer3', 'items': [{'name': 'reactions', 'label': '\u0647\u0644 \u0627\u0639\u062c\u0628\u0643 \u0627\u0644\u0643\u062a\u0627\u0628'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'backlinks', 'label': 'Links to this post'}, {'name': 'labels', 'label': ''}, {'name': 'reactions', 'label': '\u0647\u0644 \u0627\u0639\u062c\u0628\u0643 \u0627\u0644\u0643\u062a\u0627\u0628'}]}, {'title': '\u0646\u0645\u0648\u0630\u062c \u0627\u0644\u0627\u062a\u0635\u0627\u0644', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'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': '\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('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': '\u0627\u0644\u0635\u0641\u062d\u0627\u062a', 'links': [{'isCurrentPage': false, 'href': 'https://www.kabbani-books.com/p/terms-of-use-and-copyright.html', 'id': '4377631504259697367', 'title': '\u0634\u0631\u0648\u0637 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645'}, {'isCurrentPage': false, 'href': 'https://www.kabbani-books.com/p/blog-page_11.html', 'id': '3304755051458916433', 'title': '\u0627\u062a\u0635\u0644 \u0628\u0646\u0627'}, {'isCurrentPage': false, 'href': 'https://www.kabbani-books.com/p/privacy-policy.html', 'id': '1306293998890899261', 'title': '\u0633\u064a\u0627\u0633\u0629 \u0627\u0644\u062e\u0635\u0648\u0635\u064a\u0629'}, {'isCurrentPage': false, 'href': 'https://www.kabbani-books.com/p/disclaimer.html', 'id': '1606478184388212093', 'title': 'Disclaimer'}], 'mobile': 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('HTML3', 'Postcs1', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3936658392-lbx__ar.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/2480925329-lightbox_bundle_rtl.css'}, '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': '4723376279498582676', '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': 'AOuZoY5ilEU2pasYCNExJFiy_q0cw2zLJg:1674985771516', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));