{"id":606,"date":"2020-02-11T09:37:00","date_gmt":"2020-02-11T01:37:00","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=606"},"modified":"2020-03-16T11:20:08","modified_gmt":"2020-03-16T03:20:08","slug":"microsoft-office-for-accounts-and-finance","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/microsoft-office-for-accounts-and-finance\/","title":{"rendered":"Microsoft Office for Accounts and Finance"},"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;https:\/\/ensy.my\/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 Office for Accounts and Finance&#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;]<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\/Word-Std-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.3em&#8221; max_width=&#8221;80%&#8221; module_alignment=&#8221;center&#8221;]<\/p>\n<h5 style=\"text-align: center;\">Microsoft Office for Accounts and Finance combines the powerful features of Excel and Word that allow you to manage and analyse your financial data with ease and increasing your day-to-day efficiency. This training will also expose you on how your business documents and forms are collaborated in order to make your work much easier. You\u2019ll be amazed with the tips and tricks that save you the most time and effort. Enjoy learning MS Office for Accounts and Finance!<\/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_MS69f22de418f4e\" class=\"master-slider-parent ms-parent-id-9\"  >\n\n\t\t\t\n\t\t\t<!-- MasterSlider Main -->\n\t\t\t<div id=\"MS69f22de418f4e\" 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_8f4e = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_8f4e.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_8f4e.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_8f4e.setup(\"MS69f22de418f4e\", {\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_8f4e );\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;4_4&#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; text_font=&#8221;||||||||&#8221; link_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h5><strong>You\u2019ll learn<\/strong><\/h5>\n<ul>\n<li>Advanced Data Management with Microsoft Excel<br \/>\n&#8211; Reporting and extracting of records will make easy using the Formulas and Functions that will streamline the workflow of your report.<\/li>\n<li>Business Data Analysis with Microsoft Excel<br \/>\n&#8211; Analysis business data is crucial for all Finance Personnel to produce meaningful report for the management.<br \/>\n&#8211; Being able to protect and secure your work is also very important.<\/li>\n<li>Business Documents and Forms with Microsoft Word<br \/>\n&#8211; Collaboration within Microsoft Office Application can make your work much easier.<br \/>\n&#8211; Reports, proposals, technical financial reports and much more are made easy with centralised formatting using Microsoft Word.<\/li>\n<\/ul>\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; background_color=&#8221;#DFEFFF&#8221;]<\/p>\n<h5><strong>Who Should Attend<\/strong><\/h5>\n<p>Individuals who have been using Microsoft Office applications and wanted to improve their skill in handling data in variety of ways to best suit the organization. Accounts and Finance staff from various industries are encouraged to participate in this program.<\/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|77px|20px&#8221; custom_padding_phone=&#8221;||20px|&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#DFEFFF&#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_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>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; 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>Why you should train with us?<\/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\/microsoft.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_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; link_font=&#8221;||||||||&#8221; ul_font=&#8221;||||||||&#8221; header_font=&#8221;||||||||&#8221;]<\/p>\n<h2>Course Outline<\/h2>\n<p>Duration: 2 days (9.00am \u2013 5.00pm)<br \/>\nVenue: In-House Training<\/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 admin_label=&#8221;Module 1&#8243; title=&#8221;MODULE 1: Functions for Financial Analysis&#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>You will learn the new financial features such as naming a cell, hiding of formulas and the meaning of the term array formula. More functions such as IF, INDEX, MATCH and OFFSET will be introduced and the application of these functions.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 Offset, Index and Match Formulas<br \/>\n\u2022 Using name range and create a dynamic Range<br \/>\n\u2022 Vlookup &amp; Hlookup Functions<br \/>\n\u2022 Logical Functions (If, And, Or, Iferror)<br \/>\n\u2022 Database Functions<br \/>\n\u2022 Text Functions<\/p>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;MODULE 3: Analysing Data&#8221; title=&#8221;MODULE 3: Analysing 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>This module will expose you to Pivot Table as a reporting tool. You will learn data extraction, how to display them in a presentable table, the manipulation of the table as well as converting the extracted data to charts and other graphics presentations.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 Understanding Data List (Database)<br \/>\n\u2022 Database Management Features<br \/>\n&#8211; Sort<br \/>\n&#8211; Subtotal<br \/>\n&#8211; AutoFilter &amp; Advance Filter<br \/>\n\u2022 PivotTable Part I<br \/>\n\u2022 PivotTable Part II<\/p>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;5&#8243; title=&#8221;MODULE 5: Streamline your workflow in Microsoft Word&#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>In this module, you will learn to deal with long documents formatting. Most Word Users will spend many hours formatting their document or repairing their formatting in the document. This issue can be solved by using the Style in Microsoft Word. You will learn to create Table of Contents, use the Reference tools and setup a cover page in just a few clicks.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 Understanding and applying styles in the document<br \/>\n\u2022 Modifying the Style<br \/>\n\u2022 Create a Table of Contents<br \/>\n\u2022 Modify and update your Table of Contents<br \/>\n\u2022 Create Cross References<br \/>\n\u2022 Collaborate Microsoft Office application<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][et_pb_blurb admin_label=&#8221;module 2&#8243; title=&#8221;MODULE 2: Sensitivity Analysis in Business&#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>This module delves into the important and commonly used Excel features such as Data Table, Solver and Scenarios. These features are used for IF analysis and you will be shown how each of them are used and applied.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 What If Analysis<br \/>\n&#8211; Data Table<br \/>\n&#8211; Scenario Manager<br \/>\n&#8211; Goal Seek<br \/>\n&#8211; Solver<br \/>\n\u2022 Data Validation<br \/>\n\u2022 Conditional Formatting<br \/>\n\u2022 Cell, Worksheet and Workbook Protection<\/p>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;MODULE 4&#8243; title=&#8221;MODULE 4: Importing Data to 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_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>This module will expose you to solve problems face when importing external data into Excel. Importing text documents (txt), word documents (docx) and other formats are made easy using the import wizards. You can also import data from the internet such as the Exchange Rates if you trade in various currencies.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 Import Data to Excel<br \/>\n&#8211; Using Text Delimiters<br \/>\n&#8211; Text to Columns<br \/>\n\u2022 Import data from the Web<\/p>\n<p>[\/et_pb_blurb][et_pb_blurb admin_label=&#8221;6&#8243; title=&#8221;MODULE 6: Finalizing Your Document&#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>You will learn how to protect and prevent the document from accidental editing or intentional editing by unauthorised user. Document authenticity will be addressed and you can sign off a document using your digital signature.<\/p>\n<p><strong>Topics Covered:<\/strong><br \/>\n\u2022 Password Protection<br \/>\n&#8211; Password to Open<br \/>\n&#8211; Password to Modify<br \/>\n&#8211; Encrypt your Document<br \/>\n\u2022 Mark document as Final<br \/>\n\u2022 Understanding Digital Signature<\/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-Microsoft-Office-for-Accounts-and-Finance.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: Microsoft Office for Accounts and Finance||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;https:\/\/ensy.my\/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 Office for Accounts and Finance&#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; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/606"}],"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=606"}],"version-history":[{"count":12,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/606\/revisions"}],"predecessor-version":[{"id":1121,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/606\/revisions\/1121"}],"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=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}