{"id":4695,"date":"2019-09-30T17:32:19","date_gmt":"2019-09-30T10:32:19","guid":{"rendered":"https:\/\/www.its.ac.id\/dptsi\/?p=4695"},"modified":"2022-07-04T14:24:04","modified_gmt":"2022-07-04T07:24:04","slug":"excel-advanced-training-from-microsoft","status":"publish","type":"post","link":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/","title":{"rendered":"Excel Advanced Training from Microsoft"},"content":{"rendered":"<p>Ms. Excel has been known as a spreadsheet worksheet application program that is very helpful in data defeating and reporting activities because it is equipped with calculations and graphs in the form of numbers with various formulations to automatically process data including basic calculations, use of functions, management data and data creation. Through this training, DPTSI is trained to use Microsoft Excel to improve:<\/p>\n<p>1. Tabular format<br \/>\n2. Cleaning outer<br \/>\n3. V lookup<br \/>\n4. Power pivot<br \/>\n5. Dax soul<br \/>\n6. Mail merge<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium wp-image-4203\" src=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/1-300x201.jpg\" alt=\"\" width=\"300\" height=\"201\" srcset=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/1-300x201.jpg 300w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/1-768x514.jpg 768w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/1-355x238.jpg 355w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/1.jpg 896w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-4204\" src=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-300x201.jpg\" alt=\"\" width=\"300\" height=\"201\" srcset=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-300x201.jpg 300w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-1024x685.jpg 1024w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-768x514.jpg 768w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-1536x1028.jpg 1536w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-2048x1371.jpg 2048w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/2-355x238.jpg 355w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-4205\" src=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-300x201.jpg\" alt=\"\" width=\"300\" height=\"201\" srcset=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-300x201.jpg 300w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-1024x685.jpg 1024w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-768x514.jpg 768w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-1536x1028.jpg 1536w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-2048x1371.jpg 2048w, https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/DSC_0119-355x238.jpg 355w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ms. Excel has been known as a spreadsheet worksheet application program that is very helpful in data defeating and reporting activities because it is equipped with calculations and graphs in the form of numbers with various formulations to automatically process data including basic calculations, use of functions, management data and data creation. Through this training, [&hellip;]<\/p>\n","protected":false},"author":243,"featured_media":4206,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[169],"tags":[356,384],"class_list":["post-4695","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-berita-en","tag-dptsitrainingseries","tag-microsoft-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Advanced Training from Microsoft - DPTSI<\/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:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Advanced Training from Microsoft - DPTSI\" \/>\n<meta property=\"og:description\" content=\"Ms. Excel has been known as a spreadsheet worksheet application program that is very helpful in data defeating and reporting activities because it is equipped with calculations and graphs in the form of numbers with various formulations to automatically process data including basic calculations, use of functions, management data and data creation. Through this training, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\" \/>\n<meta property=\"og:site_name\" content=\"DPTSI\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-30T10:32:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-04T07:24:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ernis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ernis\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\"},\"author\":{\"name\":\"ernis\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd\"},\"headline\":\"Excel Advanced Training from Microsoft\",\"datePublished\":\"2019-09-30T10:32:19+00:00\",\"dateModified\":\"2022-07-04T07:24:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\"},\"wordCount\":81,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg\",\"keywords\":[\"dptsitrainingseries\",\"microsoft\"],\"articleSection\":[\"News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\",\"url\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\",\"name\":\"Excel Advanced Training from Microsoft - DPTSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg\",\"datePublished\":\"2019-09-30T10:32:19+00:00\",\"dateModified\":\"2022-07-04T07:24:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage\",\"url\":\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg\",\"contentUrl\":\"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg\",\"width\":900,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.its.ac.id\/dptsi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Advanced Training from Microsoft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#website\",\"url\":\"https:\/\/www.its.ac.id\/dptsi\/\",\"name\":\"DPTSI\",\"description\":\"Just another Institut Teknologi Sepuluh Nopember Sites site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.its.ac.id\/dptsi\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd\",\"name\":\"ernis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03576ef6a9741548ce0ca854cad1601db017206abf92720a5dc13714aaec8fae?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03576ef6a9741548ce0ca854cad1601db017206abf92720a5dc13714aaec8fae?s=96&d=mm&r=g\",\"caption\":\"ernis\"},\"url\":\"https:\/\/www.its.ac.id\/dptsi\/author\/ernis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Advanced Training from Microsoft - DPTSI","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:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/","og_locale":"en_US","og_type":"article","og_title":"Excel Advanced Training from Microsoft - DPTSI","og_description":"Ms. Excel has been known as a spreadsheet worksheet application program that is very helpful in data defeating and reporting activities because it is equipped with calculations and graphs in the form of numbers with various formulations to automatically process data including basic calculations, use of functions, management data and data creation. Through this training, [&hellip;]","og_url":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/","og_site_name":"DPTSI","article_published_time":"2019-09-30T10:32:19+00:00","article_modified_time":"2022-07-04T07:24:04+00:00","og_image":[{"width":900,"height":900,"url":"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg","type":"image\/jpeg"}],"author":"ernis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ernis"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#article","isPartOf":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/"},"author":{"name":"ernis","@id":"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd"},"headline":"Excel Advanced Training from Microsoft","datePublished":"2019-09-30T10:32:19+00:00","dateModified":"2022-07-04T07:24:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/"},"wordCount":81,"commentCount":0,"image":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage"},"thumbnailUrl":"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg","keywords":["dptsitrainingseries","microsoft"],"articleSection":["News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/","url":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/","name":"Excel Advanced Training from Microsoft - DPTSI","isPartOf":{"@id":"https:\/\/www.its.ac.id\/dptsi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage"},"image":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage"},"thumbnailUrl":"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg","datePublished":"2019-09-30T10:32:19+00:00","dateModified":"2022-07-04T07:24:04+00:00","author":{"@id":"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd"},"breadcrumb":{"@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#primaryimage","url":"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg","contentUrl":"https:\/\/www.its.ac.id\/dptsi\/wp-content\/uploads\/sites\/8\/2019\/10\/kisspng-microsoft-excel-microsoft-office-macos-excel-5ab876b7359026.8945918215220384552194.jpg","width":900,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/www.its.ac.id\/dptsi\/en\/2019\/09\/30\/excel-advanced-training-from-microsoft\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.its.ac.id\/dptsi\/"},{"@type":"ListItem","position":2,"name":"Excel Advanced Training from Microsoft"}]},{"@type":"WebSite","@id":"https:\/\/www.its.ac.id\/dptsi\/#website","url":"https:\/\/www.its.ac.id\/dptsi\/","name":"DPTSI","description":"Just another Institut Teknologi Sepuluh Nopember Sites site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.its.ac.id\/dptsi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/d319d83b8ea507b8c512d6825d9d39bd","name":"ernis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.its.ac.id\/dptsi\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03576ef6a9741548ce0ca854cad1601db017206abf92720a5dc13714aaec8fae?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03576ef6a9741548ce0ca854cad1601db017206abf92720a5dc13714aaec8fae?s=96&d=mm&r=g","caption":"ernis"},"url":"https:\/\/www.its.ac.id\/dptsi\/author\/ernis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/posts\/4695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/users\/243"}],"replies":[{"embeddable":true,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/comments?post=4695"}],"version-history":[{"count":1,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/posts\/4695\/revisions"}],"predecessor-version":[{"id":4697,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/posts\/4695\/revisions\/4697"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/media\/4206"}],"wp:attachment":[{"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/media?parent=4695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/categories?post=4695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.its.ac.id\/dptsi\/wp-json\/wp\/v2\/tags?post=4695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}