{"id":2568,"date":"2019-05-06T18:47:00","date_gmt":"2019-05-06T10:47:00","guid":{"rendered":"http:\/\/mssbizsolutions.com\/?page_id=2568"},"modified":"2019-05-06T19:06:43","modified_gmt":"2019-05-06T11:06:43","slug":"advanced-microsoft-excel-training-philippines","status":"publish","type":"page","link":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/","title":{"rendered":"Advanced Microsoft Excel Training in the Philippines"},"content":{"rendered":"

ADVANCED MICROSOFT EXCEL TRAINING<\/strong><\/span><\/h1>\n

A Two-day Corporate EnterTRAINment on <\/strong>Advanced Microsoft Excel<\/strong><\/span><\/h2>\n

by Ms. Daphnee Solas<\/h3>\n

DAY ONE (1)<\/strong><\/span><\/h3>\n

SESSION ONE (1): QUICK REVIEW OF EXCEL BASIC FUNCTIONS AND FEATURES <\/strong><\/h3>\n

SESSION TWO (2): MANAGING DATA<\/strong><\/h3>\n
    \n
  • Organizing Data<\/li>\n
  • Importing Data from external source<\/li>\n
  • Outlining and Grouping Data<\/li>\n
  • Consolidating Information<\/li>\n
  • Removing Duplicates<\/li>\n
  • Configuring Data Validation<\/li>\n
  • Transposing Data<\/li>\n
  • Converting Text to Columns<\/li>\n<\/ul>\n

    SESSION THREE (3): ADVANCED FORMULA TASKS<\/strong><\/h3>\n
      \n
    • Understanding Relative and Absolute Cell References<\/li>\n
    • Using Multiple Cell References<\/li>\n
    • Using Array Formulas<\/li>\n<\/ul>\n

      SESSION FOUR (4): WORKING WITH NAMED RANGES<\/strong><\/h3>\n
        \n
      • Understanding Named Ranges<\/li>\n
      • Defining Named Ranges<\/li>\n
      • Editing Named Ranges<\/li>\n
      • Deleting Named Ranges<\/li>\n
      • Using Named Ranges in Formulas<\/li>\n<\/ul>\n

        SESSION FIVE (5): USING ADVANCED FUNCTIONS<\/strong><\/h3>\n
          \n
        • PMT Function<\/li>\n
        • FV Function<\/li>\n
        • VLOOKUP and HLOOKUP Functions<\/li>\n
        • IF, AND, OR Functions<\/li>\n
        • TODAY, NOW, DATE and TIME Functions<\/li>\n
        • TRIM Functions<\/li>\n
        • LEN and SUBSTITUTE Functions<\/li>\n
        • LEFT, RIGHT, and MID Functions<\/li>\n
        • CONCATENATE Function<\/li>\n
        • SUMIF, COUNTIF, and AVERAGEIF Functions<\/li>\n
        • NESTED Functions<\/li>\n<\/ul>\n

          SESSION SIX (6): USING CONDITIONAL AND CUSTOM FORMATS<\/strong><\/h3>\n

          SESSION SEVEN (7): RESOLVING FORMULA ERRORS<\/strong><\/h3>\n
            \n
          • Tracing Formula Precedents and Dependents<\/li>\n
          • Showing Formulas<\/li>\n
          • Evaluating Formulas<\/li>\n
          • Setting Error Checking Options<\/li>\n
          • Using Error Option Buttons<\/li>\n
          • Running and Error Check<\/li>\n<\/ul>\n

             <\/p>\n

            DAY TWO (2)<\/strong><\/span><\/h3>\n

            SESSION EIGHT (8): REVIEW OF DAY 1<\/strong><\/h3>\n

            SESSION NINE (9): ADVANCED PIVOT TABLE FEATURES<\/strong><\/h3>\n
              \n
            • Creating Basic Pivot Table<\/li>\n
            • Creating Basic Pivot Chart<\/li>\n
            • Using PivotTable Fields Pane<\/li>\n
            • Adding Calculated Fields<\/li>\n
            • Sorting Pivoted Data<\/li>\n
            • Filtering Pivoted Data<\/li>\n<\/ul>\n

              SESSION TEN (10): SUMMARIZING RESULTS OF CALCULATIONS (WORKING WITH GRAPHICS AND CHARTS)<\/strong><\/h3>\n
                \n
              • Creating charts from data tables and pivot tables<\/li>\n
              • Modifying chart types<\/li>\n
              • Formatting chart properties<\/li>\n
              • Formatting cells<\/li>\n<\/ul>\n

                SESSION ELEVEN (11): DASHBOARDS<\/strong><\/h3>\n
                  \n
                • Creating dashboard<\/li>\n
                • Linking control buttons to worksheets and charts<\/li>\n<\/ul>\n

                  SESSION TWELVE (12): USING MACROS<\/strong><\/h3>\n
                    \n
                  • Recording a Macro<\/li>\n
                  • Editing a Macro<\/li>\n
                  • Running a Macro<\/li>\n<\/ul>\n

                    FINAL SESSION:\u00a0 SHARING AND PROTECTING WORKBOOKS<\/strong><\/h3>\n
                      \n
                    • Co-authoring<\/li>\n
                    • Sharing a workbook<\/li>\n
                    • Protecting a worksheet<\/li>\n
                    • Protecting Cells<\/li>\n
                    • Protecting a Workbook<\/li>\n<\/ul>\n

                       <\/p>\n

                      TRAINING METHODS:<\/strong><\/span><\/h3>\n
                        \n
                      • Interactive Discussions<\/span><\/li>\n
                      • Trainer Demonstrations<\/span><\/li>\n
                      • Hands-on Exercises<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                        ADVANCED MICROSOFT EXCEL TRAINING A Two-day Corporate EnterTRAINment on Advanced Microsoft Excel by Ms. Daphnee Solas DAY ONE (1) SESSION ONE (1): QUICK REVIEW OF EXCEL BASIC FUNCTIONS AND FEATURES […]<\/p>\n","protected":false},"author":2,"featured_media":2570,"parent":2574,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-2568","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nAdvanced Microsoft Excel Training in the Philippines - MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines<\/title>\n<meta name=\"description\" content=\"MSS Business Solutions is an HR Training and Consultancy company in the Philippines that offers outsourced corporate training, public seminars, speakers and trainers bureau, professional motivational and inspirational speaking, human resources consulting, first-line leadership and management mentoring, soft skills coaching, team and team culture building, and corporate event hosting.\" \/>\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.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Microsoft Excel Training in the Philippines\" \/>\n<meta property=\"og:description\" content=\"Are you looking for an Advanced Microsoft Excel Training in the Philippines? Give us a call at (02) 919-2734 or (02) 260-5081 or email us at info@mssbizsolutions.com\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/\" \/>\n<meta property=\"og:site_name\" content=\"MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/MSSBizSolutions\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-06T11:06:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png\" \/>\n<meta name=\"twitter:site\" content=\"@MyronStaAna\" \/>\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:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/\",\"url\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/\",\"name\":\"Advanced Microsoft Excel Training in the Philippines - MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines\",\"isPartOf\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png\",\"datePublished\":\"2019-05-06T10:47:00+00:00\",\"dateModified\":\"2019-05-06T11:06:43+00:00\",\"description\":\"MSS Business Solutions is an HR Training and Consultancy company in the Philippines that offers outsourced corporate training, public seminars, speakers and trainers bureau, professional motivational and inspirational speaking, human resources consulting, first-line leadership and management mentoring, soft skills coaching, team and team culture building, and corporate event hosting.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage\",\"url\":\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png\",\"contentUrl\":\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png\",\"width\":1200,\"height\":630,\"caption\":\"Advanced Microsoft Excel Training in the Philippines\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mssbizsolutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Computer Training in the Philippines\",\"item\":\"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Advanced Microsoft Excel Training in the Philippines\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mssbizsolutions.com\/#website\",\"url\":\"https:\/\/www.mssbizsolutions.com\/\",\"name\":\"MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines\",\"description\":\"The Leader in EnterTRAINment and DeveLAUGHment\",\"publisher\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mssbizsolutions.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.mssbizsolutions.com\/#organization\",\"name\":\"MSS Business Solutions\",\"url\":\"https:\/\/www.mssbizsolutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mssbizsolutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2023\/02\/MSS-logo-profile-YELLOW.jpg\",\"contentUrl\":\"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2023\/02\/MSS-logo-profile-YELLOW.jpg\",\"width\":1000,\"height\":1000,\"caption\":\"MSS Business Solutions\"},\"image\":{\"@id\":\"https:\/\/www.mssbizsolutions.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/MSSBizSolutions\",\"https:\/\/x.com\/MyronStaAna\",\"http:\/\/www.instagram.com\/MSSBizSolutions\",\"https:\/\/ph.linkedin.com\/company\/mssbusinesssolutions\",\"http:\/\/www.pinterest.com\/MyronStaAna\",\"http:\/\/www.youtube.com\/MyronStaAna\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Microsoft Excel Training in the Philippines - MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines","description":"MSS Business Solutions is an HR Training and Consultancy company in the Philippines that offers outsourced corporate training, public seminars, speakers and trainers bureau, professional motivational and inspirational speaking, human resources consulting, first-line leadership and management mentoring, soft skills coaching, team and team culture building, and corporate event hosting.","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.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Microsoft Excel Training in the Philippines","og_description":"Are you looking for an Advanced Microsoft Excel Training in the Philippines? Give us a call at (02) 919-2734 or (02) 260-5081 or email us at info@mssbizsolutions.com","og_url":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/","og_site_name":"MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines","article_publisher":"http:\/\/www.facebook.com\/MSSBizSolutions","article_modified_time":"2019-05-06T11:06:43+00:00","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png","twitter_site":"@MyronStaAna","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/","url":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/","name":"Advanced Microsoft Excel Training in the Philippines - MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines","isPartOf":{"@id":"https:\/\/www.mssbizsolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage"},"image":{"@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png","datePublished":"2019-05-06T10:47:00+00:00","dateModified":"2019-05-06T11:06:43+00:00","description":"MSS Business Solutions is an HR Training and Consultancy company in the Philippines that offers outsourced corporate training, public seminars, speakers and trainers bureau, professional motivational and inspirational speaking, human resources consulting, first-line leadership and management mentoring, soft skills coaching, team and team culture building, and corporate event hosting.","breadcrumb":{"@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#primaryimage","url":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png","contentUrl":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2019\/05\/Advanced-Microsoft-Excel-Training-in-the-Philippines.png","width":1200,"height":630,"caption":"Advanced Microsoft Excel Training in the Philippines"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/advanced-microsoft-excel-training-philippines\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mssbizsolutions.com\/"},{"@type":"ListItem","position":2,"name":"Computer Training in the Philippines","item":"https:\/\/www.mssbizsolutions.com\/computer-training-philippines\/"},{"@type":"ListItem","position":3,"name":"Advanced Microsoft Excel Training in the Philippines"}]},{"@type":"WebSite","@id":"https:\/\/www.mssbizsolutions.com\/#website","url":"https:\/\/www.mssbizsolutions.com\/","name":"MSS Business Solutions - a Top HR Training and Consultancy Company in the Philippines","description":"The Leader in EnterTRAINment and DeveLAUGHment","publisher":{"@id":"https:\/\/www.mssbizsolutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mssbizsolutions.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mssbizsolutions.com\/#organization","name":"MSS Business Solutions","url":"https:\/\/www.mssbizsolutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mssbizsolutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2023\/02\/MSS-logo-profile-YELLOW.jpg","contentUrl":"https:\/\/www.mssbizsolutions.com\/wp-content\/uploads\/2023\/02\/MSS-logo-profile-YELLOW.jpg","width":1000,"height":1000,"caption":"MSS Business Solutions"},"image":{"@id":"https:\/\/www.mssbizsolutions.com\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/MSSBizSolutions","https:\/\/x.com\/MyronStaAna","http:\/\/www.instagram.com\/MSSBizSolutions","https:\/\/ph.linkedin.com\/company\/mssbusinesssolutions","http:\/\/www.pinterest.com\/MyronStaAna","http:\/\/www.youtube.com\/MyronStaAna"]}]}},"_links":{"self":[{"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/pages\/2568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/comments?post=2568"}],"version-history":[{"count":1,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/pages\/2568\/revisions"}],"predecessor-version":[{"id":2571,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/pages\/2568\/revisions\/2571"}],"up":[{"embeddable":true,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/pages\/2574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/media\/2570"}],"wp:attachment":[{"href":"https:\/\/www.mssbizsolutions.com\/wp-json\/wp\/v2\/media?parent=2568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}