{"id":351,"date":"2020-01-10T18:15:08","date_gmt":"2020-01-10T10:15:08","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=351"},"modified":"2020-03-16T11:14:21","modified_gmt":"2020-03-16T03:14:21","slug":"mastering-microsoft-excel-dashboard-creation","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/mastering-microsoft-excel-dashboard-creation\/","title":{"rendered":"Mastering Microsoft Excel: Dashboard Creation"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Hero Section&#8221; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;http:\/\/ensy.ioweb.studio\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_fullwidth_header subhead=&#8221;Mastering Microsoft Excel: Dashboard Creation&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_font=&#8221;Poppins|600||on|||||&#8221; title_font_size=&#8221;18px&#8221; title_letter_spacing=&#8221;4px&#8221; title_line_height=&#8221;1.8em&#8221; content_font_size_last_edited=&#8221;off|desktop&#8221; subhead_font=&#8221;|700|||||||&#8221; subhead_font_size=&#8221;50px&#8221; subhead_font_size_tablet=&#8221;40px&#8221; subhead_font_size_phone=&#8221;30px&#8221; subhead_font_size_last_edited=&#8221;on|desktop&#8221; subhead_line_height=&#8221;1.1em&#8221; background_color=&#8221;rgba(126,190,197,0)&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;rgba(255,255,255,0.75)&#8221; background_color_gradient_end=&#8221;#ffffff&#8221; background_color_gradient_direction=&#8221;1deg&#8221; background_color_gradient_start_position=&#8221;100%&#8221; background_color_gradient_end_position=&#8221;0%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; custom_button_two=&#8221;on&#8221; button_two_text_size=&#8221;14px&#8221; button_two_text_color=&#8221;#29cb8b&#8221; button_two_bg_color=&#8221;#ffffff&#8221; button_two_border_width=&#8221;12px&#8221; button_two_border_color=&#8221;#ffffff&#8221; button_two_letter_spacing=&#8221;2px&#8221; button_two_font=&#8221;Poppins|600||on|||||&#8221; button_two_icon=&#8221;%%3%%&#8221; button_two_letter_spacing_hover=&#8221;2px&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;14px&#8221; button_one_bg_color=&#8221;#29cb8b&#8221; button_one_border_width=&#8221;12px&#8221; button_one_border_color=&#8221;#29cb8b&#8221; button_one_letter_spacing=&#8221;2px&#8221; button_one_font=&#8221;Poppins|600||on|||||&#8221; button_one_icon=&#8221;%%3%%&#8221; button_one_letter_spacing_hover=&#8221;2px&#8221; custom_padding=&#8221;25px||25px||true&#8221; background_layout=&#8221;light&#8221; subhead_text_color=&#8221;#000000&#8243;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; _builder_version=&#8221;3.11.1&#8243; prev_background_color=&#8221;#000000&#8243; next_background_color=&#8221;#f8fbfe&#8221;][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243;][et_pb_image src=&#8221;\/wp-content\/uploads\/2020\/01\/Slide6-2.png&#8221; show_in_lightbox=&#8221;on&#8221; align=&#8221;center&#8221; _builder_version=&#8221;3.11.1&#8243; animation_style=&#8221;fade&#8221;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_image][et_pb_text _builder_version=&#8221;3.11.1&#8243; header_5_font_size=&#8221;20px&#8221; header_5_line_height=&#8221;1.2em&#8221; max_width=&#8221;80%&#8221; module_alignment=&#8221;center&#8221;]<\/p>\n<h5 style=\"text-align: center;\">Dashboard is one of the advanced features of Excel that provides graphical<br \/>\nvisualizations that provides at-a-glance views into key measures relevant to a particular objective or business process. This training will expose you how Dashboards are designed with key pieces of information that are relevant to the goal of dashboard and enable you to present your analysis and conclusions effectively<\/h5>\n<p>[\/et_pb_text][et_pb_code _builder_version=&#8221;3.11.1&#8243;]\n\t\t<!-- MasterSlider -->\n\t\t<div id=\"P_MS69f22d987b3c6\" class=\"master-slider-parent ms-parent-id-2\"  >\n\n\t\t\t\n\t\t\t<!-- MasterSlider Main -->\n\t\t\t<div id=\"MS69f22d987b3c6\" class=\"master-slider ms-skin-default\" >\n\t\t\t\t \t\t\t\t \n\n\t\t\t<div  class=\"ms-slide\" data-delay=\"6\" data-fill-mode=\"fill\"   >\n\t\t\t\t\t<img src=\"https:\/\/ensy.my\/wp-content\/plugins\/masterslider\/public\/assets\/css\/blank.gif\" alt=\"\" title=\"job_recruitement_04\" data-src=\"https:\/\/ensy.my\/wp-content\/uploads\/2019\/12\/job_recruitement_04.jpg\" \/>\n\n\n\t\t\t\t<\/div>\n\t\t\t<div  class=\"ms-slide\" data-delay=\"6\" data-fill-mode=\"fill\"   >\n\t\t\t\t\t<img src=\"https:\/\/ensy.my\/wp-content\/plugins\/masterslider\/public\/assets\/css\/blank.gif\" alt=\"\" title=\"job_recruitement_01\" data-src=\"https:\/\/ensy.my\/wp-content\/uploads\/2019\/12\/job_recruitement_01.jpg\" \/>\n\n\n\t\t\t\t<\/div>\n\n\t\t\t<\/div>\n\t\t\t<!-- END MasterSlider Main -->\n\n\t\t\t \n\t\t<\/div>\n\t\t<!-- END MasterSlider -->\n\n\t\t<script>\n\t\t( window.MSReady = window.MSReady || [] ).push( function( $ ) {\n\n\t\t\t\"use strict\";\n\t\t\tvar masterslider_b3c6 = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_b3c6.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_b3c6.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_b3c6.setup(\"MS69f22d987b3c6\", {\n\t\t\t\twidth           : 1000,\n\t\t\t\theight          : 450,\n\t\t\t\tminHeight       : 0,\n\t\t\t\tspace           : 0,\n\t\t\t\tstart           : 1,\n\t\t\t\tgrabCursor      : true,\n\t\t\t\tswipe           : true,\n\t\t\t\tmouse           : true,\n\t\t\t\tkeyboard        : false,\n\t\t\t\tlayout          : \"fillwidth\",\n\t\t\t\twheel           : false,\n\t\t\t\tautoplay        : true,\n                instantStartLayers:false,\n\t\t\t\tmobileBGVideo:false,\n\t\t\t\tloop            : false,\n\t\t\t\tshuffle         : false,\n\t\t\t\tpreload         : 0,\n\t\t\t\theightLimit     : true,\n\t\t\t\tautoHeight      : false,\n\t\t\t\tsmoothHeight    : true,\n\t\t\t\tendPause        : false,\n\t\t\t\toverPause       : true,\n\t\t\t\tfillMode        : \"fill\",\n\t\t\t\tcenterControls  : true,\n\t\t\t\tstartOnAppear   : false,\n\t\t\t\tlayersMode      : \"center\",\n\t\t\t\tautofillTarget  : \"\",\n\t\t\t\thideLayers      : false,\n\t\t\t\tfullscreenMargin: 0,\n\t\t\t\tspeed           : 20,\n\t\t\t\tdir             : \"h\",\n\t\t\t\tparallaxMode    : 'swipe',\n\t\t\t\tview            : \"basic\"\n\t\t\t});\n\n\t\t\t\n\t\t\twindow.masterslider_instances = window.masterslider_instances || [];\n\t\t\twindow.masterslider_instances.push( masterslider_b3c6 );\n\t\t});\n\t\t<\/script>\n\n[\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.11.1&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#959baf&#8221; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_font_size=&#8221;45px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#535b7c&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Improve Your Microsoft Excel Skill Now !<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;1_3&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221;]<\/p>\n<h5><strong>Course Objectives<\/strong><\/h5>\n<ul>\n<li>Understanding Dashboards in MS Excel<\/li>\n<li>Creating and Customizing Dashboards<\/li>\n<li>Dashboards Visualization Techniques &#8211; Charts<\/li>\n<li>Interactive Controls in Dashboards<\/li>\n<li>Using PivotTables<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221;]<\/p>\n<h5><strong>Duration<\/strong><\/h5>\n<p>2 days (9:00am to 5:00pm)<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#DFEFFF&#8221;]<\/p>\n<h5><strong>Venue<\/strong><\/h5>\n<p>In-House Training<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#DFEFFF&#8221;]<\/p>\n<h5><strong>Who should attend?<\/strong><\/h5>\n<p>Individuals who use Excel in their day-to-day work or those involve in Reporting and Data Analysis but would like to discover the power of Dashboard.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#C4E1FF&#8221;]<\/p>\n<h5><strong>Learning Methodology<\/strong><\/h5>\n<ul>\n<li>Instructor-led Training<\/li>\n<li>Group Discussion<\/li>\n<li>Hands-On<\/li>\n<li>Exercises<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#C4E1FF&#8221;]<\/p>\n<h5><strong>Pre-requisite before Attending the Class<\/strong><\/h5>\n<p>Excel Foundation or equivalent experience.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Images Row&#8221; _builder_version=&#8221;3.0.83&#8243;][et_pb_column type=&#8221;1_3&#8243;][et_pb_blurb title=&#8221;Quality Assured&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/medal.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;Generate New Idea&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/idea-1.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;Telephone Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/call.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_blurb title=&#8221;Certified Instructor&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/award.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;Improve Productivity&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/hand.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;SMS Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/sms.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_blurb title=&#8221;Practical Example&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/pencil.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;Updated Resources&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/excel.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][et_pb_blurb title=&#8221;Email Support&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/email.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_slide=&#8221;10%&#8221;]<br \/>\n[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; _builder_version=&#8221;3.0.87&#8243; background_color=&#8221;#f8fbfe&#8221; custom_padding=&#8221;54px|0px|3px|0px|false|false&#8221; prev_background_color=&#8221;#ffffff&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_row _builder_version=&#8221;3.0.83&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#959baf&#8221; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_font_size=&#8221;45px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#535b7c&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Course Outline<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; custom_padding=&#8221;15px||15px|&#8221; use_background_color_gradient_1=&#8221;off&#8221; use_background_color_gradient_2=&#8221;off&#8221; use_background_color_gradient_3=&#8221;on&#8221; background_color_gradient_start_1=&#8221;#3D72E7&#8243; background_color_gradient_start_2=&#8221;#3D72E7&#8243; background_color_gradient_start_3=&#8221;#3D72E7&#8243; background_color_gradient_end_1=&#8221;#53a0fe&#8221; background_color_gradient_end_2=&#8221;#53a0fe&#8221; background_color_gradient_end_3=&#8221;#53A0FE&#8221; background_color_gradient_direction_1=&#8221;243deg&#8221; background_color_gradient_direction_2=&#8221;243deg&#8221; background_color_gradient_direction_3=&#8221;243deg&#8221; _builder_version=&#8221;3.0.87&#8243;][et_pb_column type=&#8221;1_2&#8243;][et_pb_blurb admin_label=&#8221;Module 1&#8243; title=&#8221;Module 1: Introducing Dashboards&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>What Are Dashboards &amp; Reports?<br \/>\n&#8211; Defining reports<\/li>\n<li>Defining dashboards<br \/>\n&#8211; Establish the User Requirements<br \/>\n&#8211; Define the message(s)<br \/>\n&#8211; Establish the audience<br \/>\n&#8211; Define the performance measures<br \/>\n&#8211; List the required data sources<br \/>\n&#8211; Define the dimensions and filters<br \/>\n&#8211; Determine the need for drill-down details<br \/>\n&#8211; Establish the update schedule<\/li>\n<li>A Quick Look at Dashboard Design Principles<\/li>\n<li>Rule number 1: Keep it simple<br \/>\n&#8211; Use layout and placement to draw focus<br \/>\n&#8211; Format numbers effectively<br \/>\n&#8211; Use titles and labels effectively<\/li>\n<li>Key Questions to Ask Before Distributing Your Dashboard<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;3&#8243; title=&#8221;Module 3: Visualization Techniques&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Enhancing Reports with Conditional Formatting<br \/>\n&#8211; Applying basic conditional formatting<br \/>\n&#8211; Adding your own formatting rules manually<br \/>\n&#8211; Show only one icon<br \/>\n&#8211; Show Data Bars and icons outside of cells<br \/>\n&#8211; Representing trends with icon sets<br \/>\n&#8211; Using Symbols to Enhance Reporting<\/li>\n<li>Using Excel\u2019s Camera Tool<br \/>\n&#8211; Finding the Camera tool<br \/>\n&#8211; Using the Camera tool<br \/>\n&#8211; Enhancing a dashboard with the Camera tool<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;5&#8243; title=&#8221;Module 5: Introducing Charts (II)&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Understanding Series Names<br \/>\n&#8211; SERIES formula syntax<br \/>\n&#8211; Changing a series name<\/li>\n<li>Adjusting the Series Plot Order<\/li>\n<li>Charting a Noncontiguous Range<\/li>\n<li>Using Series on Different Sheets<\/li>\n<li>Handling Missing Data<\/li>\n<li>Controlling a Data Series by Hiding Data<\/li>\n<li>Unlinking a Chart Series from Its Data Range<br \/>\n&#8211; Converting a chart to a picture<br \/>\n&#8211; Converting a range reference to arrays<\/li>\n<li>Working with Multiple Axes<br \/>\n&#8211; Creating a secondary value axis<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;module 7&#8243; title=&#8221;Module 7: Developing Data Mode&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Separating the data, analysis, and presentation layers<br \/>\n&#8211; The Data Layer<br \/>\n&#8211; The analysis layer<br \/>\n&#8211; The presentation layer<\/li>\n<li>Data Model Best Practices<br \/>\n&#8211; Avoid storing excess data<br \/>\n&#8211; Use tabs to document and organize your data model<br \/>\n&#8211; Test your data model before building presentation components<\/li>\n<li>Excel Functions for Your Data Model<br \/>\n&#8211; Understanding lookup tables<br \/>\n&#8211; The VLOOKUP function<br \/>\n&#8211; The HLookup function<br \/>\n&#8211; The SUMPRODUCT function<br \/>\n&#8211; The Choose function<\/li>\n<li>Working with Excel Tables<br \/>\n&#8211; Converting a range to an Excel table<br \/>\n&#8211; Converting an Excel table back to a range<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;module 8&#8243; title=&#8221;Module 8: Adding Interactive Controls&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Getting Started with Form Controls<br \/>\n&#8211; Finding Form controls<br \/>\n&#8211; Adding a control to a worksheet<\/li>\n<li>Using the Button Control<\/li>\n<li>Using the Check Box Control<br \/>\n&#8211; Check box example: Toggling a chart series on and off<\/li>\n<li>Using the Option Button Control<br \/>\n&#8211; Option button example: Showing many views through one chart<\/li>\n<li>Using the Combo Box Control<br \/>\n&#8211; Combo box example: Changing chart data with a drop-down selector<\/li>\n<li>Using the List Box Control<br \/>\n&#8211; List box example: Controlling multiple charts with one selector<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][et_pb_blurb admin_label=&#8221;2&#8243; title=&#8221;Module 2: Table Design Best Practices&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Table Design Principles<br \/>\n&#8211; Use colors sparingly<br \/>\n&#8211; De-emphasize borders<br \/>\n&#8211; Use effective number formatting<br \/>\n&#8211; Subdue your labels and headers<\/li>\n<li>Enhancing Reporting with Custom Number Formatting<br \/>\n&#8211; Number formatting basics<br \/>\n&#8211; Formatting numbers in thousands and millions<br \/>\n&#8211; Hiding and suppressing zeros<br \/>\n&#8211; Formatting dates and times<br \/>\n&#8211; Adding conditions to customer number formatting<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;4&#8243; title=&#8221;Module 4: Introducing Charts (I)&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Basic Steps for Creating a Chart<br \/>\n&#8211; Creating the chart<br \/>\n&#8211; Switching the row and column orientation<br \/>\n&#8211; Changing the chart type<br \/>\n&#8211; Applying chart styles<br \/>\n&#8211; Adding and deleting chart elements<br \/>\n&#8211; Moving and deleting chart elements<br \/>\n&#8211; Formatting chart elements<\/li>\n<li>Working with Charts<br \/>\n&#8211; Moving and resizing a chart<\/li>\n<li>Working with Chart Series<br \/>\n&#8211; Specifying the Data for Your Chart<br \/>\n&#8211; Adding a New Series to a Chart<br \/>\n&#8211; Adding a new series by extending the range highlight<br \/>\n&#8211; Adding a new series using the Select Data Source dialog box<\/li>\n<li>Modifying the Data Range for a Chart Series<br \/>\n&#8211; Using range highlighting to change series data<br \/>\n&#8211; Using the Select Data Source dialog box to change series data<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;module 6&#8243; title=&#8221;Module 6: Formatting And Customizing Charts&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Selecting chart elements<\/li>\n<li>Adjusting Fills and Borders:<br \/>\n&#8211; About the Fill tab<br \/>\n&#8211; Formatting borders<\/li>\n<li>Formatting Chart Background<br \/>\n&#8211; Working with the chart area<br \/>\n&#8211; Working with the plot area<\/li>\n<li>Formatting Chart Series<br \/>\n&#8211; Basic series formatting<br \/>\n&#8211; Using pictures and graphics for series formatting<br \/>\n&#8211; Additional series options<\/li>\n<li>Working with Chart Titles<br \/>\n&#8211; Adding titles to a chart<br \/>\n&#8211; Changing title text<br \/>\n&#8211; Formatting title text<br \/>\n&#8211; Linking title text to a cell<\/li>\n<li>Working with a Chart\u2019s Legend<br \/>\n&#8211; Adding or removing a legend<br \/>\n&#8211; Formatting a legend<br \/>\n&#8211; Changing the legend text<br \/>\n&#8211; Deleting a legend entry<br \/>\n&#8211; Identifying series without using a legend<\/li>\n<li>Working with Chart Axes<br \/>\n&#8211; Value axis versus category axis<br \/>\n&#8211; Value axis scales<\/li>\n<li>Working with Data Labels<br \/>\n&#8211; Adding or removing data labels<br \/>\n&#8211; Editing data labels<\/li>\n<li>Working with a Chart Data Table<\/li>\n<li>Adding and removing a data table<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;module 9&#8243; title=&#8221;Module 9: Excel Macro&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Building navigation buttons<\/li>\n<li>Dynamically rearranging pivot table data<\/li>\n<li>Offering one-touch reporting options<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;module 10&#8243; title=&#8221;Module 10: Using Pivot Tables&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;470px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_align=&#8221;left&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3D72E7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||6%|&#8221; custom_padding=&#8221;40px|20px|40px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;10%&#8221;]<\/p>\n<ul>\n<li>Introducing the Pivot Table<\/li>\n<li>Anatomy of a pivot table<br \/>\n&#8211; Values area<br \/>\n&#8211; Row Labels area<br \/>\n&#8211; Column Labels area<br \/>\n&#8211; Filter area<\/li>\n<li>Creating the basic pivot table<br \/>\n&#8211; Laying out the pivot table<br \/>\n&#8211; Modifying the pivot table<br \/>\n&#8211; Updating your pivot table<\/li>\n<li>Pivot tables and worksheet bloat<\/li>\n<li>Customizing Your Pivot Table<br \/>\n&#8211; Changing the pivot table layout<br \/>\n&#8211; Renaming the fields<br \/>\n&#8211; Formatting numbers<br \/>\n&#8211; Changing summary calculations<br \/>\n&#8211; Suppressing subtotals<br \/>\n&#8211; Removing all subtotals at one time<br \/>\n&#8211; Removing the subtotals for only one field<br \/>\n&#8211; Removing grand totals<br \/>\n&#8211; Hiding and showing data items<br \/>\n&#8211; Hiding or showing items without data<br \/>\n&#8211; Sorting your pivot table<\/li>\n<li>Examples of Filtering Your Data<br \/>\n&#8211; Producing top and bottom views<br \/>\n&#8211; Creating views by month, quarter, and year<br \/>\n&#8211; Creating a percent distribution view<br \/>\n&#8211; Creating a YTD totals view<br \/>\n&#8211; Creating a month-over-month variance view<\/li>\n<li>Using conditional formatting with pivot tables<br \/>\n&#8211; Customizing conditional formatting<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Features CTA Section&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;https:\/\/ensy.my\/wp-content\/uploads\/2020\/02\/bg-image-2.jpg&#8221; custom_padding=&#8221;2px|0px|4px|0px|false|false&#8221; saved_tabs=&#8221;all&#8221; prev_background_color=&#8221;#f8fbfe&#8221; next_background_color=&#8221;#f8fbfe&#8221;][et_pb_row admin_label=&#8221;Left Sided Image&#8221; custom_padding=&#8221;60px|0px|60px|0px&#8221; _builder_version=&#8221;3.0.83&#8243;][et_pb_column type=&#8221;1_2&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#ffffff&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#000000&#8243; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; link_font=&#8221;||||||||&#8221; ul_font=&#8221;|300|||||||&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Require more support than our training courses?<\/h2>\n<h4>Our full range of services can help you in many ways:<\/h4>\n<p><b>Custom Courses<\/b><\/p>\n<ul>\n<li>We can work with you to deliver a tailored made course for your staff, not only in Microsoft Excel, but also PowerPoint, Word and other Microsoft Office software<\/li>\n<\/ul>\n<p><b>Standard Business Documents<\/b><\/p>\n<ul>\n<li>We can work with you to design standard business documents in Microsoft Excel, Word, and PowerPoint, making it quick and easy to produce professional, branded, stunning business documents<\/li>\n<\/ul>\n<p><b>Automated Reporting<\/b><\/p>\n<ul>\n<li>Unsure if Microsoft Excel gives you the information you need to run your business? We can design, develop and generate monthly reports in easily accessible formats such as PDF, giving you the information at your fingertips to run your business \u2013 no more days wasted in incomprehensible data reports<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Features&#8221; _builder_version=&#8221;3.0.83&#8243; background_color=&#8221;#f8fbfe&#8221; custom_padding=&#8221;0|0px|52px|0px|false|false&#8221; prev_background_color=&#8221;#ffffff&#8221; next_background_color=&#8221;#202332&#8243;][et_pb_row admin_label=&#8221;Tittle&#8221; custom_padding=&#8221;50px|0px|27px|0px|false|false&#8221; _builder_version=&#8221;3.0.83&#8243;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#959baf&#8221; text_font_size=&#8221;18px&#8221; text_line_height=&#8221;1.8em&#8221; header_font=&#8221;||||||||&#8221; header_text_align=&#8221;center&#8221; header_text_color=&#8221;#535b7c&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_color=&#8221;#535b7c&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; text_orientation=&#8221;center&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221;]<\/p>\n<h2>What You Can Expect From Our Course<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Features Row&#8221; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; custom_padding=&#8221;0.75%||0.75%|&#8221; use_background_color_gradient_1=&#8221;off&#8221; use_background_color_gradient_2=&#8221;off&#8221; use_background_color_gradient_3=&#8221;off&#8221; background_color_gradient_start_1=&#8221;#3D72E7&#8243; background_color_gradient_start_2=&#8221;#3D72E7&#8243; background_color_gradient_start_3=&#8221;#3D72E7&#8243; background_color_gradient_end_1=&#8221;#53a0fe&#8221; background_color_gradient_end_2=&#8221;#53a0fe&#8221; background_color_gradient_end_3=&#8221;#53A0FE&#8221; background_color_gradient_direction_1=&#8221;243deg&#8221; background_color_gradient_direction_2=&#8221;243deg&#8221; background_color_gradient_direction_3=&#8221;243deg&#8221; _builder_version=&#8221;3.0.87&#8243;][et_pb_column type=&#8221;1_4&#8243;][et_pb_blurb title=&#8221;Qualified Trainer&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/certificate-1.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#1e1584&#8243; border_width_top=&#8221;6px&#8221; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;54px|20px|60px|20px&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;5%&#8221;]<\/p>\n<p>Our trainer is a Microsoft Office 2010 Master Specialist and well-sought after Microsoft Certified Trainer with more than 15 years of experience. He has conducted hundreds of Microsoft Office application classes with leading companies in the region and gets excellent ratings for<br \/>\nall his classes.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243;][et_pb_blurb title=&#8221;Small Class Sizes&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/teacher.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#3D72E7&#8243; border_width_top=&#8221;6px&#8221; border_color_top=&#8221;#3d72e7&#8243; border_color_right=&#8221;#3d72e7&#8243; border_color_bottom=&#8221;#3d72e7&#8243; border_color_left=&#8221;#3d72e7&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;54px|20px|175px|20px&#8221; custom_padding_phone=&#8221;||60px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;5%&#8221;]<\/p>\n<p>We limit the number of participants to 15 pax per session. This means that participants will become more productive immediately after the training session.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243;][et_pb_blurb title=&#8221;Solutions&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/qa.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#b030db&#8221; border_width_top=&#8221;6px&#8221; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;54px|20px|265px|20px&#8221; custom_padding_phone=&#8221;||60px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;5%&#8221;]<\/p>\n<p>Real answers and solutions to your issues, not off the shelf training.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243;][et_pb_blurb title=&#8221;Ask Our Expert&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/email.png&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#535b7c&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_text_color=&#8221;#959baf&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;#ffffff&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221; border_color_all=&#8221;#e09900&#8243; border_width_top=&#8221;6px&#8221; box_shadow_style=&#8221;preset3&#8243; box_shadow_color=&#8221;rgba(34,56,101,0.12)&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;54px|20px|265px|20px&#8221; custom_padding_phone=&#8221;||60px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;zoom&#8221; animation_intensity_zoom=&#8221;5%&#8221;]<\/p>\n<p>Participants will be given an email for assistance on future inquiries.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Get Started CTA&#8221; _builder_version=&#8221;3.0.83&#8243; background_color=&#8221;#202332&#8243; box_shadow_style=&#8221;preset3&#8243; box_shadow_vertical=&#8221;160px&#8221; box_shadow_blur=&#8221;0px&#8221; box_shadow_spread=&#8221;-80px&#8221; box_shadow_color=&#8221;#ffffff&#8221; box_shadow_position=&#8221;inner&#8221; custom_padding=&#8221;0px|0px|100px|0px&#8221; saved_tabs=&#8221;all&#8221; prev_background_color=&#8221;#f8fbfe&#8221; next_background_color=&#8221;#f1f5f9&#8243;][et_pb_row admin_label=&#8221;CTA Row&#8221; custom_padding=&#8221;32px|40px||40px&#8221; _builder_version=&#8221;3.0.93&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#3D72E7&#8243; background_color_gradient_end=&#8221;#53A0FE&#8221; background_color_gradient_direction=&#8221;243deg&#8221; border_radii=&#8221;on|4px|4px|4px|4px&#8221;][et_pb_column type=&#8221;2_3&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;Nunito Sans||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;15px&#8221; header_font=&#8221;|700|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#ffffff&#8221; header_font_size=&#8221;35px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_align=&#8221;left&#8221; header_2_text_color=&#8221;#ffffff&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.4em&#8221; custom_margin=&#8221;||| &#8220;]<\/p>\n<h2>Download PDF Version Here<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_button button_url=&#8221;\/wp-content\/uploads\/2020\/01\/ENSY-Mastering-Ms-Excel-Dashboard-Creation.pdf&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Download&#8221; button_alignment=&#8221;right&#8221; _builder_version=&#8221;3.11.1&#8243; custom_button=&#8221;on&#8221; button_text_size=&#8221;13px&#8221; button_text_color=&#8221;#3d72e7&#8243; button_bg_color=&#8221;#ffffff&#8221; button_bg_color_gradient_start=&#8221;#3D72E7&#8243; button_bg_color_gradient_end=&#8221;#53a0fe&#8221; button_bg_color_gradient_direction=&#8221;243deg&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;26px&#8221; button_letter_spacing=&#8221;1px&#8221; button_font=&#8221;|600||on|||||&#8221; button_use_icon=&#8221;off&#8221; button_text_color_hover=&#8221;#3d72e7&#8243; button_bg_color_hover=&#8221;#ffffff&#8221; button_border_radius_hover=&#8221;26px&#8221; button_letter_spacing_hover=&#8221;1px&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;15px|30px|15px|30px&#8221;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; module_id=&#8221;contact-section&#8221; _builder_version=&#8221;3.11.1&#8243; background_color=&#8221;#f1f5f9&#8243; animation_style=&#8221;slide&#8221; animation_duration=&#8221;1100ms&#8221; animation_speed_curve=&#8221;ease-in&#8221; prev_background_color=&#8221;#202332&#8243;][et_pb_row _builder_version=&#8221;3.0.48&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;]<\/p>\n<h3 style=\"text-align: center;\"><strong>Interested to know more about this course? Reach out to us now!<\/strong><\/h3>\n<p>[\/et_pb_text][et_pb_contact_form email=&#8221;training@ensy.my, maychung@ensy.my&#8221; custom_message=&#8221;Course: Mastering Microsoft Excel: Dashboard Creation||et_pb_line_break_holder||||et_pb_line_break_holder||Name: %%Name%%||et_pb_line_break_holder||Email: %%Email%%||et_pb_line_break_holder||Mobile: %%Mobile%%||et_pb_line_break_holder||Message: %%Message%%||et_pb_line_break_holder||&#8221; module_id=&#8221;et_pb_contact_form_0&#8243; _builder_version=&#8221;3.11.1&#8243;][et_pb_contact_field field_id=&#8221;Name&#8221; field_title=&#8221;Name *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Email&#8221; field_title=&#8221;Email *&#8221; field_type=&#8221;email&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Mobile&#8221; field_title=&#8221;Mobile *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Message&#8221; field_title=&#8221;Message&#8221; field_type=&#8221;text&#8221; required_mark=&#8221;off&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][\/et_pb_contact_form][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Hero Section&#8221; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;http:\/\/ensy.ioweb.studio\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_fullwidth_header subhead=&#8221;Mastering Microsoft Excel: Dashboard Creation&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_font=&#8221;Poppins|600||on|||||&#8221; title_font_size=&#8221;18px&#8221; title_letter_spacing=&#8221;4px&#8221; title_line_height=&#8221;1.8em&#8221; content_font_size_last_edited=&#8221;off|desktop&#8221; subhead_font=&#8221;|700|||||||&#8221; subhead_font_size=&#8221;50px&#8221; subhead_font_size_tablet=&#8221;40px&#8221; subhead_font_size_phone=&#8221;30px&#8221; subhead_font_size_last_edited=&#8221;on|desktop&#8221; subhead_line_height=&#8221;1.1em&#8221; background_color=&#8221;rgba(126,190,197,0)&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;rgba(255,255,255,0.75)&#8221; background_color_gradient_end=&#8221;#ffffff&#8221; background_color_gradient_direction=&#8221;1deg&#8221; background_color_gradient_start_position=&#8221;100%&#8221; background_color_gradient_end_position=&#8221;0%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; custom_button_two=&#8221;on&#8221; button_two_text_size=&#8221;14px&#8221; button_two_text_color=&#8221;#29cb8b&#8221; button_two_bg_color=&#8221;#ffffff&#8221; button_two_border_width=&#8221;12px&#8221; button_two_border_color=&#8221;#ffffff&#8221; button_two_letter_spacing=&#8221;2px&#8221; button_two_font=&#8221;Poppins|600||on|||||&#8221; button_two_icon=&#8221;%%3%%&#8221; button_two_letter_spacing_hover=&#8221;2px&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;14px&#8221; button_one_bg_color=&#8221;#29cb8b&#8221; button_one_border_width=&#8221;12px&#8221; button_one_border_color=&#8221;#29cb8b&#8221; button_one_letter_spacing=&#8221;2px&#8221; button_one_font=&#8221;Poppins|600||on|||||&#8221; button_one_icon=&#8221;%%3%%&#8221; button_one_letter_spacing_hover=&#8221;2px&#8221; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/351"}],"collection":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":23,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/351\/revisions"}],"predecessor-version":[{"id":1111,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/351\/revisions\/1111"}],"up":[{"embeddable":true,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/36"}],"wp:attachment":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/media?parent=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}