{"id":25579993,"date":"2024-03-28T02:14:00","date_gmt":"2024-03-27T20:44:00","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25579993"},"modified":"2025-08-06T15:50:57","modified_gmt":"2025-08-06T10:20:57","slug":"excel-tips-and-tricks-every-quantity-surveyor-should-know","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/","title":{"rendered":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69ea10ebc6fa1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69ea10ebc6fa1\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#Excel_Tips_and_Tricks_Every_Quantity_Surveyor_Should_Know\" >Excel Tips and Tricks Every Quantity Surveyor Should Know<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#Why_Excel_is_Crucial_for_Quantity_Surveyors\" >Why Excel is Crucial for Quantity Surveyors<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#Final_Thoughts\" >Final Thoughts<\/a><\/li><\/ul><\/nav><\/div>\n<div data-breakout=\"normal\">\n<div class=\"hsg-featured-snippet\">\n<div class=\"hsg-featured-snippet__wrapper\">\n<div class=\"hsg-featured-snippet__wrapper--content\" data-type=\"paragraph\">\n<p data-start=\"438\" data-end=\"718\">Microsoft Excel is one of the <strong data-start=\"468\" data-end=\"492\">most essential tools<\/strong> in a Quantity Surveyor\u2019s toolkit. While specialised software like <strong data-start=\"559\" data-end=\"589\">CostX, PlanSwift, or Candy<\/strong> has its place, <strong data-start=\"608\" data-end=\"644\">Excel remains the go\u2011to platform<\/strong> for cost estimation, budgeting, BoQ preparation, and project reporting.<\/p>\n<p data-start=\"720\" data-end=\"897\">In this detailed guide, we\u2019ll explore <strong data-start=\"758\" data-end=\"806\">practical Excel tips, formulas, and features<\/strong> that can help Quantity Surveyors work smarter, reduce errors, and save hours every week.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/quantity-surveying-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Quantity Surveyor online certification course on Entri app! Join Now!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Tips_and_Tricks_Every_Quantity_Surveyor_Should_Know\"><\/span><strong>Excel Tips and Tricks Every Quantity Surveyor Should Know<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-25619971 aligncenter\" src=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know.webp\" alt=\"Excel Tips and Tricks Every Quantity Surveyor Should Know\" width=\"614\" height=\"403\" srcset=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know.webp 999w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know-300x197.webp 300w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know-768x504.webp 768w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know-150x98.webp 150w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks-Every-Quantity-Surveyor-Should-Know-750x492.webp 750w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p id=\"viewer-4a4dd\" class=\"H0BMW qw9d2 _5TXqj t077n _39sR0\">As a quantity surveyor, you are often expected to work with large amounts of data and perform complex calculations. Excel can be a powerful tool to help you manage data and streamline calculations, but it&#8217;s essential to know tips and tricks that can make your life easier and save time. In this blog we will cover some basic Excel tips and tricks that every quantity surveyor must know.<\/p>\n<\/div>\n<div data-breakout=\"normal\">\n<div>\n<h3 id=\"viewer-am0ft\" class=\"H0BMW qw9d2 _5TXqj t077n _39sR0\"><strong><span class=\"GkipB\">1.Keyboard Shortcuts<\/span><\/strong><\/h3>\n<\/div>\n<\/div>\n<div data-hook=\"rcv-block4\">Excel has a large number of keyboard shortcuts that can help you navigate the application more efficiently. Most useful shortcuts include:<\/div>\n<div data-hook=\"rcv-block4\">\n<h4 id=\"workbook_shortcut_keys\"><strong>Workbook Shortcut Keys<\/strong><\/h4>\n<p>In this section, we will understand the basics of working with a workbook. We&#8217;ll learn how to create a new workbook, open an existing workbook, and save a spreadsheet so you don&#8217;t lose any data or calculations you&#8217;ve done. Then we&#8217;ll walk through how you can switch between several different sheets in a workbook.<\/p>\n<table width=\"616\">\n<tbody>\n<tr>\n<td>Description<\/td>\n<td width=\"258\">Excel Shortcuts<\/td>\n<\/tr>\n<tr>\n<td>1. To create a new workbook<\/td>\n<td width=\"258\">Ctrl + N<\/td>\n<\/tr>\n<tr>\n<td>2. To open an existing workbook<\/td>\n<td width=\"258\">Ctrl + O<\/td>\n<\/tr>\n<tr>\n<td>3. To save a workbook\/spreadsheet<\/td>\n<td width=\"258\">Ctrl + S<\/td>\n<\/tr>\n<tr>\n<td>4. To close the current workbook<\/td>\n<td width=\"258\">Ctrl + W<\/td>\n<\/tr>\n<tr>\n<td>5. To close Excel<\/td>\n<td width=\"258\">Ctrl + F4<\/td>\n<\/tr>\n<tr>\n<td>6. To move to the next sheet<\/td>\n<td width=\"258\">Ctrl + PageDown<\/td>\n<\/tr>\n<tr>\n<td>7. To move to the previous sheet<\/td>\n<td width=\"258\">Ctrl + PageUp<\/td>\n<\/tr>\n<tr>\n<td>8. To go to the Data tab<\/td>\n<td width=\"258\">Alt + A<\/td>\n<\/tr>\n<tr>\n<td>9. To go to the View tab<\/td>\n<td width=\"258\">Alt + W<\/td>\n<\/tr>\n<tr>\n<td>10. To go the Formula tab<\/td>\n<td width=\"258\">Alt + M<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>These were Excel keyboard shortcuts to help you navigate your spreadsheet. After creating the workbook, the next key step is to format the cells.<\/p>\n<h4><strong>Cell Formatting Shortcut Keys<\/strong><\/h4>\n<p>A cell in Excel contains all the data you work with. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell content, adding a border to a cell, adding an outline to all selected cells, and many more. Here is a small preview of these Excel shortcuts.<\/p>\n<table width=\"616\">\n<tbody>\n<tr>\n<td>Description<\/td>\n<td width=\"258\">Excel Shortcuts<\/td>\n<\/tr>\n<tr>\n<td>11. To edit a cell<\/td>\n<td width=\"258\">F2<\/td>\n<\/tr>\n<tr>\n<td>12. To copy and paste cells<\/td>\n<td width=\"258\">Ctrl + C, Ctrl + V<\/td>\n<\/tr>\n<tr>\n<td>13. To italicize and make the font bold<\/td>\n<td width=\"258\">Ctrl + I, Ctrl + B<\/td>\n<\/tr>\n<tr>\n<td>14. To center align cell contents<\/td>\n<td width=\"258\">Alt + H + A + C<\/td>\n<\/tr>\n<tr>\n<td>15. To fill color<\/td>\n<td width=\"258\">Alt + H + H<\/td>\n<\/tr>\n<tr>\n<td>16. To add a border<\/td>\n<td width=\"258\">Alt + H + B<\/td>\n<\/tr>\n<tr>\n<td>17. To remove outline border<\/td>\n<td width=\"258\">Ctrl + Shift + _<\/td>\n<\/tr>\n<tr>\n<td>18. To add an outline to the select cells<\/td>\n<td width=\"258\">Ctrl + Shift + &amp;<\/td>\n<\/tr>\n<tr>\n<td>19. To move to the next cell<\/td>\n<td width=\"258\">Tab<\/td>\n<\/tr>\n<tr>\n<td>20. To move to the previous cell<\/td>\n<td width=\"258\">Shift + Tab<\/td>\n<\/tr>\n<tr>\n<td>21. To select all the cells on the right<\/td>\n<td width=\"258\">Ctrl + Shift + Right arrow<\/td>\n<\/tr>\n<tr>\n<td>22. To select all the cells on the left<\/td>\n<td width=\"258\">Ctrl + Shift + Left Arrow<\/td>\n<\/tr>\n<tr>\n<td>23. To select the column from the selected cell to the end of the table<\/td>\n<td width=\"258\">Ctrl + Shift + Down Arrow<\/td>\n<\/tr>\n<tr>\n<td>24. To select all the cells above the selected cell<\/td>\n<td width=\"258\">Ctrl + Shift + Up Arrow<\/td>\n<\/tr>\n<tr>\n<td>25. To select all the cells below the selected cell<\/td>\n<td width=\"258\">Ctrl + Shift + Down Arrow<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>In addition to the above cell formatting shortcuts, let&#8217;s look at some additional and advanced Excel cell formatting shortcuts that might come in handy.<\/p>\n<p>We will learn how to add a comment to a cell. Comments are useful for providing additional information about the contents of a cell. We will also learn how to find a value and replace it with another value in a table. Then we&#8217;ll see how to insert the current time, the current date, activate a filter, and add a hyperlink to a cell. Finally, we&#8217;ll see how to apply a format to the data in a cell.<\/p>\n<table width=\"616\">\n<tbody>\n<tr>\n<td>Description<\/td>\n<td width=\"258\">Excel Shortcuts<\/td>\n<\/tr>\n<tr>\n<td>26. To add a comment to a cell<\/td>\n<td width=\"258\">Shift + F2<\/td>\n<\/tr>\n<tr>\n<td>27. To delete a cell comment<\/td>\n<td width=\"258\">Shift + F10 + D<\/td>\n<\/tr>\n<tr>\n<td>28. To display find and replace<\/td>\n<td width=\"258\">Ctrl + H<\/td>\n<\/tr>\n<tr>\n<td>29. To activate the filter<\/td>\n<td width=\"258\">Ctrl + Shift + L<\/p>\n<p>Alt + Down Arrow<\/td>\n<\/tr>\n<tr>\n<td>30. To insert the current date<\/td>\n<td width=\"258\">Ctrl + ;<\/td>\n<\/tr>\n<tr>\n<td>31. To insert current time<\/td>\n<td width=\"258\">Ctrl + Shift + :<\/td>\n<\/tr>\n<tr>\n<td>32. To insert a hyperlink<\/td>\n<td width=\"258\">Ctrl + k<\/td>\n<\/tr>\n<tr>\n<td>33. To apply the currency format<\/td>\n<td width=\"258\">Ctrl + Shift + $<\/td>\n<\/tr>\n<tr>\n<td>34. To apply the percent format<\/td>\n<td width=\"258\">Ctrl + Shift + %<\/td>\n<\/tr>\n<tr>\n<td>35. To go to the \u201cTell me what you want to do\u201d box<\/td>\n<td width=\"258\">Alt + Q<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After working with Excel&#8217;s cell formatting shortcuts, the next step is to understand how to work with an entire row\/column in Excel.<\/p>\n<h4><strong>Row and Column Formatting Shortcut Keys<\/strong><\/h4>\n<p>In this section, we&#8217;ll look at some critical keyboard shortcuts for formatting rows and columns.<\/p>\n<p>We will understand how to delete rows and columns, hide and show selected rows and columns, and group and ungroup rows and columns.<\/p>\n<table width=\"616\">\n<tbody>\n<tr>\n<td>Description<\/td>\n<td width=\"258\">Excel Shortcuts<\/td>\n<\/tr>\n<tr>\n<td>36. To select the entire row<\/td>\n<td width=\"258\">Shift + Space<\/td>\n<\/tr>\n<tr>\n<td>37. To select the entire column<\/td>\n<td width=\"258\">Ctrl + Space<\/td>\n<\/tr>\n<tr>\n<td>38. To delete a column<\/td>\n<td width=\"258\">Alt+H+D+C<\/td>\n<\/tr>\n<tr>\n<td>39. To delete a row<\/td>\n<td width=\"258\">Shift + Space, Ctrl + &#8211;<\/td>\n<\/tr>\n<tr>\n<td>40. To hide selected row<\/td>\n<td width=\"258\">Ctrl + 9<\/td>\n<\/tr>\n<tr>\n<td>41. To unhide selected row<\/td>\n<td width=\"258\">Ctrl + Shift + 9<\/td>\n<\/tr>\n<tr>\n<td>42. To hide a selected column<\/td>\n<td width=\"258\">Ctrl + 0<\/td>\n<\/tr>\n<tr>\n<td>43. To unhide a selected column<\/td>\n<td width=\"258\">Ctrl + Shift + 0<\/td>\n<\/tr>\n<tr>\n<td>44. To group rows or columns<\/td>\n<td width=\"258\">Alt + Shift + Right arrow<\/td>\n<\/tr>\n<tr>\n<td>45. To ungroup rows or columns<\/td>\n<td width=\"258\">Alt + Shift + Left arrow<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now that we&#8217;ve looked at the different keyboard shortcuts for formatting cells, rows, and columns, it&#8217;s time to jump into understanding an advanced topic in Excel, working with pivot tables. Let&#8217;s look at different shortcuts for summarizing data using a pivot table.<\/p>\n<h4><strong>Pivot Table Shortcut Keys<\/strong><\/h4>\n<p>First, create a pivot table using the sales dataset.<\/p>\n<p>In the image below, you can see that we have a pivot table that summarizes the total sales for each product subcategory within each category.<\/p>\n<table width=\"616\">\n<tbody>\n<tr>\n<td>46. To group pivot table items<\/td>\n<td width=\"258\">Alt + Shift + Right arrow<\/td>\n<\/tr>\n<tr>\n<td>47. To ungroup pivot table items<\/td>\n<td width=\"258\">Alt + Shift + Left arrow<\/td>\n<\/tr>\n<tr>\n<td>48. To hide pivot table items<\/td>\n<td width=\"258\">Ctrl + &#8211;<\/td>\n<\/tr>\n<tr>\n<td>49. To create a pivot chart on the same sheet<\/td>\n<td width=\"258\">Alt + F1<\/td>\n<\/tr>\n<tr>\n<td>50. To create a pivot chart on a new worksheet<\/td>\n<td width=\"258\">F11<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Use these keyboard shortcuts to perform common tasks faster and more efficiently, freeing up time for more important tasks.<\/p>\n<\/div>\n<h3 data-hook=\"rcv-block7\"><strong>2.Conditional Formatting<\/strong><\/h3>\n<div data-hook=\"rcv-block8\">Conditional formatting allows you to highlight cells in a certain range based on specific conditions. For example, you can highlight cells with a certain value or cells that are above or below a certain value. It&#8217;s a powerful tool that helps you quickly identify important data in your spreadsheets. To apply conditional formatting, select the cells you want to format and go to Home &gt; Conditional Formatting &gt; Cell Highlight Rules. Here you can choose the conditions you want to use.<\/div>\n<div data-hook=\"rcv-block8\"><strong>for example :<\/strong><\/div>\n<div data-hook=\"rcv-block8\">\n<p>Highlight cells using conditional formatting<\/p>\n<p>Let&#8217;s start by highlighting the cells that have a value greater than 350. Do the following:<\/p>\n<ul>\n<li>Select the range of cells you want to apply the highlight to.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25580008 aligncenter\" src=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1-300x97.jpg\" alt=\"\" width=\"637\" height=\"206\" srcset=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1-300x97.jpg 300w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1-768x248.jpg 768w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1-150x48.jpg 150w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1-750x242.jpg 750w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/step1.jpg 828w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/p>\n<\/div>\n<div data-breakout=\"normal\">\n<div>\n<h3 id=\"viewer-d8uqq\" class=\"H0BMW qw9d2 _5TXqj t077n _39sR0\"><strong><span class=\"GkipB\">3.Using Formulas<\/span><\/strong><\/h3>\n<\/div>\n<\/div>\n<div data-hook=\"rcv-block10\">Excel is a powerful calculation tool and the use of formulas is a key aspect of its functionality. Some of the most useful formulas for quantity surveyors include:<\/div>\n<div style=\"text-align: left;\" data-hook=\"rcv-block10\">\n<div class=\"hsg-featured-snippet\">\n<ol>\n<li>SUM<\/li>\n<li>IF<\/li>\n<li>Percentage<\/li>\n<li>Subtraction<\/li>\n<li>Multiplication<\/li>\n<li>Division<\/li>\n<li>DATE<\/li>\n<li>Array<\/li>\n<li>COUNT<\/li>\n<li>AVERAGE<\/li>\n<li>SUMIF<\/li>\n<li>TRIM<\/li>\n<li>LEFT, MID, and RIGHT<\/li>\n<li>VLOOKUP<\/li>\n<li>RANDOMIZE<\/li>\n<\/ol>\n<\/div>\n<p>To help you use Excel more effectively (and save a ton of time), we&#8217;ve compiled a list of essential formulas, keyboard shortcuts, and other small tricks and functions you should know.<\/p>\n<h4><strong> SUM\u00a0\u00a0<\/strong><\/h4>\n<p>All Excel formulas begin with the equals sign, =, followed by a specific text tag denoting the formula you&#8217;d like Excel to perform.<\/p>\n<p>The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find the sum (or total) of two or more values.\u00a0To perform the SUM formula, enter the values you&#8217;d like to add together using the format,\u00a0<strong>=SUM(value 1, value 2, etc)<\/strong>.<\/p>\n<p>The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet.<\/p>\n<ul>\n<li>To find the SUM of 30 and 80, for example, type the following formula into a cell of your spreadsheet:\u00a0<strong>=SUM(30, 80)<\/strong>. Press &#8220;Enter,&#8221; and the cell will produce the total of both numbers: 110.<\/li>\n<li>To find the SUM of the values in cells B2 and B11, for example, type the following formula into a cell of your spreadsheet:\u00a0<strong>=SUM(B2, B11)<\/strong>. Press &#8220;Enter,&#8221; and the cell will produce the total of the numbers currently filled in cells B2 and B11. If there are no numbers in either cell, the formula will return 0.<\/li>\n<\/ul>\n<p>Keep in mind you can also find the total value of a\u00a0<em>list<\/em>\u00a0of numbers in Excel. To find the SUM of the values in cells B2\u00a0<em>through<\/em>\u00a0B11, type the following formula into a cell of your spreadsheet:\u00a0<strong>=SUM(B2:B11)<\/strong>. Note the colon between both cells, rather than a comma. See how this might look in an Excel spreadsheet for a content marketer, below:<\/p>\n<p><img decoding=\"async\" class=\"sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=294&amp;name=sum-formula-excel.jpg\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=147&amp;name=sum-formula-excel.jpg 147w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=294&amp;name=sum-formula-excel.jpg 294w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=441&amp;name=sum-formula-excel.jpg 441w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=588&amp;name=sum-formula-excel.jpg 588w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=735&amp;name=sum-formula-excel.jpg 735w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-excel.jpg?width=882&amp;name=sum-formula-excel.jpg 882w\" alt=\"sum-formula-excel\" width=\"294\" \/><\/p>\n<h4><strong>\u00a0IF<\/strong><\/h4>\n<p>The IF formula in Excel is denoted\u00a0<strong>=IF(logical_test, value_if_true, value_if_false)<\/strong>. This allows you to enter a text value into the cell &#8220;if&#8221; something else in your spreadsheet is true or false. For example, =IF(D2=&#8221;Gryffindor&#8221;,&#8221;10&#8243;,&#8221;0&#8243;) would award 10 points to cell D2 if that cell contained the word &#8220;Gryffindor.&#8221;<\/p>\n<p>There are times when we want to know how many times a value appears in our spreadsheets. But there are also those times when we want to find the cells that contain those values, and input specific data next to it.<\/p>\n<p>We&#8217;ll go back to Sprung&#8217;s example for this one. If we want to award 10 points to everyone who belongs in the Gryffindor house, instead of manually typing in 10&#8217;s next to each Gryffindor student&#8217;s name, we&#8217;ll use the IF-THEN formula to say:\u00a0<em>If\u00a0<\/em>the student is in Gryffindor,\u00a0<em>then\u00a0<\/em>he or she should get ten points.<\/p>\n<ul>\n<li>The formula:\u00a0<strong>IF(logical_test, value_if_true, value_if_false)<\/strong>\n<ul>\n<li><strong>Logical_Test:\u00a0<\/strong>The logical test is the &#8220;IF&#8221; part of the statement. In this case, the logic is D2=&#8221;Gryffindor.&#8221; Make sure your Logical_Test value is in quotation marks.<\/li>\n<li><strong>Value_if_True:\u00a0<\/strong>If the value is true that is, if the student lives in Gryffindor &#8212; this value is the one that we want to be displayed. In this case, we want it to be the number 10, to indicate that the student was awarded the 10 points. Note: Only use quotation marks if you want the result to be text instead of a number.<\/li>\n<li><strong>Value_if_False:\u00a0<\/strong>If the value is false and the student does <em>not<\/em> live in Gryffindor we want the cell to show &#8220;0,&#8221; for 0 points.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/quantity-surveying-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Quantity Surveyor online certification course on Entri app! Join Now!<\/strong><\/a><\/p>\n<h4>\u00a0<strong>Percentage<\/strong><\/h4>\n<p>To perform the percentage formula in Excel, enter the cells you&#8217;re finding a percentage for in the format,\u00a0<strong>=A1\/B1<\/strong>. To convert the resulting decimal value to a percentage, highlight the cell, click the Home tab, and select &#8220;Percentage&#8221; from the numbers dropdown.<\/p>\n<div id=\"hs_cos_wrapper_widget_27268fa7-42a7-4a11-b559-8059db0a0b74\" class=\"hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module\" data-hs-cos-general-type=\"widget\" data-hs-cos-type=\"module\">\n<div class=\"blog-post-full-width-cta\" data-form-state=\"disabled\">There isn&#8217;t an Excel &#8220;formula&#8221; for percentages per se, but Excel makes it easy to convert the value of any cell into a percentage so you&#8217;re not stuck calculating and reentering the numbers yourself.<\/div>\n<\/div>\n<p>The basic setting to convert a cell&#8217;s value into a percentage is under Excel&#8217;s\u00a0Home tab. Select this tab, highlight the cell(s) you&#8217;d like to convert to a percentage, and click into the dropdown menu next to Conditional Formatting (this menu button might say &#8220;General&#8221; at first). Then, select\u00a0&#8220;Percentage&#8221;\u00a0from the list of options that appears. This will convert the value of each cell you&#8217;ve highlighted into a percentage. See this feature below.<\/p>\n<p><img decoding=\"async\" class=\"sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=650&amp;name=percentage-formula-in-excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=325&amp;name=percentage-formula-in-excel.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=650&amp;name=percentage-formula-in-excel.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=975&amp;name=percentage-formula-in-excel.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=1300&amp;name=percentage-formula-in-excel.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=1625&amp;name=percentage-formula-in-excel.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/percentage-formula-in-excel.png?width=1950&amp;name=percentage-formula-in-excel.png 1950w\" alt=\"percentage-formula-in-excel\" width=\"650\" \/><\/p>\n<p>Keep in mind if you&#8217;re using other formulas, such as the division formula (denoted\u00a0<strong>=A1\/B1<\/strong>), to return new values, your values might show up as decimals by default. Simply highlight your cells before or after you perform this formula, and set these cells&#8217; format to &#8220;Percentage&#8221; from the Home tab , as shown above.<\/p>\n<h4><strong>Subtraction<\/strong><\/h4>\n<p>To perform the subtraction formula in Excel, enter the cells you&#8217;re subtracting in the format,\u00a0<strong>=SUM(A1, -B1)<\/strong>. This will subtract a cell using the SUM formula by adding a negative sign before the cell you&#8217;re subtracting. For example, if A1 was 10 and B1 was 6, =SUM(A1, -B1) would perform 10 + -6, returning a value of 4.<\/p>\n<p>Like percentages, subtracting doesn&#8217;t have its own formula in Excel either, but that doesn&#8217;t mean it can&#8217;t be done. You can subtract any values (or those values inside cells) two different ways.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hubfs\/subtraction-formula-excel.png\" alt=\"Subtraction formula in Excel\" \/><\/p>\n<ul>\n<li><strong>Using the =SUM formula.<\/strong>\u00a0To subtract multiple values from one another, enter the cells you&#8217;d like to subtract in the format =SUM(A1, -B1), with a negative sign (denoted with a hyphen) before the cell whose value you&#8217;re subtracting. Press enter to return the difference between both cells included in the parentheses. See how this looks in the screenshot above.<\/li>\n<li><strong>Using the format, =A1-B1<\/strong>. To subtract multiple values from one another, simply type an equals sign followed by your first value or cell, a hyphen, and the value or cell you&#8217;re subtracting. Press Enter to return the difference between both values.<\/li>\n<\/ul>\n<h4><strong> Multiplication<\/strong><\/h4>\n<p>To perform the multiplication formula in Excel, enter the cells you&#8217;re multiplying in the format,\u00a0<strong>=A1*B1<\/strong>. This formula uses an asterisk to multiply cell A1 by cell B1. For example, if A1 was 10 and B1 was 6, =A1*B1 would return a value of 60.<\/p>\n<p>You might think multiplying values in Excel has its own formula or uses the &#8220;x&#8221; character to denote multiplication between multiple values. Actually, it&#8217;s as easy as an asterisk &#8211; *.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=566&amp;name=multiplication-formula-in-excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=283&amp;name=multiplication-formula-in-excel.png 283w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=566&amp;name=multiplication-formula-in-excel.png 566w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=849&amp;name=multiplication-formula-in-excel.png 849w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=1132&amp;name=multiplication-formula-in-excel.png 1132w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=1415&amp;name=multiplication-formula-in-excel.png 1415w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/multiplication-formula-in-excel.png?width=1698&amp;name=multiplication-formula-in-excel.png 1698w\" alt=\"multiplication-formula-in-excel\" width=\"566\" \/><\/p>\n<p>To multiply two or more values in an Excel spreadsheet, highlight an empty cell. Then, enter the values or cells you want to multiply together in the format,\u00a0<strong>=A1*B1*C1<\/strong>\u00a0&#8230; etc. The asterisk will effectively multiply each value included in the formula.<\/p>\n<p>Press Enter to return your desired product. See how this looks in the screenshot above.<\/p>\n<h4><strong> Division<\/strong><\/h4>\n<p>To perform the division formula in Excel, enter the cells you&#8217;re dividing in the format,\u00a0<strong>=A1\/B1<\/strong>. This formula uses a forward slash, &#8220;\/,&#8221; to divide cell A1 by cell B1. For example, if A1 was 5 and B1 was 10, =A1\/B1 would return a decimal value of 0.5.<\/p>\n<p>Division in Excel is one of the simplest functions you can perform. To do so, highlight an empty cell, enter an equals sign, &#8220;=,&#8221; and follow it up with the two (or more) values you&#8217;d like to divide with a forward slash, &#8220;\/,&#8221; in between. The result should be in the following format:\u00a0<strong>=B2\/A2<\/strong>, as shown in the screenshot below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=450&amp;name=excel-division-formula.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=225&amp;name=excel-division-formula.png 225w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=450&amp;name=excel-division-formula.png 450w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=675&amp;name=excel-division-formula.png 675w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=900&amp;name=excel-division-formula.png 900w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=1125&amp;name=excel-division-formula.png 1125w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-division-formula.png?width=1350&amp;name=excel-division-formula.png 1350w\" alt=\"excel-division-formula\" width=\"450\" \/><\/p>\n<p>Hit Enter, and your desired quotient should appear in the cell you initially highlighted.<\/p>\n<h4><strong>DATE<\/strong><\/h4>\n<p>The Excel DATE formula is denoted\u00a0<strong>=DATE(year, month, day)<\/strong>. This formula will return a date that corresponds to the values entered in the parentheses ,even values referred from other cells. For example, if A1 was 2018, B1 was 7, and C1 was 11, =DATE(A1,B1,C1) would return 7\/11\/2018.<\/p>\n<p>Creating dates in the cells of an Excel spreadsheet can be a fickle task every now and then. Luckily, there&#8217;s a handy formula to make formatting your dates easy. There are two ways to use this formula:<\/p>\n<ul>\n<li><strong>Create dates from a series of cell values.<\/strong>\u00a0To do this, highlight an empty cell, enter &#8220;=DATE,&#8221; and in parentheses, enter the cells whose values create your desired date &#8212; starting with the year, then the month number, then the day. The final format should look like this: =DATE(year, month, day). See how this looks in the screenshot below.<\/li>\n<li><strong>Automatically set today&#8217;s date.<\/strong>\u00a0To do this, highlight an empty cell and enter the following string of text:\u00a0=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())).\u00a0Pressing enter will return the current date you&#8217;re working in your Excel spreadsheet.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=650&amp;name=7.%20DATE.jpg\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=325&amp;name=7.%20DATE.jpg 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=650&amp;name=7.%20DATE.jpg 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=975&amp;name=7.%20DATE.jpg 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=1300&amp;name=7.%20DATE.jpg 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=1625&amp;name=7.%20DATE.jpg 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/7.%20DATE.jpg?width=1950&amp;name=7.%20DATE.jpg 1950w\" alt=\"excel date formula\" width=\"650\" \/><\/p>\n<p>In either usage of Excel&#8217;s date formula, your returned date should be in the form of\u00a0<strong>&#8220;mm\/dd\/yy&#8221; <\/strong>,unless your Excel program is formatted differently.<\/p>\n<h4><strong> Array<\/strong><\/h4>\n<p>An array formula in Excel surrounds a simple formula in brace characters using the format,\u00a0<strong>{=(Start Value 1:End Value 1)*(Start Value 2:End Value 2)}<\/strong>. By pressing Ctrl+Shift+Center, this will calculate and return value from multiple ranges, rather than just individual cells added to or multiplied by one another.<\/p>\n<p>Calculating the sum, product, or quotient of individual cells is easy ,just use the =SUM formula and enter the cells, values, or range of cells you want to perform that arithmetic on. But what about multiple ranges? How do you find the combined value of a large group of cells?<\/p>\n<div id=\"hs_cos_wrapper_widget_1019a940-acef-408f-9345-fe2a55928c5c\" class=\"hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module\" data-hs-cos-general-type=\"widget\" data-hs-cos-type=\"module\">\n<div class=\"blog-post-full-width-cta\" data-form-state=\"disabled\">Numerical arrays are a useful way to perform more than one formula at the same time in a single cell so you can see one final sum, difference, product, or quotient. If you&#8217;re looking to find total sales revenue from several sold units, for example, the array formula in Excel is perfect for you. Here&#8217;s how you&#8217;d do it:<\/div>\n<\/div>\n<ol>\n<li>To start using the array formula, type &#8220;=SUM,&#8221; and in parentheses, enter the\u00a0<em>first<\/em>\u00a0of two (or three, or four) ranges of cells you&#8217;d like to multiply together. Here&#8217;s what your progress might look like:\u00a0<strong>=SUM(C2:C5<\/strong><\/li>\n<li>Next, add an asterisk after the last cell of the first range you included in your formula. This stands for multiplication. Following this asterisk, enter your second range of cells. You&#8217;ll be multiplying this second range of cells by the first. Your progress in this formula should now look like this:\u00a0<strong>=SUM(C2:C5*D2:D5)<\/strong><\/li>\n<li>Ready to press Enter? Not so fast &#8230; Because this formula is so complicated, Excel reserves a different keyboard command for arrays. Once you&#8217;ve closed the parentheses on your array formula, press\u00a0<strong>C<\/strong><strong>trl+Shift+Enter<\/strong>.\u00a0This will recognize your formula as an array, wrapping your formula in brace characters and successfully returning your product of both ranges combined.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=650&amp;name=excel-array-formula.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=325&amp;name=excel-array-formula.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=650&amp;name=excel-array-formula.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=975&amp;name=excel-array-formula.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=1300&amp;name=excel-array-formula.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=1625&amp;name=excel-array-formula.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/excel-array-formula.png?width=1950&amp;name=excel-array-formula.png 1950w\" alt=\"Excel array formula\" width=\"650\" \/><\/p>\n<p>In revenue calculations, this can cut down on your time and effort significantly. See the final formula in the screenshot above.<\/p>\n<h4><strong> COUNT<\/strong><\/h4>\n<p>The COUNT formula in Excel is denoted\u00a0<strong>=COUNT(Start Cell:End Cell)<\/strong>. This formula will return a value that is equal to the number of entries found within your desired range of cells. For example, if there are eight cells with entered values between A1 and A10, =COUNT(A1:A10) will return a value of 8.<\/p>\n<p>The COUNT formula in Excel is particularly useful for\u00a0<em>large<\/em>\u00a0spreadsheets, wherein you want to see how many cells contain actual entries. Don&#8217;t be fooled:\u00a0<strong>This formula won&#8217;t do any math on the values of the cells themselves.<\/strong>\u00a0This formula is simply to find out how many cells in a selected range are occupied with something.<\/p>\n<p>Using the formula in bold above, you can easily run a count of active cells in your spreadsheet. The result will look a little something like this:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=350&amp;name=count-formula-in-excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=175&amp;name=count-formula-in-excel.png 175w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=350&amp;name=count-formula-in-excel.png 350w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=525&amp;name=count-formula-in-excel.png 525w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=700&amp;name=count-formula-in-excel.png 700w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=875&amp;name=count-formula-in-excel.png 875w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/count-formula-in-excel.png?width=1050&amp;name=count-formula-in-excel.png 1050w\" alt=\"count-formula-in-excel\" width=\"350\" \/><\/p>\n<h4><strong>AVERAGE<\/strong><\/h4>\n<p>To perform the average formula in Excel, enter the values, cells, or range of cells of which you&#8217;re calculating the average in the format,\u00a0<strong>=AVERAGE(number1, number2, etc.)<\/strong>\u00a0or =AVERAGE(Start Value:End Value). This will calculate the average of all the values or range of cells included in the parentheses.<\/p>\n<p>Finding the average of a range of cells in Excel keeps you from having to find individual sums and then performing a separate division equation on your total. Using\u00a0<strong>=AVERAGE<\/strong>\u00a0as your initial text entry, you can let Excel do all the work for you.<\/p>\n<p>For reference, the average of a group of numbers is equal to the sum of those numbers, divided by the number of items in that group.<\/p>\n<h4><strong> SUMIF<\/strong><\/h4>\n<p>The SUMIF formula in Excel is denoted\u00a0<strong>=SUMIF(range, criteria, [sum range])<\/strong>. This will return the sum of the values within a desired range of cells that all meet one criterion. For example, =SUMIF(C3:C12,&#8221;&gt;70,000&#8243;) would return the sum of values between cells C3 and C12 from only the cells that are greater than 70,000.<\/p>\n<p>Let&#8217;s say you want to determine the profit you generated from a list of leads who are associated with specific area codes, or calculate the sum of certain employees&#8217; salaries &#8212; but only if they fall above a particular amount. Doing that manually sounds a bit time-consuming, to say the least.<\/p>\n<p>With the SUMIF function, you can easily add up the sum of cells that meet certain criteria, like in the salary example above.<\/p>\n<ul>\n<li><strong>The formula<\/strong>:\u00a0<strong>=<strong class=\"ocpLegacyBold\">SUMIF(range, criteria, [sum_range])<\/strong><\/strong>\n<ul>\n<li><strong>Range:\u00a0<\/strong>The range that is being tested using your criteria.<\/li>\n<li><strong>Criteria:\u00a0<\/strong>The criteria that determine which cells in Criteria_range1 will be added together<\/li>\n<li><strong>[Sum_range]:<\/strong>\u00a0An\u00a0optional range of cells you&#8217;re going to add up in addition to the first\u00a0<strong>Range\u00a0<\/strong>entered. This field may be omitted.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>In the example below, we wanted to calculate the sum of the salaries that were greater than $70,000. The SUMIF function added up the dollar amounts that exceeded that number in the cells C3 through C12, with the formula\u00a0<strong>=SUMIF(C3:C12,&#8221;&gt;70,000&#8243;)<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignCenter shadow aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=650&amp;name=SUMIF.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=325&amp;name=SUMIF.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=650&amp;name=SUMIF.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=975&amp;name=SUMIF.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=1300&amp;name=SUMIF.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=1625&amp;name=SUMIF.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/SUMIF.png?width=1950&amp;name=SUMIF.png 1950w\" alt=\"SUMIF formula in Excel\" width=\"650\" data-constrained=\"true\" \/><\/p>\n<h4><strong>TRIM<\/strong><\/h4>\n<p>The TRIM formula in Excel is denoted\u00a0<strong>=TRIM(text)<\/strong>. This formula will remove any spaces entered before and after the text entered in the cell. For example, if A2 includes the name &#8221; Steve Peterson&#8221; with unwanted spaces before the first name, =TRIM(A2) would return &#8220;Steve Peterson&#8221; with no spaces in a new cell.<\/p>\n<p>Email and file sharing are wonderful tools in today&#8217;s workplace. That is, until one of your colleagues sends you a worksheet with some really funky spacing. Not only can those rogue spaces make it difficult to search for data, but they also affect the results when you try to add up columns of numbers.<\/p>\n<p>Rather than painstakingly removing and adding spaces as needed, you can clean up any irregular spacing using the TRIM function, which is used to remove extra spaces from data (except for single spaces between words).<\/p>\n<ul>\n<li><strong>The formula<\/strong>:\u00a0<strong>=TRIM(text).<\/strong>\n<ul>\n<li><strong>Text:\u00a0<\/strong>The text or cell from which you want to remove spaces.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div id=\"hs_cos_wrapper_widget_5a0eb370-26df-4954-8a7f-2498217cc258\" class=\"hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module\" data-hs-cos-general-type=\"widget\" data-hs-cos-type=\"module\">\n<div class=\"blog-post-full-width-cta\" data-form-state=\"disabled\">Here&#8217;s an example of how we used the TRIM function to remove extra spaces before a list of names. To do so, we entered <strong>=TRIM(&#8220;A2&#8221;)<\/strong>\u00a0into the Formula Bar, and replicated this for each name below it in a new column next to the column with unwanted spaces.<\/div>\n<\/div>\n<p><img decoding=\"async\" class=\"sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=280&amp;name=trim-formula-in-excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=140&amp;name=trim-formula-in-excel.png 140w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=280&amp;name=trim-formula-in-excel.png 280w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=420&amp;name=trim-formula-in-excel.png 420w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=560&amp;name=trim-formula-in-excel.png 560w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=700&amp;name=trim-formula-in-excel.png 700w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/trim-formula-in-excel.png?width=840&amp;name=trim-formula-in-excel.png 840w\" alt=\"trim-formula-in-excel\" width=\"280\" \/><\/p>\n<h4><strong> LEFT, MID, and RIGHT<\/strong><\/h4>\n<p>Let&#8217;s say you have a line of text within a cell that you want to break down into a few different segments. Rather than manually retyping each piece of the code into its respective column, users can leverage a series of string functions to deconstruct the sequence as needed: LEFT, MID, or RIGHT.<\/p>\n<h5><strong>LEFT<\/strong><\/h5>\n<ul>\n<li><strong>Purpose<\/strong>: Used to extract the first X numbers or characters in a cell.<\/li>\n<li><strong>The formula<\/strong>:<strong>\u00a0=<\/strong><strong>LEFT(text, number_of_characters)<\/strong>\n<ul>\n<li><strong>Text<\/strong>: The string that you wish to extract from.<\/li>\n<li><strong>Number_of_characters<\/strong>: The number of characters that you wish to extract starting from the left-most character.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>In the example below, we entered\u00a0<strong>=LEFT(A2,4)<\/strong>\u00a0into cell B2, and copied it into B3:B6. That allowed us to extract the first 4 characters of the code.<\/p>\n<p><img decoding=\"async\" class=\"alignCenter shadow sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=650&amp;name=Left_Function_Excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=325&amp;name=Left_Function_Excel.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=650&amp;name=Left_Function_Excel.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=975&amp;name=Left_Function_Excel.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=1300&amp;name=Left_Function_Excel.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=1625&amp;name=Left_Function_Excel.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Left_Function_Excel.png?width=1950&amp;name=Left_Function_Excel.png 1950w\" alt=\"LEFT formula in Excel\" width=\"650\" data-constrained=\"true\" \/><\/p>\n<h5><strong>MID<\/strong><\/h5>\n<ul>\n<li><strong>Purpose<\/strong>: Used to extract characters or numbers in the middle based on position.<\/li>\n<li><strong>The formula<\/strong>:<strong>\u00a0=<\/strong><strong>MID(text, start_position, number_of_characters)<\/strong>\n<ul>\n<li><strong>Text<\/strong>: The string that you wish to extract from.<\/li>\n<li><strong>Start_position<\/strong>: The position in the string that you want to begin extracting from. For example, the first position in the string is 1.<\/li>\n<li><strong>Number_of_characters<\/strong>: The number of characters that you wish to extract.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>In this example, we entered<strong>\u00a0=MID(A2,5,2)<\/strong>\u00a0into cell B2, and copied it into B3:B6. That allowed us to extract the two numbers starting in the fifth position of the code.<\/p>\n<p><img decoding=\"async\" class=\"alignCenter shadow sweezy-custom-cursor-hover aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=650&amp;name=Mid_Function_Excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=325&amp;name=Mid_Function_Excel.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=650&amp;name=Mid_Function_Excel.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=975&amp;name=Mid_Function_Excel.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=1300&amp;name=Mid_Function_Excel.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=1625&amp;name=Mid_Function_Excel.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/Mid_Function_Excel.png?width=1950&amp;name=Mid_Function_Excel.png 1950w\" alt=\"MID formula in Excel\" width=\"650\" data-constrained=\"true\" \/><\/p>\n<h5><strong>RIGHT<\/strong><\/h5>\n<ul>\n<li><strong>Purpose:<\/strong>\u00a0Used to extract the last X numbers or characters in a cell.<\/li>\n<li>The formula:<strong>\u00a0=<\/strong><strong>RIGHT(text, number_of_characters)<\/strong>\n<ul>\n<li><strong>Text<\/strong>: The string that you wish to extract from.<\/li>\n<li><strong>Number_of_characters<\/strong>: The number of characters that you want to extract starting from the right-most character.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>For the sake of this example, we entered\u00a0<strong>=RIGHT(A2,2)<\/strong>\u00a0into cell B2, and copied it into B3:B6. That allowed us to extract the last two numbers of the code.<\/p>\n<p><img decoding=\"async\" class=\"alignCenter shadow aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=650&amp;name=Right_Function_Excel.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=325&amp;name=Right_Function_Excel.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=650&amp;name=Right_Function_Excel.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=975&amp;name=Right_Function_Excel.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=1300&amp;name=Right_Function_Excel.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=1625&amp;name=Right_Function_Excel.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/00-Blog-Related_Images\/Right_Function_Excel.png?width=1950&amp;name=Right_Function_Excel.png 1950w\" alt=\"RIGHT formula in EXCEL\" width=\"650\" data-constrained=\"true\" \/><\/p>\n<h4><strong>VLOOKUP<\/strong><\/h4>\n<p>This one is an oldie, but a goodie and it&#8217;s a bit more in depth than some of the other formulas we&#8217;ve listed here. But it&#8217;s especially helpful for those times when you have two sets of data on two different spreadsheets, and want to combine them into a single spreadsheet<\/p>\n<p>Note: When using this formula, you must be certain that at least one column appears\u00a0<em>identically<\/em>\u00a0in both spreadsheets. Scour your data sets to make sure the column of data you&#8217;re using to combine your information is exactly the same, including no extra spaces.<\/p>\n<ul>\n<li>The formula:\u00a0<strong>VLOOKUP(lookup value, table array, column number, [range lookup])<\/strong>\n<ul>\n<li><strong>Lookup Value:<\/strong>\u00a0The identical value you have in both spreadsheets. Choose the first value in your first spreadsheet. In Sprung&#8217;s example that follows, this means the first email address on the list, or cell 2 (C2).<\/li>\n<li><strong>Table Array:<\/strong>\u00a0The range of columns on Sheet 2 you&#8217;re going to pull your data from, including the column of data identical to your lookup value (in our example, email addresses) in Sheet 1 as well as the column of data you&#8217;re trying to copy to Sheet 1. In our example, this is &#8220;Sheet2!A:B.&#8221; &#8220;A&#8221; means Column A in Sheet 2, which is the column in Sheet 2 where the data identical to our lookup value (email) in Sheet 1 is listed. The &#8220;B&#8221; means Column B, which contains the information that&#8217;s only available in Sheet 2 that you want to translate to Sheet 1.<\/li>\n<li><strong>Column Number:<\/strong>\u00a0The table array tells Excel where (which column) the new data you want to copy to Sheet 1 is located. In our example, this would be the &#8220;House&#8221; column, the second one in our table array, making it column number 2.<\/li>\n<li><strong>Range Lookup:<\/strong>\u00a0Use FALSE to ensure you pull in only exact value matches.<\/li>\n<\/ul>\n<\/li>\n<li>The formula with variables from Sprung&#8217;s example below:<strong>\u00a0=VLOOKUP(C2,Sheet2!A:B,2,FALSE)<\/strong><\/li>\n<\/ul>\n<p>In this example, Sheet 1 and Sheet 2 contain lists describing different information about the same people, and the common thread between the two is their email addresses. Let&#8217;s say we want to combine both datasets so that all the house information from Sheet 2 translates over to Sheet 1.<\/p>\n<h4><strong> RANDOMIZE<\/strong><\/h4>\n<p>In marketing, you might use this feature when you want to assign a random number to a list of contacts, like if you wanted to experiment with a new email campaign and had to use blind criteria to select who would receive it. By assigning numbers to said contacts, you could apply the rule, \u201cAny contact with a figure of 6 or above will be added to the new campaign.<\/p>\n<ul>\n<li>The formula:\u00a0<strong>RAND<\/strong><strong>()<\/strong>\n<ul>\n<li>Start with a single column of contacts. Then, in the column adjacent to it, type \u201cRAND()\u201d &#8211; without the quotation marks, starting with the top contact\u2019s row.<\/li>\n<\/ul>\n<ul>\n<li>RANDBETWEEN allows you to dictate the range of numbers that you want to be assigned. In the case of this example, I wanted to use one through 10.<\/li>\n<li><strong>bottom:\u00a0<\/strong>The lowest number in the range.<\/li>\n<li><strong>top:\u00a0<\/strong>The highest number in the range,For the example below:\u00a0<strong>RANDBETWEEN<\/strong><strong>(bottom,top)<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Sometimes, you might want to run the same formula across an entire row or column of your spreadsheet.\u00a0Let&#8217;s say, for example, you\u00a0have a list of numbers in columns A and B of a spreadsheet and want to enter individual totals of each row into\u00a0column C.<\/p>\n<p>Obviously, it would be too tedious to adjust the values of the formula for each cell so you&#8217;re finding the total of each row&#8217;s respective numbers. Luckily, Excel allows you to automatically complete the column; all you have to do is enter the formula in the first row. Check out the following steps:<\/p>\n<ol>\n<li>Type your formula into an empty cell and press &#8220;Enter&#8221; to run the formula.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=650&amp;height=371&amp;name=sum-formula-two-columns.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=325&amp;height=186&amp;name=sum-formula-two-columns.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=650&amp;height=371&amp;name=sum-formula-two-columns.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=975&amp;height=557&amp;name=sum-formula-two-columns.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=1300&amp;height=742&amp;name=sum-formula-two-columns.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=1625&amp;height=928&amp;name=sum-formula-two-columns.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/sum-formula-two-columns.png?width=1950&amp;height=1113&amp;name=sum-formula-two-columns.png 1950w\" alt=\"SUM formula entered in column C of Excel spreadsheet to find the sum of cells B2 and C2.\" width=\"650\" height=\"371\" \/><\/li>\n<li>Hover your cursor over the bottom-right corner of the cell containing the formula. You&#8217;ll see a small, bold &#8220;+&#8221; symbol appear.<\/li>\n<li>While you can double-click this symbol to automatically fill the entire column with your formula, you can also\u00a0<em>click and drag<\/em>\u00a0your cursor down manually to fill only a specific length of the column.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=650&amp;height=392&amp;name=insert-formula-in-excel-for-entire-column.png\" srcset=\"https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=325&amp;height=196&amp;name=insert-formula-in-excel-for-entire-column.png 325w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=650&amp;height=392&amp;name=insert-formula-in-excel-for-entire-column.png 650w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=975&amp;height=588&amp;name=insert-formula-in-excel-for-entire-column.png 975w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=1300&amp;height=784&amp;name=insert-formula-in-excel-for-entire-column.png 1300w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=1625&amp;height=980&amp;name=insert-formula-in-excel-for-entire-column.png 1625w, https:\/\/blog.hubspot.com\/hs-fs\/hubfs\/insert-formula-in-excel-for-entire-column.png?width=1950&amp;height=1176&amp;name=insert-formula-in-excel-for-entire-column.png 1950w\" alt=\"insert-formula-in-excel-for-entire-column\" width=\"650\" height=\"392\" \/><\/li>\n<\/ol>\n<p>Once you&#8217;ve reached the last cell in the column you&#8217;d like to enter your formula, release your mouse to copy the formula. Then, simply check each new value to ensure it corresponds to the correct cell.<\/p>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/04\/Quantity-Surveyor-Course.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/04\/Quantity-Surveyor-Course.pdf\" class=\"lead-pdf-download\" data-id=\"25558707\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">Download quantity surveying course Syllabus<\/button><\/p>\n<\/a><\/div>\n<h2 data-start=\"904\" data-end=\"957\"><span class=\"ez-toc-section\" id=\"Why_Excel_is_Crucial_for_Quantity_Surveyors\"><\/span><strong data-start=\"907\" data-end=\"957\">Why Excel is Crucial for Quantity Surveyors<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p data-start=\"959\" data-end=\"1084\">A Quantity Surveyor\u2019s work revolves around <strong data-start=\"1002\" data-end=\"1047\">numbers, measurements, and financial data<\/strong>. Excel allows QS professionals to:<\/p>\n<ul data-start=\"1085\" data-end=\"1403\">\n<li data-start=\"1085\" data-end=\"1148\">\n<p data-start=\"1087\" data-end=\"1148\">Create <strong data-start=\"1094\" data-end=\"1124\">Bills of Quantities (BoQs)<\/strong> with auto\u2011calculation<\/p>\n<\/li>\n<li data-start=\"1149\" data-end=\"1190\">\n<p data-start=\"1151\" data-end=\"1190\">Perform <strong data-start=\"1159\" data-end=\"1176\">rate analysis<\/strong> efficiently<\/p>\n<\/li>\n<li data-start=\"1191\" data-end=\"1248\">\n<p data-start=\"1193\" data-end=\"1248\">Track project <strong data-start=\"1207\" data-end=\"1246\">cash flows and payment certificates<\/strong><\/p>\n<\/li>\n<li data-start=\"1249\" data-end=\"1300\">\n<p data-start=\"1251\" data-end=\"1300\">Compare tender prices from multiple contractors<\/p>\n<\/li>\n<li data-start=\"1301\" data-end=\"1350\">\n<p data-start=\"1303\" data-end=\"1350\">Analyse <strong data-start=\"1311\" data-end=\"1340\">material and labour costs<\/strong> quickly<\/p>\n<\/li>\n<li data-start=\"1351\" data-end=\"1403\">\n<p data-start=\"1353\" data-end=\"1403\">Generate <strong data-start=\"1362\" data-end=\"1376\">dashboards<\/strong> for client presentations<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1405\" data-end=\"1484\">In short, Excel bridges the gap between <strong data-start=\"1445\" data-end=\"1459\">field data<\/strong> and <strong data-start=\"1464\" data-end=\"1483\">decision\u2011making<\/strong>.<\/p>\n<p>Finding the best online platform to learn the nuances of quantitative research can help you improve your quality in the field of quantitative research. <a href=\"https:\/\/entri.app\/course\/quantity-surveying-course\/\" target=\"_blank\" rel=\"noopener\">Entri\u2019s Quantity Surveying<\/a> helps you gain experience from industry experts. The Entri Elevate Quantity Survey Certification course will help you dive deep into QS-related concepts from basic to advanced level.<\/p>\n<p>The course syllabus is carefully compiled by QS experts. The syllabus will help you deal with real life situations. Internships will help you gain the necessary experience in the field. The systematic and comprehensive learning methodologies adopted at Entri will equip you to deal with real-life situations.<\/p>\n<p>Live projects from the Middle East, expert guidance, timely assessment, practice tests and live doubt clearing sessions will enhance the flexibility of the course. Learn strategies to become a qualified QS expert with Entri!<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/quantity-surveying-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Want to be a Quantity Surveyor at your dream firm? Register for the course now!<\/strong><\/a><\/p>\n<h2 data-start=\"6083\" data-end=\"6107\"><span class=\"ez-toc-section\" id=\"Final_Thoughts\"><\/span><strong data-start=\"6086\" data-end=\"6107\">Final Thoughts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p data-start=\"6109\" data-end=\"6368\">For Quantity Surveyors, <strong data-start=\"6133\" data-end=\"6179\">Excel is more than just a spreadsheet tool<\/strong> ,it\u2019s a cost management powerhouse. By mastering formulas, templates, and automation tools, you can significantly <strong data-start=\"6295\" data-end=\"6348\">improve efficiency, accuracy, and decision\u2011making<\/strong> in your projects.<\/p>\n<p data-start=\"6370\" data-end=\"6593\">In 2025, as projects become more data\u2011driven, <strong data-start=\"6416\" data-end=\"6510\">those QS professionals who can leverage Excel effectively will stand out in the job market<\/strong>. Start by applying a few of these tips today and build your skills step\u2011by\u2011step.<\/p>\n<table class=\"table\" dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Related Links<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><strong><a href=\"https:\/\/entri.app\/blog\/quantity-surveyor-skills\/\" target=\"_blank\" rel=\"noopener\">The Skills You Need as a Quantity Surveyor<\/a><\/strong><\/td>\n<td><strong><a href=\"https:\/\/entri.app\/blog\/is-quantity-surveying-a-good-career\/\" target=\"_blank\" rel=\"noopener\">Is Quantity Surveying a Good Career<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong><a class=\"in-cell-link\" href=\"https:\/\/entri.app\/blog\/what-is-data-interpretation-methods-and-benefits\/\" target=\"_blank\" rel=\"noopener\">What is Data Interpretation? Methods and Benefits<\/a><\/strong><\/td>\n<td><strong><a class=\"in-cell-link\" href=\"https:\/\/entri.app\/blog\/understanding-machine-learning-basics-a-simple-guide\/\" target=\"_blank\" rel=\"noopener\">Understanding Machine Learning Basics \u2013 A Simple Guide<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong><a href=\"https:\/\/entri.app\/blog\/quantity-surveyor-skills\/\" target=\"_blank\" rel=\"noopener\">The Skills You Need as a Quantity Surveyor<\/a><\/strong><\/td>\n<td><strong><a class=\"in-cell-link\" href=\"https:\/\/entri.app\/blog\/data-analysis-process-methods-types\/\" target=\"_blank\" rel=\"noopener\">Data Analysis \u2013 Process, Methods, Types<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"modal\" id=\"modal25558707\"><div class=\"modal-content\"><span class=\"close-button\">&times;<\/span>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f25558707-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"25558707\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/25579993#wpcf7-f25558707-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"25558707\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.4\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f25558707-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:25558707,&quot;conditions&quot;:[{&quot;then_field&quot;:&quot;group-coding&quot;,&quot;and_rules&quot;:[{&quot;if_field&quot;:&quot;course&quot;,&quot;operator&quot;:&quot;equals&quot;,&quot;if_value&quot;:&quot;Coding&quot;}]},{&quot;then_field&quot;:&quot;group-accounting&quot;,&quot;and_rules&quot;:[{&quot;if_field&quot;:&quot;course&quot;,&quot;operator&quot;:&quot;equals&quot;,&quot;if_value&quot;:&quot;Commerce&quot;}]}],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false,&quot;notice_dismissed_update-cf7-5.9.8&quot;:true,&quot;notice_dismissed_update-cf7-6.1.1&quot;:true}}\" \/>\n<\/fieldset>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"full_name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name\" value=\"\" type=\"text\" name=\"full_name\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"phone\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone\" value=\"\" type=\"tel\" name=\"phone\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"email_id\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-text wpcf7-validates-as-email\" aria-invalid=\"false\" placeholder=\"Email\" value=\"\" type=\"email\" name=\"email_id\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"language\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" name=\"language\"><option value=\"\">Language<\/option><option value=\"Malayalam\">Malayalam<\/option><option value=\"Tamil\">Tamil<\/option><option value=\"Telugu\">Telugu<\/option><option value=\"Kannada\">Kannada<\/option><option value=\"Hindi\">Hindi<\/option><\/select><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"course\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-field-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course\"><option value=\"\">Upskill in<\/option><option value=\"Quantity Surveying\">Quantity Surveying<\/option><option value=\"Structural Design\">Structural Design<\/option><option value=\"BIM\">BIM<\/option><option value=\"MEP\">MEP<\/option><option value=\"Embedded System Software Engineering\">Embedded System Software Engineering<\/option><option value=\"Robotics &amp; AI Course\">Robotics &amp; AI Course<\/option><option value=\"Coding\">Coding<\/option><option value=\"Commerce\">Commerce<\/option><option value=\"Stock Market Course\">Stock Market Course<\/option><option value=\"HR Management\">HR Management<\/option><option value=\"Spoken English\">Spoken English<\/option><option value=\"German Language\">German Language<\/option><option value=\"Montessori Teacher Training\">Montessori Teacher Training<\/option><option value=\"IELTS\">IELTS<\/option><option value=\"OET\">OET<\/option><option value=\"Hospital and Healthcare Administration\">Hospital and Healthcare Administration<\/option><option value=\"Yoga TTC\">Yoga TTC<\/option><option value=\"Digital Marketing\">Digital Marketing<\/option><option value=\"AI Courses\">AI Courses<\/option><option value=\"Arabic\">Arabic<\/option><\/select><\/span>\n<\/p>\n<div data-id=\"group-coding\" data-orig_data_id=\"group-coding\" data-clear_on_hide class=\"\" data-class=\"wpcf7cf_group\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course_name\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-name-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course_name\"><option value=\"\">Select Course<\/option><option value=\"Full Stack Development\">Full Stack Development<\/option><option value=\"Data Science and ML\">Data Science and ML<\/option><option value=\"Software Testing\">Software Testing<\/option><option value=\"Python Programming\">Python Programming<\/option><option value=\"AWS Training\">AWS Training<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<div data-id=\"group-accounting\" data-orig_data_id=\"group-accounting\" data-clear_on_hide class=\"\" data-class=\"wpcf7cf_group\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course_name\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-name-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course_name\"><option value=\"\">Select Course<\/option><option value=\"Business Accounting\">Business Accounting<\/option><option value=\"SAP FICO\">SAP FICO<\/option><option value=\"SAP MM\">SAP MM<\/option><option value=\"SAP SD\">SAP SD<\/option><option value=\"ACCA\">ACCA<\/option><option value=\"Tally\">Tally<\/option><option value=\"UAE Accounting\">UAE Accounting<\/option><option value=\"GST\">GST<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"education\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Educational qualification\" value=\"\" type=\"text\" name=\"education\" \/><\/span>\n<\/p>\n<div style=\"display:none\">\n<input class=\"wpcf7-form-control wpcf7-hidden course-name-input\" value=\"\" type=\"hidden\" name=\"course_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-source\" value=\"\" type=\"hidden\" name=\"utm_source\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-medium\" value=\"\" type=\"hidden\" name=\"utm_medium\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-campaign\" value=\"\" type=\"hidden\" name=\"utm_campaign\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-content\" value=\"\" type=\"hidden\" name=\"utm_content\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-term\" value=\"\" type=\"hidden\" name=\"utm_term\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden blog-url\" value=\"\" type=\"hidden\" name=\"blog_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-category-name\" value=\"\" type=\"hidden\" name=\"post_category_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-author-name\" value=\"\" type=\"hidden\" name=\"post_author_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden file-url\" value=\"\" type=\"hidden\" name=\"file_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden video-url\" value=\"\" type=\"hidden\" name=\"video_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden courseid\" value=\"\" type=\"hidden\" name=\"course_id\" \/>\n<\/div>\n<div class=\"cf7-cf-turnstile\" style=\"margin-top: 0px; margin-bottom: -15px;\"> <div id=\"cf-turnstile-cf7-2879925904\" class=\"cf-turnstile\" data-sitekey=\"0x4AAAAAABVigxtkiZeGTu5L\" data-theme=\"light\" data-language=\"auto\" data-size=\"normal\" data-retry=\"auto\" data-retry-interval=\"1000\" data-action=\"contact-form-7\" data-appearance=\"always\"><\/div> <script>document.addEventListener(\"DOMContentLoaded\", function() { setTimeout(function(){ var e=document.getElementById(\"cf-turnstile-cf7-2879925904\"); e&&!e.innerHTML.trim()&&(turnstile.remove(\"#cf-turnstile-cf7-2879925904\"), turnstile.render(\"#cf-turnstile-cf7-2879925904\", {sitekey:\"0x4AAAAAABVigxtkiZeGTu5L\"})); }, 0); });<\/script> <br class=\"cf-turnstile-br cf-turnstile-br-cf7-2879925904\"> <style>#cf-turnstile-cf7-2879925904 { margin-left: -15px; }<\/style> <script>document.addEventListener(\"DOMContentLoaded\",function(){document.querySelectorAll('.wpcf7-form').forEach(function(e){e.addEventListener('submit',function(){if(document.getElementById('cf-turnstile-cf7-2879925904')){setTimeout(function(){turnstile.reset('#cf-turnstile-cf7-2879925904');},1000)}})})});<\/script> <\/div><br\/><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is one of the most essential tools in a Quantity Surveyor\u2019s toolkit. While specialised software like CostX, PlanSwift, or Candy has its place, Excel remains the go\u2011to platform for cost estimation, budgeting, BoQ preparation, and project reporting. In this detailed guide, we\u2019ll explore practical Excel tips, formulas, and features that can help Quantity [&hellip;]<\/p>\n","protected":false},"author":92,"featured_media":25579994,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1927],"tags":[],"class_list":["post-25579993","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-quantity-surveying"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]<\/title>\n<meta name=\"description\" content=\"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]\" \/>\n<meta property=\"og:description\" content=\"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-27T20:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T10:20:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aleena V Noushad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aleena V Noushad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\"},\"author\":{\"name\":\"Aleena V Noushad\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2\"},\"headline\":\"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]\",\"datePublished\":\"2024-03-27T20:44:00+00:00\",\"dateModified\":\"2025-08-06T10:20:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\"},\"wordCount\":5121,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png\",\"articleSection\":[\"Articles\",\"Quantity Surveying\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\",\"url\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\",\"name\":\"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png\",\"datePublished\":\"2024-03-27T20:44:00+00:00\",\"dateModified\":\"2025-08-06T10:20:57+00:00\",\"description\":\"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png\",\"width\":820,\"height\":615,\"caption\":\"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entri Skilling\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Quantity Surveying\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/quantity-surveying\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2\",\"name\":\"Aleena V Noushad\",\"description\":\"Aleena is a passionate Blog writer and a Postgraduate in Master of Computer Application. She also holds a diploma in Aviation and Hospitality. She has been writing for Entri over the past three years, specialising in exam preparation and skill and career development\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/aleena-v-noushad-a81632126\/\"],\"url\":\"https:\/\/entri.app\/blog\/author\/aleena\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]","description":"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.","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:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]","og_description":"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.","og_url":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2024-03-27T20:44:00+00:00","article_modified_time":"2025-08-06T10:20:57+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png","type":"image\/png"}],"author":"Aleena V Noushad","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Aleena V Noushad","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/"},"author":{"name":"Aleena V Noushad","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2"},"headline":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]","datePublished":"2024-03-27T20:44:00+00:00","dateModified":"2025-08-06T10:20:57+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/"},"wordCount":5121,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png","articleSection":["Articles","Quantity Surveying"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/","url":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/","name":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png","datePublished":"2024-03-27T20:44:00+00:00","dateModified":"2025-08-06T10:20:57+00:00","description":"Discover the best Excel tricks, formulas, and tools for Quantity Surveyors. Learn how to speed up BoQ preparation and cost control.","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/Excel-Tips-and-Tricks.png","width":820,"height":615,"caption":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]"},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/excel-tips-and-tricks-every-quantity-surveyor-should-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Entri Skilling","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/"},{"@type":"ListItem","position":3,"name":"Quantity Surveying","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/quantity-surveying\/"},{"@type":"ListItem","position":4,"name":"Excel Tips and Tricks Every Quantity Surveyor Should Know [Latest Guide]"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/282abb73bf1e2468d08cf486d1f075e2","name":"Aleena V Noushad","description":"Aleena is a passionate Blog writer and a Postgraduate in Master of Computer Application. She also holds a diploma in Aviation and Hospitality. She has been writing for Entri over the past three years, specialising in exam preparation and skill and career development","sameAs":["https:\/\/www.linkedin.com\/in\/aleena-v-noushad-a81632126\/"],"url":"https:\/\/entri.app\/blog\/author\/aleena\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25579993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25579993"}],"version-history":[{"count":13,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25579993\/revisions"}],"predecessor-version":[{"id":25619944,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25579993\/revisions\/25619944"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25579994"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25579993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25579993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25579993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}