{"id":3210,"date":"2023-06-14T18:57:06","date_gmt":"2023-06-14T11:57:06","guid":{"rendered":"https:\/\/diringkas.com\/?p=3210"},"modified":"2023-06-14T18:57:07","modified_gmt":"2023-06-14T11:57:07","slug":"5-fungsi-excel-wajib","status":"publish","type":"post","link":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/","title":{"rendered":"5 Microsoft Excel Functions You Must Know"},"content":{"rendered":"\r\n\r\nHello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you.\r\n\r\n\r\n\r\nIn this article, we will discuss 5 functions of Microsoft Excel that you must know and understand. These functions are very useful to help you process data more easily, quickly and accurately. Let&#8217;s see together!\r\n\r\n\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar isi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><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><\/span><\/a><\/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:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#1_SUM_function\" >1. SUM function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#2_IF_function\" >2. IF function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#3_VLOOKUP_function\" >3. VLOOKUP function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#4_COUNTIF_function\" >4. COUNTIF function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#5_CONCATENATE_function\" >5. CONCATENATE function<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_SUM_function\"><\/span>1. SUM function<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\nThe SUM function is the most basic and frequently used function in Excel. This function is used to add up the values in a certain range of cells. For example, if you wanted to add up the sales values from January to March, you could use the formula =SUM(B2:B4), where B2:B4 is the range of cells that contain the sales values. For an example like the image below.\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"720\" height=\"468\" class=\"wp-image-3211 lazyload\" data-src=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel.jpg\" alt=\"\" data-srcset=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel.jpg 720w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel-300x195.jpg 300w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel-150x98.jpg 150w\" data-sizes=\"(max-width: 720px) 100vw, 720px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 720px; --smush-placeholder-aspect-ratio: 720\/468;\" \/><\/figure>\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_IF_function\"><\/span>2. IF function<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\nThe IF function is a function used to create logical conditions in Excel. This function checks whether a condition is met or not, then returns a value that matches the result of that check. For example, if you wanted to determine whether a student passed or failed based on test scores, you could use the formula =IF(C2&gt;=75,&#8221;Pass&#8221;,&#8221;Failed&#8221;), where C2 is the cell containing the test scores and 75 is the grade minimum to pass.\r\n\r\n\r\n\r\nThe IF function can be used with a very broad range of conditions, so please make the most of it and be as creative as possible! Here&#8217;s an example.\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"720\" height=\"468\" class=\"wp-image-3212 lazyload\" data-src=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel2.jpg\" alt=\"\" data-srcset=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel2.jpg 720w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel2-300x195.jpg 300w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excel2-150x98.jpg 150w\" data-sizes=\"(max-width: 720px) 100vw, 720px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 720px; --smush-placeholder-aspect-ratio: 720\/468;\" \/><\/figure>\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_VLOOKUP_function\"><\/span>3. VLOOKUP function<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\nThe VLOOKUP function is a function used to search and retrieve data from a table based on certain criteria. This function is very useful if you have large and complex data, and want to display only certain data. For example, if you have an employee data table that contains name, title, salary, and bonuses, and you want to display the salary and bonuses of a specific employee by name, you can use the formula =VLOOKUP(D2,A2:E10,4,FALSE) , where D2 is the cell containing the name of the employee being searched for, A2:E10 is the range of cells containing the employee data table, 4 is the column number containing the salary, and FALSE is the argument indicating that the search must be exact.\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_COUNTIF_function\"><\/span>4. COUNTIF function<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\nThe COUNTIF function is a function used to count the number of cells that meet certain criteria in a range of cells. This function is useful for analyzing data statistically, such as calculating the number of students who pass, the number of products sold, or the number of satisfied customers. For example, if you wanted to count the number of students who passed a math test, you could use the formula =COUNTIF(C2:C20,&#8221;Pass&#8221;), where C2:C20 is the range of cells that contains the students&#8217; passing status and &#8220;Pass&#8221; is the criteria to look for.\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"720\" height=\"468\" class=\"wp-image-3213 lazyload\" data-src=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelcountif.jpg\" alt=\"\" data-srcset=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelcountif.jpg 720w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelcountif-300x195.jpg 300w, https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelcountif-150x98.jpg 150w\" data-sizes=\"(max-width: 720px) 100vw, 720px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 720px; --smush-placeholder-aspect-ratio: 720\/468;\" \/><\/figure>\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_CONCATENATE_function\"><\/span>5. CONCATENATE function<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\nThe CONCATENATE function is a function used to combine two or more texts into one text. This function is useful for making text more informative and easy to read, such as creating a complete address from a street name, house number, city, and zip code. For example, if you wanted to create a complete address from the data in columns A through D, you could use the formula =CONCATENATE(A2,&#8221; &#8220;,B2,&#8221;, &#8220;,C2,&#8221; &#8220;,D2), where A2:D2 is the range cells that contain address data.\r\n\r\n\r\n\r\nThose are 5 functions of Microsoft Excel that you must know. By learning and mastering these functions, you can increase your productivity and efficiency in processing data using Excel. Hopefully this article is useful and helps you. If you have questions, suggestions or criticism, please write in the comments column below. Thank you for reading this article to the end. See you in the next article!\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must<\/p>\n","protected":false},"author":1,"featured_media":3214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,4],"tags":[2050,262],"class_list":["post-3210","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge","category-technology","tag-excel","tag-teknologi","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>5 Microsoft Excel Functions You Must Know<\/title>\n<meta name=\"description\" content=\"Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you. In&hellip;\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/Hello,%20Diringkas%20friend!%20Do%20you%20often%20use%20Microsoft%20Excel%20in%20your%20work%20or%20daily%20activities?%20If%20yes,%20then%20you%20must%20be%20familiar%20with%20the%20various%20functions%20offered%20by%20this%20data%20processing%20application.%20However,%20if%20you%20are%20still%20a%20beginner%20or%20want%20to%20improve%20your%20skills%20in%20using%20Excel,%20then%20this%20article%20is%20for%20you.%20In&hellip;\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Microsoft Excel Functions You Must Know\" \/>\n<meta property=\"og:description\" content=\"Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you. In&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/\" \/>\n<meta property=\"og:site_name\" content=\"RingRing-Diringkas\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-14T11:57:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T11:57:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vrory\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vrory\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/\"},\"author\":{\"name\":\"Vrory\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/#\\\/schema\\\/person\\\/8f62bda68ac9483eece5601234115798\"},\"headline\":\"5 Microsoft Excel Functions You Must Know\",\"datePublished\":\"2023-06-14T11:57:06+00:00\",\"dateModified\":\"2023-06-14T11:57:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/\"},\"wordCount\":569,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/#\\\/schema\\\/person\\\/8f62bda68ac9483eece5601234115798\"},\"image\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/excelthumb.jpg\",\"keywords\":[\"excel\",\"teknologi\"],\"articleSection\":[\"Knowledge\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/\",\"url\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/\",\"name\":\"5 Fungsi Microsoft Excel yang Wajib Anda Ketahui\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/excelthumb.jpg\",\"datePublished\":\"2023-06-14T11:57:06+00:00\",\"dateModified\":\"2023-06-14T11:57:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#primaryimage\",\"url\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/excelthumb.jpg\",\"contentUrl\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/excelthumb.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/5-function-excel-mandatory\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/diringkas.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Microsoft Excel Functions You Must Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/diringkas.com\\\/en\\\/\",\"name\":\"RingRing-Diringkas\",\"description\":\"Kami meringkas apapun yang Anda cari!\",\"publisher\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/#\\\/schema\\\/person\\\/8f62bda68ac9483eece5601234115798\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/diringkas.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/diringkas.com\\\/en\\\/#\\\/schema\\\/person\\\/8f62bda68ac9483eece5601234115798\",\"name\":\"Vrory\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/sho-byutipul.jpg\",\"url\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/sho-byutipul.jpg\",\"contentUrl\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/sho-byutipul.jpg\",\"width\":736,\"height\":1104,\"caption\":\"Vrory\"},\"logo\":{\"@id\":\"https:\\\/\\\/diringkas.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/sho-byutipul.jpg\"},\"description\":\"Writer and proudly owner of Diringkas.com! I like to Staying up-to-date with the latest tech advancements, playing video games, discovering new games, and writing about them.\",\"sameAs\":[\"https:\\\/\\\/diringkas.com\"],\"url\":\"https:\\\/\\\/diringkas.com\\\/en\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Microsoft Excel Functions You Must Know","description":"Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you. In&hellip;","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":"Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you. In&hellip;","og_locale":"en_US","og_type":"article","og_title":"5 Microsoft Excel Functions You Must Know","og_description":"Hello, Diringkas friend! Do you often use Microsoft Excel in your work or daily activities? If yes, then you must be familiar with the various functions offered by this data processing application. However, if you are still a beginner or want to improve your skills in using Excel, then this article is for you. In&hellip;","og_url":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/","og_site_name":"RingRing-Diringkas","article_published_time":"2023-06-14T11:57:06+00:00","article_modified_time":"2023-06-14T11:57:07+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg","type":"image\/jpeg"}],"author":"Vrory","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vrory","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#article","isPartOf":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/"},"author":{"name":"Vrory","@id":"https:\/\/diringkas.com\/#\/schema\/person\/8f62bda68ac9483eece5601234115798"},"headline":"5 Microsoft Excel Functions You Must Know","datePublished":"2023-06-14T11:57:06+00:00","dateModified":"2023-06-14T11:57:07+00:00","mainEntityOfPage":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/"},"wordCount":569,"commentCount":0,"publisher":{"@id":"https:\/\/diringkas.com\/#\/schema\/person\/8f62bda68ac9483eece5601234115798"},"image":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#primaryimage"},"thumbnailUrl":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg","keywords":["excel","teknologi"],"articleSection":["Knowledge","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/","url":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/","name":"5 Fungsi Microsoft Excel yang Wajib Anda Ketahui","isPartOf":{"@id":"https:\/\/diringkas.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#primaryimage"},"image":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#primaryimage"},"thumbnailUrl":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg","datePublished":"2023-06-14T11:57:06+00:00","dateModified":"2023-06-14T11:57:07+00:00","breadcrumb":{"@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#primaryimage","url":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg","contentUrl":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/06\/excelthumb.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/diringkas.com\/en\/5-function-excel-mandatory\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/diringkas.com\/"},{"@type":"ListItem","position":2,"name":"5 Microsoft Excel Functions You Must Know"}]},{"@type":"WebSite","@id":"https:\/\/diringkas.com\/en\/#website","url":"https:\/\/diringkas.com\/en\/","name":"RingRing-Diringkas","description":"Kami meringkas apapun yang Anda cari!","publisher":{"@id":"https:\/\/diringkas.com\/en\/#\/schema\/person\/8f62bda68ac9483eece5601234115798"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/diringkas.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/diringkas.com\/en\/#\/schema\/person\/8f62bda68ac9483eece5601234115798","name":"Vrory","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/03\/sho-byutipul.jpg","url":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/03\/sho-byutipul.jpg","contentUrl":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/03\/sho-byutipul.jpg","width":736,"height":1104,"caption":"Vrory"},"logo":{"@id":"https:\/\/diringkas.com\/wp-content\/uploads\/2023\/03\/sho-byutipul.jpg"},"description":"Writer and proudly owner of Diringkas.com! I like to Staying up-to-date with the latest tech advancements, playing video games, discovering new games, and writing about them.","sameAs":["https:\/\/diringkas.com"],"url":"https:\/\/diringkas.com\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/posts\/3210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/comments?post=3210"}],"version-history":[{"count":2,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/posts\/3210\/revisions"}],"predecessor-version":[{"id":3227,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/posts\/3210\/revisions\/3227"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/media\/3214"}],"wp:attachment":[{"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/media?parent=3210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/categories?post=3210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diringkas.com\/en\/wp-json\/wp\/v2\/tags?post=3210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}