Welcome To

Learn 2020 Best Excel Tricks Here!

What is learnexceltricks.com?

learnexceltricks.com is a Excel learning and training site, with tutorials and formulas and Examples on Microsoft Excel Learning Beginning, Advance and Expert and covering most aspects of Microsoft Excel.The site derives its name from the Microsoft Excel, but is not affiliated with the Microsoft Excel. learnexceltricks.com was originally created in 2020 by learnexceltricks.com, an Indian software and WEB development company.

Examples

learnexceltricks.com presents thousands of Excel examples. By using our online Excel tutorial and examples you can execute and perform functions experimentally, to see what works and what does not, before implementing it.

You Can Help

Many people work very hard to ensure learnexceltricks.com remains useful, educational, updated, and interesting.

Easy Learning

learnexceltricks.com has focus on simplicity.
learnexceltricks.com practice easy and straight-forward learning.
learnexceltricks.com uses simple explanations with simple illustrations of how to use it.
learnexceltricks.com tutorials start from basic level and move all the way up to professional references.

learnexceltricks.com is Free

learnexceltricks.com is, and will always be, a completely free Excel learner resource.

Learn 2020 Best Excel tricks here!

Excel Operations

Math Functions

Logical Operations

Date & Time Functions

@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.latest-post-selection{display:unset !important;}.latest-post-selection article{width:100% !important;}#footer .wrapper{padding:0 0 0 0px !important;}footer #footer-top #footer-social{padding:0 20px 0 0;}}body #main{margin-top:5px;}.latest-post-selection article{margin-top:10px;margin-left:10px;}::-webkit-scrollbar{width:5px;}::-webkit-scrollbar-track{box-shadow:inset 0 0 5px grey;border-radius:10px;}::-webkit-scrollbar-thumb{background:#00a523;border-radius:10px;}.wrapper{padding:0 0 0 15px;}.latest-post-selection article{margin-top:10px;width:1607%;}.latest-post-selection{display:flex;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.menu-excel-main-container{height:100%;width:330px;position:unset;overflow-y:scroll;}}@media (min-width: 1025px) and (max-width: 3280px){.menu-excel-main-container{height:100%;width:275px;position:fixed;overflow-y:scroll;}}#footer-social h3{color:#207245;}.latest-post-selection article .read-more{padding:8px;float:right;background:#207245;border-radius:4px;color:white;}.latest-post-selection a{color:#207245;}.latest-post-selection article{margin-top:10px;}.breadcrumb-container{margin-top:8px;}.breadcrumb-container ul li a span{position:relative;bottom:8px;}@media (min-width: 1025px) and (max-width: 3280px){#header-navigation:hover{position:unset;width:110%;margin-top:108px;}#header-navigation{position:fixed;width:250px;margin-top:90px;}#main{top:108px;}.exhead-top{width:1155px;position:fixed;background:white;padding-top:10px;padding-bottom:11px;border-bottom:solid 3px green;display:flex;z-index:1;}}nav#site-navigation ul.nav-menu > li > a{font-size:14px !important;}.menu-item-type-post_type a{padding:2px 2px 2px 30px !important;}nav#site-navigation ul.nav-menu > li > a{padding:3px 3px 3px 30px !important;}.copy-the-code-button{background:#00a523 !important;padding:10px 20px !important;cursor:pointer !important;color:#fff !important;font-size:14px !important;font-weight:700 !important;border-radius:2px !important;text-transform:capitalize !important;border:none !important;margin-bottom:3px;}.copy-the-code-button:hover{background:#007233 !important;}.entry-header h2 a{font-weight:700;position:absolute;}.entry-header{display:none;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){#buttonmobo .elementor-top-column:nth-child(2){position:absolute;width:50%;left:50%;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.navbar{display:none !important;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.logo{margin-left:98px !important;}}.navbar-light .navbar-nav .nav-link{color:#207245;font-size:17px;}.bg-light{background-color:#207245 !important;width:75%;margin-left:50px;border-radius:5px;}#navbarNav ul li,ol li{line-height:32px;margin-right:2px;background:gainsboro;border:solid green;border-radius:5px;margin-left:0px;padding:1px 15px;}#navbarNav ul li:hover{background:#00a523;}.navbar-light .navbar-nav .nav-link:hover{color:white;}table,th,td{border:1px solid rgba(158,158,158,.59);}#comments{display:none;}@media (min-width: 481px) and (max-width: 1024px) and (orientation: landscape){.elementor-container .elementor-row .has_ae_slider:first-child .elementor-column-wrap .elementor-widget-wrap .elementor-button-warning .elementor-widget-container{position:absolute;top:20px;}}#masthead img{margin-left:40px;margin-top:5px;}@media (min-width: 1025px) and (max-width: 1980px){#masthead .header #header-logo{display:none;}}#masthead .header #header-logo img{visibility:hidden;}#masthead .header #header-logo .icon_cart_wrap{visibility:hidden;}#masthead .header #header-logo .mobile-search-icon .header a{margin-top:9px;margin-right:15px;}.entry-meta{display:none;}.header-top{display:none;}nav#site-navigation ul.nav-menu li a:hover,nav#site-navigation ul.nav-menu li a:focus{background:#8bc34a;color:#fff;}#main #primary #content article .entry-header{margin-top:15px;}nav#site-navigation ul.nav-menu li#menu-item-13783 a,nav#site-navigation ul.nav-menu li#menu-item-13793 a,nav#site-navigation ul.nav-menu li#menu-item-13788 a{background:#207245;color:white;}nav#site-navigation ul.nav-menu li#menu-item-13904 a,nav#site-navigation ul.nav-menu li#menu-item-14003 a,nav#site-navigation ul.nav-menu li#menu-item-14004 a,nav#site-navigation ul.nav-menu li#menu-item-14005 a,nav#site-navigation ul.nav-menu li#menu-item-14006 a,nav#site-navigation ul.nav-menu li#menu-item-14007 a,nav#site-navigation ul.nav-menu li#menu-item-14008 a,nav#site-navigation ul.nav-menu li#menu-item-14009 a,nav#site-navigation ul.nav-menu li#menu-item-14010 a,nav#site-navigation ul.nav-menu li#menu-item-14800 a,nav#site-navigation ul.nav-menu li#menu-item-14782 a{background:#00a523;color:white;}nav#site-navigation ul.nav-menu li.current-menu-item > a,nav#site-navigation ul.nav-menu li.current-menu-ancestor > a,nav#site-navigation ul.nav-menu li.current-menu-parent > a,nav#site-navigation ul.nav-menu li.current_page_parent > a,nav#site-navigation ul.nav-menu li.current_page_ancestor > a{background:#8bc34a;color:#fff;border-bottom:2px solid #4c7f11;}footer #footer-top #footer-social{background:#207245 !important;}footer #footer-bottom #back_to_top{top:80%;}.menu-excel-main-container ul{margin-bottom:140px !important;}