{"id":11713,"date":"2023-05-08T18:30:00","date_gmt":"2023-05-08T13:00:00","guid":{"rendered":"https:\/\/www.saasworthy.com\/blog\/?p=11713"},"modified":"2023-05-09T16:30:17","modified_gmt":"2023-05-09T11:00:17","slug":"7-excel-formulas-keyboard-shortcuts-tricks","status":"publish","type":"post","link":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks","title":{"rendered":"7 Excel Formulas, Keyboard Shortcuts &#038; Tricks"},"content":{"rendered":"\n<p>For many business owners, using <a href=\"https:\/\/www.saasworthy.com\/product\/microsoft-excel\" target=\"_blank\" aria-label=\"Microsoft Excel (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">Microsoft Excel<\/a> to create and analyze spreadsheets might feel like continuously running up against a brick wall if you aren&#8217;t familiar with its formulas. You think to yourself as you manually duplicate columns and scribble long-form equations on a scrap of paper.&nbsp;<\/p>\n\n\n\n<p>But running excel formulas is no kids play either. In fact, Excel may be challenging in that sense. On the one hand, it is software that reports and analyses marketing and advertising data extraordinarily well. It may even demonstrate how to use charts and pivot tables to visualize data. On the other hand, it is simple to feel as though it is working against you without the proper training. To begin with, Excel can automatically execute more than a dozen important formulae for you, saving you from having to go through several cells with a calculator on your desk.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<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:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#What_are_Excel_Formulas\" title=\"What are Excel Formulas?\">What are Excel Formulas?<\/a><ul class=\"ez-toc-list-level-3\"><li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#7_Most_Used_Excel_Formulas_That_Make_Your_Life_Easy\" title=\"7 Most Used Excel Formulas That Make Your Life Easy&nbsp;\">7 Most Used Excel Formulas That Make Your Life Easy&nbsp;<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#1_Sum\" title=\"1. Sum&nbsp;\">1. Sum&nbsp;<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#2_IF\" title=\"2. IF\">2. IF<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#3_Proportion\" title=\"3. Proportion\">3. Proportion<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#4_Array\" title=\"4. Array\">4. Array<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#5_Count\" title=\"5. Count&nbsp;\">5. Count&nbsp;<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#6_Average\" title=\"6. Average\">6. Average<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#7_Division\" title=\"7. Division&nbsp;\">7. Division&nbsp;<\/a><\/li><\/ul><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><ul class=\"ez-toc-list-level-3\"><li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\/#Read_More\" title=\"Read More\">Read More<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"what-are-excel-formulas\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_are_Excel_Formulas\"><\/span><strong>What are Excel Formulas?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/res.cloudinary.com\/dyd911kmh\/image\/upload\/v1664461740\/Basic_Excel_Formulas_Header_f0beea2ce8.png\" alt=\"The 15 Basic Excel Formulas Everyone Needs to Know | DataCamp\"\/><figcaption>Source: Data Camp<\/figcaption><\/figure>\n\n\n\n<p>Excel formulas teach you how to create connections between the values in your spreadsheet&#8217;s cells, perform calculations using these values, and then deliver the results in your chosen cell. Formulas you can automatically complete include sum, subtraction, proportion, division, average, and even dates and occasions.<\/p>\n\n\n\n<p>Let&#8217;s go over some basic formulas one by one for your better understanding.<\/p>\n\n\n\n<h3 id=\"7-most-used-excel-formulas-that-make-your-life-easy\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_Most_Used_Excel_Formulas_That_Make_Your_Life_Easy\"><\/span><strong>7 Most Used Excel Formulas That Make Your Life Easy&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 id=\"1-sum\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Sum\"><\/span>1. Sum&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SUM The equals sign, =, is used at the beginning of every Excel calculation, followed by a specific text tag designating the operation you want Excel to perform.<\/p>\n\n\n\n<p>One of the simplest formulas you can enter directly into a spreadsheet to find the sum (or total) of two or more numbers is the SUM method in Excel. Enter the values you want to add together using the syntax =SUM to use the SUM system (worth 1, worth 2, and many others).<\/p>\n\n\n\n<p>The values you submit into the SUM system might be either exact numbers or the quantity in a specific spreadsheet cell.<\/p>\n\n\n\n<h4 id=\"how-to-use-it\" class=\"wp-block-heading\">How to use it?&nbsp;<\/h4>\n\n\n\n<p>For instance, enter the following formula into a spreadsheet cell to look for the SUM of 30 and 80: =SUM (30, 80). When you hit &#8220;Enter,&#8221; the cell will display the sum of all the numbers, 110.<\/p>\n\n\n\n<p>For example, enter the following formula into a cell of your spreadsheet to find the SUM of the values in cells B2 and B11: =SUM (B2, B11). When you hit &#8220;Enter,&#8221; the cell will display the sum of the integers that are now crammed into cells B2 and B11. The computer will return 0 if there are no numbers in any of the two cells.<\/p>\n\n\n\n<h3 id=\"2-if\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_IF\"><\/span>2. IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>=IF(logical test, value if true, value if false) in Excel stands for the Excel IF system. This enables you to add text into the cell that asks whether another condition in your spreadsheet is true or false. For instance, the expression =IF(D2=&#8221;Gryffindor&#8221;,&#8221;10&#8243;,&#8221;0&#8243;&#8221;) would give cell D2 10 factors if it contained the word &#8220;Gryffindor.&#8221;<\/p>\n\n\n\n<p>There are times when we need to know how frequently a price appears in our spreadsheets. However, there are also times when we must locate the cells that contain these values and insert specific information next to them.<\/p>\n\n\n\n<h3 id=\"3-proportion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Proportion\"><\/span>3. Proportion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Enter the cells you are determining a proportion for in the format =A1\/B1 in Excel to use the share system. Highlight the cell, select the &#8220;Residence&#8221; tab, pick &#8220;Proportion&#8221; from the numbers dropdown menu, and the resulting decimal value will be converted to a percentage.<\/p>\n\n\n\n<p>Excel does not have a &#8220;system&#8221; for percentages per se, but it does make it simple to convert the value of any cell into a \\%, so you are not forced to calculate and reenter the numbers yourself.<\/p>\n\n\n\n<p>Under Excel&#8217;s Home tab is the key setting for converting a cell&#8217;s value into a percentage. Pick this tab, highlight the cell or cells you want to convert to a proportion, then select Conditional Formatting from the dropdown menu (this). Menu button may say \u201cBasic\u201d at first). Then, choose \u201cProportion\u201d from the checklist of choices that seems. It will convert the worth of every cell you\u2019ve got highlighted right into a proportion. See this function under<\/p>\n\n\n\n<h3 id=\"4-array\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Array\"><\/span>4. Array<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The Excel formula =(Begin Worth 1:Finish Worth 1)*(Begin Worth 2:Finish Worth 2) encapsulates a simple system in brace letters. Instead of just adding or multiplying individual cells, pressing Ctrl, Shift, and Heart will calculate and return values from many ranges.<\/p>\n\n\n\n<p>Simply enter the cells, values, or range of cells you want to perform that arithmetic on and use the =SUM system to calculate the sum, product, or quotient of individual cells. But what about many ranges? How can you determine the combined value of a sizable bunch of cells?<\/p>\n\n\n\n<p>Useful tools for running multiple systems simultaneously in one are numerical arrays.<\/p>\n\n\n\n<h3 id=\"5-count\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Count\"><\/span>5. Count&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In Excel, the COUNT system is shown by =COUNT (Begin Cell:Finish Cell). This system will return a price equal to the number of entries found inside the range of cells you specified. For instance, =COUNT(A1:A10) will return the price of 8 if there are eight cells with values entered between A1 and A10.<\/p>\n\n\n\n<p>Excel&#8217;s COUNT feature is extremely useful for large spreadsheets where you need to know how many cells contain specific information. Beware: This system will not perform any calculations on the cell values themselves. The sole purpose of this approach is to determine how many cells in a certain variety are focused on a single activity.<\/p>\n\n\n\n<h3 id=\"6-average\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Average\"><\/span>6. Average<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Enter the numbers, cells, or range of cells you are computing the typical for in Excel using the syntax =AVERAGE(number1, number2, and many others.) or =AVERAGE (Begin Worth:Finish Worth). It will determine the average value across all cell ranges or values contained within the parenthesis.<\/p>\n\n\n\n<p>Excel&#8217;s ability to calculate the average of many cells saves you from having to look up individual sums and then solve a separate division equation for the total. You can let Excel handle all of the fine tunings for you if you use =AVERAGE as your initial text entry.<\/p>\n\n\n\n<h3 id=\"7-division\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_Division\"><\/span>7. Division&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Enter the cells you&#8217;re dividing into Excel with the format =A1\/B1 to use the division system. This approach divides cell A1 by cell B1 using a forward slash, &#8220;\/.&#8221; For instance, the result of =A1\/B1 would be 0.5 if A1 was 5 and B1 was 10.<\/p>\n\n\n\n<p>One of the simplest functions you may use in Excel is division. To do this, place the cursor in an empty cell, type the equals sign (&#8220;=&#8221;), and then add the two (or more) values you wish to divide, separating them with a forward slash (&#8220;\/&#8221;). The result must have the following format: =B2\/A2.<\/p>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/dev.saasworthy.com\/blog5-best-add-ins-for-microsoft-excel\" target=\"_blank\" aria-label=\"Excel usage (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">Excel usage<\/a> in marketing and advertising is largely inevitable; nevertheless, with these strategies, it need not be so intimidating. As they say, observation is the mother of all wisdom. These formulas, quick cuts, and techniques will become more automatic the more you use them.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"read-more\"><span class=\"ez-toc-section\" id=\"Read_More\"><\/span>Read More<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/dev.saasworthy.com\/blogfalse-advertising-statistics\">False Advertising Statistics Debunked in 2022<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/dev.saasworthy.com\/blogsmall-business-statistics\">10 Small Business Statistics To Know in 2022<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them. <\/p>\n","protected":false},"author":14,"featured_media":11714,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":4,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[31],"tags":[187],"class_list":{"0":"post-11713","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-research-report","8":"tag-research-report"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>7 Excel Formulas, Keyboard Shortcuts &amp; Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS<\/title>\n<meta name=\"description\" content=\"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 Excel Formulas, Keyboard Shortcuts &amp; Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS\" \/>\n<meta property=\"og:description\" content=\"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\" \/>\n<meta property=\"og:site_name\" content=\"SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/saasworthy\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-08T13:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T11:00:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"515\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Rajnish Shankhar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@saasworthy\" \/>\n<meta name=\"twitter:site\" content=\"@saasworthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rajnish Shankhar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\",\"url\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\",\"name\":\"7 Excel Formulas, Keyboard Shortcuts & Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS\",\"isPartOf\":{\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg\",\"datePublished\":\"2023-05-08T13:00:00+00:00\",\"dateModified\":\"2023-05-09T11:00:17+00:00\",\"author\":{\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/dec77e6e857a3d0865a918458e7cad4f\"},\"description\":\"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage\",\"url\":\"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg\",\"contentUrl\":\"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg\",\"width\":770,\"height\":515},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.saasworthy.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 Excel Formulas, Keyboard Shortcuts &#038; Tricks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/#website\",\"url\":\"https:\/\/dev.saasworthy.com\/blog\/\",\"name\":\"SaaSworthy Blog\",\"description\":\"Stay ahead in the SaaS industry with top software insights, latest statistics, and more. Explore the SaaSworthy Blog to choose the best SaaS solutions for your business.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.saasworthy.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/dec77e6e857a3d0865a918458e7cad4f\",\"name\":\"Rajnish Shankhar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c704b19def1b43440fe1008ecd5d9e19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c704b19def1b43440fe1008ecd5d9e19?s=96&d=mm&r=g\",\"caption\":\"Rajnish Shankhar\"},\"url\":\"https:\/\/dev.saasworthy.com\/blog\/author\/rajnish\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 Excel Formulas, Keyboard Shortcuts & Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS","description":"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.","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:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks","og_locale":"en_US","og_type":"article","og_title":"7 Excel Formulas, Keyboard Shortcuts & Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS","og_description":"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.","og_url":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks","og_site_name":"SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS","article_publisher":"https:\/\/www.facebook.com\/saasworthy\/","article_published_time":"2023-05-08T13:00:00+00:00","article_modified_time":"2023-05-09T11:00:17+00:00","og_image":[{"width":770,"height":515,"url":"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg","type":"image\/jpeg"}],"author":"Rajnish Shankhar","twitter_card":"summary_large_image","twitter_creator":"@saasworthy","twitter_site":"@saasworthy","twitter_misc":{"Written by":"Rajnish Shankhar","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks","url":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks","name":"7 Excel Formulas, Keyboard Shortcuts & Tricks - SaaSworthy Blog | Top Software, Statistics, Insights, Reviews &amp; Trends in SaaS","isPartOf":{"@id":"https:\/\/dev.saasworthy.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage"},"image":{"@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage"},"thumbnailUrl":"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg","datePublished":"2023-05-08T13:00:00+00:00","dateModified":"2023-05-09T11:00:17+00:00","author":{"@id":"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/dec77e6e857a3d0865a918458e7cad4f"},"description":"As convenient as Excel is, it can be tricky to use. Especially when it comes to Excel Formulas. Saving you from having to go through several cells with a calculator on your desk. Here is how you can ace them.","breadcrumb":{"@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#primaryimage","url":"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg","contentUrl":"https:\/\/dev.saasworthy.com\/blog\/wp-content\/uploads\/2022\/08\/Excel_Formulas.jpg","width":770,"height":515},{"@type":"BreadcrumbList","@id":"https:\/\/dev.saasworthy.com\/blog\/7-excel-formulas-keyboard-shortcuts-tricks#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.saasworthy.com\/blog\/"},{"@type":"ListItem","position":2,"name":"7 Excel Formulas, Keyboard Shortcuts &#038; Tricks"}]},{"@type":"WebSite","@id":"https:\/\/dev.saasworthy.com\/blog\/#website","url":"https:\/\/dev.saasworthy.com\/blog\/","name":"SaaSworthy Blog","description":"Stay ahead in the SaaS industry with top software insights, latest statistics, and more. Explore the SaaSworthy Blog to choose the best SaaS solutions for your business.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.saasworthy.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/dec77e6e857a3d0865a918458e7cad4f","name":"Rajnish Shankhar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.saasworthy.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c704b19def1b43440fe1008ecd5d9e19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c704b19def1b43440fe1008ecd5d9e19?s=96&d=mm&r=g","caption":"Rajnish Shankhar"},"url":"https:\/\/dev.saasworthy.com\/blog\/author\/rajnish"}]}},"_links":{"self":[{"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/posts\/11713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/comments?post=11713"}],"version-history":[{"count":3,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/posts\/11713\/revisions"}],"predecessor-version":[{"id":13418,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/posts\/11713\/revisions\/13418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/media\/11714"}],"wp:attachment":[{"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/media?parent=11713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/categories?post=11713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.saasworthy.com\/blog\/wp-json\/wp\/v2\/tags?post=11713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}