Latest Posts

How to Use the AVERAGE Formula in Excel

If you're an Excel user and need to quickly calculate the average of a set of numbers, the AVERAGE formula is the perfect tool for you...

formulas-functions

VLOOKUP formula in excel with example

Hossam Ali

Excel is packed with powerful functions that can make your data analysis faster and more efficient. One of the most commonly used functions...

basics

How to Freeze a Cell in Excel: A Complete Guide

Hossam Ali

Excel is a powerful tool used by millions for organizing data, performing calculations, and analyzing information. One of its most useful fe...

basics

How to Find Duplicate in Excel?

Hossam Ali

Find and remove duplicate in excel| To find duplicates in Excel, use the Conditional Formatting feature. Select the range of data, then g...

basics

How to Insert a Calendar in Excel

Hossam Ali

Inserting a calendar into Excel can help manage dates, deadlines, and events more efficiently. Whether you’re looking for a drop-down calend...

basics

How to Insert Headers and Footers in Excel

Hossam Ali

Headers and footers are helpful for organizing your Excel worksheets, especially when printing them. They allow you to insert additional inf...

basics

Insert Row in Excel Shortcut Key

Hossam Ali

In Excel, inserting a row is a common task that can be accomplished quickly using a shortcut key. The shortcut key for inserting a row in Ex...

Showing

No More Posts

window['__wavt'] = 'AOuZoY61nsSZCsU60yGVuF4I77XP9eMvUA:1740079375329';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6571197898080719811','//www.excel-formula.com/search?updated-max\x3d2025-01-29T04:27:00-08:00\x26max-results\x3d7','6571197898080719811'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6571197898080719811', 'title': 'Excel Formula ', 'url': 'https://www.excel-formula.com/search?updated-max\x3d2025-01-29T04:27:00-08:00\x26max-results\x3d7', 'canonicalUrl': 'https://www.excel-formula.com/search?updated-max\x3d2025-01-29T04:27:00-08:00\x26max-results\x3d7', 'homepageUrl': 'https://www.excel-formula.com/', 'searchUrl': 'https://www.excel-formula.com/search', 'canonicalHomepageUrl': 'https://www.excel-formula.com/', 'blogspotFaviconUrl': 'https://www.excel-formula.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\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Excel Formula - RSS\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6571197898080719811/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/00632895841370585127\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-4646798504000105', '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/a53efe5a9107f97a', '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': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'pageName': '', 'pageTitle': 'Excel Formula ', 'metaDescription': 'Excel Formula is your go-to site to learn and master Excel for free with easy guides and tips for all skill levels.'}}, {'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': 'Excel Formula ', 'description': 'Excel Formula is your go-to site to learn and master Excel for free with easy guides and tips for all skill levels.', 'url': 'https://www.excel-formula.com/search?updated-max\x3d2025-01-29T04:27:00-08: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': 'Excel Formula (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': 'Social Media icons', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Main Menu', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList001'}, {'title': 'search ...', 'type': 'BlogSearch', 'sectionId': 'searchform', 'id': 'BlogSearch2'}, {'title': 'table of contents feature', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML1'}, {'title': 'contact form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '3117034382187848537', 'title': 'How to Use the AVERAGE Formula in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihtZxUigU0GhplQWmCJvshpCPG17K33P9lnc1CwAg8S82e2HlN9_i5X3UN9P_RdUCnCD5tOJgt_rq44OwpqszaBUh_RktbjIGlQCqTDrllajule-Mz9OprhxZDdslOhFUvMNwxxX-dIWz7Hx4zNrSimEfiMjh2FypeZRH9NppBGhPzrkdd6x44Q2zyKf36/w640-h360/How%20to%20Use%20the%20AVERAGE%20Formula%20in%20Excel.jpg', 'showInlineAds': false}, {'id': '3362496046972645195', 'title': 'VLOOKUP formula in excel with example', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKamLli8BJudZPgTJosj2Gjl1B-gOeupWHyncdlad5CPlj60Vdslblt_6RZ2KedXRfdpzWYkCf3JQVMgu5M6UFnBHdSOHmuFhok6e_WkfQbAC-6Z4ItsUsXOessaC2-pCqNyzZffwgn8z9jcAWbevqYZguSDs6MHSKHDfpAo-5NM2XqISJsLKQB19D8WBi/w640-h360/vlookup%20formula%20in%20excel%20with%20example.jpg', 'showInlineAds': false}, {'id': '2242936164954229744', 'title': 'How to Freeze a Cell in Excel: A Complete Guide', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDPveFIf4eavq3uiqAzhIkU349pp4K_l51ffCOnuWgwZacNJxx3lSpS3L9ONm1FCl4GYG4C9LHFFJgqpukHTdA0UZMWAZaFi4IHgRLJhsaE00cz3tdAlsorhgzGq1b88fWuo0RsS_2hPdy9-r41tm5fA6SsRl94dlFKPs0Uo0ZvvLOQNT3t4tvr29ktu9y/w640-h360/How%20to%20Freeze%20a%20Cell%20in%20Excel.jpg', 'showInlineAds': false}, {'id': '3228625590129259517', 'title': 'How to Find Duplicate in Excel?', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOkLjRd04ZhTVdRvWy5ngJW-sqMk8oY8UWYWdSxVymQVfgq7YVYL-_ZEjag4o0qvS1Vw0CrbhsBswdsrHO8tdMCGQFd5H2K3ta20Q46vysC8wDYDcLgbCzBJrGrDXbTG_FZOnhXspcLcwu_CyWGBtYdk-NPfVbPzbT_URsouLsxdYb5d5E_QASDQD-Z-HF/w640-h362/how-to-find-duplicate-in-excel.webp', 'showInlineAds': false}, {'id': '5580606121535032329', 'title': 'How to Insert a Calendar in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaC0rScoIZBdA0TykNdRhMQ1FDtysSPZE3Cg47kkZiwCiKlz_tHNUFKlSgGo2CxXuaBFbMxdHVbh9vgm-0yCtfddxkHEHnQxIyBa1C2yTCKfUL29RTyj-ZcnH9Jcnb2ukbzGAoVz8S1BnTF1iHSs2E2d0HQozMssf6mZF5HKrNQDRk5pYBW5v0ofHakRle/w640-h360/how-to-insert-a-calendar-in-excel.webp', 'showInlineAds': false}, {'id': '4159951143012790634', 'title': 'How to Insert Headers and Footers in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEjZzUs2TTgd3ZfjgX_loaYwmkcVt1dTaKFiCPCgHk2Iqf3opWsjkfGDq6ljnaX47l3y-OiygdwPmIHvK56pLgVkTKerH4O07H4Esy4oJhS3NKTqVWO8ixMcTsoHQQoXSLhrQ-0c4XIzgs69QsBNF2HwEZpRfX1TTlwvZVlmxEWhfd-HKuDYZ6E2d0krPz/w640-h360/how-to-insert-headers-and-footers-in-excel.webp', 'showInlineAds': false}, {'id': '4317970457712986528', 'title': 'Insert Row in Excel Shortcut Key', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/w640-h360/insert-row-in-excel-shortcut-key.webp', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'labels', 'label': ''}]}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'sidepar', 'id': 'FeaturedPost1', 'postId': '3537475267977373232'}, {'title': 'social media icons', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': []}]}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'https://www.excel-formula.com/', 'id': '0', 'title': 'Home Page'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList001', 'menu', document.getElementById('LinkList001'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch2', 'searchform', document.getElementById('BlogSearch2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'AddOns', document.getElementById('HTML1'), {}, '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': '6571197898080719811', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY6WCJL01NP6s0tzii2uP6Mzgj2RuA:1740079375329', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1361836472-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'sidepar', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));