{"id":17685,"date":"2020-03-04T05:59:38","date_gmt":"2020-03-04T05:59:38","guid":{"rendered":"https:\/\/mmco.com.ph\/elearning\/?page_id=17685"},"modified":"2020-08-22T07:17:36","modified_gmt":"2020-08-21T23:17:36","slug":"advanced-excel-training","status":"publish","type":"page","link":"https:\/\/mmco.com.ph\/elearning\/advanced-excel-training\/","title":{"rendered":"Advanced Excel Training"},"content":{"rendered":"<section class=\"l-section wpb_row height_auto with_img\"><div class=\"l-section-img lazyload\" role=\"img\" aria-label=\"Image\" data-img-width=\"1920\" data-img-height=\"200\" style=\"background-image:inherit;\" data-bg-image=\"url(https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2019\/08\/TitleBG.jpg_plain.jpg)\"><\/div><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_grid cols_1 laptops-cols_inherit tablets-cols_inherit mobiles-cols_1 valign_top type_default stacking_default\"><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"w-separator size_medium\"><\/div><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><h3 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>ADVANCED EXCEL TRAINING<\/strong><\/span><\/h3>\n<\/div><\/div><div class=\"w-separator size_medium\"><\/div><\/div><\/div><\/div><\/div><\/section><section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_grid cols_1-4-1 laptops-cols_inherit tablets-cols_inherit mobiles-cols_1 valign_top type_default stacking_default\"><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"w-separator size_medium\"><\/div><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><p style=\"text-align: center;\">P224 Non-CPD<\/p>\n<p style=\"text-align: center;\">If you need a certificate (Non-CPD), we can send you the link to the certificate ready for your printing.<\/p>\n<\/div><\/div><div class=\"w-separator size_small\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><\/div><\/div><\/section><section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_grid cols_1-4-1 laptops-cols_inherit tablets-cols_inherit mobiles-cols_1 valign_top type_default stacking_default\"><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"w-separator size_small\"><\/div><div class=\"w-grid type_grid layout_blog_1 cols_2\" id=\"us_grid_1\" style=\"--columns:2;--gap:1.5rem;\"><style>@media (max-width:600px){#us_grid_1{--columns:1!important}}.layout_blog_1 .w-grid-item-h{}.layout_blog_1 .usg_post_image_1{margin-bottom:0.5rem!important}.layout_blog_1 .usg_post_title_1{font-size:1rem!important}<\/style><div class=\"w-grid-list\">\t<article class=\"w-grid-item size_1x1 post-17683 sfwd-courses type-sfwd-courses status-publish has-post-thumbnail hentry ld_course_category-advanced-excel-trianing ld_course_category-seminar\" data-id=\"17683\">\r\n\t\t<div class=\"w-grid-item-h\">\r\n\t\t\t\t\t\t<div class=\"w-post-elm post_image usg_post_image_1 stretched\"><a href=\"https:\/\/mmco.com.ph\/elearning\/courses\/advanced-excel-training-day-1\/\" aria-label=\"Advanced Excel Training Day 1\"><img decoding=\"async\" width=\"450\" height=\"300\" data-src=\"https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-1.png\" class=\"attachment-large size-large wp-post-image lazyload\" alt=\"\" data-srcset=\"https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-1.png 450w, https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-1-300x200.png 300w, https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-1-350x233.png 350w\" data-sizes=\"(max-width: 450px) 100vw, 450px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 450px; --smush-placeholder-aspect-ratio: 450\/300;\" \/><\/a><\/div><h2 class=\"w-post-elm post_title usg_post_title_1 entry-title color_link_inherit\"><a href=\"https:\/\/mmco.com.ph\/elearning\/courses\/advanced-excel-training-day-1\/\">Advanced Excel Training Day 1<\/a><\/h2>\t\t<\/div>\r\n\t\t\t<\/article>\r\n\t<article class=\"w-grid-item size_1x1 post-17688 sfwd-courses type-sfwd-courses status-publish has-post-thumbnail hentry ld_course_category-advanced-excel-trianing ld_course_category-seminar\" data-id=\"17688\">\r\n\t\t<div class=\"w-grid-item-h\">\r\n\t\t\t\t\t\t<div class=\"w-post-elm post_image usg_post_image_1 stretched\"><a href=\"https:\/\/mmco.com.ph\/elearning\/courses\/advanced-excel-training-day-2\/\" aria-label=\"Advanced Excel Training Day 2\"><img decoding=\"async\" width=\"450\" height=\"300\" data-src=\"https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-2.png\" class=\"attachment-large size-large wp-post-image lazyload\" alt=\"\" data-srcset=\"https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-2.png 450w, https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-2-300x200.png 300w, https:\/\/mmco.com.ph\/elearning\/wp-content\/uploads\/2020\/03\/Advanced-Excel-Training-Day-2-350x233.png 350w\" data-sizes=\"(max-width: 450px) 100vw, 450px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 450px; --smush-placeholder-aspect-ratio: 450\/300;\" \/><\/a><\/div><h2 class=\"w-post-elm post_title usg_post_title_1 entry-title color_link_inherit\"><a href=\"https:\/\/mmco.com.ph\/elearning\/courses\/advanced-excel-training-day-2\/\">Advanced Excel Training Day 2<\/a><\/h2>\t\t<\/div>\r\n\t\t\t<\/article>\r\n<\/div><div class=\"w-grid-preloader\">\t<div class=\"g-preloader type_1\">\r\n\t\t<div><\/div>\r\n\t<\/div>\r\n\t<\/div>\t<div class=\"w-grid-json hidden\" onclick='return {&quot;action&quot;:&quot;us_ajax_grid&quot;,&quot;infinite_scroll&quot;:0,&quot;max_num_pages&quot;:1,&quot;pagination&quot;:&quot;none&quot;,&quot;template_vars&quot;:{&quot;columns&quot;:&quot;2&quot;,&quot;exclude_items&quot;:&quot;none&quot;,&quot;img_size&quot;:&quot;default&quot;,&quot;ignore_items_size&quot;:0,&quot;items_layout&quot;:&quot;blog_1&quot;,&quot;items_offset&quot;:&quot;1&quot;,&quot;load_animation&quot;:&quot;none&quot;,&quot;overriding_link&quot;:&quot;{\\&quot;url\\&quot;:\\&quot;\\&quot;}&quot;,&quot;post_id&quot;:0,&quot;query_args&quot;:{&quot;ignore_sticky_posts&quot;:1,&quot;post_type&quot;:&quot;any&quot;,&quot;post__in&quot;:[&quot;17688&quot;,&quot;17683&quot;],&quot;posts_per_page&quot;:&quot;10&quot;},&quot;orderby_query_args&quot;:{&quot;orderby&quot;:{&quot;title&quot;:&quot;ASC&quot;},&quot;order&quot;:&quot;ASC&quot;},&quot;type&quot;:&quot;grid&quot;,&quot;us_grid_post_type&quot;:&quot;ids&quot;,&quot;us_grid_ajax_index&quot;:1,&quot;us_grid_filter_query_string&quot;:null,&quot;us_grid_index&quot;:1,&quot;page_args&quot;:[]}}'><\/div>\r\n\t<\/div><div class=\"w-separator size_medium\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><\/div><\/div><\/section><section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_grid cols_custom laptops-cols_inherit tablets-cols_inherit mobiles-cols_1 valign_top type_default stacking_default\" style=\"--custom-columns:1fr 2fr 2fr 1fr \"><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><h5><strong><span lang=\"EN-US\">Day 1 Outline:<\/span><\/strong><\/h5>\n<ol>\n<li><span lang=\"EN-US\">Brief History of MS Excel<\/span><\/li>\n<li><span lang=\"EN-US\">Review of basic functions and features &#8211; (copy, paste, cut) with shortcuts.<\/span><\/li>\n<li><span lang=\"EN-US\">General and Advanced Excel Options &#8211; specifying default settings for toolbars, font sizes, color schemes<\/span><\/li>\n<li><span lang=\"EN-US\">Advanced Formulas and Functions &#8211; (string, date, numerical, look-up and logical functions)<\/span><\/li>\n<li><span lang=\"EN-US\">Resolving Formula Errors (common errors and troubleshooting; eg. #N\/A, #VALUE!, etc.)<\/span><\/li>\n<\/ol>\n<\/div><\/div><div class=\"w-separator size_small\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><h5><strong><span lang=\"EN-US\">Day 2 Outline:<\/span><\/strong><\/h5>\n<ol>\n<li><span lang=\"EN-US\">Data Handling and Analysis (using data validation, pivot table, sort, filter, conditional formatting)<\/span><\/li>\n<li><span lang=\"EN-US\">Data Outlining and Grouping (using group\/ungroup function, split and freeze panes)<\/span><\/li>\n<li><span lang=\"EN-US\">Creating reports (data entry forms, charting)<\/span><\/li>\n<li><span lang=\"EN-US\">Sharing and protecting workbooks (password enable files or sections of a workbook)<\/span><\/li>\n<\/ol>\n<\/div><\/div><div class=\"w-separator size_small\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><\/div><\/div><\/section><section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_grid cols_custom laptops-cols_inherit tablets-cols_inherit mobiles-cols_1 valign_top type_default stacking_default\" style=\"--custom-columns:1fr 2fr 2fr 1fr \"><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"w-separator size_small\"><\/div><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><h5><strong><span lang=\"EN-US\">Objectives:<\/span><\/strong><\/h5>\n<ol>\n<li><span lang=\"EN-US\">To equip participants on the basic and advanced features and functionalities of MS Excel;<\/span><\/li>\n<li><span lang=\"EN-US\">To know how excel features and functionalities can be of help in doing analyses and reports. <\/span><\/li>\n<li><span lang=\"EN-US\">To help participants appreciate the importance of data security and accuracy in preparing spreadsheets.<\/span><\/li>\n<li><span lang=\"EN-US\">To apply all these learnings in various cases and problems at work.<\/span><\/li>\n<\/ol>\n<\/div><\/div><div class=\"w-separator size_medium\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"w-separator size_small\"><\/div><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><h5><strong><span lang=\"EN-US\">Remarks:<\/span><\/strong><\/h5>\n<ol>\n<li><span lang=\"EN-US\"> Exploring General and Advanced Excel Options\/ Settings <\/span><\/li>\n<li><span lang=\"EN-US\">Revisiting Basic functions and Features of Excel<\/span><\/li>\n<li><span lang=\"EN-US\">Learning Advanced Formulas and Functions <\/span><\/li>\n<li><span lang=\"EN-US\">Resolving Formula Errors<\/span><\/li>\n<li><span lang=\"EN-US\">Data Management and Analyses <\/span><\/li>\n<li><span lang=\"EN-US\">Data Outlining and Grouping<\/span><\/li>\n<\/ol>\n<\/div><\/div><div class=\"w-separator size_medium\"><\/div><\/div><\/div><div class=\"wpb_column vc_column_container\"><div class=\"vc_column-inner\"><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-17685","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/pages\/17685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/comments?post=17685"}],"version-history":[{"count":15,"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/pages\/17685\/revisions"}],"predecessor-version":[{"id":21610,"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/pages\/17685\/revisions\/21610"}],"wp:attachment":[{"href":"https:\/\/mmco.com.ph\/elearning\/wp-json\/wp\/v2\/media?parent=17685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}