{"id":39217,"date":"2023-08-07T12:37:42","date_gmt":"2023-08-07T12:37:42","guid":{"rendered":"http:\/\/104.211.25.86:7097\/basic-excel-functions-long-division\/"},"modified":"2023-08-07T12:37:42","modified_gmt":"2023-08-07T12:37:42","slug":"basic-excel-functions-long-division","status":"publish","type":"post","link":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/","title":{"rendered":"Basic Excel Functions: No More Long Division!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Welcome to this week\u2019s Tip of the Week! If you\u2019ve missed our previous Tips of the Week, be sure to check them out <a href=\"\/staging\/category\/tip-of-the-week\/\"><span style=\"text-decoration: underline;\">here<\/span><\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have to confess something right off the bat: I never learned long division. When I was in elementary school, and then when taking standardized tests in later years, I would always use trial and error and my knowledge of multiplication, addition, and subtraction to work around my flaw. Did I make things harder on myself? Certainly. Do I regret not putting in the time to learn it? Somewhat, yes, but with my handy TI- 83, I felt unstoppable. These days, I view this lack of knowledge as a combination of me being lazy and me being efficient. Why should I learn long division when I have a calculator on my phone and my computer, and most importantly, when I have Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I use Excel all the time for calculations both simple and complex and it saves me an incredible amount of time. In this post, I\u2019m going to go over some of the simplest Excel functions (and one advanced one) that will save you time and many a headache. These functions are the ones that I use most often, and are the ones that I believe are the most relevant to the translation industry. If you disagree, or use other functions regularly, let me know!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. Addition<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The SUM function in Excel is an easy one to memorize and is used to add together numbers in multiple cells. An example of where I would use this function would be a project involving two separate translators, Translator A and Translator B. We owe Translator A $45.50 and we owe Translator B $56.79. If we had the money we owed Translator A in cell A1 and the money we owed Translator B in cell A2, we could use the SUM function to determine the total amount of money we owed the translators for this project.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=(A1+A2)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10945\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/1-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Hit enter and boom! We owe them $102.29.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10948\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/2-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">What if we have multiple rows or columns and we want to apply the same function to all of them at once? Typing out the same function over and over again sounds way too tedious for me, and luckily for us, Excel makes it easy to apply the same function to multiple cells. You can do this by selecting the bottom right corner of the cell you want to copy and dragging it across the cells to which you want to copy it. In the below screenshots you can see that I have dragged the screenshots over using my mouse.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10949\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/3-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">And here is the final result!<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10950\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/4-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">While I will only be doing this for the addition function, you can apply this same technique to drag functions across multiple cells for any function in Excel!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. Subtraction<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">What if instead, cell A2 denoted how much our client was paying us for the translation and cell A1 denoted how much we were paying the translator? This time, we\u2019ll use a function to subtract one cell from another:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(A2-A1)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10951\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/5-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Which returns\u2026 $11.29.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10953\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/6-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. Multiplication<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This time let\u2019s imagine that cell A1 denotes your interpretation rate (say $50\/hr) and A2 denotes the number of hours you worked on a specific assignment (5.75 or 5 hours 45 minutes). With the multiplication function you can automatically calculate the amount that you are owed!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=(A1*A2)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10954\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/7-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Congrats, you just made $287.50!<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"300\" height=\"161\" class=\"wp-image-10955\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/8-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. Division<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Finally, we come to my good friend division. Let\u2019s pretend that you receive a 13,548 word translation project (cell A1) and are asked to give your client a turnaround time. You know that you can translate 2500 words\/day (cell A2), how many days will it take you?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=(A1\/A2)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10956\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/9-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Hit enter and you know how many days to quote, about 5 \u00bd.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10957\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/10-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5. \u00a0Expert bonus: word counts in Excel<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Say you receive a new translation in Excel. Now, if you aren\u2019t using a word count software (and even if you are since you won\u2019t necessarily be translating every cell), you may be asking yourself, how do I get an accurate word count? Before answering, I just want to say, I\u2019m sorry; this function is not easy and not intuitive. I don\u2019t have it memorized and I expect that few people do. I would definitely recommend copy\/pasting this one (do you remember the <span style=\"text-decoration: underline;\">shortcut keys<\/span>?).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,&#8221; &#8220;,&#8221;&#8221;))+1)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Wow, that\u2019s a lot, so I\u2019ll try to break the process down. I won\u2019t get too technical, but instead will explain what each part of the function is doing.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first thing to look at is the \u201cA1\u201d that appears throughout the function. This specifies the cell that is being analyzed, if you want the word count of another cell, just plug the other cell in instead (e.g. A2).<\/li>\n\n\n\n<li>The first part, IF(LEN(TRIM(A1))=0,0, determines if the cell is empty, and if it is, it returns \u201c0.\u201d<\/li>\n\n\n\n<li>The second part, LEN(TRIM(A1)), says that if the cell isn\u2019t empty, count the number of characters in that cell. Think of this as value \u201cA.\u201d Note that this value includes spaces in the cell.<\/li>\n\n\n\n<li>The third part, -LEN(SUBSTITUTE(A1,&#8221; &#8220;,&#8221;&#8221;)), removes the spaces and then counts the characters again. Think of this as value \u201cB.\u201d Then, the function does the calculation \u201cA &#8211; B.\u201d<\/li>\n\n\n\n<li>Finally, the \u201c+1\u201d adds one word to adjust for the first word.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re like me, you need to see some examples before you truly understand it, so here we go.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Imagine a cell (A1) that contains the following: \u201cMy name is Nathanael Burt.\u201d Part one would determine that the cell is not empty, so we move on. Part two determines that the number of characters is 26, so, A = 26. Part three determines that the number of characters (without spaces) is 22, so, B = 22. Then it runs A &#8211; B, which equals 4. Finally, we do the last operation, + 1, to account for the first word and end up with 5, the number of words in cell A1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here are the screenshots from Excel:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" class=\"wp-image-10959\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/11-300x162-300x162-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">And once the function runs\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"300\" height=\"161\" class=\"wp-image-10960\" src=\"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/12-300x161-300x161-1.png\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">I hope these functions (especially the last one, if you made it through) help you see the power of Excel and the amount of time it can save you. This was definitely a long post and we went through a lot, but there was a lot to cover!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do you have a suggestion for a Tip of the Week? Did we miss something in this post? Please let us know on social media or in the comments below!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Welcome to this week\u2019s Tip of the Week! If you\u2019ve missed our previous Tips of the Week, be sure to check them out <a href=\"\/staging\/category\/tip-of-the-week\/\"><span style=\"text-decoration: underline;\"><span style=\"color: #0070c0;\">here<\/span><\/span><\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have to confess something right off the bat: I never learned long division. When I was in elementary school, and then when taking standardized tests in later years, I would always use trial and error and my knowledge of multiplication, addition, and subtraction to work around my flaw. Did I make things harder on myself? Certainly. Do I regret not putting in the time to learn it? Somewhat, yes, but with my handy TI- 83, I felt unstoppable. These days, I view this lack of knowledge as a combination of me being lazy and me being efficient. Why should I learn long division when I have a calculator on my phone and my computer, and most importantly, when I have Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I use Excel all the time for calculations both simple and complex and it saves me an incredible amount of time. In this post, I\u2019m going to go over some of the simplest Excel functions (and one advanced one) that will save you time and many a headache. These functions are the ones that I use most often, and are the ones that I believe are the most relevant to the translation industry. If you disagree, or use other functions regularly, let me know!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Addition<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The SUM function in Excel is an easy one to memorize and is used to add together numbers in multiple cells. An example of where I would use this function would be a project involving two separate translators, Translator A and Translator B. We owe Translator A $45.50 and we owe Translator B $56.79. If we had the money we owed Translator A in cell A1 and the money we owed Translator B in cell A2, we could use the SUM function to determine the total amount of money we owed the translators for this project.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman','serif'; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\">=(A1+A2)<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to this week\u2019s Tip of the Week! If you\u2019ve missed our previous Tips of the Week, be sure to check them out here. I have to confess something right off the bat: I never learned long division. When I was in elementary school, and then when taking standardized tests in later years, I would [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[390],"tags":[95],"class_list":["post-39217","post","type-post","status-publish","format-standard","hentry","category-tip-of-the-week","tag-basic-excel-function"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence<\/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:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence\" \/>\n<meta property=\"og:description\" content=\"Welcome to this week\u2019s Tip of the Week! If you\u2019ve missed our previous Tips of the Week, be sure to check them out here. I have to confess something right off the bat: I never learned long division. When I was in elementary school, and then when taking standardized tests in later years, I would [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/\" \/>\n<meta property=\"og:site_name\" content=\"Translation &amp; Interpreting Services | Translation Excellence\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-07T12:37:42+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#\\\/schema\\\/person\\\/dfb90104da031da49902a6621c1cd90a\"},\"headline\":\"Basic Excel Functions: No More Long Division!\",\"datePublished\":\"2023-08-07T12:37:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/\"},\"wordCount\":1430,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/1-300x162-300x162-1.png\",\"keywords\":[\"Basic Excel Function\"],\"articleSection\":[\"Tip of the Week\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/\",\"url\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/\",\"name\":\"Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/1-300x162-300x162-1.png\",\"datePublished\":\"2023-08-07T12:37:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/basic-excel-functions-long-division\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Basic Excel Functions: No More Long Division!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#website\",\"url\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/\",\"name\":\"Translation &amp; Interpreting Services | Translation Excellence\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#organization\",\"name\":\"Translation &amp; Interpreting Services | Translation Excellence\",\"url\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Logo.png\",\"contentUrl\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Logo.png\",\"width\":210,\"height\":61,\"caption\":\"Translation &amp; Interpreting Services | Translation Excellence\"},\"image\":{\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/#\\\/schema\\\/person\\\/dfb90104da031da49902a6621c1cd90a\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/translationexcellence.com\\\/staging\"],\"url\":\"https:\\\/\\\/translationexcellence.com\\\/staging\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence","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:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/","og_locale":"en_US","og_type":"article","og_title":"Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence","og_description":"Welcome to this week\u2019s Tip of the Week! If you\u2019ve missed our previous Tips of the Week, be sure to check them out here. I have to confess something right off the bat: I never learned long division. When I was in elementary school, and then when taking standardized tests in later years, I would [&hellip;]","og_url":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/","og_site_name":"Translation &amp; Interpreting Services | Translation Excellence","article_published_time":"2023-08-07T12:37:42+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#article","isPartOf":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/"},"author":{"name":"admin","@id":"https:\/\/translationexcellence.com\/staging\/#\/schema\/person\/dfb90104da031da49902a6621c1cd90a"},"headline":"Basic Excel Functions: No More Long Division!","datePublished":"2023-08-07T12:37:42+00:00","mainEntityOfPage":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/"},"wordCount":1430,"commentCount":0,"publisher":{"@id":"https:\/\/translationexcellence.com\/staging\/#organization"},"image":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#primaryimage"},"thumbnailUrl":"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/1-300x162-300x162-1.png","keywords":["Basic Excel Function"],"articleSection":["Tip of the Week"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/","url":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/","name":"Basic Excel Functions: No More Long Division! - Translation &amp; Interpreting Services | Translation Excellence","isPartOf":{"@id":"https:\/\/translationexcellence.com\/staging\/#website"},"primaryImageOfPage":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#primaryimage"},"image":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#primaryimage"},"thumbnailUrl":"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2023\/08\/1-300x162-300x162-1.png","datePublished":"2023-08-07T12:37:42+00:00","breadcrumb":{"@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/translationexcellence.com\/staging\/basic-excel-functions-long-division\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/translationexcellence.com\/staging\/"},{"@type":"ListItem","position":2,"name":"Basic Excel Functions: No More Long Division!"}]},{"@type":"WebSite","@id":"https:\/\/translationexcellence.com\/staging\/#website","url":"https:\/\/translationexcellence.com\/staging\/","name":"Translation &amp; Interpreting Services | Translation Excellence","description":"","publisher":{"@id":"https:\/\/translationexcellence.com\/staging\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/translationexcellence.com\/staging\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/translationexcellence.com\/staging\/#organization","name":"Translation &amp; Interpreting Services | Translation Excellence","url":"https:\/\/translationexcellence.com\/staging\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/translationexcellence.com\/staging\/#\/schema\/logo\/image\/","url":"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2025\/12\/Logo.png","contentUrl":"https:\/\/translationexcellence.com\/staging\/wp-content\/uploads\/2025\/12\/Logo.png","width":210,"height":61,"caption":"Translation &amp; Interpreting Services | Translation Excellence"},"image":{"@id":"https:\/\/translationexcellence.com\/staging\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/translationexcellence.com\/staging\/#\/schema\/person\/dfb90104da031da49902a6621c1cd90a","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b1892a0f9fb66e6caef4fa74461bdbc10cbb2295f2dce5fe3828abc24a0a75ed?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/translationexcellence.com\/staging"],"url":"https:\/\/translationexcellence.com\/staging\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/posts\/39217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/comments?post=39217"}],"version-history":[{"count":0,"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/posts\/39217\/revisions"}],"wp:attachment":[{"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/media?parent=39217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/categories?post=39217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/translationexcellence.com\/staging\/wp-json\/wp\/v2\/tags?post=39217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}