{"id":309,"date":"2020-01-10T17:53:29","date_gmt":"2020-01-10T09:53:29","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=309"},"modified":"2020-03-16T11:12:01","modified_gmt":"2020-03-16T03:12:01","slug":"microsoft-excel-advanced-beyond","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/microsoft-excel-advanced-beyond\/","title":{"rendered":"Microsoft Excel: Advanced &#038; Beyond"},"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;Microsoft Excel &#8211; Advanced &amp; Beyond&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_level=&#8221;h5&#8243; title_font=&#8221;|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_text_color=&#8221;#000000&#8243; 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.4em&#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;2%&#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|&#8221;]<br \/>\n[\/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;]<br \/>\n[\/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;\">Do you ever find yourself searching through an Excel manual \u2026 wishing you had an Excel expert to ask \u2026 or even giving up in frustration by \u201cworking around\u201d features that you know Excel is capable of because you don\u2019t know how to use them? This workshop will show you how to end your Excel frustrations for good by providing the \u201chow-to\u2019s\u201d for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and timesaving techniques. Work smarter, not harder, by enrolling in this workshop today!<\/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_MS69f22e1303a14\" 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=\"MS69f22e1303a14\" 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_3a14 = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_3a14.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_3a14.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_3a14.setup(\"MS69f22e1303a14\", {\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_3a14 );\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.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_2&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;||||||||&#8221; link_font=&#8221;||||||||&#8221; ul_font=&#8221;||||||||&#8221; ol_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;||||||||&#8221; header_3_font=&#8221;||||||||&#8221; header_4_font=&#8221;||||||||&#8221; header_5_font=&#8221;||||||||&#8221; header_6_font=&#8221;||||||||&#8221; background_color=&#8221;#F0F8FF&#8221; custom_padding=&#8221;20px|20px|60px|20px&#8221; custom_padding_phone=&#8221;||20px|&#8221; custom_padding_last_edited=&#8221;on|desktop&#8221; animation_style=&#8221;fade&#8221;]<\/p>\n<h5><strong>What can this workshop do for you?<\/strong><\/h5>\n<p>&nbsp;<\/p>\n<ol>\n<li>You\u2019ll get more done in less time<\/li>\n<li>You\u2019ll learn and retain more in one day than you can imagine<\/li>\n<li>You\u2019ll increase your abilities<\/li>\n<li>You\u2019ll get great tips and tricks to help you in your daily work<\/li>\n<li>You\u2019ll build skills and learn techniques you can use immediately<\/li>\n<li>You\u2019ll get our 24\/7 after class help line<\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; background_color=&#8221;#DFEFFF&#8221; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221;]<\/p>\n<h5><strong>Who should attend?<\/strong><\/h5>\n<p>Account Executives, Managers, Supervisors, Project Managers, Sales Executives, Directors and Business Owners<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; background_color=&#8221;#C4E1FF&#8221; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221;]<\/p>\n<h5><strong>About the Trainer<\/strong><\/h5>\n<p>Kelvin Ng is a Microsoft Certified Trainer (MCT) and Microsoft Office 2010 Master Specialist with 15 years of training experience. He is able to relate practical usage of Formulas and Excel Features in your daily work and save you a great deal of time.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.11.1&#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;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;]<\/p>\n<h2>Improve Your Microsoft Excel Skill Now !<\/h2>\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;#202332&#8243;][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;||||||||&#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;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;]<\/p>\n<h2>Course Outline<\/h2>\n<p>Duration: 1 Day<\/p>\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 title=&#8221;Module 1: Time-saving 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<p>To really get the most out of Excel, you need to know not only how to accomplish certain tasks but how to accomplish them fast. That\u2019s what this session is all about. You\u2019ll learn some quick keyboard shortcuts that\u2019ll get you where you want to be many times faster than using your mouse to maneuver through your worksheets. You\u2019ll also uncover some amazing techniques for importing data so you don\u2019t have to re-enter data from other applications. You\u2019ll also learn \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>How to format large blocks of cells quickly and efficiently with the power of Format Painter<\/li>\n<li>Make your titles and headings stand out by using the Merge and Center formatting feature<\/li>\n<li>How to quickly create cus<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 3: Data analysis and formulas&#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<p>The real power of Excel is in data analysis, and that\u2019s what this session is all about. You\u2019ll dive headfirst into the data analysis techniques and formulas found in Excel, but you won\u2019t have to be a mathematician to make sense of all the possibilities Excel has to offer. We\u2019ll explain the most commonly used functions and analysis tools in plain English so you\u2019ll walk away with the skills you need to get the most out of Excel. You\u2019ll learn \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>A technique that allows you to sum only the data that meets conditions you specify<\/li>\n<li>Using the Goal Seek function to help determine how to get your desired result<\/li>\n<li>The right way to use the Lookup Wizard to help you write a formula that finds the value at the intersection of a column and a row<\/li>\n<li>What the Excel Data Table is, how to load it and how to take advantage of the new user interface to get the most out of it<\/li>\n<li>How to use the Scenario tool to do a what-if-analysis?<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 5: Getting the most out of PivotTable and PivotChart\u00ae reports&#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<p>Trying to view and understand worksheets that contain hundreds or even thousands of rows of data used to be a nearly impossible task. But now you can use PivotTable reports to view and organize your Excel data quickly and easily, and that\u2019s what you\u2019ll learn in this session. You\u2019ll discover how you can organize your data with just a few simple mouse clicks to see comparisons, reveal patterns and analyze trends. You\u2019ll also find out \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>The in\u2019s and out\u2019s of Excel PivotTable and PivotChart reports, including the terminology used in PivotTable reports<\/li>\n<li>How to use slicers and other techniques to quickly drill down in your PivotTable without having to go back to your source data to identify specific information<\/li>\n<li>The quick and easy way to create a PivotTable using the PivotTable Wizard<\/li>\n<li>The techniques that allow you to instantly restructure your PivotTable and change the information reported<\/li>\n<li>How to change your PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][et_pb_blurb title=&#8221;Module 2: Designing forms and formatting&#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<p>Using Excel to create custom forms such as invoices, purchase orders and others is a great way to take advantage of some of the advanced features it has to offer. This session will show you how to create virtually any type of form quickly\u2014and with features you might not have thought were even possible. You\u2019ll discover \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>How to create stunning 3-D effects with your cells and implement the new artistic effects on images in your worksheets<\/li>\n<li>Using templates to create your worksheet can have you finished and on to the next project in a fraction of the time<\/li>\n<li>How to use Excel to quickly create professional-looking forms in minutes (not hours!)<\/li>\n<li>How to implement conditional formatting, take advantage of the new icon sets and a dozen other formatting tips and techniques for making your data stand out<\/li>\n<li>How to add control items to your worksheets, including combo boxes, option buttons and many others<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 4: Advanced charting and graphing functions&#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<p>Virtually anyone can put some numbers down in a spreadsheet, select them and then click the Chart Wizard button to create a reasonable-looking chart, but it takes advanced skills to make charts and graphs with stunning effects that really capture the reader\u2019s attention. In this session, you\u2019ll learn how to create some amazing special effects that\u2019ll give your charts a professional appearance without taking hours to complete. You\u2019ll find out \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>How to quickly create a basic chart with a single keystroke<\/li>\n<li>Use pictures to create exciting charts that are even more descriptive<\/li>\n<li>How to insert a Sparkline into a cell to instantly reveal patterns in your data?<\/li>\n<li>How to know which chart or graph type to use?<\/li>\n<li>How to add a chart\u2014or virtually any kind of image\u2014to a comment that displays when the user moves the mouse over a cell<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 6: Validating and securing your data&#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<p>Having data in your spreadsheet is only half the battle. Making sure your data is valid and secure is extremely important, and that\u2019s what this session is all about. Your spreadsheets are only as good as the data they contain, and human error in data entry is an extremely common problem. We\u2019ll show you some of the best techniques to help eliminate human error from your data management equation. You\u2019ll learn \u2026<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>How to lock values and formulas in your Excel worksheets<\/li>\n<li>Track down mistakes in your worksheet using the Formula Auditing tools<\/li>\n<li>How to share your Excel workbook and not worry about someone making changes that\u2019ll ruin your work<\/li>\n<li>How to use Data Validation to make sure the data going into any cell meets the criteria you\u2019ve specified<\/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;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;||||||||&#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-Advanced-Beyond-Microsoft-Excel.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;]<br \/>\n[\/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;]<\/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: Microsoft Excel: Advanced &amp; Beyond||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;Microsoft Excel &#8211; Advanced &amp; Beyond&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#8243; title_level=&#8221;h5&#8243; title_font=&#8221;|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_text_color=&#8221;#000000&#8243; 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.4em&#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;2%&#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; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/309"}],"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=309"}],"version-history":[{"count":16,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/309\/revisions"}],"predecessor-version":[{"id":1107,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/309\/revisions\/1107"}],"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=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}