Home دروس الاكسيل

تمرين عن كيفية انشاء الجداول على الاكسيل

September 17, 2021

تمرين عن كيفية عمل جدول على الاكسيل

هذه التدوينة ستكون عبارة عن تمرين تطبيقي للدرس السابق عن كيفية انشاء الجداول على Excel

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

الهدف من هذا التمرين هو استخدام المعرفة المكتسبة من خلال الدرس السابق لإنشاء الجدول على Excel

تنسيق الجداول

أنت الآن تعرف كيفية تطبيق الحدود أو الخطوط وتخصيصها ، ولكن لتسهيل عملك ، يمكنك استخدام ميزة "تنسيق الجدول" في Excel لتطبيق تنسيق الجدول على الخلايا المحددة مسبقًا.

للقيام بذلك ، حدد نطاق الخلايا في جدولك ، وانقر على "تنسيق كجدول" واختر تنسيقًا:

قد تلاحظ أن الجدول الذي تم إنشاؤه بهذه الطريقة ليس مجرد تنسيق بسيط وله ميزات إضافية (سنعود إلى بعض هذه الميزات لاحقًا في هذه الدورة التدريبية):

Tags دروس الاكسيل

Latest articles from : دروس الاكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY7LE8oEcfMqsvt4hqguGdkBF3xJIw:1733720891645';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/07/excel.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/07/excel.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/07/excel.html', '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': '', '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\n\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/501615564531099089/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-6657372632750930', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/36eb93a0ea1bb211', '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': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', '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': 'item', 'postId': '501615564531099089', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis_VqHH7su_XMBQE33WEY_g6nF4853sBTNoCMdgFUs_c74SS8_LHUEvp7XFesxO_L2Cm7kTp09puT4DOJxE6fXEGh9I-0XPBzxiIHl3xI9An7M205L0El3-btpncFDoCHYY0lCCjcFWvk/s72-w640-c-h400/tab+ex+1.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis_VqHH7su_XMBQE33WEY_g6nF4853sBTNoCMdgFUs_c74SS8_LHUEvp7XFesxO_L2Cm7kTp09puT4DOJxE6fXEGh9I-0XPBzxiIHl3xI9An7M205L0El3-btpncFDoCHYY0lCCjcFWvk/w640-h400/tab+ex+1.png', 'pageName': '\u062a\u0645\u0631\u064a\u0646 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0627\u0643\u0633\u064a\u0644', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u062a\u0645\u0631\u064a\u0646 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0627\u0643\u0633\u064a\u0644', 'metaDescription': '\u0647\u0630\u0647 \u0627\u0644\u062a\u062f\u0648\u064a\u0646\u0629 \u0633\u062a\u0643\u0648\u0646 \u0639\u0628\u0627\u0631\u0629 \u0639\u0646 \u062a\u0645\u0631\u064a\u0646 \u062a\u0637\u0628\u064a\u0642\u064a \u0644\u0644\u062f\u0631\u0633 \u0627\u0644\u0633\u0627\u0628\u0642 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 Excel\n\n\n\u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0645\u0646 \u0633\u0646\u0642\u0648\u0645 \u0628\u0643\u062a\u0627\u0628\u0629 \u0628\u0639\u0636 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0643\u0645\u0627 \u064a\u0644\u064a:'}}, {'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': '\u062a\u0645\u0631\u064a\u0646 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0627\u0643\u0633\u064a\u0644', 'description': '\u0647\u0630\u0647 \u0627\u0644\u062a\u062f\u0648\u064a\u0646\u0629 \u0633\u062a\u0643\u0648\u0646 \u0639\u0628\u0627\u0631\u0629 \u0639\u0646 \u062a\u0645\u0631\u064a\u0646 \u062a\u0637\u0628\u064a\u0642\u064a \u0644\u0644\u062f\u0631\u0633 \u0627\u0644\u0633\u0627\u0628\u0642 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 Excel\n\n\n\u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0645\u0646 \u0633\u0646\u0642\u0648\u0645 \u0628\u0643\u062a\u0627\u0628\u0629 \u0628\u0639\u0636 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0643\u0645\u0627 \u064a\u0644\u064a:', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis_VqHH7su_XMBQE33WEY_g6nF4853sBTNoCMdgFUs_c74SS8_LHUEvp7XFesxO_L2Cm7kTp09puT4DOJxE6fXEGh9I-0XPBzxiIHl3xI9An7M205L0El3-btpncFDoCHYY0lCCjcFWvk/w640-h400/tab+ex+1.png', 'url': 'https://www.practiceexcel-365.com/2021/07/excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 501615564531099089}}, {'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': '\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': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '501615564531099089', 'title': '\u062a\u0645\u0631\u064a\u0646 \u0639\u0646 \u0643\u064a\u0641\u064a\u0629 \u0627\u0646\u0634\u0627\u0621 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0627\u0643\u0633\u064a\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis_VqHH7su_XMBQE33WEY_g6nF4853sBTNoCMdgFUs_c74SS8_LHUEvp7XFesxO_L2Cm7kTp09puT4DOJxE6fXEGh9I-0XPBzxiIHl3xI9An7M205L0El3-btpncFDoCHYY0lCCjcFWvk/w640-h400/tab+ex+1.png', 'showInlineAds': false}], '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': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0639\u0646\u0648\u0627\u0646 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML222'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0641\u0642\u0631\u0629 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML223'}, {'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': 'Fiver', 'type': 'HTML', 'sectionId': 'Postnw6', 'id': 'HTML3'}, {'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('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2385764300-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML222', 'PostA3lan2', document.getElementById('HTML222'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML223', 'PostA3lan2', document.getElementById('HTML223'), {}, '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': 'AOuZoY5I5v8CZWVp6e_3rZ7NwTwTE9gNbg:1733720891645', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'Postnw6', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));