{"id":1550,"date":"2022-09-17T06:34:04","date_gmt":"2022-09-17T06:34:04","guid":{"rendered":"https:\/\/learntube.ai\/blog\/?p=1550"},"modified":"2022-10-13T05:35:10","modified_gmt":"2022-10-13T05:35:10","slug":"10-basic-excel-functions-everyone-should-know","status":"publish","type":"post","link":"https:\/\/learntube.ai\/blog\/business-finance\/excel\/10-basic-excel-functions-everyone-should-know\/","title":{"rendered":"10 Basic Excel Functions Everyone Should Know"},"content":{"rendered":"\n<p>Excel functions can help you get more done in your day-to-day office activities. Even while Microsoft Excel offers hundreds of formulas, most users only use a few of them, and you&#8217;ll probably never need to use the majority of them. That\u2019s why in this blog we\u2019ve put together some of Excel&#8217;s most innovative and practical features. Let&#8217;s have a look at some of the most commonly used functions.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>VLOOKUP &amp; HLOOKUP: <\/strong>VLOOKUP is a well-known Excel function for matching data from a table to a user selection. HLOOKUP, a lesser-known function, performs the identical task but in a reversed search pattern. To look up and find a value, both functions require a table. VLOOKUP looks for the lookup value, whereas HLOOKUP looks in the first row. After locating the lookup value in the search column or row, both functions return the value in the specified column or row number in the table array selection. The final parameter of the formula determines whether it should search for an exact or approximate string (range lookup).<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/yNYGcOeld34uWB5abjWN9w3zr7vYMntIEeiCe5rEBkgC6nmXxqjH7KkHU1VdNDBv5uudYuyHXZLCw2RkgReb9cTKuPKKKeqDLSL6d4IZ0k6DQMNqJuQ39jL7D4ECalOq017ShxgZRXGYQihItNHwZnEYymziK7RsG8Xt3f8MrlOfcvmyp5USRkcY\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li><strong>IF, AND, OR: <\/strong>The IF function is a handy and straightforward tool. Excel may detect a logical test and assign a value to the cell or perform another calculation based on the test&#8217;s result, which can be True or False.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax: <\/strong>IF(logical_test, value_if_true, [value_if_false])<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/O_VSP0FmafY-4VleWcsz51qLu-MGe_sqo3e9UG5T9XiPQ2wpYweHVml-P_SM-LklVshKpV44Oh3TNJRxYRZYyDYz9B342iJE9p-iISPxqP5o6A_rnmRjnEDvFbZKlXfzbrEzXhm7wL4NV4mYm8ZgeCBxA6n93XlpGs3CEPiV2MJmpduOvhEeLL6V\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li><strong>SUM: <\/strong>The SUM function does exactly what it says. It adds things up. It adds up all of the numerical values given as inputs. A single cell, a range, or a static numerical value can be used as arguments. Up to 255 arguments can be passed to a single SUM function.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax:<\/strong> SUM(number1,[number2],&#8230;)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/aEYLaAtxzCMHj7DjCmtTSCB8qIQiThQdydLjvUPlGqBkfl2-v2LYO0vdScJzHD8sXxgodsxVItsB8pHi7QxRgNN8Oh_7jSVoJQp070hcW-iw0f1VjlWjXiVYvIabuWWR8Stlg6xCWUPgFV-8x_CwYtPQdVyCE0sJxCtI5xOV8NNkIpgdpTwJc0M6\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li><strong>SUBTOTAL: <\/strong>Let&#8217;s take a closer look at the subtotal function now. The SUBTOTAL() function returns the subtotal of a database. Depending on your demands, you can choose among average, count, sum, min, max, min, and other options.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax: <\/strong>SUBTOTAL(function_num,ref1,[ref2],&#8230;)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/Uff4XTrGPoVS04YtXxQ72_wRkhU7Fcl9P-u0rR8fmsLv1nP7GX7WERJeX4iSHG9d8nIRKrqbA3FvXDdqrKZ_hYmaDJW_RyZqrqehq6vTGtBJ6Mzn-COb1VmwmpZlu-qrRVEG5J-sK7DpQ0RnN35OSvODLbyXqEKXBNk49gN8pZBbSTjYMjZ_N5Io\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li><strong>AVERAGE: <\/strong>The average function work similarly to the SUM function. It calculates the average of all the numbers in the syntax. The argument limit is 255, just like the SUM function. Arguments can be static values, single cells, or ranges.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax: <\/strong>AVERAGE(number1,[number2],&#8230;)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/zCkjwKRM4zgfKPcWNjmUUEbjXXuanHTsq84-qCVLa0Y8ayorwuuTHa4FKKmrYtAli-DTyVJayWfz6sjUIy9z2QVMzaJoLHEhw8sgb6NMkF6HXvM50SdW8eAZP-IVAX1ywdh-tPJwmSEu_RRwCR1SpM7d2kS2AfH_Gjyb5r1jpV_HQCUa3ifdc3CA\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li><strong>MODULUS: <\/strong>When a given number is divided by a division, the MOD() function returns the remaining.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax: <\/strong>MOD(number, divisor)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/ncKRG_fZYQnNZTc7Xajc8CdsldBbG-3FXzh2R7Uxx98zpLCQRcaDopWxFxjQCtiFUJbFJ26hCdIX6i0CREdEOnGV9ljip-LUCDzV891EZWhydyb8i9U8VvVAKC2Yn65u0WSfRUHIK1tDqgerU-8niry8PRTZdNsRuB6OEW9LJe8pgE-sLm0il7pH\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\"><li><strong>REPLACE: <\/strong>The REPLACE() method, as its name implies, replaces a segment of a text string with another text string. start_num is the index position where you wish to start replacing the characters. num_chars indicate the number of characters you want to replace.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/Az3Ba-_HT8TamvSW-RhZQmP7BQvG-nyHoA_WQegTcfZdcZHRwikLjgwg0s1RKOARMpika4zl_uJJLV5tqcR7hespIQsasqP_Rw3tjxEIddFiHKZ_m_JuSiVIMkB6aognsuVHnsuvfer8TDlKbEJs-UgAFONKv3wPJBdilAbrD0V__ldZOPvgYEwU\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\"><li><strong>SUMIF and COUNTIF:<\/strong> The SUMIF and COUNTIF function sum up or count the number of values when a set of criteria is met. Both functions search the range of arguments for the condition specified in the criteria parameters. The SUMIF function contains an optional argument entitled sum range that is used if the sum values and search values are in different ranges. The criterion argument can be set for logical circumstances such as equal, not equal, greater than, equal to or greater than, lesser than, and equal to or lesser than. For the equal to condition, you can use a static value or a cell reference, and operators for the others. For example &#8220;&gt;&#8221;&amp;C5 should be the criteria parameter for looking for values &#8220;greater than the value of C5 cell.&#8221;<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/sSOM4ePHeSoEgtW8FMB1VYb3Jqrq8WUlBEY6AxbL2SfkCE-tlKAxtuU2ftI1YeyRGFitUcushJ2PULGTYRUFA7gq3O31XBxYSYamxDWzxitM-1YHACz2_OSu2D1_wC9Hl7JfkXOqYHqBpXNVYrGL_VVDHL4Ew7d87ff-omOzor7RV-mWmfjv8DiK\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"9\"><li><strong>RIGHT, LEFT, MID: <\/strong>These are Excel&#8217;s fundamental text functions for extracting specific sections of text. Text is the first argument for all functions. While the RIGHT and LEFT functions each have an extra parameter to specify the number of characters (num bytes) to include, the MID function has two extra arguments to specify where the characters (start num) begin and how many characters (num bytes) to extract.<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax:&nbsp;<\/strong><\/li><\/ul>\n\n\n\n<p>LEFT(text, [num_chars])<\/p>\n\n\n\n<p>RIGHT(text, [num_chars])<\/p>\n\n\n\n<p>MID(text, start_num, num_chars)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/SXYjvTbEQV-CLM9vHmPgX2M2cqj4d7MIMw0dGerFBIcjqtJ87WqHOyVFs-SjcvSOsOyo_R53IXXtqvzYp9XyUwNfvZVt533GZxydX6wmPkb5FghhY06gXMkYcrbb_NOz2zDBAhAKSgnBXS701oIIrWVCTuzQuI8XKp2J-lAerTi3PazdHa9LSSG6\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"10\"><li><strong>ROUND: <\/strong>The ROUND function allows you to alter the decimal component of a numeric number. There are two arguments required. The first is the numerical value itself (number). This can be a static number or a cell reference, as is typical. The number of decimals to round to is specified by the second option (num digits).<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Syntax: <\/strong>ROUND(number, num_digits)<\/li><\/ul>\n\n\n\n<ol class=\"wp-block-list\" start=\"11\"><li><strong>COUNT: <\/strong>COUNT() returns the total number of cells in a number-filled range. It rejects blank cells and cells with data in any format other than numeric. If you need to count all the cells with numerical values, text, or any other data format, use the COUNTA() function. COUNTA(), on the other hand, does not include any blank cells in its calculations.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/yxDorBq64wzcvFtiBPRQv5nqDgp6lwVgu4j3NenOGx9L3dhU88Yy5P9I_23J4VuGXtEuQM_Q-6LOis39qR90am48YDcTi0OHErstLSlgLBq08FW0BGeEjRw8gsc9UDmGnCeqo57-3tUdIxmFgemcbygGVqhyxrg1Sb_GLUdeVkiVeNpiKlohqhFU\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"12\"><li><strong>POWER: <\/strong>The method &#8220;Power()&#8221; returns the result of increasing an integer to a specified power.&nbsp;<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/h3wTGuF9lFfAhrsg5i4JkBUrjgC7inbQUxaLP9tF7Kvwbe-lK86RbjzxNYpQlZBokzXKKmQTM1VVRDzyvxHlBibiBxmG2jOixy1cKEEuJn8hZrlJ6PhIRY0cy9Z-uYzY73AcyZEuFVGT7Dbf74iAHNU7K9DhNTOpvo3MiJNLUPVGNjwzrRDwlWRM\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"13\"><li><strong>CEILING: <\/strong>A value is rounded to the next significant multiple via the CEILING() function.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/w_EOp__xieZ0uK2NdyXL7bjubHxKFBVL0MeBjflu5hrGcJ6cTUx1ZVkhfOgiHwwUSJF6RiVZVSf-oDNoOatJOM54pzmzhsd-YnHvDViMFUHuS7sE4TGSqsKrAA1P7G4x5hjlWzS6KRvpyZpA7kr-DqywewrVdWp5Ut-OG2Og0r4vuas0vIvpbFkS\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"14\"><li><strong>FLOOR: <\/strong>Unlike the ceiling function, the floor function rounds an integer to the next significant multiple.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/ia2JJnh_IeBUk6PLfV3INHd2T88bUnOzt1Ztwhvbao3NXYumeJECdPlg86jULiJm_ubg2GQO2jkl2nJFZmUsfO0d-pIzuQ1PNTikz-YzL-45LSDMCmy8lsSVBme6JIbYJLo5E-9iyNYHTzYlkywTRQwBn0TFUlsdl0dhteibMo56fpAWjaQKtVwC\" alt=\"\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"15\"><li><strong>CONCATENATE: <\/strong>This function joins or combines several text strings into one.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/bdWPip1RBeRILs9VBYf-irx1urX6Y9B7x-LfY_Y9wOz6RgE6RK-XYhNvyn9DsycGdW7zHTdJknSufpqRviMTpATyN6EMnC4oZGvLyfPHpPmVx0BkvP178TO790h2u_5s9aRjvVJwHjr6mA3xI1b3i0GQkVCzLOfLxuTCcG7tWiYgwtpWIawge2w5\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Final Thought: <\/strong>There are a plethora of excel formulae available. However, not all of them are essential. The list above is good enough. Youtube is a good place to start if you want to learn more. One problem you&#8217;ll have with YouTube is deciding where to begin. Use <a href=\"https:\/\/careerninja.in\/\">Career Ninja<\/a>&#8216;s <a href=\"https:\/\/app.learntube.ai\/\">Learn Tube<\/a> chrome addon, which is free. From the first to the final video, the extension will show you. You don&#8217;t have to click all over the place. Remember to use the formulas and practice them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel functions can help you get more done in your day-to-day office activities. Even while Microsoft Excel offers hundreds of formulas, most users only use a few of them, and you&#8217;ll probably never need to use the majority of them. That\u2019s why in this blog we\u2019ve put together some of Excel&#8217;s most innovative and practical [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1551,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[74,112],"tags":[],"class_list":{"0":"post-1550","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-business-finance","8":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>10 Basic Excel Functions Everyone Should Know - Learn Tube<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"10 Basic Excel Functions Everyone Should Know - Learn Tube\" \/>\n<meta property=\"og:description\" content=\"Excel functions can help you get more done in your day-to-day office activities. Even while Microsoft Excel offers hundreds of formulas, most users only use a few of them, and you&#8217;ll probably never need to use the majority of them. That\u2019s why in this blog we\u2019ve put together some of Excel&#8217;s most innovative and practical [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Tube\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CareerNinjaIndia\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-17T06:34:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-13T05:35:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png\" \/>\n\t<meta property=\"og:image:width\" content=\"812\" \/>\n\t<meta property=\"og:image:height\" content=\"447\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Team LearnTube\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Team LearnTube\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\"},\"author\":{\"name\":\"Team LearnTube\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07\"},\"headline\":\"10 Basic Excel Functions Everyone Should Know\",\"datePublished\":\"2022-09-17T06:34:04+00:00\",\"dateModified\":\"2022-10-13T05:35:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\"},\"wordCount\":924,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\"},\"articleSection\":[\"Business &amp; Finance\",\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\",\"url\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\",\"name\":\"10 Basic Excel Functions Everyone Should Know - Learn Tube\",\"isPartOf\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#website\"},\"datePublished\":\"2022-09-17T06:34:04+00:00\",\"dateModified\":\"2022-10-13T05:35:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learntube.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"10 Basic Excel Functions Everyone Should Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learntube.ai\/blog\/#website\",\"url\":\"https:\/\/learntube.ai\/blog\/\",\"name\":\"LearnTube\",\"description\":\"10000+ Free Courses with Free Certification and doubt solving -\",\"publisher\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learntube.ai\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\",\"name\":\"LearnTube\",\"url\":\"https:\/\/learntube.ai\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png\",\"contentUrl\":\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png\",\"width\":3000,\"height\":742,\"caption\":\"LearnTube\"},\"image\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/CareerNinjaIndia\/\",\"https:\/\/www.instagram.com\/careerninjaindia\/\",\"https:\/\/www.linkedin.com\/company\/careerninja\/\",\"https:\/\/www.youtube.com\/c\/CareerNinja\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07\",\"name\":\"Team LearnTube\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g\",\"caption\":\"Team LearnTube\"},\"sameAs\":[\"https:\/\/learntube.ai\/blog\"],\"url\":\"https:\/\/learntube.ai\/blog\/author\/team-learntube\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"10 Basic Excel Functions Everyone Should Know - Learn Tube","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:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/","og_locale":"en_US","og_type":"article","og_title":"10 Basic Excel Functions Everyone Should Know - Learn Tube","og_description":"Excel functions can help you get more done in your day-to-day office activities. Even while Microsoft Excel offers hundreds of formulas, most users only use a few of them, and you&#8217;ll probably never need to use the majority of them. That\u2019s why in this blog we\u2019ve put together some of Excel&#8217;s most innovative and practical [&hellip;]","og_url":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/","og_site_name":"Learn Tube","article_publisher":"https:\/\/www.facebook.com\/CareerNinjaIndia\/","article_published_time":"2022-09-17T06:34:04+00:00","article_modified_time":"2022-10-13T05:35:10+00:00","og_image":[{"width":812,"height":447,"url":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png","type":"image\/png"}],"author":"Team LearnTube","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Team LearnTube","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#article","isPartOf":{"@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/"},"author":{"name":"Team LearnTube","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07"},"headline":"10 Basic Excel Functions Everyone Should Know","datePublished":"2022-09-17T06:34:04+00:00","dateModified":"2022-10-13T05:35:10+00:00","mainEntityOfPage":{"@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/"},"wordCount":924,"commentCount":0,"publisher":{"@id":"https:\/\/learntube.ai\/blog\/#organization"},"articleSection":["Business &amp; Finance","Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/","url":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/","name":"10 Basic Excel Functions Everyone Should Know - Learn Tube","isPartOf":{"@id":"https:\/\/learntube.ai\/blog\/#website"},"datePublished":"2022-09-17T06:34:04+00:00","dateModified":"2022-10-13T05:35:10+00:00","breadcrumb":{"@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learntube.ai\/blog\/business-finance\/10-basic-excel-functions-everyone-should-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learntube.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"10 Basic Excel Functions Everyone Should Know"}]},{"@type":"WebSite","@id":"https:\/\/learntube.ai\/blog\/#website","url":"https:\/\/learntube.ai\/blog\/","name":"LearnTube","description":"10000+ Free Courses with Free Certification and doubt solving -","publisher":{"@id":"https:\/\/learntube.ai\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learntube.ai\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/learntube.ai\/blog\/#organization","name":"LearnTube","url":"https:\/\/learntube.ai\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png","contentUrl":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png","width":3000,"height":742,"caption":"LearnTube"},"image":{"@id":"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CareerNinjaIndia\/","https:\/\/www.instagram.com\/careerninjaindia\/","https:\/\/www.linkedin.com\/company\/careerninja\/","https:\/\/www.youtube.com\/c\/CareerNinja"]},{"@type":"Person","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07","name":"Team LearnTube","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g","caption":"Team LearnTube"},"sameAs":["https:\/\/learntube.ai\/blog"],"url":"https:\/\/learntube.ai\/blog\/author\/team-learntube\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",812,447,false],"thumbnail":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-150x150.png",150,150,true],"medium":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-300x165.png",300,165,true],"medium_large":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-768x423.png",696,383,true],"large":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",696,383,false],"1536x1536":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",812,447,false],"2048x2048":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",812,447,false],"td_218x150":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-218x150.png",218,150,true],"td_324x400":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-324x400.png",324,400,true],"td_485x360":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-485x360.png",485,360,true],"td_696x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-696x383.png",696,383,true],"td_1068x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",812,447,false],"td_1920x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436.png",812,447,false],"td_324x235":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/09\/Screenshot-2022-09-17-120436-324x235.png",324,235,true]},"uagb_author_info":{"display_name":"Team LearnTube","author_link":"https:\/\/learntube.ai\/blog\/author\/team-learntube\/"},"uagb_comment_info":0,"uagb_excerpt":"Excel functions can help you get more done in your day-to-day office activities. Even while Microsoft Excel offers hundreds of formulas, most users only use a few of them, and you&#8217;ll probably never need to use the majority of them. That\u2019s why in this blog we\u2019ve put together some of Excel&#8217;s most innovative and practical&hellip;","_links":{"self":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":1,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/1550\/revisions"}],"predecessor-version":[{"id":1552,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/1550\/revisions\/1552"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/media\/1551"}],"wp:attachment":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/media?parent=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/categories?post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/tags?post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}