{"id":305,"date":"2020-01-10T17:43:25","date_gmt":"2020-01-10T09:43:25","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=305"},"modified":"2020-04-28T14:06:34","modified_gmt":"2020-04-28T06:06:34","slug":"getting-the-most-from-microsoft-excel","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/getting-the-most-from-microsoft-excel\/","title":{"rendered":"Getting the Most From Microsoft Excel"},"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;Getting the Most From Microsoft Excel&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#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;rgba(255,255,255,0.7)&#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; background_layout=&#8221;light&#8221; custom_padding=&#8221;25px||25px|&#8221; title_level=&#8221;h2&#8243; \/][\/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; header_font=&#8221;||||||||&#8221; header_5_font=&#8221;||||||||&#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_MS6a3cd80bca7aa\" 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=\"MS6a3cd80bca7aa\" 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_a7aa = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_a7aa.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_a7aa.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_a7aa.setup(\"MS6a3cd80bca7aa\", {\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_a7aa );\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; background_color=&#8221;#f0f8ff&#8221; custom_padding=&#8221;20px|20px|30px|20px&#8221; custom_padding_phone=&#8221;||20px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;fade&#8221; text_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;]<\/p>\n<h5><strong>You\u2019ll learn:<\/strong><\/h5>\n<ul>\n<li>How to customize the ribbon to increase your productivity and even create new tabs and even create new tabs and hide the ones you never use<\/li>\n<li>Data, reports, graphs and formulas-making the most of Excel\u2019s many talents<\/li>\n<li>How to solve print problems and get your information to look the way you want it<\/li>\n<li>Spreadsheets, charts and more-easy to make spreadsheets and figures into colorful, clear and precise presentations<\/li>\n<li>And much more<\/li>\n<\/ul>\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, Business Owners and Individuals who want to improve the Microsoft Excel skills<\/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_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;#000000&#8243;][et_pb_row _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_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;]<\/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 title=&#8221;Module 1: Getting Started \u2013 Excel Essentials&#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 you need to know about the Excel interface including working with the ribbon<\/li>\n<li>How to customize the ribbon to increase your productivity and even create new tabs and hide the ones you never use<\/li>\n<li>The Microsoft Office button is gone\u2014how to use the new Microsoft Office Backstage view<\/li>\n<li>Workbook and worksheet essentials\u2014how to create, manage, save and rename workbooks and worksheets<\/li>\n<li>How to increase your productivity with special keyboard shortcuts and mouse techniques?<\/li>\n<li>How to get started quickly with one of the many templates Excel has to offer<\/li>\n<li>Uncover all the different Options settings and find out which ones you may want to change depending on how you use Excel<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 3: Formulas and functions\u2014The real power of Excel&#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>Mastering the mysteries of relative and absolute cell references\u2014 \u201cmust-know\u201d information for working with formulas<\/li>\n<li>Discover the Function Library and how to add functions to your formulas and make sure you\u2019re using the correct syntax<\/li>\n<li>How to use the Insert Function dialog box to insert functions and to quickly get help on how the selected function works<\/li>\n<li>How to use the Name Manager to name a data range and use it in your formulas to save time and effort<\/li>\n<li>Understanding and using the Trace Precedents and Trace Dependents features<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 5: Managing your data\u2014Connections, sorting, filtering and data tools&#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>How to create data connections to virtually any type of data, including simple text files, Web pages and other Microsoft Office applications<\/li>\n<li>How to use the Sort feature to sort on not only values of cells but the color of the cells, color of the cell font and more<\/li>\n<li>How to prevent bad data from being entered by using the Data Validation feature<\/li>\n<li>How to automatically add subtotals to several rows of related data with just a couple of mouse clicks<\/li>\n<li>Using the powerful filter features of Excel to view only the data you have need of<\/li>\n<li>How to insert a Slicer to interactively filter data?<\/li>\n<li>How to easily separate the contents of one cell into multiple columns such as first and last names<\/li>\n<li>How to dramatically speed up data input with the powerful AutoFill feature and increase the power of the AutoFill feature by using Custom Lists<\/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: Formatting and styles\u2014Getting the look you want&#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>How to modify the format of numerical data in your worksheets?<\/li>\n<li>How to format large blocks of cells quickly and efficiently with the power of Format Painter<\/li>\n<li>How to add, change, find or clear conditional formats<\/li>\n<li>What icon sets are and how to use them to make your important data stand out<\/li>\n<li>Quick cell formatting from predefined styles<\/li>\n<li>How to easily select a range of cells and convert it into a great-looking table that stands out on your worksheet<\/li>\n<li>Secrets of the Merge and Center button and how to use it to create professional-looking headings<\/li>\n<li>How to use the Format option to modify cell sizes and visibility, and organize and protect your worksheets?<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 4: Objects, charts and Sparkline&#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>How to quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse<\/li>\n<li>How to insert complex mathematical equations and symbols into your worksheets<\/li>\n<li>How to use the new Screenshot feature to quickly insert a screenshot of any open application?<\/li>\n<li>How to quickly select your data and insert a chart into your worksheet<\/li>\n<li>Bar chart, pie chart, line chart\u2014how to choose and use the right type of chart to get your point across<\/li>\n<li>How to use the Chart Tools to create stunning charts that have that professional look?<\/li>\n<li>How to save your finished chart as a template that you can apply to future charts?<\/li>\n<li>Stock, Surface, Doughnut, Bubble and Radar\u2014how using advanced chart types can capture your audience\u2019s attention<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 6: Reviewing, sharing and printing&#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>How to add comments to a worksheet?<\/li>\n<li>Keeping track of the changes made to a spreadsheet by others so you can decide which to keep and which to discard<\/li>\n<li>How to protect a workbook so that only those you choose can open it<\/li>\n<li>The steps you\u2019ll need to take in order to share your workbook with others<\/li>\n<li>How to quickly check for issues such as compatibility with previous versions before you share your workbook<\/li>\n<li>How to create a range of cells that other users can edit while the rest of the worksheet is locked?<\/li>\n<li>How to save time by creating a Custom view to select a print area you need to print on a regular basis<\/li>\n<li>How to use the Print Titles feature to specify rows and columns to repeat on each printed page?<\/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;Clients Logos&#8221; _builder_version=&#8221;3.0.83&#8243; background_color=&#8221;#f8fbfe&#8221; custom_padding=&#8221;5px|0px|54px|0px|false|false&#8221; prev_background_color=&#8221;#000000&#8243; next_background_color=&#8221;#202332&#8243;][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_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;Nunito Sans|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; header_font=&#8221;||||||||&#8221;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/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;]<\/p>\n<p>&nbsp;<\/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;||||||||&#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-Getting-The-Most-From-MS-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;]<\/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;]<\/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: Getting the Most From Microsoft Excel||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;Getting the Most From Microsoft Excel&#8221; content_max_width=&#8221;900px&#8221; _builder_version=&#8221;3.11.1&#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;rgba(255,255,255,0.7)&#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; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/305"}],"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=305"}],"version-history":[{"count":29,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/305\/revisions"}],"predecessor-version":[{"id":1105,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/305\/revisions\/1105"}],"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=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}