{"id":7349,"date":"2023-08-05T08:50:30","date_gmt":"2023-08-05T08:50:30","guid":{"rendered":"https:\/\/www.hashmicro.com\/blog\/?p=7349"},"modified":"2024-05-30T04:50:14","modified_gmt":"2024-05-30T04:50:14","slug":"excel-formulas","status":"publish","type":"post","link":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/","title":{"rendered":"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]"},"content":{"rendered":"\r\n<p>You may be familiar with Microsoft Excel. This application made by Microsoft Corporation is the application with the most users in the world in 140+ countries. This application has a myriad of Excel formulas that can accurately present numbers and data.<\/p>\r\n\r\n\r\n\r\n<p>The primary function of Microsoft Excel is calculation, which is why it has been used by many users, both students and office workers. Despite other spreadsheet programs (competitors), Excel maintained its dominance and even became an industry standard.<\/p>\r\n<p>Apparently, Excel seems too good to be true. All you have to do is enter an Excel formula, and almost everything you need to do manually can be done automatically. Use the best <a href=\"https:\/\/www.hashmicro.com\/accounting\">accounting software<\/a> to do the cash flow forecast appropriately and analyze financial statements more optimally.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<p>If you need to combine two sheets with the same data, Excel can do this. Do you need help with mathematics? Excel can do this. Are you using data from multiple cells? Excel can do this too.<\/p>\r\n\r\n\r\n\r\n<p>In this article, you will understand the function of Excel in different professional fields. Then you&#8217;ll understand what formulas you need to know. Later, you will be able to apply automatic calculations to be used according to your needs.<\/p>\r\n<a href=\"https:\/\/www.hashmicro.com\/free-product-tour\/?medium=free-product-tour\" target=\"_blank\"><img decoding=\"async\" loading=\"lazy\" width=\"712\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2025\/11\/Free-Product-Tour-resized.webp\" alt=\"Free Demo\"><\/a>\r\n<p><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\"><!-- <div id=\"toc_group_article\" style=''>\r\n\t<p style='font-size:25px;font-weight:bold; margin-bottom:0px'>\r\n\t\tTable of Content:\r\n\t<\/p>\r\n\t<ul id=\"list_toc\" class='list_toc'><\/ul>\r\n<\/div> -->\r\n\r\n<!-- <div class=\"dropdown-fixed-top\" id=\"dropdown-fixed-top\">\r\n\t<div class=\"row\">\r\n\t\t<p id=\"pilihDaftarIsi\">Table of Content<\/p>\r\n\t\t<p><i class=\"td-icon-menu-down\"><\/i><\/p>\r\n\t<\/div>\r\n\t\r\n\t<div>\r\n\t\t<ul id=\"list_toc_top\" class='list_toc'><\/ul>\r\n\t<\/div>\r\n<\/div> -->\r\n\r\n<div id=\"placeholder-toc\"><\/div>\r\n<div id=\"toc\">\r\n    <div class=\"header\">\r\n\t<span class=\"toc-title\" id=\"toc-title\">Table of Content<\/span>\t\r\n\t <i class=\"toc-icon\">\r\n        <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"30\" height=\"30\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#000\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"header-icon\">\r\n          <path d=\"m6 9 6 6 6-6\" \/>\r\n        <\/svg>\r\n      <\/i>\r\n\t<\/div>\r\n    <div class=\"list\">\r\n      <ul id=\"toc-list\"><\/ul>\r\n    <\/div>\r\n <\/div>\r\n\r\n<style>\r\n\t@media (max-width: 992px) {\r\n\t\t#toc_group_article {\r\n\t\t\tpadding-top: 24px;\r\n\t\t}\r\n\t}\r\n\t\r\n\t#list_toc_float {\r\n\t\tmax-height: calc(100vh - 250px);\r\n\t\toverflow-y: auto;\r\n\t}\r\n\t\r\n\t#list_toc_top {\r\n\t\tdisplay: none;\r\n\t\tbackground: #fff;\r\n\t\tmargin-bottom: 4px;\r\n\t}\r\n\t\r\n\t#list_toc_top li {\r\n\t\tdisplay: block;\r\n\t\tmargin-left: 0;\r\n\t\tlist-style: none;\r\n\t}\r\n\t\r\n\t#list_toc_top a {\r\n\t\tpadding: 5px;\r\n\t\tdisplay: block;\r\n\t}\r\n\t\r\n\t#list_toc_top.show {\r\n\t\tdisplay: block;\r\n\t}\r\n\r\n\t#list_toc_top a {\r\n\t\tcolor: #434343;\r\n\t\tborder-bottom: 1px solid #bbb;\r\n\t}\r\n\t\r\n\t.dropdown-fixed-top {\r\n\t\tposition: fixed;\r\n\t\ttop: 59px;\r\n\t\twidth: 100%;\r\n\t\tz-index: 99;\r\n\t\tborder-bottom: 2px solid #9c171e;\r\n\t\tpadding: 12px;\r\n\t\tbackground: #fff;\r\n\t\twidth: 100%;\r\n\t\tcursor: pointer;\r\n\t\tdisplay: none;\r\n\t\tleft: 0;\r\n\t\tbox-shadow: 0 -2px 7px 6px rgba(0, 0, 0, 0.17);\r\n\t}\r\n\t\r\n\t#dropdown-fixed-top.show {\r\n\t\tanimation: showAnim 0.5s ease;\r\n\t\tdisplay: block;\r\n\t\topacity: 1;\r\n\t}\r\n\t\r\n\t@keyframes showAnim {\r\n\t\tfrom {\r\n\t\t\tdisplay: none;\r\n\t\t\topacity: 0;\r\n\t\t}\r\n\t\tto {\r\n\t\t\tdisplay: block;\r\n\t\t\topacity: 1;\r\n\t\t}\r\n\t}\r\n\t\r\n\t.dropdown-fixed-top #list_toc_top {\r\n\t\tmax-height: calc(50vh - 110px);\r\n\t\toverflow-y: scroll;\r\n\t}\r\n\t\r\n\t.dropdown-fixed-top .row {\r\n\t\tdisplay: flex;\r\n\t\tjustify-content: space-between\r\n\t}\r\n\t\r\n\t.dropdown-fixed-top .row p {\r\n\t\tmargin-bottom: 0;\r\n\t}\r\n\t\r\n\t#pilihDaftarIsi {\r\n\t\tmax-width: 100%;\r\n\t\toverflow: hidden;\r\n\t\twhite-space: nowrap;\r\n\t}\r\n\t\r\n\t@media (min-width: 1018px) {\r\n\t\t.dropdown-fixed-top {\r\n\t\t\tdisplay: none;\r\n\t\t}\r\n\t}\r\n\t\r\n\t#list_toc li {margin-bottom: 0;margin-top: 5px;}\r\n\t#list_toc > li > ul {padding-left: 20px;margin-bottom: 0;}\r\n\t#list_toc{height:max-content;transition:ease-in-out}\r\n\t#list_toc li {margin-bottom: 0;margin-top: 5px;}\r\n\t#list_toc_float li.active > a {color:#b1252d;background: #ffe1e3;}\r\n\t#list_toc_top li.active > a {color:#b1252d;background: #ffe1e3;}\r\n\t#list_toc_float li a {padding:3px 7px}\r\n\t#list_toc_float li a {\r\n\t\tdisplay: block;\r\n\t\tcolor: #000;\r\n\t\tmargin-bottom: 6px;\r\n\t\tpadding-top: 2px;\r\n\t\tpadding-bottom: 2px;\r\n\t\ttransition: all 0.2s ease-in-out;\r\n\t\tfont-size: 15px;\r\n\t\tline-height: 18px;\r\n\t}\r\n\t#list_toc_float li{list-style:none;list-style-position:inside; margin-left:0;}\r\n\t#list_toc_float a:hover{color:#b1252d;}\r\n\t\r\n\t#toc_group_float{\r\n\t\tline-height: 24px;\r\n\t\tmax-height: calc(100vh - 100px);\r\n\t\toverflow: auto;\r\n\t\tz-index: 99;\r\n\t\tdisplay:none!important;\r\n\t\tbackground:#fff;\r\n\t\ttransition:all 0.5s linear\r\n\t}\r\n\t\r\n\t@media (min-width:1019px){\r\n\t\t#toc_group_float {\r\n\t\t\tdisplay:block!important;\r\n\t\t\t}\r\n\t\t\t\t#toc_group_article {\r\n\t\t\tdisplay:none;\r\n\t\t}\r\n\t}\r\n\r\n<\/style>\r\n\r\n<!-- ToC styling  -->\r\n<style>\r\n\t\/* Simple styling for the TOC *\/\r\n\t\r\n\t#toc ul li:last-child {\r\n    padding-bottom: 16px; \/* Adjust the value as needed *\/\r\n}\r\n\r\n.td-fix-index {\r\n\t transform: unset !important;\r\n     -webkit-transform: unset !important; \r\n}\r\n.footer-contact .td-fix-index {\r\n\t transform: translateZ(0) !important;\r\n     -webkit-transform: translateZ(0) !important; \r\n}\r\n\t.tdb_single_content .tdb-block-inner.td-fix-index{\r\n\t\tposition: static;\r\n\t}\r\n\t\r\n\r\n\t\r\n#toc {\r\n  background-color: #FFF;\r\n\tpadding: 17px 24px 0px 24px !important;\r\n  margin-bottom: 20px;\r\n\/*   border: 1px solid #9C171E; *\/\r\n  border-radius: 6px;\r\n\tdisplay: none;\r\n  max-width: 100%;\r\n  transition: .4s ease height;\r\n\tmargin-left: 0;\r\n\toverflow: hidden;\r\n}\r\n\r\n#toc .header{\r\n  display: flex;\r\n  align-items: center;\r\n  justify-content: space-between;\r\n\tbackground-color: transparent;\r\n}\r\n\t\r\n\t#toc.sticky .header{\r\n\t\tpadding: 4px 0;\r\n\t}\r\n\t\r\n.header p{\r\n  font-size: 18px !important;\r\n  font-weight: 600 !important;\r\n  color: #393939;\r\n   margin-bottom: 0;\r\n  \/* margin-top: 20px; *\/\r\n}\r\n\r\n.toc-icon{\r\n  float: right;\r\n\/*   visibility: hidden; *\/\r\n}\r\n\r\n\t.toc-title{\r\n\t\tmargin-right: auto;\r\n\/* \t\tpadding-left: 20px; *\/\r\n\t\tfont-weight: 600;\r\n\t\talign-self: center;\t}\t\r\n\r\n#toc ul {\r\n  list-style-type: none;\r\n  padding-left: 0;\r\n}\r\n\t\r\n#toc.sticky ul{\r\n\toverflow-y: auto;\r\n\tmax-height: 250px;\r\n\tmargin-top: 0px;\r\n\tpadding-top: 20px;\r\n\/* \tborder-top: 1px solid #d3d3d3; *\/\r\n}\r\n\t\r\n#toc ul li {\r\n\/*   margin-bottom: 10px; *\/\r\n  margin-bottom: 10px;\r\n\tmargin-left: 0;\r\n\ttransition: .2s ease;\r\n\tcursor: pointer;\r\n}\r\n\t\r\n\t#toc.sticky ul li {\r\n\t  margin-right: 10px;\r\n\t}\r\n\t\r\n.td-post-content #toc-list li a:hover, .td-post-content #toc-list a.active{\r\n\tbackground-color: #FFF;\r\n\/* \tpadding: 8px 16px 8px 16px; *\/\r\n\tpadding: 4px 16px 4px 16px;\r\n\tborder-radius: 6px;\r\n\tcolor: #9c171e !important;\r\n\tfont-weight: 600 !important;\r\n}\r\n\t\r\n\t.td-post-content #toc-list li:hover a, .td-post-content #toc-list a.active{\r\n\t\tcolor: #9C171E !important;\r\n\t\tfont-weight: 600 !important;\r\n\t}\r\n\t\r\n.td-post-content #toc-list a.active{\r\n\tfont-weight: bold !important;\r\n\tcolor: #9C171E !important;\r\n}\r\n\t\r\n#toc a, .td-post-content #toc-list a {\r\n  text-decoration: none;\r\n  color: #ea1717 !important;\r\n  transition: .2s ease;\r\n\tfont-weight: 400 !important;\r\n\tdisplay: block;\r\n\t\r\n\tpadding: 4px 16px 4px 0;\r\n}\r\n\r\n#toc.sticky {\r\n  position: fixed;\r\n\/*   top: 73px; *\/\r\n\tbottom: 0;\r\n  z-index: 100; \r\n  box-shadow: 0 2px 5px rgba(0,0,0,0.1); \r\n\twidth: 100%; \r\n\tbackground-color: #FFF;\r\n\/* \tbackground-color: #FFF1F1; *\/\r\n\tborder-bottom: 1px solid #ea1717;\r\n\/*   border: 1px solid #393939; *\/\r\n  box-shadow: 0px 0px 14px 0px #00000040;\r\n  cursor: pointer;\r\n\tanimation: fadein .3s ease;\r\n\tpadding: 12px 16px !important;\r\n}\r\n\t\r\n\t.fadein{\r\n\t\tanimation: fadein .3s ease;\r\n\t}\r\n\t\r\n\t.fadeout{\r\n\t\tanimation: fadeout .3s ease;\r\n\t}\r\n\t\r\n\t\r\n\t@keyframes fadein{\r\n\t\t0% {\r\n\t\t\topacity: 0;\r\n\t\t}\r\n\t\t100%{\r\n\t\t\topacity: 1;\r\n\t\t}\r\n\t}\r\n\t\r\n\t@keyframes fadeout{\r\n\t\t0% {\r\n\t\t\topacity: 1;\r\n\t\t}\r\n\t\t100%{\r\n\t\t\topacity: 0;\r\n\t\t}\r\n\t}\r\n\r\n\t\r\n#toc.sticky .header p{\r\n\tmargin-bottom: 10px;\r\n\tmargin-top: 10px;\r\n}\r\n\r\n#toc.sticky .toc-icon{\r\n  visibility: visible;\r\n\/* \ttransition: 0.4s ease; *\/\r\n}\r\n\t\r\n\t.toc-icon{\r\n\t\talign-items: center;\r\n    \tdisplay: flex;\r\n\t}\r\n\t\r\n\tsvg.header-icon{\r\n\/* \t\tbackground-color: #9c171e; *\/\r\n\t\tbackground-color: #FFF;\r\n\t\tborder-radius: 30px;\r\n\t\tpadding: 5px;\r\n\t}\r\n\r\n#toc.sticky .list{\r\n\/*   max-height: 0; *\/\r\n  transition: height 0.4s ease;\r\n}\r\n\t\r\n\t#toc .list{\r\n\/*   max-height: 0; *\/\r\n  transition: height 0.4s ease;\r\n}\r\n\r\n#toc .header.active .toc-icon{\r\n\ttransform: rotate(0deg); \r\n\topacity: 1;\r\n}\r\n\r\n\t#toc .header.active + .list {\r\n\t  max-height: 200px; \/* Adjust this value as needed *\/\r\n\t  opacity: 1;\r\n\t}\r\n\t\r\n\t#placeholder-toc{\r\n\/* \t\tdisplay: none; *\/\r\n\t}\r\n\t\r\n\t@media (min-width: 768px) and (max-width: 991px){\r\n\t\t#toc.sticky{\r\n\/* \t\t\ttop: 104px; *\/\r\n\t\t\tbottom: 0px;\r\n\t\t}\r\n\t\t\r\n\t\t#toc{\r\n\t\t\twidth: unset !important;\r\n\t\t}\r\n\t}\r\n\t\r\n\t@media (max-width: 767px){\r\n\t\t#toc{\r\n\t\t\twidth: 100% !important;\r\n\t\t\tdisplay: inline-block;\r\n\t\t}\r\n\t\t\r\n\t\t#toc.sticky{\r\n\t\t\twidth: 90% !important;\r\n\/* \t\t\ttop: 81px; *\/\r\n\t\t\tbottom: 60px;\r\n\t\t\tmargin-left: auto;\r\n\t\t\tmargin-right: auto;\r\n\t\t\tpadding: 0 16px;\r\n\t\t\tright: 5%;\r\n\t\t}\r\n\t}\r\n\t\r\n\t<\/style>\r\n\r\n<!-- ToC List for mobile -->\r\n<script>\r\n \/\/ Generate TOC based on headings\r\ndocument.addEventListener(\"DOMContentLoaded\", function() {\r\n  \/\/ Get the element that will contain the TOC\r\n  const tocList = document.getElementById('toc-list');\r\n\r\n  \/\/ Get the element with the ID 'article-left'\r\n  const article = document.querySelector('.td-post-content');\r\n\r\n  \/\/ Find all h2 elements within 'myarticle'\r\n  const headers = article.getElementsByTagName('h2');\r\n\r\n  \/\/ Loop through the h2 elements and create a list item for each one\r\n  for (let i = 0; i < headers.length; i++) {\r\n    const header = headers[i];\r\n    const headerText = header.textContent;\r\n\/\/     const headerId = 'header-' + i;\r\n    const headerId = headerText\r\n    .toLowerCase()\r\n    .trim()\r\n    .replace(\/[^\\w\\s-]\/g, '')  \/\/ hapus tanda baca\r\n    .replace(\/\\s+\/g, '-'); \/\/ ganti spasi jadi \"-\"\r\n\r\n    \/\/ Set an ID for the header if it doesn't have one\r\n    header.setAttribute('id', headerId);\r\n\r\n    \/\/ Create a list item for the TOC\r\n    const listItem = document.createElement('li');\r\n\r\n    \/\/ Create a link for the list item\r\n    const link = document.createElement('a');\r\n    link.setAttribute('href', '#' + headerId);\r\n    link.textContent = headerText;\r\n\r\n    \/\/ Append the link to the list item\r\n    listItem.appendChild(link);\r\n\r\n    \/\/ Append the list item to the TOC list\r\n    tocList.appendChild(listItem);\r\n  }\r\n});\r\n\r\n\/\/ Keep height and placement of content using placeholder in place of TOC\r\ndocument.addEventListener(\"DOMContentLoaded\", function() {\r\n  const toc = document.querySelector('#toc');\r\n  const placeholderToc = document.querySelector('#placeholder-toc');\r\n\r\n  function setPlaceholderHeight() {\r\n    placeholderToc.style.height = `${toc.offsetHeight}px`;\r\n  }\r\n\r\n  \/\/ Set the initial height of the placeholder\r\n  setPlaceholderHeight();\r\n\r\n  \/\/ Update the height on window resize\r\n  window.addEventListener('resize', setPlaceholderHeight);\r\n});\r\n  const tocTitle = document.querySelector('#toc-title'); \/\/ Assuming header-faq is the element for TOC title\r\n\r\n\/\/ Sticky TOC and update heading\r\ndocument.addEventListener(\"DOMContentLoaded\", function() {\r\n  const toc = document.querySelector('#toc');\r\n  const footer = document.querySelector('.td-footer-template-wrap');\r\n  const tocParent = toc.parentElement;\r\n  const divTop = tocParent.getBoundingClientRect().top + window.pageYOffset;\r\n  const tocHeight = toc.offsetHeight;\r\n  const triggerPoint = divTop + tocHeight + 700;\r\n  const footerHeight = footer.offsetHeight;\r\n  const triggerFooterPoint = footer.getBoundingClientRect().top + window.pageYOffset - footerHeight - footerHeight - footerHeight;\r\n  const phtoc = document.querySelector('#placeholder-toc');\r\n  const headers = document.querySelectorAll('.td-post-content h2');\r\n  const navLinks = document.querySelectorAll('#toc-list a');\r\n\t\r\n\tconst panel2 = document.querySelector(\"#toc .list\");\r\n\tvar icon = document.querySelector(\".toc-icon\");\r\n\r\n  let activeLink = null; \/\/ Declare activeLink outside the loop\r\n\t\r\n  \/\/ Function to handle scroll and add\/remove .sticky class\r\n  function handleScroll() {\r\n    const windowTop = window.pageYOffset || document.documentElement.scrollTop;\r\n    let currentHeader = '';\r\n\r\n    \/\/ Highlight user progress as the heading comes\r\n    headers.forEach(header => {\r\n\t\tconst headerTop = header.offsetTop;\r\n\t\tconst headerHeight = header.clientHeight;\r\n\t\tif (window.scrollY >= (headerTop - headerHeight + 700)) {\r\n\t\t\tconst currentHeaderId = header.getAttribute('id');\r\n\t\t\tconst currentHeaderText = document.getElementById(currentHeaderId).textContent;\r\n\/\/ \t\t\tconsole.log(\"current header text:\", currentHeaderText);\r\n\t\t\ttocTitle.textContent = currentHeaderText;\r\n\t\t\tcurrentHeader = currentHeaderId;\r\n\t\t\t\r\n\t\t\tif(window.innerWidth < 767){\r\n\t\t\t\ttocTitle.textContent = 'Table of Content';\r\n\t\t\t}\r\n\t\t}\r\n\t});\r\n\r\n    navLinks.forEach(link => {\r\n      link.classList.remove('active');\r\n      if(currentHeader != '') {\r\n\t\t  if (link.getAttribute('href').includes(currentHeader)) {\r\n\t\t\t  link.classList.add('active');\r\n\t\t  }\r\n\t  }\r\n    });\r\n\/\/     if (windowTop < triggerFooterPoint) {\r\n\/\/         toc.style.display = 'block';\r\n\/\/ \t}else{\r\n\/\/         toc.style.display = 'none';\r\n\/\/ \t}\r\n    \/\/ Update TOC title if sticky\r\n    if (windowTop > triggerPoint) {\r\n      if (!toc.classList.contains('sticky')) {\r\n        phtoc.style.display = \"block\";\r\n        toc.classList.add('sticky');\r\n        toc.style.width = `${tocParent.offsetWidth}px`; \/\/ Set width to match the parent element\r\n        toc.setAttribute('style', 'width: ' + tocParent.offsetWidth + 'px !important;');\r\n        toc.style.backgroundColor = \"#FFF\";\r\n\t\tpanel2.style.height = '0px';\r\n\t\t  icon.style.transform = \"rotate(180deg)\";\r\n\t\t  if(window.innerWidth < 767){\r\n\/\/ \t\t\t  const tocs = document.querySelector('#toc.sticky');\r\n\t\t\t  tocTitle.textContent = 'Table of Content'; \/\/ Reset title\r\n       \t\t  toc.style.width = '150px'; \/\/ Set width to match the parent element\r\n\t\t  }\r\n      }\r\n      if (currentHeader) {\r\n\/\/         console.log(\"activeLink:\", activeLink);\r\n        if (activeLink) {\r\n\/\/           tocTitle.textContent = activeLink.textContent; \/\/ Update TOC title\r\n          tocTitle.textContent = activeLink ? activeLink.textContent : \"\"; \/\/ Update title only if activeLink exists\r\n        }\r\n      }\r\n    } else {\r\n      toc.classList.remove('sticky');\r\n      phtoc.style.display = \"none\";\r\n      toc.style.width = 'unset'; \/\/ Reset to original width\r\n      toc.style.backgroundColor = \"#FFF\";\r\n      tocTitle.textContent = 'Table of Content'; \/\/ Reset title\r\n\t\tpanel2.style.height = panel2.scrollHeight + \"px\";\r\n\t\ticon.style.transform = \"rotate(180deg)\";\r\n    }\r\n  }\r\n\r\n    \/\/ Attach the scroll event listener to the window\r\n    window.addEventListener('scroll', handleScroll);\r\n\r\n    \/\/ Initial call to handleScroll to set the correct state on load\r\n    handleScroll();\r\n});\r\n\t\r\n\t\/\/ Open toggle TOC\r\n\t  document.addEventListener(\"DOMContentLoaded\", function() {\r\n\t\tvar tocHeader = document.querySelector(\"#toc .header\");\r\n\t\tvar toc = document.querySelector(\"#toc\");\r\n\t\tvar icon = document.querySelector(\".toc-icon\");\r\n\t\tconst tocTitle = document.querySelector('#toc-title');\r\n\t\tconst tocs = document.querySelector('#toc.sticky');\r\n \t\tconst tocParent = toc.parentElement;\t\t  \r\n\r\n\t\t  tocHeader.addEventListener(\"click\", function() {\r\n\t\t\tvar panel = this.nextElementSibling;\r\n\t\t\tif (panel.style.height !== '0px') { \/\/ Check if height is not 0px\r\n\t\t\t  panel.style.height = '0px'; \/\/ Set height to 0 for full collapse\r\n\t\t\t  icon.style.transform = \"rotate(180deg)\";\r\n\/\/ \t\t\t\ttoc.style.paddingBottom = '6px'; \r\n\t\t\t\tif(window.innerWidth > 768){\r\n\t\t\t\t\tif(!toc.classList.contains('sticky')){\r\n\t\t\t\t\t\ttoc.style.width = \"unset\";\r\n\/\/ \t\t\t\t\t\ttoc.setAttribute('style', 'width: ' + tocParent.offsetWidth + 'px !important;');\r\n\t\t\t\t\t}\r\n\t\t\t\t\tif (toc.classList.contains('sticky')){\r\n\t\t\t\t\t\ttoc.style.width = '${tocParent.offsetWidth}px';\r\n\t\t\t\t\t\ttoc.setAttribute('style', 'width: ' + tocParent.offsetWidth + 'px !important;');\r\n\t\t\t\t\t}\r\n\t\t\t\t}\r\n\t\t\t\tif(window.innerWidth < 767){\r\n\t\t\t\t\ttoc.style.width = \"unset\"; \/\/ Reset width\r\n\t\t\t\t}\r\n\t\t\t\ttoc.style.backgroundColor = \"#FFF1F1\";\r\n\t\t\t} else {\r\n\t\t\t  panel.style.height = panel.scrollHeight + \"px\";\r\n\t\t\t  icon.style.transform = \"rotate(0deg)\";\r\n\t\t\t  toc.style.backgroundColor = \"#FFF\";\r\n\t\t\t  tocTitle.textContent = 'Table of Content'; \/\/ Reset title\r\n\t\t\t\ttoc.style.paddingBottom = '24px';\r\n\t\t\t \tif(window.innerWidth < 767){\r\n\t\t\t\t\ttoc.style.width = `${tocParent.offsetWidth}px`; \/\/ Set width to match the parent element\r\n\t\t\t\t\ttoc.setAttribute('style', 'width: ' + tocParent.offsetWidth + 'px !important;');\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t  });\r\n\r\n\t\t  \/\/ Close TOC when a link inside it is clicked\r\n\t\t  var tocLinks = document.querySelectorAll(\"#toc .list a\");\r\n\t\t  tocLinks.forEach(function(link) {\r\n\t\t\tlink.addEventListener(\"click\", function() {\r\n\t\t\t  var panel = document.querySelector(\"#toc .list\");\r\n\t\t\t  panel.style.height = '0px'; \/\/ Set height to 0 for full collapse\r\n\t\t\t  icon.style.transform = \"rotate(180deg)\";\r\n\t\t\t  toc.style.backgroundColor = \"#FFF\";\r\n\t\t\t});\r\n\t\t  });\r\n\t\t});\r\n\r\n\r\n\r\n\t\r\n\/\/ \tmake the heading at the center of the viewport\r\n\/\/ \tdocument.addEventListener('DOMContentLoaded', function() {\r\n\/\/     \/\/ Add click event listener to all links in the TOC list\r\n\/\/     document.querySelectorAll('#toc-list a').forEach(anchor => {\r\n\/\/         anchor.addEventListener('click', function (e) {\r\n\/\/             e.preventDefault(); \/\/ Prevent the default behavior of jumping to the anchor\r\n\/\/ \/\/ \t\t\tconsole.log(\"prevent default\");\r\n\/\/             const targetId = this.getAttribute('href').substring(1); \/\/ Get the ID of the target element\r\n\/\/             const targetElement = document.getElementById(targetId); \/\/ Get the target element\r\n\r\n\/\/             if (targetElement) {\r\n\/\/                 const headerHeight = document.querySelector('#toc .header').offsetHeight; \/\/ Get the height of the fixed header\r\n\/\/                 const windowHeight = window.innerHeight; \/\/ Get the height of the viewport\r\n\/\/                 const targetOffset = targetElement.offsetTop; \/\/ Get the top offset of the target element\r\n\/\/                 const scrollTo = targetOffset + (windowHeight \/ 2) + (headerHeight); \/\/ Calculate the scroll position to center the target element\r\n\r\n\/\/                 \/\/ Scroll to the calculated position smoothly\r\n\/\/                 window.scrollTo({\r\n\/\/                     top: scrollTo,\r\n\/\/                     behavior: 'smooth'\r\n\/\/                 });\r\n\/\/             }\r\n\/\/         });\r\n\/\/     });\r\n\/\/ });\r\n<\/script>\r\n\r\n<!-- START script lama -->\r\n<!-- <script>\r\n\/\/ \tvar pilihDaftarIsi = document.getElementById('pilihDaftarIsi');\r\n\t\r\n\/\/ \tdocument.addEventListener('DOMContentLoaded', function() {\r\n\/\/ \t\tvar dropdownFixedTop = document.querySelector('.dropdown-fixed-top');\r\n\r\n\/\/ \t\tdropdownFixedTop.addEventListener('click', function() {\r\n\/\/ \t\t\tvar dropdownContent = this.querySelector('.list_toc');\r\n\/\/ \t\t\tdropdownContent.classList.toggle('show');\r\n\/\/ \t\t});\r\n\r\n\/\/ \t\twindow.addEventListener('click', function(event) {\r\n\/\/ \t\t\tvar listTocTop = document.getElementById('list_toc_top');\r\n\r\n\/\/ \t\t\tif (!dropdownFixedTop.contains(event.target)) {\r\n\/\/ \t\t\t\tlistTocTop.classList.remove('show');\r\n\/\/ \t\t\t}\r\n\/\/ \t\t});\r\n\/\/ \t});\r\n\t\r\n\/\/ \tvar daftarIsiContainer = document.getElementById('toc_group_article');\r\n\/\/ \tvar dropdownFixedTop = document.getElementById('dropdown-fixed-top');\r\n\/\/     var triggered = false; \/\/ Flag to keep track of whether the function has been triggered\r\n\r\n\/\/     window.addEventListener('scroll', function() {\r\n\/\/         if (!triggered && isCompletelyScrolledPast(daftarIsiContainer)) {\r\n\/\/             showSectionDropdownFixedTop(false);\r\n\/\/             triggered = true;\r\n\/\/         } else if (triggered && !isCompletelyScrolledPast(daftarIsiContainer)) {\r\n\/\/             showSectionDropdownFixedTop(true);\r\n\/\/             triggered = false;\r\n\/\/         }\r\n\/\/     });\r\n\r\n\/\/     function isCompletelyScrolledPast(element) {\r\n\/\/         var elementTop = element.getBoundingClientRect().top;\r\n\/\/         var elementBottom = element.getBoundingClientRect().bottom;\r\n\/\/         return elementTop < 0 && elementBottom < 0;\r\n\/\/     }\r\n\r\n\/\/     function showSectionDropdownFixedTop(show) {\r\n\/\/ \t\tif (show) {\r\n\/\/ \t\t\tdropdownFixedTop.classList.remove(\"show\");\r\n\/\/ \t\t} else {\r\n\/\/ \t\t\tdropdownFixedTop.classList.add(\"show\");\r\n\/\/ \t\t}\r\n\/\/     }\r\n<\/script> -->\r\n<!-- <script>\r\n    \/\/ Scrollspy function to highlight the active TOC item based on the scroll position\r\n  function scrollSpy(tocClass) {\r\n    const scrollPosition = window.scrollY;\r\n\r\n    \/\/ Find the active h2 and h3 headings based on their position in the corresponding TOC\r\n    let activeH2 = null;\r\n    let activeH3 = null;\r\n\r\n    const tocItems = document.querySelectorAll(`.${tocClass} li`);\r\n    tocItems.forEach(item => {\r\n      const a = item.querySelector('a');\r\n      if (!a) return;\r\n      const href = a.getAttribute('href');\r\n      const targetId = href.substring(1); \/\/ Remove the '#' from the href to get the target ID\r\n      const targetElement = document.getElementById(targetId);\r\n      if (!targetElement) return;\r\n\r\n      const targetTop = targetElement.getBoundingClientRect().top + scrollPosition;\r\n      const nextItem = item.nextElementSibling;\r\n      const nextTop = nextItem ? nextItem.getBoundingClientRect().top + scrollPosition : Infinity;\r\n\r\n      if (targetTop <= scrollPosition + 150) {\r\n        if (a.parentElement.parentElement === tocItems) {\r\n          \/\/ The h2 heading is at the root level of the TOC\r\n          activeH2 = { id: targetId, level: 'h2' };\r\n        } else {\r\n          \/\/ The h3 heading is nested under an h2 heading\r\n          const parentH2 = a.parentElement.parentElement.previousElementSibling;\r\n          if (parentH2) {\r\n            const h2Link = parentH2.querySelector('a');\r\n            if (h2Link) {\r\n              const h2Href = h2Link.getAttribute('href');\r\n              const h2Id = h2Href.substring(1);\r\n              activeH2 = { id: h2Id, level: 'h2' };\r\n            }\r\n          }\r\n          activeH3 = { id: targetId, level: 'h3' };\r\n        }\r\n      }\r\n\r\n      if (targetTop > scrollPosition + 150 && nextTop > scrollPosition + 150 && !activeH3) {\r\n        \/\/ Reset the activeH2 when there are no more active h3 headings\r\n        activeH2 = null;\r\n      }\r\n    });\r\n\r\n    \/\/ Update the active state for the TOC items\r\n    tocItems.forEach(item => {\r\n      item.classList.remove('active');\r\n      const a = item.querySelector('a');\r\n      if (a) {\r\n        const href = a.getAttribute('href');\r\n        const targetId = href.substring(1);\r\n        if ((activeH2 && activeH2.id === targetId) || (activeH3 && activeH3.id === targetId)) {\r\n          item.classList.add('active');\r\n\t\t  pilihDaftarIsi.innerHTML = a.textContent;\r\n        }\r\n      }\r\n    });\r\n  }\r\n\r\n  \/\/ Call scrollSpy for each TOC on window scroll\r\n  const tocClasses = ['list_toc', 'list_toc_float', 'list_toc_top']; \/\/ Add other TOC class names here if you have more than two instances\r\n  tocClasses.forEach(tocClass => {\r\n    window.addEventListener('scroll', () => scrollSpy(tocClass));\r\n  });\r\n<\/script> -->\r\n<!-- END script lama -->\r\n\t\r\n<script>\r\n    \/\/ Scrollspy function to highlight the active TOC item based on the scroll position\r\n  function scrollSpy(tocClass) {\r\n    const scrollPosition = window.scrollY;\r\n\r\n    \/\/ Find the active h2 and h3 headings based on their position in the corresponding TOC\r\n    let activeH2 = null;\r\n    let activeH3 = null;\r\n\r\n    const tocItems = document.querySelectorAll(`.${tocClass} li`);\r\n    tocItems.forEach(item => {\r\n      const a = item.querySelector('a');\r\n      if (!a) return;\r\n      const href = a.getAttribute('href');\r\n      const targetId = href.substring(1); \/\/ Remove the '#' from the href to get the target ID\r\n      const targetElement = document.getElementById(targetId);\r\n      if (!targetElement) return;\r\n\r\n      const targetTop = targetElement.getBoundingClientRect().top + scrollPosition;\r\n      const nextItem = item.nextElementSibling;\r\n      const nextTop = nextItem ? nextItem.getBoundingClientRect().top + scrollPosition : Infinity;\r\n\r\n      if (targetTop <= scrollPosition + 150) {\r\n        if (a.parentElement.parentElement === tocItems) {\r\n          \/\/ The h2 heading is at the root level of the TOC\r\n          activeH2 = { id: targetId, level: 'h2' };\r\n        } else {\r\n          \/\/ The h3 heading is nested under an h2 heading\r\n          const parentH2 = a.parentElement.parentElement.previousElementSibling;\r\n          if (parentH2) {\r\n            const h2Link = parentH2.querySelector('a');\r\n            if (h2Link) {\r\n              const h2Href = h2Link.getAttribute('href');\r\n              const h2Id = h2Href.substring(1);\r\n              activeH2 = { id: h2Id, level: 'h2' };\r\n            }\r\n          }\r\n          activeH3 = { id: targetId, level: 'h3' };\r\n        }\r\n      }\r\n\r\n      if (targetTop > scrollPosition + 150 && nextTop > scrollPosition + 150 && !activeH3) {\r\n        \/\/ Reset the activeH2 when there are no more active h3 headings\r\n        activeH2 = null;\r\n      }\r\n    });\r\n\r\n    \/\/ Update the active state for the TOC items\r\n    tocItems.forEach(item => {\r\n      item.classList.remove('active');\r\n      const a = item.querySelector('a');\r\n      if (a) {\r\n        const href = a.getAttribute('href');\r\n        const targetId = href.substring(1);\r\n        if ((activeH2 && activeH2.id === targetId) || (activeH3 && activeH3.id === targetId)) {\r\n          item.classList.add('active');\r\n        }\r\n      }\r\n    });\r\n  }\r\n\r\n  \/\/ Call scrollSpy for each TOC on window scroll\r\n  const tocClasses = ['list_toc', 'list_toc_float']; \/\/ Add other TOC class names here if you have more than two instances\r\n  tocClasses.forEach(tocClass => {\r\n    window.addEventListener('scroll', () => scrollSpy(tocClass));\r\n  });\r\n<\/script>\r\n\t\r\n\r\n<!-- ToC List for desktop side bar, diganti jadi inject by php, di code snippet \"Sidebar Accordion\" -->\r\n<!--  <script>\r\n\tdocument.addEventListener(\"DOMContentLoaded\", function() {\r\nToC List for desktop side bar, diganti jadi inject by php, di code snippet \"Sidebar Accordion\"\r\n        Fungsi untuk mengubah teks menjadi format id\r\n        function formatId(text) {\r\n            return text.trim().replace(\/[^\\w\\d]+\/g, '_');\r\n        }\r\n\r\n        \/\/ Fungsi untuk membuat nested list\r\n        function createNestedList(parentNode, children) {\r\n            if (children.length === 0) return;\r\n\r\n            const nestedUl = document.createElement('ul');\r\n            children.forEach(child => {\r\n                const nestedLi = document.createElement('li');\r\n                const nestedA = document.createElement('a');\r\n                nestedA.textContent = child.title;\r\n                nestedA.href = `#${child.id}`;\r\n                nestedLi.appendChild(nestedA);\r\n                nestedUl.appendChild(nestedLi);\r\n\r\n                if (child.children.length > 0) {\r\n                    createNestedList(nestedLi, child.children);\r\n                }\r\n            });\r\n\r\n            parentNode.appendChild(nestedUl);\r\n        }\r\n\r\n        \/\/ Membuat objek untuk menyimpan daftar h2 dan h3 beserta judulnya\r\n        const headings = [];\r\n\r\n           \/\/ Mengambil semua elemen h2 dan h3\r\n        const elements = document.querySelectorAll('.td-post-content h2');\r\n\t\t\t\/\/, .td-post-content h3\r\n\r\n        elements.forEach(element => {\r\n            if (element.tagName === 'H2') {\r\n                const id = formatId(element.textContent);\r\n                element.id = id;\r\n\t\t\t\tif (element.textContent.toLowerCase() === \"key takeaways\") {return;} \/\/ Kalau Key Takeaways, jangan dimasukin\r\n                headings.push({ level: 'h2', id: id, title: element.textContent, children: [] });\r\n            } else if (element.tagName === 'H3') {\r\n                const id = formatId(element.textContent);\r\n                element.id = id;\r\n                if (headings.length > 0) {\r\n                    headings[headings.length - 1].children.push({ level: 'h3', id: id, title: element.textContent, children: [] });\r\n                }\r\n            }\r\n        });\r\n\r\n        \/\/ Membuat list HTML dari objek headings\r\n        const ul = document.getElementById('list_toc');\r\n        let currentUl = ul;\r\n        headings.forEach(heading => {\r\n            const li = document.createElement('li');\r\n            const a = document.createElement('a');\r\n            a.textContent = heading.title;\r\n            a.href = `#${heading.id}`;\r\n            li.appendChild(a);\r\n\r\n            if (heading.level === 'h2') {\r\n                \/\/ Menyimpan ul saat ini untuk menambahkan nested ul\r\n                currentUl = li;\r\n                ul.appendChild(li);\r\n            } else if (heading.level === 'h3') {\r\n                if (!currentUl.lastElementChild || currentUl.lastElementChild.tagName !== 'UL') {\r\n                    \/\/ Jika belum ada nested ul, buat satu\r\n                    const nestedUl = document.createElement('ul');\r\n                    currentUl.appendChild(nestedUl);\r\n                    currentUl = nestedUl;\r\n                }\r\n                currentUl.appendChild(li);\r\n            }\r\n\r\n            createNestedList(li, heading.children);\r\n        });\r\n\t\tDapatkan elemen ul dengan id 'list_toc_float'\r\nconst ulFloat = document.getElementById('list_toc');\r\nconst ulJourney = document.getElementById('list_journey');\r\n\r\nDapatkan isi (child elements) dari ul dengan id 'list_toc_float'\r\n\tif (ulFloat !== null) {\r\n\t\tconst clonedChildren = ulFloat.cloneNode(true).children;\r\n\t\tconst ulToc = document.getElementById('list_toc_float');\r\n\t\tconst ulTocTop = document.getElementById('list_toc_top');\r\n\t\tif ((ulToc !== null || ulToc !== undefined) && window.innerWidth > 1018){\r\n\t\t\tulToc.append(...clonedChildren);\r\n\t\t} else {\r\n\t\t\tulTocTop.append(...clonedChildren);\r\n\t\t}\r\n\t} \r\n\r\n\tif (ulJourney !== null) {\r\n\t\tconst clonedChildrenJourney = ulJourney.cloneNode(true).children;\r\n\t\tconst ulTocJourney = document.getElementById('list_toc_journey');\r\n\t\tulTocJourney.append(...clonedChildrenJourney);\r\n\t} \r\n\t\r\n        Fungsi untuk mengambil tinggi navbar\r\n        function getNavbarHeight() {\r\n            const navbar = document.getElementById('tdi_34');\r\n            return navbar ? navbar.offsetHeight : 0;\r\n        }\r\n\r\n        \/\/ Fungsi untuk menambahkan offset posisi scroll\r\n        function scrollToElementWithOffset(elementId) {\r\n            const element = document.getElementById(elementId);\r\n            if (element) {\r\n                const offset = getNavbarHeight();\r\n                const elementPosition = element.getBoundingClientRect().top;\r\n                const offsetPosition = elementPosition - offset-40;\r\n\r\n                window.scrollBy({\r\n                    top: offsetPosition,\r\n                    behavior: 'smooth'\r\n                });\r\n            }\r\n        }\r\n\r\n        \/\/ Fungsi untuk menangani klik pada tautan judul\r\n        function handleTitleClick(event) {\r\n            event.preventDefault();\r\n            const href = event.target.getAttribute('href').substr(1);\r\n            scrollToElementWithOffset(href);\r\n        }\r\n\r\n        \/\/ Tambahkan event listener untuk semua tautan judul\r\n        const titleLinks = document.querySelectorAll('a[href^=\"#\"]');\r\n        titleLinks.forEach(link => {\r\n            link.addEventListener('click', handleTitleClick);\r\n        });\r\n\t});\r\n    <\/script> -->\r\n<\/span><\/p>\r\n<div id=\"toc_container\">\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\"><\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h2 class=\"wp-block-heading\" id=\"1\"><strong>The Uses of Excel in Professional Fields<\/strong><\/h2>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Many job openings require candidates to master Excel. Not surprisingly, excel is needed by a wide variety of fields of work that require data collection.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>To that end, we will present the following professions, which can benefit from the use of Excel, among others:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">Accountancy<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>It is widespread for accountants to be able to use Excel. The field of accounting benefits from using Microsoft Excel in several ways, including making it easier to calculate corporate profit and loss, identify large profits over a period, calculate employee salaries, and more.<\/p>\r\n<p>An accountant can facilitate his work by using the <a href=\"https:\/\/www.hashmicro.com\/accounting\">accounting system<\/a> as a tool he worked. The system can provide convenience in managing the company&#8217;s financial circulation and calculating it optimally and accurately.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p><strong>Also Read:<\/strong> <a href=\"https:\/\/www.hashmicro.com\/blog\/what-is-payslip\/\" target=\"_blank\" rel=\"noreferrer noopener\">Salary Slip: Understanding, Benefits, Format, Example<\/a><\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">Mathematical calculations<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The next advantage of using Microsoft Excel is mathematical calculations. Use calculations to find data from numbers, subtractions, multiplications, and divisions, as well as various other variations such as <a href=\"https:\/\/www.omnicalculator.com\/math\/slope\" target=\"_blank\" rel=\"noopener\">calculating the slope<\/a>.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">Data processing<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>In data management, there are helpful excel formulas, including managing statistical databases, calculating data, searching for median values, and averages, and searching for the maximum and minimum values of data sets.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">Graphic creation<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Excel allows you to create graphics. Such as graphing population development data for one year, the graph of student library visits for one year, the student graduation graph for six years, the graph of student number development for three years, and others.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">Table operations<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The last application is to be able to operate the table. With a total of 1,084,576 rows and 16,384 columns in Microsoft Excel, it will make it easier for you to enter data that requires a large number of columns and rows.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"330\" loading=\"lazy\" class=\"wp-image-7355\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1.png\" alt=\"Excel Formulas\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1.png 900w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1-300x110.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1-768x282.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1-150x55.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/microsoft-excel^2016^excel-logo-new-1-696x255.png 696w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/>\r\n<figcaption>Source: versionmuseum.com<\/figcaption>\r\n<\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h2 class=\"wp-block-heading\" id=\"2\">Complete Excel Formulas with Their Functions<\/h2>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>In addition to the functionality and use of Microsoft Excel mentioned earlier, operating this Excel program requires Excel formulas. Each formula has a different function that you can use for a specific need.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Here are the Excel formulas you need to know, among others:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-table\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>Formulas<\/td>\r\n<td>Functional Description<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>SUM<\/td>\r\n<td>Summing<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>AVERAGE<\/td>\r\n<td>Looking for Average Values<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>AND<\/td>\r\n<td>Finding Value by comparison and<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>NOT<\/td>\r\n<td>Finding Value with Exceptions<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>OR<\/td>\r\n<td>Finding Value by Comparison or<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>SINGLE IF<\/td>\r\n<td>Looking for Values If Conditions ARE RIGHT\/WRONG<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>MULTI IF<\/td>\r\n<td>Finding Values If Conditions ARE RIGHT\/WRONG With Many Comparisons<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>AREAS<\/td>\r\n<td>View The Number of Areas (Range or Cells)<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>CHOOSE<\/td>\r\n<td>View Selection Results Based on Index Numbers<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>HLOOKUP<\/td>\r\n<td>Search for Data from a table organized in a horizontal format<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>VLOOKUP<\/td>\r\n<td>Search for Data from a table arranged in an upright format<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>MATCH<\/td>\r\n<td>Displays the position of a specific cell address<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>COUNTIF<\/td>\r\n<td>Counting the Number of Cells in a Range with specific criteria<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>COUNTA<\/td>\r\n<td>Counting the Number of Filled Cells<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>CEILING<\/td>\r\n<td>Round the number up<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>FLOOR<\/td>\r\n<td>Rounds numbers down<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>DAY<\/td>\r\n<td>Looking for The Value of the Day<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>MONTH<\/td>\r\n<td>Searching for the Value of the Moon<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>YEAR<\/td>\r\n<td>Looking for Year Value<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>DATE<\/td>\r\n<td>Get a Date Value<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>LOWER<\/td>\r\n<td>Change text letters to lowercase<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>UPPER<\/td>\r\n<td>Change Text Letters to UpperCase<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>PROPER<\/td>\r\n<td>Change the Initial Character of the Text To UpperCase<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<figcaption>23 Excel Formulas<\/figcaption>\r\n<\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For more information about how to use the excel function formulas mentioned above, here is a detailed description, along with examples:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">SUM<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>This Excel summation formula has the primary function of summing numbers in specific cells. However, it is also often used to complete a job or task quickly.\u00a0<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>To use SUM, first create a summation table and enter the summation formula below. For example, <strong>=SUM(G8:H8)<\/strong>, or as shown in the image below:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"473\" height=\"78\" loading=\"lazy\" class=\"wp-image-7359\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM.png\" alt=\"Excel Formula: Sum\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM.png 473w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM-300x49.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM-150x25.png 150w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/figure>\r\n<\/div>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Then, if the SUM formula has been entered, press enters to specify the amount. As shown in the picture below:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"472\" height=\"77\" loading=\"lazy\" class=\"wp-image-7360\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM_2.png\" alt=\"Excel Formula: Sum 2\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM_2.png 472w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM_2-300x49.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/SUM_2-150x24.png 150w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/figure>\r\n<\/div>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">AVERAGE<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The primary function of the AVERAGE formula or the average formula in Excel is to find the average value of a variable. The trick is to create a table for grades and then enter the AVERAGE formula to determine the student&#8217;s grade point average. For example, <strong>=AVERAGE(D2:F2)<\/strong>, as in the following image:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"330\" loading=\"lazy\" class=\"wp-image-7361\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-1024x330.png\" alt=\"Excel Formula: Average\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-1024x330.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-300x97.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-768x248.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-150x48.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE-696x225.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE.png 1066w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>If you enter the AVERAGE formula, press enters to see the result, shown in the image below.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"334\" loading=\"lazy\" class=\"wp-image-7362\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-1024x334.png\" alt=\"Excel Formula: Average 2\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-1024x334.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-300x98.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-768x250.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-150x49.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2-696x227.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AVERAGE_2.png 1055w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">AND<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The AND formula function generates a TRUE value if all previously tested arguments are correct or can return a FALSE value if all arguments or answers are incorrect.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>To determine TRUE or FALSE, you must create a table and enter THE FORMULA AND. For example, =AND(G7&gt;I7).<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>This technique is usually used to help fill out questionnaires or answer question columns to speed up the value-setting process.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">NOT<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The NOT formula has the opposite function of the AND formula because it produces TRUE if the condition tested is FALSE and FALSE if the condition tested is TRUE.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The first step is to create a table and enter the FORMULA NOT to find out the results. For example, as shown in the diagram below, =NOT(G7&gt;J7).<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">OR<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The OR is the following excel formula that will produce TRUE data if some given argument is correct. If all of the arguments presented are incorrect, the answer is FALSE.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>A student&#8217;s average test score result is an example of how OR can use it in Excel. If it is less than 70, he must repeat the course; if it is greater than 70, the student graduates.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">SINGLE IF<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The IF function is to return a value that, when examined, is TRUE and another value that is visible as FALSE.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Not much different from the technique of using formulas in OR. It just seems more straightforward.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For example, when a student&#8217;s average grade is less than 75, that student does not graduate, and vice versa. How to create an IF formula is <strong>=IF(J8&lt;75;&#8221; NOT GRADUATING&#8221;;&#8221; PASS&#8221;)<\/strong>. To be clear, take a look at the following image:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"215\" loading=\"lazy\" class=\"wp-image-7363\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-1024x215.png\" alt=\"Excel Formula: Single IF\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-1024x215.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-300x63.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-768x162.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-150x32.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-696x146.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF-1068x225.png 1068w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF.png 1317w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>After entering the formula, press enters, and the result will match what you ordered.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"175\" loading=\"lazy\" class=\"wp-image-7364\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-1024x175.png\" alt=\"Excel Formula: Single IF 2\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-1024x175.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-300x51.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-768x131.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-150x26.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-696x119.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2-1068x182.png 1068w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/IF_2.png 1318w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">MULTI IF<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>This formula is a further lesson from SINGLE IF, but if SINGLE IF only uses only one condition with two options, The MULTI IF uses two terms and three options.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>A Double\/Multi FORMULA is a type of logic-IF formula consisting of 2 or more IF in formula writing. If a single IF only needs 1 IF, for example, <strong>=IF(B2=&gt;=70;&#8221; Graduated&#8221;;&#8221; Failed&#8221;)<\/strong> then Double IF requires more than 1 IF, for example, <strong>=IF(B2&gt;=70;&#8221; Good&#8221;;IF(B2&gt;=50;&#8221; Enough&#8221;;&#8221; Less&#8221;))<\/strong>.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>So that the full Excel formula will provide Syntax on Double \/ Multi IF, among others:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p><strong>=IF(Logical_Test; Value_If_True;IF(Logical_Test; Value_If_True; Value_If_False))<\/strong><\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">AREAS<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>You can use the usability of AREAS if you want to calculate the number of areas you want to select. The AREAS formula can use the formula <strong>=AREAS(G6:K8)<\/strong>.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"213\" loading=\"lazy\" class=\"wp-image-7365\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-1024x213.png\" alt=\"Excel Formula: AREAS\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-1024x213.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-300x62.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-768x160.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-1536x320.png 1536w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-150x31.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-696x145.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2-1068x222.png 1068w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/AREAS_2.png 1570w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The result is one area. The results are based on the example in the image of selecting only one range of cells.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">CHOOSE<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The primary function of a CHOOSE formula is to display selection results based on index numbers or sequences in reference (VALUE) that contain text, numeric, formula, or range names. The image below shows an example of how to write the CHOOSE formula.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"481\" height=\"207\" loading=\"lazy\" class=\"wp-image-7366\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE.png\" alt=\"Excel Formula: CHOOSE\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE.png 481w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE-300x129.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE-150x65.png 150w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/figure>\r\n<\/div>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Meanwhile, the results of the CHOOSE formula are shown in the image below.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"355\" height=\"151\" loading=\"lazy\" class=\"wp-image-7367\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE_2.png\" alt=\"Excel Formula: CHOOSE 2\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE_2.png 355w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE_2-300x128.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/CHOOSE_2-150x64.png 150w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\r\n<\/div>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">HLOOKUP<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The HLOOKUP function displays data from tables arranged horizontally. However, The arrangement of tables or data in the first row should be based on small to large sequences or raising them.\u00a0<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For example, the number 1,2,3,4\u2026 Or the letter A-Z. Sort by ascending the menu if you previously typed randomly. Cases like the ones listed below are examples.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"672\" height=\"79\" loading=\"lazy\" class=\"wp-image-7368\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/HLOOKUP.png\" alt=\"Excel Formula: HLOOKUP\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/HLOOKUP.png 672w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/HLOOKUP-300x35.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/HLOOKUP-150x18.png 150w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p><strong>=HLOOKUP(Cells that contain packet types; Range cell table details costs; The location of the data column you want to retrieve;0)<\/strong>.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">VLOOKUP<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The primary function of the VLOOKUP formula is almost identical to the HLOOKUP formula; The difference is that the VLOOKUP formula displays data from tables arranged in an upright or vertical format. The requirement is that the first row of the data table is prepared in small to large order or up.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For example 1,2,3,4\u2026 Or the letter A-Z. For example 1,2,3,4\u2026 Or the letter A-Z. Sort through the Ascending menu if you previously typed randomly.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">MATCH<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The MATCH function is one of the components of an Excel formula that you can use to perform lookups or reference data searches.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The MATCH function works by finding the relative position of a value in a range or array and generating a number that is the index of the cell&#8217;s relative position that contains the value it is looking for.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The use of the Excel MATCH function must follow the syntax rules, namely <strong>MATCH(lookup_value, lookup_array, [match_type])<\/strong><\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>To better understand, understand the image below:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7369\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MATCH.png\" alt=\"MATCH\" width=\"410\" height=\"358\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MATCH.png 410w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MATCH-300x262.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MATCH-150x131.png 150w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/>\r\n<figcaption>Source: je-excel\u00a0<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">COUNTIF<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>COUNTIF is a helpful formula for counting the number of cells that have the same criteria. As a result, you no longer have to struggle with data sorting.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Assume you&#8217;re doing a survey. You want to know how many civil servants there are out of 20 respondents. As a result, you can use the following formulas:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7370\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF.png\" alt=\"COUNTIF\" width=\"978\" height=\"647\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF.png 978w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF-300x198.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF-768x508.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF-150x99.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTIF-696x460.png 696w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/>\r\n<figcaption>Source: bitlabs<\/figcaption>\r\n<\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>To get started, all you need to do is enter the range of cells you want to identify into the COUNTIF formula (B2:B21)<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Then, enter the cell calculation criteria, namely &#8220;PNS&#8221; (must be in quotation marks).<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>This formula produces a result of 7. So, out of 20 respondents, seven were civil servants.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">COUNTA<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>COUNTA has the function of counting the number of cells that contain numbers and the number of cells that contain anything. As a result, you can determine the number of cells that are not empty.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Assume that cells A1 through D1 are words and cells G1 through I1 number. Therefore the use of the formula is <strong>=COUNTA(A1:I1)<\/strong><\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7371\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA.png\" alt=\"COUNTA\" width=\"907\" height=\"211\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA.png 907w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA-300x70.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA-768x179.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA-150x35.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/COUNTA-696x162.png 696w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/>\r\n<figcaption>Source: bitlabs<\/figcaption>\r\n<\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>That results in 7 because the empty cells are only E1 and F1.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">CEILING<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The CEILING formula can round the number UP at the multiple values of a specific number. The formula is CEILING (CELLS number; Multiples).<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Misalnya, CEILING(G9;100). Then the number on Cells G9 will be rounded up with a multiple of 100.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">FLOOR<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>If the previous use of the formula is to round to the nearest integer and above, the FLOOR formula is used to round to the nearest integer. The formula is almost identical to the one for CEILING, but with the addition of FLOOR.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The FLOOR formula is FLOOR (Number cell; Multiples).<\/p>\r\n<p><span style=\"font-weight: 400;\"><style>\r\n.cta-in-article-image .desktop-banner{\r\n    display: none;\r\n    text-align: center;\r\n}\r\n.cta-in-article-image .desktop-mobile{\r\n    display: block;\r\n    text-align: center;\r\n    width: 100%;\r\n}\r\n@media (min-width: 650px) {\r\n    .cta-in-article-image .desktop-banner {\r\n        display: block!important;\r\n    }\r\n}\r\n@media (min-width: 650px) {\r\n   .cta-in-article-image .desktop-mobile {\r\n        display: none!important;\r\n    }\r\n}\r\n<\/style>\r\n<div class=\"cta-in-article-image\">\r\n\t<a href=\"https:\/\/www.hashmicro.com\/grants?utm_source=blog&medium=banner-article\" target=\"_blank\" rel=\"noopener\">\r\n\t\t<div id=\"desktop-banner-container\">\r\n\t\t\t<div class=\"desktop-banner\">\r\n<!-- \tnew CTC Grants Banner\t\t -->\r\n\t\t\t\t<img decoding=\"async\" width='696' height='189' src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2025\/07\/CTC-Grants-scaled.webp\" alt=\"download skema harga software erp\">\r\n\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t\t<div id=\"mobile-banner-container\">\r\n\t\t\t<div class=\"desktop-mobile\">\r\n\t\t\t\t<img decoding=\"async\" width='450' height='497' src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2023\/11\/EDG-Banner-Mobile.png.webp\" alt=\"download skema harga software erp\">\r\n\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/a>\r\n<\/div>\r\n\r\n\r\n<\/span><\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">DAY<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The DAY formula is used to find the date type data&#8217;s day (in the numbers 1-31). Consider the DAY function (column B). The date data in column A will be extracted and converted into numbers 1-31, following the explanation through the image:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7372\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY.png\" alt=\"DAY\" width=\"999\" height=\"336\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY.png 999w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY-300x101.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY-768x258.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY-150x50.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY-696x234.png 696w\" sizes=\"auto, (max-width: 999px) 100vw, 999px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>After entering the formula =DAY(NUMBER), press enters and see the results below:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"979\" height=\"281\" loading=\"lazy\" class=\"wp-image-7373\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2.png\" alt=\"Excel Formula: DAY (2)\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2.png 979w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2-300x86.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2-768x220.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2-150x43.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DAY_2-696x200.png 696w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">MONTH<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Almost similar to the DAY formula, the use of the MONTH formula to search for months (in numbers 1-12) from date type data. For example, the use of the MONTH function (column K) of a column I date data, after extracting it, produces the numbers 1-12 as in the figure below:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7374\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-1024x225.png\" alt=\"MONTH\" width=\"1024\" height=\"225\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-1024x225.png 1024w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-300x66.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-768x169.png 768w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-150x33.png 150w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-696x153.png 696w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH-1068x235.png 1068w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/MONTH.png 1243w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">YEAR<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Meanwhile, there is a YEAR formula. The way you use this formula is similar to the way the previous two formulas were. The use of the YEAR formula takes years (in the range of 1900-9999) from date-type data.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">DATE<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The DATE formula has a function that allows you to get date data types by entering years, months, and days. The DATE function is the opposite of the DAY, MONTH, and YEAR functions, which describe month and year-type data from their respective dates.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Year, month, and day data in the form of numbers combined with the DATE function generate data with data types, as shown in the figure below. Date formula writing image, namely:<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-7375\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DATE.png\" alt=\"DATE\" width=\"636\" height=\"367\" srcset=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DATE.png 636w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DATE-300x173.png 300w, https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/DATE-150x87.png 150w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/figure>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">LOWER<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>The lower formula function converts all uppercase letters in the text to lowercase. To use the formula, type the LOWER command, and texts will convert the desired writing to lowercase.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For example, when implementing the LOWER formula with the formula =LOWER (Don&#8217;t Forget to Use HashMicro Software), the result is &#8220;don&#8217;t forget to use has micro software.&#8221;<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">UPPER<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>In addition to lower formulas, Microsoft Excel includes upper formulas. The use of UPPER is to convert all text containing lowercase letters into uppercase, the opposite of the LOWER function.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>For example, if you type UPPER (hashmicro), your writing will be entirely in capital letters.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3 class=\"wp-block-heading\">PROPER<\/h3>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Sometimes you forget to write sentences in all lowercase letters and no capital letters. So with the PROPER formula, you can capitalize on the first character in each word while keeping the rest. The formula is APPROPRIATE (text).<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h2 class=\"wp-block-heading\" id=\"3\">Conclusion<\/h2>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Although understanding Excel entirely takes time, you will be familiar with all the correct formulas and applications.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>In a company, the use of Excel is overwhelming, especially in presenting data, statistics, and company finances such as salaries. The digital world is bringing corporate transformation to provide information and payroll more easily with automated systems. You can use <a href=\"https:\/\/www.hashmicro.com\/accounting\">HashMicro accounting software<\/a> as a tool to calculate financial circulation optimally and accurately.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Moreover, HashMicro has a system that helps with all your human resource and employee administration tasks. With <a href=\"https:\/\/www.hashmicro.com\/human-resource-management\" target=\"_blank\" rel=\"noreferrer noopener\">HashMicro&#8217;s HRM Software<\/a>, calculates salaries, and manages leave and attendance lists, reimbursement processes, <a href=\"https:\/\/www.hashmicro.com\/timesheet-management\" target=\"_blank\" rel=\"noreferrer noopener\">timesheets<\/a>, and other operational activities in just seconds.<\/p>\r\n<ul class=\"toc_list\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"toc_list\">\r\n\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Produce reports accurately and comprehensively like thousands of large companies that have joined HashMicro. To check out more, click <a href=\"https:\/\/www.hashmicro.com\/?country=sg\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\r\n<a href=\"https:\/\/www.hashmicro.com\/accounting?medium=moneysite-banner\" target=\"_blank\"><img decoding=\"async\" loading=\"lazy\" width=\"712\" src=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2025\/06\/Accounting.webp\" alt=\"Accounting\"><\/a>\r\n<ul class=\"toc_list\"><\/ul>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>You may be familiar with Microsoft Excel. This application made by Microsoft Corporation is the application with the most users in the world in 140+ countries. This application has a myriad of Excel formulas that can accurately present numbers and data. The primary function of Microsoft Excel is calculation, which is why it has been [&hellip;]<\/p>\n","protected":false},"author":199,"featured_media":7387,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[153],"tags":[],"class_list":{"0":"post-7349","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-accounting"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.6 (Yoast SEO v26.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>20+ Most Popular Excel Formulas For Beginners You Should Know<\/title>\n<meta name=\"description\" content=\"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]\" \/>\n<meta property=\"og:description\" content=\"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"BusinessTech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/web.facebook.com\/hashmicro\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-05T08:50:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-30T04:50:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png\" \/>\n\t<meta property=\"og:image:width\" content=\"870\" \/>\n\t<meta property=\"og:image:height\" content=\"520\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Lucas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hashmicro\" \/>\n<meta name=\"twitter:site\" content=\"@hashmicro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lucas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\"},\"author\":{\"name\":\"Lucas\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/1d507d1ae58f14604279ad39f6076838\"},\"headline\":\"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]\",\"datePublished\":\"2023-08-05T08:50:30+00:00\",\"dateModified\":\"2024-05-30T04:50:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\"},\"wordCount\":2449,\"publisher\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png\",\"articleSection\":[\"Accounting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\",\"name\":\"20+ Most Popular Excel Formulas For Beginners You Should Know\",\"isPartOf\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png\",\"datePublished\":\"2023-08-05T08:50:30+00:00\",\"dateModified\":\"2024-05-30T04:50:14+00:00\",\"description\":\"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png\",\"contentUrl\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png\",\"width\":870,\"height\":520,\"caption\":\"Rumus Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.hashmicro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#website\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/\",\"name\":\"BusinessTech\",\"description\":\"Business Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.hashmicro.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#organization\",\"name\":\"HashMicro\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2016\/02\/bt_logo-1.png\",\"contentUrl\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2016\/02\/bt_logo-1.png\",\"width\":334,\"height\":51,\"caption\":\"HashMicro\"},\"image\":{\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/web.facebook.com\/hashmicro\/\",\"https:\/\/x.com\/hashmicro\",\"https:\/\/www.linkedin.com\/company\/hashmicro\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/1d507d1ae58f14604279ad39f6076838\",\"name\":\"Lucas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2024\/01\/cropped-expertise-blog-2-96x96.png\",\"contentUrl\":\"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2024\/01\/cropped-expertise-blog-2-96x96.png\",\"caption\":\"Lucas\"},\"description\":\"Lucas Yeo creates in-depth articles on accounting topics tailored to the challenges and questions faced by finance professionals. His articles are SEO-friendly and designed to attract readers seeking accounting solutions.\",\"url\":\"https:\/\/www.hashmicro.com\/blog\/author\/lucas-yeo\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"20+ Most Popular Excel Formulas For Beginners You Should Know","description":"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/","og_locale":"en_US","og_type":"article","og_title":"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]","og_description":"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...","og_url":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/","og_site_name":"BusinessTech","article_publisher":"https:\/\/web.facebook.com\/hashmicro\/","article_published_time":"2023-08-05T08:50:30+00:00","article_modified_time":"2024-05-30T04:50:14+00:00","og_image":[{"width":870,"height":520,"url":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png","type":"image\/png"}],"author":"Lucas","twitter_card":"summary_large_image","twitter_creator":"@hashmicro","twitter_site":"@hashmicro","twitter_misc":{"Written by":"Lucas","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#article","isPartOf":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/"},"author":{"name":"Lucas","@id":"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/1d507d1ae58f14604279ad39f6076838"},"headline":"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]","datePublished":"2023-08-05T08:50:30+00:00","dateModified":"2024-05-30T04:50:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/"},"wordCount":2449,"publisher":{"@id":"https:\/\/www.hashmicro.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png","articleSection":["Accounting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/","url":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/","name":"20+ Most Popular Excel Formulas For Beginners You Should Know","isPartOf":{"@id":"https:\/\/www.hashmicro.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage"},"image":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png","datePublished":"2023-08-05T08:50:30+00:00","dateModified":"2024-05-30T04:50:14+00:00","description":"Here are list of Excel formulas that you need to know, among others: 1. SUM \u00b7 2. AVERAGE \u00b7 3. SINGLE IF \u00b7 4. CEILING \u00b7 5. FLOOR \u00b7 6. ...","breadcrumb":{"@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hashmicro.com\/blog\/excel-formulas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#primaryimage","url":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png","contentUrl":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2021\/10\/20-Most-Popular-Excel-Formulas-You-Should-Know-Beginner-Friendly.png","width":870,"height":520,"caption":"Rumus Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hashmicro.com\/blog\/excel-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hashmicro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"20+ Most Popular Excel Formulas You Should Know [Beginner Friendly]"}]},{"@type":"WebSite","@id":"https:\/\/www.hashmicro.com\/blog\/#website","url":"https:\/\/www.hashmicro.com\/blog\/","name":"BusinessTech","description":"Business Management Blog","publisher":{"@id":"https:\/\/www.hashmicro.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hashmicro.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hashmicro.com\/blog\/#organization","name":"HashMicro","url":"https:\/\/www.hashmicro.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hashmicro.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2016\/02\/bt_logo-1.png","contentUrl":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2016\/02\/bt_logo-1.png","width":334,"height":51,"caption":"HashMicro"},"image":{"@id":"https:\/\/www.hashmicro.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/web.facebook.com\/hashmicro\/","https:\/\/x.com\/hashmicro","https:\/\/www.linkedin.com\/company\/hashmicro"]},{"@type":"Person","@id":"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/1d507d1ae58f14604279ad39f6076838","name":"Lucas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hashmicro.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2024\/01\/cropped-expertise-blog-2-96x96.png","contentUrl":"https:\/\/www.hashmicro.com\/blog\/wp-content\/uploads\/2024\/01\/cropped-expertise-blog-2-96x96.png","caption":"Lucas"},"description":"Lucas Yeo creates in-depth articles on accounting topics tailored to the challenges and questions faced by finance professionals. His articles are SEO-friendly and designed to attract readers seeking accounting solutions.","url":"https:\/\/www.hashmicro.com\/blog\/author\/lucas-yeo\/"}]}},"order_j":"","_links":{"self":[{"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/posts\/7349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/users\/199"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/comments?post=7349"}],"version-history":[{"count":21,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/posts\/7349\/revisions"}],"predecessor-version":[{"id":58815,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/posts\/7349\/revisions\/58815"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/media\/7387"}],"wp:attachment":[{"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/media?parent=7349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/categories?post=7349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hashmicro.com\/blog\/wp-json\/wp\/v2\/tags?post=7349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}