{"id":385,"date":"2022-12-29T14:05:26","date_gmt":"2022-12-29T14:05:26","guid":{"rendered":"http:\/\/bncisirsa.com\/?page_id=385"},"modified":"2023-01-05T14:24:46","modified_gmt":"2023-01-05T14:24:46","slug":"corporate-advance-excel","status":"publish","type":"page","link":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/","title":{"rendered":"Corporate Advance EXCEL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"385\" class=\"elementor elementor-385\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a045dd3 elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"a045dd3\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d3b1f4\" data-id=\"1d3b1f4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-28c5ccb elementor-widget elementor-widget-heading\" data-id=\"28c5ccb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Corporate Advance EXCEL<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7b8281f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7b8281f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5935d50 animated-slow elementor-invisible\" data-id=\"5935d50\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;animation&quot;:&quot;fadeInLeft&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-542fa69 elementor-widget elementor-widget-heading\" data-id=\"542fa69\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Advanced Excel Course <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c891c80 elementor-widget elementor-widget-text-editor\" data-id=\"c891c80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>During this Advanced Excel Course, participants will learn how to perform complex calculations more efficiently using various Excel functions. They should also be trained in organizing and analyzing large amounts of data. Furthermore, the student will learn how to create MIS reports in Excel, design and use templates, and consolidate and manage data from multiple workbooks. Microsoft Office Specialist Certification in Excel is awarded upon completion of this course.<\/p><p><strong>Advanced Excel Formulas &amp; Functions Course Content<\/strong><\/p><p>This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-39afe73 animated-slow elementor-invisible\" data-id=\"39afe73\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;animation&quot;:&quot;fadeInRight&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b39598 elementor-widget elementor-widget-image\" data-id=\"0b39598\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"700\" height=\"600\" src=\"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png\" class=\"attachment-large size-large wp-image-498\" alt=\"\" srcset=\"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png 700w, https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1-300x257.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-84e1ed5 animated-slow elementor-section-boxed elementor-section-height-default elementor-section-height-default elementor-invisible\" data-id=\"84e1ed5\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;fadeIn&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7a41340\" data-id=\"7a41340\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-adff434 elementor-widget elementor-widget-text-editor\" data-id=\"adff434\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>The main formulas &amp; functions covered in this training course include:<\/strong><\/p><ul><li>INDEX and MATCH<\/li><li>IF with AND \/ OR<\/li><li>OFFSET is combined with other functions<\/li><li>CHOOSE for creating scenarios<\/li><li>INDIRECT combined with other functions<\/li><li>XNPV and XIRR<\/li><li>CELL, COUNTA, and MID functions combined together<\/li><li>PMT, IPMT, and principal payment calculations<\/li><li>The main types of data analysis in this advanced tutorial include:<\/li><li>Data tables<\/li><li>Pivot tables<\/li><li>Column and line charts<\/li><li>Stacked column charts<\/li><li>Waterfall charts<\/li><li>Gauge charts Etc<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-f03fa9f\" data-id=\"f03fa9f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Corporate Advance EXCEL Advanced Excel Course During this Advanced Excel Course, participants will learn how to perform complex calculations more efficiently using various Excel functions. They should also be trained in organizing and analyzing large amounts of data. Furthermore, the student will learn how to create MIS reports in Excel, design and use templates, and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-385","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Corporate Advance EXCEL - Bhagwati National Computer Institute<\/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:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Corporate Advance EXCEL - Bhagwati National Computer Institute\" \/>\n<meta property=\"og:description\" content=\"Corporate Advance EXCEL Advanced Excel Course During this Advanced Excel Course, participants will learn how to perform complex calculations more efficiently using various Excel functions. They should also be trained in organizing and analyzing large amounts of data. Furthermore, the student will learn how to create MIS reports in Excel, design and use templates, and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Bhagwati National Computer Institute\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bhagwatinationalcomputerinstitute\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-05T14:24:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/\",\"url\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/\",\"name\":\"Corporate Advance EXCEL - Bhagwati National Computer Institute\",\"isPartOf\":{\"@id\":\"https:\/\/bncisirsa.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png\",\"datePublished\":\"2022-12-29T14:05:26+00:00\",\"dateModified\":\"2023-01-05T14:24:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage\",\"url\":\"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png\",\"contentUrl\":\"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png\",\"width\":700,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bncisirsa.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Corporate Advance EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bncisirsa.com\/#website\",\"url\":\"https:\/\/bncisirsa.com\/\",\"name\":\"Bhagwati National Computer Institute\",\"description\":\"Best Computer Institute in Sirsa\",\"publisher\":{\"@id\":\"https:\/\/bncisirsa.com\/#organization\"},\"alternateName\":\"Telly Institute in Sirsa\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bncisirsa.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bncisirsa.com\/#organization\",\"name\":\"Bhagwati National Computer Institute\",\"url\":\"https:\/\/bncisirsa.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bncisirsa.com\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/bncisirsa.com\/wp-content\/uploads\/2023\/01\/Untitled-design-4-1.png\",\"contentUrl\":\"http:\/\/bncisirsa.com\/wp-content\/uploads\/2023\/01\/Untitled-design-4-1.png\",\"width\":500,\"height\":500,\"caption\":\"Bhagwati National Computer Institute\"},\"image\":{\"@id\":\"https:\/\/bncisirsa.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/bhagwatinationalcomputerinstitute\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Corporate Advance EXCEL - Bhagwati National Computer Institute","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:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/","og_locale":"en_US","og_type":"article","og_title":"Corporate Advance EXCEL - Bhagwati National Computer Institute","og_description":"Corporate Advance EXCEL Advanced Excel Course During this Advanced Excel Course, participants will learn how to perform complex calculations more efficiently using various Excel functions. They should also be trained in organizing and analyzing large amounts of data. Furthermore, the student will learn how to create MIS reports in Excel, design and use templates, and [&hellip;]","og_url":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/","og_site_name":"Bhagwati National Computer Institute","article_publisher":"https:\/\/www.facebook.com\/bhagwatinationalcomputerinstitute\/","article_modified_time":"2023-01-05T14:24:46+00:00","og_image":[{"url":"http:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/","url":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/","name":"Corporate Advance EXCEL - Bhagwati National Computer Institute","isPartOf":{"@id":"https:\/\/bncisirsa.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage"},"image":{"@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png","datePublished":"2022-12-29T14:05:26+00:00","dateModified":"2023-01-05T14:24:46+00:00","breadcrumb":{"@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#primaryimage","url":"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png","contentUrl":"https:\/\/bncisirsa.com\/wp-content\/uploads\/2022\/12\/Corporate-Advance-EXCEL-1.png","width":700,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/bncisirsa.com\/index.php\/corporate-advance-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bncisirsa.com\/"},{"@type":"ListItem","position":2,"name":"Corporate Advance EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/bncisirsa.com\/#website","url":"https:\/\/bncisirsa.com\/","name":"Bhagwati National Computer Institute","description":"Best Computer Institute in Sirsa","publisher":{"@id":"https:\/\/bncisirsa.com\/#organization"},"alternateName":"Telly Institute in Sirsa","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bncisirsa.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/bncisirsa.com\/#organization","name":"Bhagwati National Computer Institute","url":"https:\/\/bncisirsa.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bncisirsa.com\/#\/schema\/logo\/image\/","url":"http:\/\/bncisirsa.com\/wp-content\/uploads\/2023\/01\/Untitled-design-4-1.png","contentUrl":"http:\/\/bncisirsa.com\/wp-content\/uploads\/2023\/01\/Untitled-design-4-1.png","width":500,"height":500,"caption":"Bhagwati National Computer Institute"},"image":{"@id":"https:\/\/bncisirsa.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/bhagwatinationalcomputerinstitute\/"]}]}},"_links":{"self":[{"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/pages\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/comments?post=385"}],"version-history":[{"count":40,"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/pages\/385\/revisions"}],"predecessor-version":[{"id":1518,"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/pages\/385\/revisions\/1518"}],"wp:attachment":[{"href":"https:\/\/bncisirsa.com\/index.php\/wp-json\/wp\/v2\/media?parent=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}