{"id":98717,"date":"2023-05-17T15:29:00","date_gmt":"2023-05-17T15:29:00","guid":{"rendered":"https:\/\/www.henryharvin.com\/blog\/?p=98717"},"modified":"2025-12-31T09:13:06","modified_gmt":"2025-12-31T09:13:06","slug":"excel-formulae-you-should-know","status":"publish","type":"post","link":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/","title":{"rendered":"Top 25 Excel Formulas you should know in 2026"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"98717\" class=\"elementor elementor-98717\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-66e07e26 elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"66e07e26\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b29f3b1\" data-id=\"5b29f3b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-333258fb elementor-widget elementor-widget-text-editor\" data-id=\"333258fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><\/p>\n<p><span style=\"font-weight: 400\">Nowadays in every organization, there is a large volume of vital data or information that needs to be processed smoothly and accurately with ease of access. You must know Top Excel Formulas for managing large volumes of data, fetching information or data, comparing, sorting and other tasks as per the requirement in the organization. <\/span><span style=\"font-weight: 400\">Excel Formulas have been used in various applications to meet various data-related requirements. <\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">With these formulas you can work fast and give accurate results. These formulas will help you to quickly access information required from the available data or information. Updated Excel Formulas in 2024 will do complex calculations and tedious tasks more efficiently. Furthermore, Excel Formulas make the task easy and present information in tabular format. You can access the required information at a glance.<\/span><\/p>\n<h2>MS Excel in 2024<\/h2>\n<p><span style=\"font-weight: 400\"> MS Excel is widely used by many organizations to record, analyze, and process data. One of the most basic and widely used features in Excel is the Excel Formula\/ Functions. And everyone using Excel should know these Excel formulas. These formulas can handle, maintain and processing large volume of data. In addition to this, <\/span><span style=\"font-weight: 400\">Advanced MS Excel has come up with various advanced features, tools and add-on formulas for quick and accurate data calculation. You can record large volumes of data in proper format. Lastly, a systematic presentation of data will give quick access to the desired information.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Update yourself with the Top 25 Excel Formulas in 2024 to perform efficiently and give accurate result. You can and handle Large volumes of data and complex tasks in a few minutes. This will further build confidence in you perform tedious task and complex calculations.<\/span><\/p>\n<h2>Excel Formula: What is It?<\/h2>\n<p><span style=\"font-weight: 400\">By applying formulas to the data in your spreadsheet, you may identify trends, perform computations, and then copy the findings to a specific cell. Excel has a plethora of fundamental formulae, such as those for adding, subtracting, dividing, calculating averages, and even dates and times, among many more.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Microsoft Excel is probably not a word you hear often if you are a professional. But if you aren&#8217;t familiar with an Excel formula, organizing and analyzing spreadsheets in MS Excel can feel like hitting a wall. You may wonder if there is an alternative to Excel&#8217;s manual operations. There is, however, a method to expedite the operation of your Excel worksheets.\u00a0<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">You can learn how to use <\/span>Excel Formulas<span style=\"font-weight: 400\"> by enrolling in the Best Advanced Excel Course Certification. The standard methods for handling massive datasets involve these Excel formulas. No matter your experience as an analyst, you will significantly enhance your data-handling talents by exploring the Excel formula list provided below.<\/span><\/p>\n<p>\u00a0<\/p>\n<h2>Why Are Formulas Necessary in Excel?<\/h2>\n<p><span style=\"font-weight: 400\">Excel Formulas are potent resources for data management and making informed decisions. If you want to know how these Excel formulae improve the worksheet, they let you do numerous actions simultaneously.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Using Excel formulae can help you save time, work more efficiently, and make fewer mistakes by hand.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">The results of data analysis using Excel formulas are reliable.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Enhanced data management capabilities result from Excel formulas that sort, filter, and change even the most complicated information.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Excel&#8217;s accessibility makes it suitable for a broader range of users, as even those without technical training may use it to import simple data.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Theoretically, they provide a buffer zone where you can manage data according to your needs.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">You can improve your employment prospects by becoming an expert with Excel spreadsheet formulas.<\/span><\/li>\n<\/ul>\n<h2>Fundamentals of Excel Formulas<\/h2>\n<h4>1. Incorporating Formula by Simply Typing It into Excel<\/h4>\n<p><span style=\"font-weight: 400\">Formulas entered into cells or the formula bar are the quickest and most basic way to use Excel. To begin, in the formula bar, type the equal sign (=) followed by the name of an Excel function. In the drop-down selection, Excel will then provide choices for which function to use.<\/span><\/p>\n<h4><b>2. Utilizing the Insert Function option in the Formulas Tab of Excel<\/b><\/h4>\n<p><span style=\"font-weight: 400\">The Excel Insert Function dialogue box gives you complete control over function insertion. Navigate to the Formulas tab and pick Insert Function from the first selection to accomplish this. There will be a dialogue window with all the functions.<\/span><\/p>\n<h3><b>3. Formula Selection in Excel&#8217;s Formula Tab<\/b><\/h3>\n<p><span style=\"font-weight: 400\">This choice is ideal for individuals who prefer to access their preferred features swiftly. Go to the Formulas page and choose your favourite group to use this option. A submenu with a list of functions will appear when you click. Next, pick the one that suits you best. If the group you want isn&#8217;t visible on the tab, try going to the More Functions menu; you can find it there.<\/span><\/p>\n<h3><b>4. Using Excel&#8217;s Quick Insert feature to access Recently Used Tabs<\/b><\/h3>\n<p><span style=\"font-weight: 400\">You can utilize the Recently Used menu to avoid tediously retyping your most recent formula. You can find it on the Formulas tab, the third option after AutoSum in the menu.<\/span><\/p>\n<h2>Boost Your Productivity with MS Excel<\/h2>\n<p><span data-preserver-spaces=\"true\">Microsoft Excel is an indispensable tool across various industrial sectors due to its versatility, ease of use, and\u00a0<\/span><span data-preserver-spaces=\"true\">powerful<\/span><span data-preserver-spaces=\"true\"> data analysis capabilities. You can manage large volume of data, analysis and decision-making processes. Several sectors where MS Excel plays <\/span><span data-preserver-spaces=\"true\">a vital<\/span><span data-preserver-spaces=\"true\"> role in maintaining a large volume of data and data analysis such as:\u00a0<\/span><\/p>\n<p>\u00a0<\/p>\n<ol>\n<li><strong><span data-preserver-spaces=\"true\">Finance and Accounting<\/span><\/strong><span data-preserver-spaces=\"true\">: Excel is extensively used for financial modeling, budgeting, forecasting, and creating financial statements. Its ability to perform complex calculations, manage large datasets, and create dynamic reports.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Marketing and Advertising<\/span><\/strong><span data-preserver-spaces=\"true\">: Marketers use Excel for data analysis, campaign planning, and performance tracking. Excel&#8217;s charts and graphs are particularly useful for visualizing data and presenting insights.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Human Resources<\/span><\/strong><span data-preserver-spaces=\"true\">: Excel is used for managing employee data, payroll processing, tracking attendance, and performance management.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Supply Chain and Logistics<\/span><\/strong><span data-preserver-spaces=\"true\">: Excel aids in inventory management, demand forecasting, and supply chain optimization.\u00a0<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Healthcare<\/span><\/strong><span data-preserver-spaces=\"true\">: In healthcare, Excel is used for patient data management, medical billing, and scheduling appointments.\u00a0<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Education<\/span><\/strong><span data-preserver-spaces=\"true\">: Excel is utilized in educational institutions for various purposes such as creating grading sheets, managing student records, and generating performance reports.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Manufacturing and Engineering<\/span><\/strong><span data-preserver-spaces=\"true\">: Engineers use it for data analysis, design calculations, and project management.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Research and Development<\/span><\/strong><span data-preserver-spaces=\"true\">: Excel is widely used in research institutions and laboratories for data collection, analysis, and visualization.\u00a0<\/span><\/li>\n<\/ol>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">Why Learning Excel Formulas?<\/h2>\n<p><\/p>\n<p><\/p>\n<p>You may be a talented employee ready to face the challenges at the workplace with the proper education and skill set. But what makes you stand out from the crowd? what makes the employer retain you? Well, it&#8217;s not just hard work; you have to be an intelligent employee with the upgraded skill sets required to meet the task.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>For those who are wondering about learning Excel formulas and spending time on it worth a shot? In a recent survey conducted more than 90% of employees responded that Excel formulas are vital to their job.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">Top 5 Reasons to learn Excel formulas\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Of course, it makes your job a lot easier\u00a0<\/li>\n<li>Enhancing your skill sets &#8211; is always an added advantage\u00a0<\/li>\n<li>Excel Formulas help you better at organizing data in a most simple manner<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Making you a valuable employee for the company\u00a0<\/li>\n<li>Increases the efficiency and productivity\u00a0<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<h2>Advantages of Learning Excel Formulas<\/h2>\n<p>Almost all companies use Microsoft Excel for various activities like data analysis, data storage,\u00a0 strategic analysis, generating reports and the list goes on. You must learn the basics of Excel. There is a wide range of features used in Excel spreadsheets and one such is Excel formulas.\u00a0<\/p>\n<h3><b>Complying with Workplace Deadlines<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Many employees struggled to fulfil job deadlines due to a lack of proficiency with Microsoft Excel, which led to low productivity and high levels of melancholy. It has an impact on both their work and personal lives.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Microsoft Excel classes, on the other hand, will teach students how to do their job faster and more accurately. Automating routine calculations is possible with advanced Microsoft Excel using formulae and functions. Microsoft Excel&#8217;s built-in commands make retrieving, saving, and editing data easy without requiring significant retyping.<\/span><\/p>\n<h3><b>Manage Massive Data Sets<\/b><\/h3>\n<p><span style=\"font-weight: 400\">People who aren&#8217;t well-versed in the many features of Microsoft Excel sometimes struggle to deal with massive data. Users who aren&#8217;t proficient with Microsoft Excel may waste time trying to extract useful information from massive databases. Time could be well-spent if it happens.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Microsoft Excel, on the other hand, makes it easy to access the many shortcuts, filter settings, and Pivot tables. So, to get to the bottom of things quickly, it&#8217;s helpful to summaries the relevant table and make mini-reports.<\/span><\/p>\n<h3><b>Attractive Presentations<\/b><\/h3>\n<p><span style=\"font-weight: 400\">To entice investors, you must present your company&#8217;s information well. The stunning presentation of data is due to Excel. However, this program also needs a spreadsheet to generate data-driven presentations.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Excel reports with pictures can be more effective when investors or coworkers struggle to understand the material. The Microsoft Excel Training Course has this as one of its primary benefits.<\/span><\/p>\n<h3><b>Work Smarter, Not Harder.<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Some employees become overly anxious when their management asks for reports quickly. They make erroneous reports in all the haste. The use of Excel makes delegation a breeze, though. It is simple to allocate cells to coworkers and upload Excel spreadsheets to shared networks.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The most excellent thing about working on a shared spreadsheet is that everyone has complete access, and the work is done on time or ahead of schedule. This allows for the execution of tasks with minimal effort and time expended.<\/span><\/p>\n<h3><b>Ease Pressure on IT Staff<\/b><\/h3>\n<p><span style=\"font-weight: 400\">Managing routine data became the responsibility of the IT department in many smaller businesses. Since the IT department may not always need this kind of data, it is a complete waste of resources. However, this impacts their tasks of developing and managing online products.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The administration department employee&#8217;s efficiency can be enhanced if given an Advanced MS Excel Course. Manage the day-to-day operations of your company with ease.<\/span><\/p>\n<h2><b>Enhance your performance with Microsoft Excel Formulas<\/b><\/h2>\n<p><span style=\"font-weight: 400\">Mastering\u00a0<\/span><a href=\"https:\/\/skillwisepro.com\/microsoft-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel Formulas<\/a><span style=\"font-weight: 400\">\u00a0provides numerous advantages that can significantly enhance personal and professional productivity and effectiveness.\u00a0<\/span><span style=\"font-weight: 400\">Here are key reasons for mastering Excel formulas and the various ways these formulas can be utilized to quickly and accurately do the task, such as:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><b>Improved Accuracy<\/b>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Accurate calculations<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ensures consistency in data processing<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><b>Enhanced Efficiency<\/b><span style=\"font-weight: 400\">:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Automates repetitive and time-consuming tasks.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Speeds up data processing and analysis.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><b>Advanced-Data Analysis<\/b><span style=\"font-weight: 400\">:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Facilitates complex data analysis with built-in statistical, financial, and logical functions.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><b>Better Data Management<\/b><span style=\"font-weight: 400\">:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Simplifies data organization, manipulation, and cleaning.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Facilitates data validation and ensures data integrity.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><b>Increased Productivity<\/b><span style=\"font-weight: 400\">:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Streamlines workflow processes.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Enables the creation of dynamic and interactive reports.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><b>Customization and Flexibility<\/b><span style=\"font-weight: 400\">:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Allows for the creation of tailored solutions specific to individual or organizational needs.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Adapts to various business functions such as finance, marketing, and operations.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3><b>Uses of Excel Formulas<\/b><\/h3>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Financial Modeling and Analysis<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Data Analysis and Reporting<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Project Management<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Database Management<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Statistical Analysis<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Sales and Marketing<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Operational Efficiency<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Human Resources<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Data Visualization<\/span><\/li>\n<li><span style=\"font-weight: 400\"> Automating Tasks with Macros<\/span><\/li>\n<\/ol>\n<h2>Top 25 Excel Formulas in 2024<\/h2>\n<p>Microsoft Excel provides a wide range of functions and formulas to perform calculations, manage large data, and analyze information. These functions and formulas form the foundation for performing a wide range of tasks in Excel to handle large volume of data.<\/p>\n<p>\u00a0<\/p>\n<p>There are many more specialized functions and formulas available depending on the specific requirements. This will help you to do complex tasks quickly and efficiently. You can use Microsoft Excel extensively in many organization for long accounting calculations, keeping records for vital information and data management.<\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">1. SUM Function: Top Excel Formulas in 2024<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The SUM function in Excel is used to add numbers. It&#8217;s one of the most commonly used function in Excel and can be applied in numerous ways. This is the most commonly used function in Excel. It allows you to find the total of a particular column or the selected range of cell values. Mathematically, it is calculated to find the total added value (addition).\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=SUM(num1,num2,&#8230;)<\/strong><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">It does the job that its name says it does. To add values, use the SUM() function. Insert a single value, a range of cells, or even both at once. So, it shows the &#8220;sum&#8221; of all the values in the chosen cells.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Example<\/p>\n<p><\/p>\n<p><\/p>\n<p>To find the total amount\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Under the Amount column for Fruit (cell B6), enter =SUM(B2:B5), or type =SUM(, then select that range with the mouse, and press Enter. This will sum the values in cells B2, B3, B4, and B5. Your answer should be 170.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/AxNPiu1eYt-Xw70BYYeUlgGZmBuRQjL1HtV4nqt7OBJF6AuSvTzLsVgJ2lyG3sXVXUSZ-gQtUg1joZzraVwXY8ZH60yle_jkKc29Z4yj7FWaPIRgnp0mpV6hRFVq3UzNfRFy6-2QZRP84gdO2f6rGnQ\" alt=\"Excel Formulae\" width=\"446\" height=\"267\" \/><\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">AUTOSUM\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<p>Now let&#8217;s try <strong>AutoSum<\/strong>. Select the yellow cell under the column for the Amount\u00a0 (cell B6), then go to <strong>Formulas<\/strong> &gt; <strong>AutoSum<\/strong> &gt; select <strong>SUM<\/strong>. You&#8217;ll see Excel automatically enter the formula for you. Press <strong>Enter<\/strong> to confirm it. The <strong>AutoSum<\/strong> feature has all of the most common functions.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/7T4wJu1fJBGnamCWv5CD7era4yETrZ1iyQfSYZdxYE0uwRc2K_TTYu2XiZYd4wLnQMCq3E9FkxvpnssiSGunevc2V_OjNDt9mV5CLF2-_cMo95Kb5N7DiibSHH6_1hhzAw86QrYcxx0kfNH6Kq1qxv8\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>A keyboard shortcut. Select cell B6, then press Alt and =\u00a0 then, <strong>Enter<\/strong>. This automatically enters <strong>SUM<\/strong> for you.<\/p>\n<p><span style=\"font-weight: 400\">Adding up the values you&#8217;ve chosen is what the popular and widely used Sum function does. To view the total, you can select the entire row and column or add up a specific portion. Counts of sales, invoices, and more can all benefit significantly from it.<\/span><\/p>\n<h3>Using the SUM Function with Conditions<\/h3>\n<p>Although the <code>SUM<\/code> function itself doesn\u2019t handle conditions directly, you can use it with other functions like <code>IF<\/code> or <code>SUMIF<\/code>.<\/p>\n<ul>\n<li>\n<p><strong>SUM with IF:<\/strong><\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(IF(A1:A5 &gt; 6, A1:A5))<br \/><\/code><\/div>\n<\/div>\n<p>This adds only the numbers in the range A1\u00a0that are greater than 6. (This is an array formula, so you must press <code>Ctrl + Shift + Enter<\/code> after typing it in.)<\/p>\n<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">2. AVERAGE Function: Basic Excel Formulas<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The <strong>AVERAGE<\/strong> function is used to get the average of numbers in a range of cells.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>Formula<\/strong> <strong>=AVERAGE(num1,num2,..)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Select cell B6, and enter an <strong>AVERAGE <\/strong>function by typing <strong>=AVERAGE(B2:B5).\u00a0<\/strong><\/p>\n<p>The <code>AVERAGE<\/code> function is very useful for quickly calculating the mean of a dataset in Excel.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/8GVn8s-o7H5IiBfmYZdxZFwnmm2CCVOQd5zpl7cEdNroeZA1Qh-lRx-6Uc0sQGNxPopRZLktD2YysLLQQpo5Jqe6-ecX3DGVLQ0aCmKU7vDkw9KI2GytKbpVpa2-ePFRR_l4JD5O9YFspYRQK4C6fb8\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">3. MAX and MIN Functions: Excel Formulas in 2024<\/h2>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p>The <strong>MAX <\/strong>function is used to get the largest number in a range of cells. <span style=\"font-weight: 400\">The most significant value of a given set of data can be obtained with this function. It reveals the data&#8217;s range. Pressing MAX on the function tab will display the maximum value in the specified data.<\/span><\/p>\n<p>\u00a0<\/p>\n<p>The <strong>MIN<\/strong> function is used to get the smallest number in a range of cells.\u00a0<span style=\"font-weight: 400\">In contrast to the max function, the MIN function allows you to find the smallest value inside the selected set of data. You will be notified of the lowest value of the primary data table.<\/span><\/p>\n<p>\u00a0<\/p>\n<p>Both MIN and MAX automatically ignore text, logical values, and empty cells in the ranges specified. These functions are\u00a0 quickly identifying extremes in your data, whether you&#8217;re looking for the smallest or largest values in a set.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/oGWSh2H4LpvsKPFQFNcATXb_ASEpHmlOCNOz-pAO8fLc5uVt7okeszdaQEwPNChr3WSwvMuQ9LTrd3d-WgAAbsR0mpq4c9DbGfQHqBz3YpTkwwrS9BbaWr5TJ5qRu6aSyodcE2kfxMRKc0RYuo1Nqsc\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/_aVuMYlYHRNKoZxNY7a7i1S8h1VaIRCtGextYfyHwVod0JY09jCOx72pXMvR8hyqZlKvESfxd2XHelEoa81RdHBXcVqCQXPjwbhoel1aJLkWXMs9aTXmWeUsWaXq7K4WDJ6efsQgwSf4vZnEKHxX-4w\" alt=\"Excel Formulae\" \/><\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">4. COUNT Function: Excel Formulas for Beginners<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The <strong>COUNT <\/strong>function allows you to find the total count of entries in the cells that contain numbers.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=COUNT (Value1,Value2&#8230;)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>Example\u00a0<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>To count the number of cells or array of numbers in B cell, select <strong>B14 <\/strong>and enter <strong>=COUNT(B1:B13). <\/strong>You can see the count of the cell which has a number alone taken.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>If you need to count the cells, which contain all the values like numbers, text, and any other data format, you can use <strong>COUNTA( )<\/strong> this does not include the blank cells.<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The COUNTA function, like several of the others mentioned above, is a simple yet helpful tool in Excel. All it does is count. In a given range, COUNTA will add up all the cells that are not empty. The cell&#8217;s contents are irrelevant to COUNTA; it will count both numbers and strings of letters and errors. <\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">However, you can use =COUNT IF you simply need to know how many cells contain numerical values. <\/span><span style=\"font-weight: 400\">Instead of arithmetically adding the values, the Count IF function counts. That is the sole difference between it and SUMIF. Once the specified criteria are satisfied, it will be considered valid.<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>COUNTBLANK( )<\/strong> to count the cells that are blank.\u00a0\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/2PbabJ-paosW_7wW33hEQVkXgrww9zUTtfFuZHL7SG3gJYqHZbS7jvzURszZp3Nu0ACfxFE7f888j4C7sE61zvkD1MjpA8XFv720M2TAtMG8h6g2JeuKyo0HOG-gsBCcjceq6aU2XpspF0JjHQJOSBw\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">5. IF statements: Excel Formulas for Working Professionals<\/h2>\n<p><\/p>\n<p><\/p>\n<p>IF statements let you make logical comparisons between conditions. It generally says that if one condition is true do something, otherwise do something else. The formulas, return text, values, or even more calculations.<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The IF function classified material as true or false based on specific criteria. An example of how to express a criteria function or variable might be:<\/span><\/p>\n<p><span style=\"font-weight: 400\">IF (Criteria, values for true and false)<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>For Example<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>In cell B2 enter <strong>=IF(A2=&#8221;Apple&#8221;, TRUE, FALSE)<\/strong>. The correct answer is <strong>TRUE<\/strong>.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/VJz-swU1Wy3fN9qghBTZPybPuaVoVXNRBecyRd0PBYF9ufIBpSI0mYyuuNtCvxoLxBt9sHLvTp92yi4lfwiWiDs5txGyYatGdYbZF0vuSCO1cYfrTzctNol73-FNQs5UtBa5Omr1v2a5vIZ4SjtHKl8\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>Apply the same formula to B3. The answer here should be <strong>FALSE<\/strong>\u00a0because orange is not an apple.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/RHWlB6YT6fpWKprvoZNhb8YeP7oPZmfTYRjWmjbjGZCkLIZCwiAXs9srcIeWvHc9Rhr0qiMSUEDLAq2i7COqKT-YNOVMMrQW2rsC_XG9jeRusCT8bBimi1Dngw3g8ALRE770WHsFv817j_oz4WKav_Q\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>Try another example by looking at the formula in cell E3. We got you started with <strong>=IF(D3&lt;100,&#8221;Less than 100&#8243;,&#8221;Greater than or equal to 100&#8243;)<\/strong>. What happens if you enter a number greater than or equal to 100 in cell D3?<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/GmyZORf2_3yQ9xxr04RWrioIpa948k-qwdKiwLWyGoiYGPzMX4mUnRCfPMRaqIDeKD_DXz65Y94fgvh_IxjivhbKEaVODh_v5gGlA69yUjcpsludJSdSyxHTzNJ7XZ41CeoARx3hC2SB1jODXaHEx7w\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>Note: <strong>TRUE<\/strong> and <strong>FALSE<\/strong> are different from other words in Excel formulas in that they don&#8217;t need to be in quotes, and Excel will automatically capitalize them. Numbers need not be in quotes either. Regular text, like <strong>Yes<\/strong> or <strong>No,<\/strong> should need to be in quotes like this:<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=IF(C3=&#8221;Apple&#8221;,&#8221;Yes&#8221;,&#8221;No&#8221;)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">6. SUMIF: Excel Conditional Functions<\/h2>\n<p><\/p>\n<p><\/p>\n<p>Conditional functions let you sum, average, count, or get the min or max of a range based on a given condition, or criteria you specify. Such as, out of all the fruits on the list, how many are apples? Or, how many oranges are the Florida type<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=SUMIF(range,criteria,[sum_range])<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>SUMIF<\/strong> lets you sum in one range based on specific criteria you look for in another range, like how many Oranges you have. Select cell E16 and type <strong>=SUMIF(D2:D13,D16,E2:E13)<\/strong>.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/COCfn6nQ4szTAYnpwHcuYCAO4QlQsMS4aklD6C95aHcT93yTx5AOblM6ETh7U2Q-ZqGybKCVZiSgTBuL4GDfGTgPCpl2uNZ7_Y7gStvzvZA1lMC_vQ2wC7mnXOPmdT3bGg-yX9UZ5hL1qEgc4cF6g2o\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p><strong>SUMIFS <\/strong>is the same as SUMIF, but it lets you use multiple criteria.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2\u2026..)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>So in this example, you can look for Fruit and Type, instead of just by Fruit. Select cell I16 and type <strong>=SUMIFS(I2:I13,G2:G13,I16,H2:H13,H16)<\/strong>.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/3fbQX7MUtK5CXpAgkF8vSI39_ZNUxIXQoYAtdXhQrbJDS81hcIb1OeOADQXqvRX1xP85yhEzB277Lf_zBXPiJwIHP1_y05CEyEYDKXr4MQBeG5NmlErBe1J133TE2A8eCVbZi71TQ_ZL9j-tvx3Pqh8\" alt=\"Excel Formulae\" \/><\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">7. COUNTIF: Basic Excel Conditional Functions<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The function <strong>COUNTIF <\/strong>is used when you are required to count cells with specified criteria.<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=COUNTIF(range,criteria)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>To count the cell that contains a specific fruit name like Banana, you need to select cell B17 and enter <strong>=COUNTIF(A1:A13,A17)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/4PR-KZ6OM49JKNDICo0_8Mjb4PbdnsWQp-JCoU6Kc8UbILsn-RvwPuaL7IgnU4Tmca1Wk_fADLspf85X0gkuyZ1HKY5ffOyyeSNBj5K6vUL-Td1dxayjn2E0L4NDUsAheIuPU0DBrfG1CygvRNczfBQ\" alt=\"Excel Formulae\" \/><\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">COUNTIFS\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<p><strong>COUNTIFS <\/strong>is the same as SUMIF, but it lets you use multiple criteria.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=COUNTIFS(criteria_range1,criteria1,..)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>So in this example, you can look for Fruit and Type, instead of just by Fruit. Select cell F17 and type <strong>=COUNTIFS(D2:D13,D17,E2:E13,E17)<\/strong>.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/Mf_GZpfn_9HlqhviipiFxK4FPYHeVLuhzOQLY8Uo16-fplT7_W6QkFjDjEWGJUEz9INdkS-Mew5OCnaBtScghxnyU_6B-7FXUDDquKiw1p7ZydrHKPxKk9Br-aWuj5s_MV5rHNCGdH3UfPdOkkKINSE\" alt=\"Excel Formulae\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">8. AVERAGEIF: Basic Excel Functions for Freshers<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The AVERAGEIF in Excel returns you the average value in a range with the specified criteria. The specified criteria can be numbers, strings, or references.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=AVERAGEIF(<\/strong><strong> (range, criteria, [average_range] )<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Example: The average price of the lemons is returned by entering <strong>=AVERAGEIF((A2:A13,A16,C2:C13)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/192UOuJsQqgA7dJ9yvZNgsQoe1eEm85r_8D3TM82UvT9GVXxVj7TOR_vaM45Ccel9nOi5q4vhldlVJtkeRF4FozbN1tTKI5MuqFWBIaNP8Q-51Efos7z_fEjFap8TrncUTfLo-Q7C83m8-vCJB0Ec4E\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>In the second example, we have got the average price of Fruits which is more than the cost of 20 by entering <strong>=AVERAGEIF(C2:C13,&#8221;&gt;20&#8243;)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/IonBgwyd0f7HxpwmL3ey_UTdw-4-dTS7lK0v-Q1oiFqAcGB-p9PGhoPmQpOQmBXH6PC2yBpif6Kh_PYlAln8RYjrJwmM4osmTSPCDeVLmWZL1TrbbAXQ44ru6sZOCWJp2LtFcE_FIxzllrM4YJMN0Es\" alt=\"\" \/><\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">9. TODAY Function: Excel Formulas and Function<\/h2>\n<p><\/p>\n<p><\/p>\n<p><strong>TODAY<\/strong> function gives you Today&#8217;s date. These are live functions, so whenever you open the workbook, it will have an updated date. Enter <strong>=TODAY() <\/strong>in the cell.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>Add Dates<\/strong> &#8211; Let&#8217;s say you want to know the bill due date, or when you need to return a book. You can add days to a date to find out. In cell B5, enter a random number of days. In cell B6, we added <strong>=B2+B5 <\/strong>to calculate the due date today.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/X4rxPMJJhGcqW-_TsnZGjrkbVib_m-KujpNgUd7AhxV204ig5ctKTrO1_KW_1FlsWgEZCMXUo1_1YVPTsXxJVdTeBi96g9FZkoYH8nUgIze5Mn6Ax30guzJkEK4K9a2I5LuX8XO3tNZOHMcTUYT_Ea4\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">10. Ceiling and Floor Functions: Top Excel Functions<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The Excel CEILING function rounds up to the nearest given multiple numbers. Use <strong>CEILING(number)<\/strong> always to ROUND UP the value\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>In the below sheet, we have used CEILING to round up the rate (number) to the multiple of 5 (significance). In cell B2 enter <strong>=CEILING(A2,5)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/GW__c9TdqhD2sPzNnuYk-4YXJ_uqdrX6IJlCCUFGAJlPeKpgRiF2kawN8RSDlNPMesOKXkHMV1MgcFNL6fFfWUsTpC5Yde5CWRpCdWho-jz4YxHVG2p19-CC5CFUj7nbTzsgf1tYJ0EmgwPSmNxc_Hk\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">FLOOR Function<\/h3>\n<p><\/p>\n<p><\/p>\n<p>Excel FLOOR function is the same but rounds down to the nearest given multiples. The <strong>FLOOR()<\/strong> is always used to ROUND DOWN the value\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>In the below sheet, we have used FLOOR to round down the rate (number) to the nearest multiple of 5 (significance). In cell B2 enter <strong>=FLOOR(A2,5)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/7EB23Jj7ekgnLoXONCr8R_IC75MOt9qeUd0ZUjqQHtDCjFUHU92r8Er2pt9PY_-9O-zG3iHxnEwzfXbB2Dc1rb5IiOTXy4IR1maEdFYOzGmWtXEb4xCWGPXNFeCCCHybMUvCLMOVuq4mF8nYWiLCJXM\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">11. VLOOKUP: Top Excel Formula for Spreadsheet<\/h2>\n<p><\/p>\n<p><\/p>\n<p>VLOOKUP is the most famous and widely used function, it is the Vertical Lookup in Excel. As the name suggests it is the Excel function that helps to look up specified values vertically. It helps you look up for value in the left column and then returns information in another column to the right if it finds a match.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=VLOOKUP (lookup_value,tabe_array,col_index_num,[range_lookup]<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>In cell B7, enter <strong>=VLOOKUP(A7,A2:B5,2,FALSE). <\/strong>The correct answer for Apples is 50. VLOOKUP looked for Apples, found them, then went over one column to the right, and returned the amount.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/9sEQRom_RKWuLDjuZsqUGGx7E5GSPLK18-_pA1vbk7kDHj4i78_CCAjmARs97fhiI2g_o3hPXKbElNKnFkkh1OqyaHCxQ3kZhiXCaGQ6w6_9pAiCc0f4EUawAOUnicOxS9lrcOeYWWrPALNqminy4Eo\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>VLOOKUP Formula structured as\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>A7 &#8211; What do you want to look for?<\/li>\n<li><strong>A2:B5 &#8211; <\/strong>Where do you want to look for it?<\/li>\n<li>2 &#8211; If you find it, how many columns to the right do you want to get a value?<\/li>\n<li>FALSE &#8211; Do you want an exact, or\u00a0<\/li>\n<li>TRUE &#8211;\u00a0 in case of an approximate match?<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<p>If VLOOKUP returns an error (<strong>#N\/A<\/strong>) then it means that the searched value does not exist in the sheet.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">12. CONCATENATE: Excel Functions for Text<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The word CONCATENATE means to combine. This Excel function simply means to combine different texts from different cells into one cell. The user can do this in two ways either using the build Excel function or the formula.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">Concatenate isn&#8217;t a function; it&#8217;s just a fun method to mix data from different cells to make your worksheets more interactive. When doing financial modelling, it is an effective tool for analysts. Accordingly, the Concatenate function is among the most valuable advanced Excel formulas according to economic analysts.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">This technique can condense many text strings onto a single line in your datasheet. Is it possible that we are unaware of the variety of available models? In such cases, the UNIQUE function comes in handy. As a result, it compiles a catalogue of every value present in the dataset. You may also use it to create a list of unique values.<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=CONCATENATE(TEXT1,TEXT2,..)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>Example\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=A1&amp;B1 <\/strong>gives the same results as<strong>\u00a0<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=CONCATENATE(A1,B1)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/QoGOhNvRJdtz3Sr43a5NP9rtJUXjFPVsfh1InyUJ6lp1PPPt_SMwIBwe9s5iOopUr2bRhDAaxlZBwzkNsBP0Wz6-flKClc03DX9e2CKli_iZ5oCDG78bOJACx5_zKjb_cDsvX3YMKR9BQur_CghN8k4\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/DjZ2QovLAbRKupMAA6rQz_zWmSRyBB8WOVAuqrZL4Fcrrzr66j-SpM3Npc87UrPkgq0_cb9ZitnJ0725GN5OmFUKlFo5O4fb_HkBahfgf5ifzZuSLJZs7GaRV5aiCyKCxvDC8rgz8QtaXJINwkj1-R0\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">13. LEFT, MID, RIGHT: Best Excel Functions for Students<\/h2>\n<p><span style=\"font-weight: 400\">To find out how many characters are left at the beginning of a text string, use the LEFT() method. Meanwhile, you can get the characters in the middle of a text string using the MID() function. It takes input from a starting position and length. Last, the right() function finds out how many characters remain in a text string.\u00a0\u00a0<\/span><\/p>\n<p>\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>LEFT function &#8211;\u00a0 To extract the given number of characters from the left of the text.<\/p>\n<p><span style=\"font-weight: 400\">With this function, you can copy and paste the data from the left side of the specified column into another column. Additionally, you may use instructions to indicate the desired amount of data for the new column.<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Formula &#8211; <strong>=LEFT(text, num_charc)<\/strong><\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/_hHU0FHYxFoPAcK-L00A3wctlnUbHn-RfoC1BOHkqDEbmHk89YZad9kNiW0nGVmtkS3yW3mmPeMroksoB4YhAPhqUnJc92zjCCegF0PMl1dIWIBCbRuz89wUNc7YQXIiGQYUNHooeQ_Sk6wRHmcTvVc\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>MID function &#8211; To extract from the middle of the characters in the text, with the given starting position and the number of characters\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Formula <strong>=MID(text,start_num,num_charc)<\/strong><\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/mMVkSKaOUHd5-Jo0xBIF0DsVQJaF4hu6qs3id0-xowc_wvar67Vn24UUWePz3r78nh2pvC6JnRuGtN0ea2v2NP6Hka0eSjMv1MspIZLSKRPmezaUKPAyRzKDcY7vokkGYAA2w8LjF3FvhEGBjUoKTU8\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>RIGHT function &#8211; To extract the given number of characters from the right of the text\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Formula <strong>=RIGHT(text,num_charc)<\/strong><\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/lgt4fTcj5X8prIsJdzBpRox4CjqEKWheBlrof97HkXXA1caIbSvLJGb380uIZyrG4OhzmzxiOQi85c1YnkpwtIfckEQ800woYQnLY758ATq2wZA0hBuWbW9Dl4szObhvzDv16st3k2gjkYhbjE7SOiw\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">14. <strong>NOW: Time Excel Function\u00a0<\/strong><\/h2>\n<p><\/p>\n<p><\/p>\n<p>Excel can give you the current time, based on your computer&#8217;s regional settings. You can also add and subtract times. For instance, you might need to keep track of how many hours an employee worked each week and calculate their pay and overtime.<\/p>\n<p><\/p>\n<p><\/p>\n<p>enter <strong>=NOW()<\/strong>, which will give the current time, and will update each time Excel calculates. If you need to change the Time format, you can go to <strong>Ctrl+1<\/strong> &gt; <strong>Number<\/strong> &gt; <strong>Time <\/strong>&gt; Select the format you want.<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/czZ8IxhsRaIOXz1SZ5Rpyldlrq3j6KGzY-9k8tzDMMeb3596YC9cnmTnMlc5wbsQ_5rx4Mjonzsxf_oDh_kDE_x8O2i0GGa0y1avoDIWJeQ0KpkIXCw4sXv9cYfuApGKLL43RNDxeErE9zuF01af518\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">15. TRIM Function: Top Functions for Spreadsheet<\/h2>\n<p><\/p>\n<p><\/p>\n<p>When you receive a worksheet with irregular spaces and the user wants to organize it, then Excel has a great function TRIM that cuts out the unwanted spaces in the cell.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Enter <strong>=TRIM(text) <\/strong>to remove the unwanted spaces in the cell<\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/5ygkgi6PtHQRNXa2kGhFaGjWxtsAGbRCOJ9DcD8tWw0PqN-tTUNZq0QQq0sGbJ6FquCOml5laG_JMTFRwZrdiMyJ8zhentw1glqp_t_DtkEsvOLi1UyPLnJ7zDVxNzH8zePVg7zyCWckI83zjYJuYz8\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">16. UPPER, LOWER, PROPER: Excel Function for Text<\/h2>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>UPPER function &#8211; To convert the texts to uppercase. <strong>=UPPER()<\/strong><\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/aIOBGirUBxCKhtQPtGWQFJhfecFcci5AjuiuJtRNGHbZ4m-egDMkYmSZrd-QIaCgxShMO88Q1IRdo9XsK20khLKsu9sXuADy9awm0TSvuIwrD6HGMSMn10SpupdGY0P1oJ1yy64MU5nzVtl6CtycdKc\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>LOWER function &#8211; To convert the texts to lowercase. <strong>=LOWER()<\/strong><\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/5-rtUuYOJo1wZwkHWuiLxl-uarejIT8xhZchgeCnUJV0TtwDGXzFyHUN15aN-_Fv9oPQoH0FFrOYdvp4kqckUCmOAylhL3Xygg2jbTS3T5B_Y5fMQso8y7OblTfBl4Ad8RKe50U9Fn0cEa6KwCg6Qro\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>PROPER function &#8211; To convert all the improper texts into the correct format\u00a0<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/WLESe_TwPNWQLlRBjsSqRdb8C61b8n-BNKhhpw6jnWbmr3YMCvBsTJIkOwSaUEZ4YG_0U6W03ZkiaOs6fpy5aDpiTbWBSRGj1XsdpNVxs3hUOILRLQzWFnaCJMWcYQUtLDokpaZvK2HGOPZkDpt_XUM\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">17. HLOOKUP: Excel Function for Spreadsheet<\/h2>\n<p><\/p>\n<p><\/p>\n<p>HLOOKUP does the exact same function as VLOOKUP but instead searches for a certain value in the rows in the Excel sheet, whereas VLOOKUP searches the column.<\/p>\n<p><\/p>\n<p><\/p>\n<p>Example: Enter <strong>=HLOOKUP<\/strong><strong>(lookup_value, table_array, row_index_num, [range_lookup])<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/Uv5j1nzHAW3Z0XQy9HJDtr7eZnUGJL1NZbcgR22DnzzVe54G-nO8G6niZCnk3cPtpmhTsIMB31IR63ncXFvXKOaVGDUVbEzqC-GOJqNXH7cBYUTquY5WO2WcW2FoOPWjsoTlk3xQK7Eu6NB77akqh98\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Lookup value &#8211; Apples\u00a0<\/li>\n<li>Table array &#8211; the table in which the data is looked up\u00a0<\/li>\n<li>Row index num &#8211; the row number in the table array from which the matching value is returned\u00a0<\/li>\n<li>Range lookup &#8211; Exact match or approximate match\u00a0<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">18. INDEX and MATCH: Excel INDEX function<\/h2>\n<p><\/p>\n<p><\/p>\n<p>INDEX and MATCH are the most popular tools in Excel for carrying out more advanced lookups. This is because INDEX and MATCH are extremely flexible \u2013 you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. If you want to enhance your Excel skills, INDEX and MATCH are musts.<\/p>\n<p>\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>The Excel INDEX function returns the value of a given location in a range or array. You can use INDEX to retrieve individual values, or entire rows and columns. However, the MATCH function is often used together with INDEX to provide row and column numbers.<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula\u00a0 <strong>=INDEX (array, row_num, [col_num])<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>For example &#8211; in the below list to retrieve data from the required row and column enter <strong>=INDEX(A25:C36,3,3)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/xJPvDVVqaSXm_XfcL0GYN98l1BVoXWe6WWwcEMbx2gluHs-okMcH2Oq79h137fr0gQrkJlWV16HBh_TVp-wxJ1n11CiL1fcy__exkySldLRWDaIq8GazyECGxiWyK75JBWWoNhq8NFA3syIp4NN5Rm4\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">MATCH\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<p>This Excel function retrieves the location of the specified value from the row, column, and table in the spreadsheet.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula &#8211; <strong>=MATCH (lookup_value, lookup_array, [match_type])<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>In the below example we are looking for the position of Kiwi, so enter <strong>=MATCH(&#8220;Kiwi&#8221;,A44:A51,0)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/14jPsdAA6N4FD0aGbsIPtSOx6EEqVkMgvaxbAgEYLXO3w7O0oF3sLOCqN2maSJXMuoRcV2Q1mTKdEHx5npprR7cZxFGpQwfyIn4K9yhraZBjncWpbPqvhMN__omHU7eh4vtpH65S5cDIAzpG93-uoAI\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>Note: Match type\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>1 &#8211; return the approximate lookup value \/ Less than the value<\/li>\n<li>0 &#8211; Exact lookup value\u00a0<\/li>\n<li>-1 &#8211;\u00a0 More than the lookup value\u00a0<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/4NAV4dGH6H5AZ4oLQ8p1BImJjtgb1t0j889idWNeOoRapkYgj61bZJEiiW8nnuyi62dfP5hWHak2I_yKGUjDsgZnCEaarGNrbvMAVcvQvC8GxUTP55FUFr_oZv8qovdYDeGU5iayDSC5MkikP0fwKr4\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>To sum up, the INDEX returns the value of the given position whereas MATCH returns the position of the lookup value.<\/p>\n<p><\/p>\n<p><\/p>\n<p>The user can combine both INDEX and MATCH functions,\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>To look at the value of Grapes in the month of Feb, enter <strong>=INDEX(B56:D63,MATCH(&#8220;Grapes&#8221;,A56:A63,0),2)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/3Av405wsaWhI_9YI99j6y-hgkJ1EUcr56NG8NSStLPXPqxhAfIpx1beE4lRCyqRQv89bt9sNsZKBpD4NMfQf9XzWnvpy0rjYa2tsk62mr8qmLmqcMiNIYWK_3tVfREjX_uOxIXIQ-SIPXp4O1YE--5Y\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">19. INT: Excel Functions for Numbers<\/h2>\n<p><\/p>\n<p><\/p>\n<p>In Excel, the INT function is used to remove the decimal from the numbers. This just eliminates the decimals and doesn&#8217;t round up or round down to the nearest value. But in case the cell has a negative value then INT acts differently by rounding up\/ down\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=INT(Num)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/Yjf2w0qgOBcZXPb41Z9HNJ_zSK2R7TuoObyNmYCrk3f9_xBI8n9uZFPA-jOA5kNVdMqZEth9UkurtD3X2XMwAuCv-SfPk_Ohwbh2hGdJKJiYXPFx0ddxV9rcyPxstKC0UhavjgGpejd3Y4-RsdG82iA\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">20. TRUNC: Top Excel Functions for Numbers<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The TRUNC function in Excel is the same as INT but this removes the decimal be it any value entered in the cell.<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=TRUNC(number,[num_digits])<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/GGmfaEfj-bx5A3ySmzG97MMo_IcAj5oPhQ3QP3_KAqhOOAmaAwCVOJKnwMjlQc9qtrSA82OatnZAnCn4QO-vfr-m0jrEOaWTqPF8pWKutrT1VJJAAagYJiQr_H3QgORfaU1NLWLePk58wOY0uPFkbtU\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">21. MOD: Basic Excel Formulas for Division<\/h2>\n<p><\/p>\n<p><\/p>\n<p>This Excel function is used in two ways. First, used when you want to extract the decimal part of the value. Second to get the remainder after the division\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula <strong>=MOD(number, division)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/h4ejZMg_vEivsCf-OE6nt8t0sPMe3KSoXLxkEcxU5Mt1owIAxIjIjiU9DBcNY6FcKXs0sOu76yAzg3xyuRmkLV_sDxzDEtS68ick2CayL1NX4TC16OGGGG4PHt0Gt4MG4d_V0B72O-zoKEjCZqXl1Ug\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/ALUq4FaOoXWtYHrP9JLt8HXrq3gw7bEG6cYCa2IJATZi9i3k9EI7PvrRpMolkGc8pQBdRw9trDgZ1S2GBdHwpwXBSxF-TuFGk3ASbS-gMxuL89wzOKbZW-CwnIgA8oK5cyOP5bOIG6FzUd-1GQMyYy0\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">22. TRANSPOSE: Basic Excel Formulas<\/h2>\n<p><\/p>\n<p><\/p>\n<p>This Excel function can be used to transpose your data from Horizontal to vertical or vice versa.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>As it is an array formula user needs to CTRL+SHIFT+ENTER the formula to get the results.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>In the below sheet, the horizontal data has been converted vertically using <strong>=TRANSPOSE(array)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Select the exact space to convert the value\u00a0<\/li>\n<li>Enter the formula\u00a0<\/li>\n<li>Press CTRL+SHIFT+ENTER<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/IXQodOBXfEOh88zVIM9Zj9B0AaoQKeqR61DCUxol09jQ89f4kbeju9N5ORMqJyUCnK9KkF6S15yuLn-5Jyx2S21zwauiUS87-cPlC-AtsahxcoA1m04NCsCOODLUt0F7kd-WCQeP2MDopD2FdqorraA\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">23. REPLACE: Excel Formulas for Replacement<\/h2>\n<p><\/p>\n<p><\/p>\n<p>This Excel function is used when the user wants to replace a certain specified text or number with a different value or to remove it. The user needs to give the exact location and the new value to get the result\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p>Formula: <strong>=REPLACE(old_text, start_num, num_chars, new_text)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<p>We have two examples- To Remove certain text enter <strong>=REPLACE(A98,1,2,&#8221;&#8221;)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/zeMq2N09fOwzwAr6p-54SthN7Ujp1d4Qye4-ZydBtRtCu_a3Eo2E73uGsd_c9Z35irc-aLzqNQ3zA3RKy3Qfwb8lpY2dqTe77ADfHmJEqjbAhg9vxieaJwZFogNXSXGRcHTvHEdGS2-exmq3VbxTOIQ\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<p>To replace a value enter <strong>=REPLACE(A103,1,2,91)<\/strong><\/p>\n<p><\/p>\n<p><\/p>\n<div>\n<figure><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/4renkMuIrCto1_56Akc3eB-ehaMaUACmovFOHoA74ovFRODKsu4KtmhpsXsZA_WbVDHlSzW-TAYlURB1lTaVnF93efECt1p2GhkeQvhRDscC-76iEJfXW27bM2chXfD-2pPZS9eCqiN-BdahAUvfA-Y\" alt=\"\" \/>\n<p>\u00a0<\/p>\n\n<\/figure>\n<\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">24. RAND and RAND BETWEEN: Basic Excel functions in 2024<\/h2>\n<p><\/p>\n<p><\/p>\n<p>The RAND Excel function retrieves a random number every time an Excel sheet is opened or calculated.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=RAND() <\/strong>returns a value &gt;= to 0 and &lt; 1<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=RAND()*100<\/strong> returns a number &gt;=0 less than 100<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=INT(RAND()*100)<\/strong> returns a random whole number &gt;=0 and less than 100<\/p>\n<p><\/p>\n<p><\/p>\n<p><strong>=RANDBETWEEN(top, bottom) <\/strong>returns a random number within the specified limit\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">25. ROW, ROWS, COLUMN, COLUMNS: Basic Formula of Excel<\/h2>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>ROW &#8211; To get the ROW number of any cell<\/li>\n<li>ROWS &#8211; To get the count of the selected array of ROWS<\/li>\n<li>COLUMN &#8211; To get the COLUMN number of the given cell<\/li>\n<li>COLUMNS &#8211; To get the count of the selected array of COLUMNS<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<p>In today&#8217;s business world, there is a large use of Microsoft Excel. And it is necessary for everyone to learn the basic formula of Excel, which benefits you in so many ways. There is a high demand for Excel skill sets as it is required by vast industries and companies.<\/p>\n<p><\/p>\n<p><\/p>\n<p>If you want to enhance your skills with <a href=\"https:\/\/www.henryharvin.com\/advanced-excel-course\">Advanced Excel<\/a> knowledge you may check out the course offered.<\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">Henry Harvin: No.1 MS Excel Learning Option<\/h2>\n<p><span style=\"font-weight: 400\">The Henry Harvin Institute is well-known and respected as the best destination for education and training. Students in Henry Harvin&#8217;s Advanced Excel Course can work on eleven or more projects while learning a great deal about advanced formulae, data analysis, visualization, dashboards, pivot tables, etc.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The institute also offers online courses; students can enroll in weekend batches. The course&#8217;s most appealing feature is its comprehensive one-year curriculum of brush-up sessions designed to keep students abreast of any changes to Excel&#8217;s core functionality.\u00a0<\/span><span style=\"font-weight: 400\">They have strong ties to prominent corporations and IIMs. Using international examples and case studies in every elegance, the institute fosters attractive mastering surroundings that focus on practical know-how.<\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400\">The education is engaging and applicable to the desires of the enterprise due to the notably qualified running shoes who have labored within the discipline. Taking an Advanced Excel course with Henry Harvin will put you on the course to becoming a Certified Advanced Excel Practitioner. This globally acknowledged certificate will add credibility to your resume.<\/span><\/p>\n<p>\u00a0<\/p>\n<h3>Advantages of Henry Harvin&#8217;s Advanced Excel Training Program<\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Top-Rated Excel Course According to BestcourseNews.com<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Excel instructors who have earned a certification and have extensive experience teaching Excel<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">The chance to work on ten or more projects and practical experience with Excel tools<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Guidance with job hunting and interview techniques<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Twelve months of online instruction and review<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Standards for worldwide acceptance inform curriculum development.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Accreditation upon course completion from CAEP<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Henry Harvin is a reputable school because of its extensive training partnerships with prominent corporations, such as Avon Cosmetics, Abbott Pharma, Deloitte, and twelve or more IIMs.\u00a0<\/span><span style=\"font-weight: 400\">Access to the learning management system (LMS), practice exams, a chance to connect with professionals in the field, and assistance finding a job are all benefits of gold membership.<\/span><\/p>\n<p><span style=\"font-weight: 400\">This course lasts a whole year and consists of 24 hours of live, interactive classroom instruction and 24 hours of review. Students are free to attend as many batches as they want beginning on the day they enroll, and there are no additional fees after that.\u00a0<\/span><a href=\"https:\/\/www.henryharvin.com\/\">Henry Harvin<\/a> offers an Advanced Excel Course and it is ranked No. 1 in India. They have trained more than 6000 participants.\u00a0<\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">Features of Henry Harvin&#8217;s Course\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Get trained by the experts with Multi-Domain exposure. The trainers are certified Excel trainers.<\/li>\n<li>Complete guidance and support throughout the course<\/li>\n<li>Gain proficiency in data management and data analysis<\/li>\n<li>Practical Excel training and application across different industries<\/li>\n<li>The program includes 11 projects from various domains such as finance, marketing, engineering, etc<\/li>\n<li>Gain practical Knowledge of Excel Training Tools<\/li>\n<li>Job assistance to all participants\u00a0<\/li>\n<li>Globally accepted program with Advanced training certification\u00a0<\/li>\n<li>Golden Membership that includes\n<ul>\n<li>Lifetime Membership of Henry Harvin Accounts Academy for Advanced Excel Certification course.<\/li>\n<li>Monthly Bootcamp Sessions \u00a0<\/li>\n<li>Access to all the recorded sessions\u00a0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">Learning Benefits\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Study the tools of Advanced Excel to generate powerful business solutions<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Learn to create a macro in MS Excel<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Learn the importance of the functions in Excel and how it help to simplify the process<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Gain knowledge on creating Excel templates, tables and charts, financial statements, and many more<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>With the Advanced Excel Certification course learn to gather, structure, and present impressive datasets<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Learn to combine the worksheets and workbooks with various features available in Excel<\/li>\n<\/ul>\n<p><\/p>\n<p><\/p>\n<h3 class=\"wp-block-heading\">Course Details\u00a0<\/h3>\n<p><\/p>\n<p><\/p>\n<ul class=\"wp-block-list\">\n<li>Duration &#8211; 24 hours of live interactive sessions\u00a0<\/li>\n<li>Fees &#8211; INR 7500 with EMI INR 833\/ month<\/li>\n<\/ul>\n<div><strong>Also, Check Media Link &#8211;<\/strong> <a href=\"https:\/\/magazines.insightssuccess.in\/The-30-Most-Admired-Companies-In-2021-September2021\/?fbclid=IwAR1WR_wfZhxB6ydrD1dvTwjikSPms8P8J5GhY7cLjeEFxX_56lLPFMHG0bI#page=4\">Insight Success\u00a0<\/a><\/div>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n<p><\/p>\n<p><\/p>\n<p><span style=\"font-weight: 400\">In enterprise, Microsoft Excel is an absolute must-have. The suitable information is that it should not be that intimidating. Learn to paint with it, and you will see a dramatic growth in your output! More than just a set of functions, these advanced Excel formulas with examples can help you simplify data, improve your analytical abilities, and change how you approach work problems.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Acquiring proficiency in these fundamental Excel formulas unveils a priceless resource for every working professional. From financial modelling to dynamic data visualization, these algorithms enable users to transform raw data into valuable insights. Improving one&#8217;s Excel skills via practice makes one more efficient at their job and sets them up for success in a corporate environment. You can enhance your capacity to make educated decisions and advance your career by adding these formulas to your Excel toolbox.<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\">FAQ&#8217;s<\/h2>\n<h4>Q1.What is a Microsoft Excel Course?<\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Excel is a strong spreadsheet program, and a vast array of subjects are covered in Microsoft Excel classes. This course includes data input and formatting, fundamental formulae and functions, and data visualisation using charts and graphs.<\/span><\/p>\n<h4><strong>Q2.Would Excel be beneficial for employment?<\/strong><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Having proficiency with Excel is still a great way to boost your employment opportunities in many different fields. Excel is a powerful tool that professionals use for complex tasks, such as financial forecasting and strategic planning. It&#8217;s more than just a data entry tool.<\/span><\/p>\n<h4><strong>Q3. Can MS Excel be quickly learned?<\/strong><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans. <\/strong>Excel simplifies working with numbers and provides tools for data analysis, such as pivot tables and charts.<\/span><\/p>\n<h4><strong>Q4. Who requires Excel?<\/strong><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong>\u00a0Here is a rundown of some common occupations that include Excel:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Administrative assistant.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Human resources (HR) administrator.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Market researcher.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Marketing officer.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Accountant.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Fleet manager.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Financial analyst.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Cost estimator.<\/span><\/li>\n<\/ul>\n<h4>Q5. Is there still a need for Excel?<\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Skills in Excel are nevertheless tremendously famous in today&#8217;s work marketplace, no matter the industry. Excel proficiency is needed for many work obligations, including data analysts, accountants, monetary analysts, and venture managers.<\/span><\/p>\n<h4>Q6. What are employers looking for in Excel skills?<\/h4>\n<p><strong>Ans.<\/strong> The employers seek the basic skills in excel like the commonly used formulas SUMIF, COUNTIF, AVERAGE, VLOOKUP, and keyboard shortcut keys.<\/p>\n<h4>Q7. Is there a demand for an Excel expert?<\/h4>\n<p><strong>Ans.<\/strong> There is a huge demand for working professionals with Advanced MS Excel skills as the application is widely used across various industries.<\/p>\n<h4>Q8. How do I get Excel certified?<\/h4>\n<p><strong>Ans.<\/strong> You can take the MOS Excel Examination. The minimum passing score is 700 to be certified.<\/p>\n<h4>Q9. What is a high-demand Excel skill?<\/h4>\n<p><strong>Ans.<\/strong> The most demanded Excel skills are VLOOKUP, INDEX, MATCH, MACROS and VBA, and PIVOT table.<\/p>\n<h4>Q10. Is Excel a good tool for learning financial modeling?<\/h4>\n<p><b>Ans. <\/b><span style=\"font-weight: 400\">Yes. Excel is used to create financial models that help with business forecasting and trends. If you&#8217;re interested in learning financial modeling, your Excel skills will come in handy.<\/span><\/p>\n<h4>Q11. How can I use VLOOKUP in Excel?<\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.\u00a0<\/span><\/p>\n<h4>Q12. What is the difference between VLOOKUP and HLOOKUP?<\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> VLOOKUP searches for a value in the first column of a table, while HLOOKUP searches for a value in the first row.<\/span><\/p>\n<h4><b>Q13. How do I use the INDEX and MATCH functions together?<\/b><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> INDEX returns the value of a cell in a table based on the row and column number, while MATCH provides the position of a value in a range. Combined, they can perform lookups.<\/span><\/p>\n<h4><b>Q14. How can I make a formula update automatically?<\/b><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Excel formulas update automatically when referenced data changes. Ensure calculation options are set to automatic under Formulas &gt; Calculation Options.<\/span><\/p>\n<h4><b>Q15. How do I copy a formula down a column?<\/b><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Drag the fill handle (a small square at the bottom-right corner of the cell) down the column, or double-click it to fill it down automatically.<\/span><\/p>\n<h4><b>Q16. How can I prevent errors in my formulas?<\/b><\/h4>\n<p><span style=\"font-weight: 400\"><strong>Ans.<\/strong> Use error-checking functions like IFERROR or ISERROR to handle potential errors. <\/span><\/p>\n<p><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Nowadays in every organization, there is a large volume of vital data or information that needs to be processed smoothly&#8230;<\/p>\n","protected":false},"author":861,"featured_media":99685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","two_page_speed":[],"footnotes":""},"categories":[18424],"tags":[],"class_list":["post-98717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Top 25 Excel Formulas 2026<\/title>\n<meta name=\"description\" content=\"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.\" \/>\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.henryharvin.com\/blog\/excel-formulae-you-should-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 25 Excel Formulas 2026\" \/>\n<meta property=\"og:description\" content=\"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/\" \/>\n<meta property=\"og:site_name\" content=\"Henry Harvin Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-17T15:29:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-31T09:13:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"1067\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Hema Priya\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:site\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hema Priya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"27 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/\"},\"author\":{\"name\":\"Hema Priya\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/b2695fa1611273ae2052337e9e6f1fd5\"},\"headline\":\"Top 25 Excel Formulas you should know in 2026\",\"datePublished\":\"2023-05-17T15:29:00+00:00\",\"dateModified\":\"2025-12-31T09:13:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/\"},\"wordCount\":6084,\"commentCount\":34,\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/19085016\\\/56.jpg\",\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/\",\"name\":\"Top 25 Excel Formulas 2026\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/19085016\\\/56.jpg\",\"datePublished\":\"2023-05-17T15:29:00+00:00\",\"dateModified\":\"2025-12-31T09:13:06+00:00\",\"description\":\"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/19085016\\\/56.jpg\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/19085016\\\/56.jpg\",\"width\":1600,\"height\":1067},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/excel-formulae-you-should-know\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/category\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Top 25 Excel Formulas you should know in 2026\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\",\"name\":\"Henry Harvin Blog\",\"description\":\"Latest Online Courses &amp; Certification Blogs\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\",\"name\":\"George L V\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"width\":445,\"height\":130,\"caption\":\"George L V\"},\"logo\":{\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\"},\"description\":\"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content.\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/b2695fa1611273ae2052337e9e6f1fd5\",\"name\":\"Hema Priya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/17112758\\\/k5g4et-150x150.jpg\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/17112758\\\/k5g4et-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/17112758\\\/k5g4et-150x150.jpg\",\"caption\":\"Hema Priya\"},\"description\":\"Banker turned to a Blogger\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/author\\\/sahe-hemsgmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Top 25 Excel Formulas 2026","description":"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.","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.henryharvin.com\/blog\/excel-formulae-you-should-know\/","og_locale":"en_US","og_type":"article","og_title":"Top 25 Excel Formulas 2026","og_description":"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.","og_url":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/","og_site_name":"Henry Harvin Blog","article_published_time":"2023-05-17T15:29:00+00:00","article_modified_time":"2025-12-31T09:13:06+00:00","og_image":[{"width":1600,"height":1067,"url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg","type":"image\/jpeg"}],"author":"Hema Priya","twitter_card":"summary_large_image","twitter_creator":"@henryharvin_in","twitter_site":"@henryharvin_in","twitter_misc":{"Written by":"Hema Priya","Est. reading time":"27 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#article","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/"},"author":{"name":"Hema Priya","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/b2695fa1611273ae2052337e9e6f1fd5"},"headline":"Top 25 Excel Formulas you should know in 2026","datePublished":"2023-05-17T15:29:00+00:00","dateModified":"2025-12-31T09:13:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/"},"wordCount":6084,"commentCount":34,"publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg","articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/","url":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/","name":"Top 25 Excel Formulas 2026","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#primaryimage"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg","datePublished":"2023-05-17T15:29:00+00:00","dateModified":"2025-12-31T09:13:06+00:00","description":"Top 25 Excel Formulas and Functions in 2026. Boost your Excel skills to do complex calculations of large data with accuracy.","breadcrumb":{"@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#primaryimage","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/08\/19085016\/56.jpg","width":1600,"height":1067},{"@type":"BreadcrumbList","@id":"https:\/\/www.henryharvin.com\/blog\/excel-formulae-you-should-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.henryharvin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/www.henryharvin.com\/blog\/category\/excel\/"},{"@type":"ListItem","position":3,"name":"Top 25 Excel Formulas you should know in 2026"}]},{"@type":"WebSite","@id":"https:\/\/www.henryharvin.com\/blog\/#website","url":"https:\/\/www.henryharvin.com\/blog\/","name":"Henry Harvin Blog","description":"Latest Online Courses &amp; Certification Blogs","publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.henryharvin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094","name":"George L V","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","width":445,"height":130,"caption":"George L V"},"logo":{"@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png"},"description":"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content."},{"@type":"Person","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/b2695fa1611273ae2052337e9e6f1fd5","name":"Hema Priya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/07\/17112758\/k5g4et-150x150.jpg","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/07\/17112758\/k5g4et-150x150.jpg","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2022\/07\/17112758\/k5g4et-150x150.jpg","caption":"Hema Priya"},"description":"Banker turned to a Blogger","url":"https:\/\/www.henryharvin.com\/blog\/author\/sahe-hemsgmail-com\/"}]}},"views":19430,"_links":{"self":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/98717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/users\/861"}],"replies":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/comments?post=98717"}],"version-history":[{"count":1,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/98717\/revisions"}],"predecessor-version":[{"id":769649,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/98717\/revisions\/769649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media\/99685"}],"wp:attachment":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media?parent=98717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/categories?post=98717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/tags?post=98717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}