معادلات إكسيل

شرح صيغة الدالة COLUMN في برنامج مايكروسوفت Excel في هذه التدوينة سنتعرف على كيفية إستعمال صيغة الدالة COLUMN في برنامج مايكروسوفت Excel. تع...

معادلات إكسيل

November 25, 2021

استخدام دالة IF مع VLOOKUP في برنامج مايكروسوفت Excel

Practice-excel

استخدام دالة IF مع VLOOKUP في برنامج مايكروسوفت Excel في هذه التدوينة سنتعلم كيفية استخدام دالة IF مع VLOOKUP في برنامج مايكروسوفت Excel الل...

دروس الاكسيل

November 24, 2021

التعرف على دوال البحث في برنامج مايكروسوفت Excel

Practice-excel

التعرف على دوال البحث في برنامج مايكروسوفت Excel في هذه التدوينة سنتعرف على دوال البحث في برنامج مايكروسوفت Excel. في برنامج مايكروسوفت Exc...

Showing

No More Posts

window['__wavt'] = 'AOuZoY6r4Pz6hKqjG8klTC_puRcLiyEBuA:1727963408653';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/search/label/%D9%85%D8%B9%D8%A7%D8%AF%D9%84%D8%A7%D8%AA%20%D8%A5%D9%83%D8%B3%D9%8A%D9%84','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/search/label/%D9%85%D8%B9%D8%A7%D8%AF%D9%84%D8%A7%D8%AA%20%D8%A5%D9%83%D8%B3%D9%8A%D9%84', 'canonicalUrl': 'https://www.practiceexcel-365.com/search/label/%D9%85%D8%B9%D8%A7%D8%AF%D9%84%D8%A7%D8%AA%20%D8%A5%D9%83%D8%B3%D9%8A%D9%84', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-204466697-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', '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\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/16751036665254405625\x22 /\x3e\n', '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/991df7aaa4d2cf44', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'index', 'searchLabel': '\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644', 'pageName': '\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644', 'metaDescription': 'Through this blog, your work will become faster and your life easier. Welcome!'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', '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': 'Practice Excel365 | Free Excel Courses', 'description': 'Through this blog, your work will become faster and your life easier. Welcome!', 'url': 'https://www.practiceexcel-365.com/search/label/%D9%85%D8%B9%D8%A7%D8%AF%D9%84%D8%A7%D8%AA%20%D8%A5%D9%83%D8%B3%D9%8A%D9%84', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': '\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644', 'resultsMessage': 'Showing posts with the label \u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3e\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', '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': 'Practice Excel365 | Free Excel Courses (Header)', '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': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '3368375494417156688', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 COLUMN \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgVF8_UFewzJZzs9tPSW8wCLdLj3JJ-P0p98bWa5JL_RM4tWGNgJzv2M_a7X06VggrXmLfkXh8UVXM3ATftlCZ1HHxg0diFp7KAssGsBxgWLhJ8ytr7hMxf6K-MPM5AWOxaVUoSkm-Gt8PKDNAzp_xjI4oEc_yyK-VS_Y7fbPorTD7TB0e4jJLj4k9L\x3dw640-h452', 'showInlineAds': true}, {'id': '8156671166494358657', 'title': '\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 IF \u0645\u0639 VLOOKUP \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEhNt3-L9BrRltKXzW6dlT20TsWXs1RxLdCQgBpWvyE5TK71UtL0pA-WTQosa_APDdr3Ic8GNNNSyOLzuRzuIuKgCbGSHhFKqb1P5RW34YZNomLlwArbxl23V7iJJWw-6gp5V1-2Uv_khl-scGVqjaLRa3PqJH6xbpbNs94xG14p26q9YfY_Px3L4-Ui\x3dw640-h640', 'showInlineAds': true}, {'id': '8964141378818959852', 'title': '\u0627\u0644\u062a\u0639\u0631\u0641 \u0639\u0644\u0649 \u062f\u0648\u0627\u0644 \u0627\u0644\u0628\u062d\u062b \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEhw7z6xj1XamH4aZj9cc880JUGu3lqVAXuULnAYr1srRfBR18yEo41B3NOmWYldOV7zRUP1YSMVrdTaZAjSSApbILxfQuWv1RDKbIsTY5AC-XWLv6dC-96d4qSDEIzwGDjfnLb71ReOtfIozo5VLzsSFxLmjZnAPoYpshUOWyYUUXcB1RJiaO7LshWa\x3dw640-h640', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'Contact Form', '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': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], '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('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3e\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0625\u0643\u0633\u064a\u0644\x3c/b\x3e. \x3ca href\x3d\x22https://www.practiceexcel-365.com/\x22\x3eShow all posts\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1203661419-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY7tIXjANMT1IHk8D962evOSVDTQ3A:1727963408663', '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'));