Latest Posts

October 27, 2021

شرح صيغة الدالة INDIRECT في برنامج مايكروسوفت Excel

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

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

October 26, 2021

شرح صيغة الدالة ADDRESS في برنامج مايكروسوفت Excel

Practice-excel

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

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

October 25, 2021

شرح صيغة الدالة HYPERLINK في برنامج مايكروسوفت Excel

Practice-excel

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

تحميلات

October 24, 2021

تحميل تصميم للوحة تحكم Dashboard مبرمج بواسطة VBA

Practice-excel

تحميل تصميم للوحة تحكم Dashboard مبرمج بواسطة VBA في برنامج مايكروسوفت Excel كثيرا ما نسمع عن Dashboard أو لوحة التحكم أو KPI أو TDB أو TA...

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

October 24, 2021

شرح صيغة الدالة ROW في برنامج مايكروسوفت Excel

Practice-excel

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

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

October 23, 2021

شرح صيغة الدالة COLUMNS في برنامج مايكروسوفت Excel

Practice-excel

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

Showing

No More Posts

window['__wavt'] = 'AOuZoY6aGw5dxsI0PupsYjKcth-Yx2IE_g:1714049081484';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/search?updated-max\x3d2021-10-28T03:30:00-07:00\x26max-results\x3d7','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/search?updated-max\x3d2021-10-28T03:30:00-07:00\x26max-results\x3d7', 'canonicalUrl': 'https://www.practiceexcel-365.com/search?updated-max\x3d2021-10-28T03:30:00-07:00\x26max-results\x3d7', '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/111cb1309c0430aa', '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', 'pageName': '', 'pageTitle': 'Practice Excel365 | Free Excel Courses', '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?updated-max\x3d2021-10-28T03:30:00-07:00\x26max-results\x3d7', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': false, 'search': {}}}, {'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': '5062363697388847509', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 INDIRECT \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/AVvXsEgd3j7a4wuwGZi3zA8cxDd1Jauz4NouTSH0DnArzfkEgnWNT2JRbSpX39oOHYYV0gVqEugP4nvkSlwkvXsZoS0kFayG4PyhJG6MEInGQR7H_Gcq9Jw8ETKFppGMHd8Xt1IlaFHwEZgI5q-bAZAnQ6PW1ykEasxqeY3ME0rPY-E2GBFqbYJeFBj5a9fv\x3dw640-h452', 'showInlineAds': true}, {'id': '161337474998665020', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 ADDRESS \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/AVvXsEh3vr-9euBA5pRstQ--Hs4IlokRt6n27SVRX9RaUi12RVYiKrbA0qvnOuUXQ_WfiohSGecGf8eRl6iSc4_J8zlPa29qCutNF5uOof3sRK_Z4auF2i5eACRKtkAnrY9H-fQgnC_t1m-o50M-PQWvkaXyHjVevbYXuV6UQ-z3RBKofehQUkCc8DLGqsph\x3dw640-h452', 'showInlineAds': true}, {'id': '902164268060289919', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 HYPERLINK \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/AVvXsEgxb8_rR1HvSPAd9WWt4QUdnEOW9zflLP1-Y87peP0gygUHhnJYqQ5koO-4DCmJgdqL-haz_DYdFkK6kNAr2lFTonNkiYl4__M2nae4un57Bx5efW6oqF3VsAUqhFWFaQJYx_1K9zVIumE6hujqHFre1kjrasGYEFtZfo6ZbgPl0qNU5GknIOl2VCZF\x3dw640-h452', 'showInlineAds': true}, {'id': '3375412067240897474', 'title': '\u062a\u062d\u0645\u064a\u0644 \u062a\u0635\u0645\u064a\u0645 \u0644\u0644\u0648\u062d\u0629 \u062a\u062d\u0643\u0645 Dashboard \u0645\u0628\u0631\u0645\u062c \u0628\u0648\u0627\u0633\u0637\u0629 VBA', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEgRIty0Tu60vEgb3P01h_rxp8ZTVklVVMj25Z-EkCkQHLB7IPgZx7nC9arx-EPuGZpxn_oInPnRNsR5h1AKi_tT57Cf3CuOZtezkq1r9ExLYxaOQ5PfNf4AVYZbsLEQabk0f69f3wznYL9mdvsCXTvOpQjL0Bbz0DIoqCcFDn4_qLgsU6T3iXNRiXSq\x3dw640-h304', 'showInlineAds': true}, {'id': '4686888308122066589', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 ROW \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/AVvXsEjw4xU9Kh6yiIcn33EWeTQaISXV6D2E_VXsnPz0b8aocXuRg5WEhh0Y39veX1G3SutAt6rDoUkCQu8qVWwhYmSmwhjOVq70crp8NuBwBiqxqq6EGZfTVeGviKtHv0lE87T0NbkUHnrK2Rnoyl070R2e-vK_AGDurO4E2adxaL10KyeXyjiAuokfCJ2N\x3dw640-h452', 'showInlineAds': true}, {'id': '4044150123890462287', 'title': '\u0634\u0631\u062d \u0635\u064a\u063a\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 COLUMNS \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/AVvXsEgEF4-BN-HH9BxZeMpqN5VoTKri9A-htiq61hpLqgHoIUxciZSX1g8AA8slIBSsNlkV9uvxc9EzZAr4CIfQR4jLmgvtZIZ8iIhIBjJl41KBj7r0GeHTHwDUM5Y_CLH4YkWRNwc8FIds_8Nuw4thXivUAGfoEacyELP_2iuUwZUkVc8g8cREWqc9gTbh\x3dw640-h452', '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, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1666805145-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': 'AOuZoY58zVycQSvadxNZEliEWsUSfw4waw:1714049081489', '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'));