{"id":15,"date":"2015-08-26T16:33:24","date_gmt":"2015-08-26T16:33:24","guid":{"rendered":"http:\/\/99excel.com\/?page_id=15"},"modified":"2015-08-26T16:33:24","modified_gmt":"2015-08-26T16:33:24","slug":"excel-vba-mis-training","status":"publish","type":"page","link":"https:\/\/99excel.com\/home\/excel-vba-mis-training\/","title":{"rendered":"Excel VBA MIS Training"},"content":{"rendered":"<h2><span style=\"color: #000000;\">EXCEL DASHBOARD &amp; DATA ANALYSIS &#8211; \u00a0COURSE OUTLINE<\/span><\/h2>\n<p>&nbsp;<\/p>\n<ul>\n<li>Data summarization with Pivot Table Charts<\/li>\n<li>Extranal Pivot Power Pivot<\/li>\n<li>Logical formulas<\/li>\n<li>Data Summarization with Formulas Database Information with formula<\/li>\n<li>Macros VBA Macros Fundamenta<\/li>\n<li>VBA Codes Concept Workbooks Calling Worksheet Sheet Calling Range Calling\n<div class=\"box3\"><\/div>\n<\/li>\n<\/ul>\n<h2><\/h2>\n<h2><span style=\"color: #000000;\">LEARN IN DASHBOARD &amp; REPORTING<\/span><\/h2>\n<p><strong>DVANCED FORMULAS<\/strong><\/p>\n<p>Advanced Lookup Method<\/p>\n<p>Data Summrication with Formulas<\/p>\n<p>Array Formulas<\/p>\n<p>Dynamic Chart for Dashboard<\/p>\n<p>&nbsp;<\/p>\n<p><strong>INDRODUCTION OF VBA FOR DASHBOARD<\/strong><\/p>\n<p>VBA Code Concept<\/p>\n<p>Event Code Concept<\/p>\n<p>Charts &amp; Button use of Chart<\/p>\n<p>&nbsp;<\/p>\n<p><strong>DASHBOARD WITH EXCEL 2007-13 PIVOT<\/strong><\/p>\n<p>Data Summrization with Pivot<\/p>\n<p>Calculation with Pivot Table<\/p>\n<p>Extranal Pivot Table<\/p>\n<p>VBA Pivot Report Automation<\/p>\n<p>SAMPLE REPORTING ON EXCEL DASHBOARD<\/p>\n<p>Learn More then 10 Sample Dashboard Creation<\/p>\n<p>&nbsp;<\/p>\n<article id=\"content\"><\/article>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>EXCEL DASHBOARD &amp; DATA ANALYSIS &#8211; \u00a0COURSE OUTLINE &nbsp; Data summarization with Pivot Table Charts Extranal Pivot Power Pivot Logical formulas Data Summarization with Formulas Database Information with formula Macros VBA Macros Fundamenta VBA Codes Concept Workbooks Calling Worksheet Sheet Calling Range Calling LEARN IN DASHBOARD &amp; REPORTING DVANCED FORMULAS Advanced Lookup Method Data Summrication &#8230; <a title=\"Excel VBA MIS Training\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/excel-vba-mis-training\/\" aria-label=\"More on Excel VBA MIS Training\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-15","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/pages\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}