{"id":312,"date":"2020-01-10T17:55:13","date_gmt":"2020-01-10T09:55:13","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=312"},"modified":"2020-03-16T11:12:56","modified_gmt":"2020-03-16T03:12:56","slug":"mastering-microsoft-excel-analysing-data-with-pivottable","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/mastering-microsoft-excel-analysing-data-with-pivottable\/","title":{"rendered":"Mastering Microsoft Excel: Analysing Data With PivotTable"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Hero Section&#8221; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;http:\/\/ensy.ioweb.studio\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_fullwidth_header subhead=&#8221;Mastering Microsoft Excel: Analysing Data With PivotTable&#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_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;#000000&#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_image src=&#8221;\/wp-content\/uploads\/2020\/01\/Slide123.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;\">PivotTable\u00a0is one of the advanced features of\u00a0Microsoft Excel\u00a0that allows you to become more productive and increase your day-to-day efficiency.\u00a0Analysing Data With PivotTable training<strong>\u00a0<\/strong>will expose you how PivotTable is used to manage and analyse data. Discover the tips and tricks that save you the most time and effort. Enjoy learning\u00a0Analysing Data with PivotTable!<\/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_MS69f22ddb200aa\" class=\"master-slider-parent ms-parent-id-4\"  >\n\n\t\t\t\n\t\t\t<!-- MasterSlider Main -->\n\t\t\t<div id=\"MS69f22ddb200aa\" 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_00aa = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_00aa.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_00aa.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_00aa.setup(\"MS69f22ddb200aa\", {\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_00aa );\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; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221;]<\/p>\n<h5><strong>You\u2019ll learn:<\/strong><\/h5>\n<ul>\n<li>Understanding PivotTable in MS Excel<\/li>\n<li>Creating and Customizing PivotTable<\/li>\n<li>Categorizing the Data Fields<\/li>\n<li>Converting to PivotChart<\/li>\n<li>Creating and Editing Calculated Field and Item<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221;]<\/p>\n<h5><strong>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_2&#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 use Excel in their dayto-day work or those involve in Reporting and Data Analysis but would like to discover the power of<br \/>\nPivotTables in analyzing and summarizing data.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#DFEFFF&#8221;]<\/p>\n<h5><strong>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>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; admin_label=&#8221;Courses Hero&#8221; _builder_version=&#8221;3.11.1&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#474ab6&#8243; background_color_gradient_end=&#8221;#9271f6&#8243; background_image=&#8221;http:\/\/ensy.ioweb.studio\/wp-content\/uploads\/2020\/02\/coding-background-texture.jpg&#8221; background_blend=&#8221;overlay&#8221; custom_padding=&#8221;50px|0px|100px|0px&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;top&#8221; animation_intensity_slide=&#8221;2%&#8221; prev_background_color=&#8221;#ffffff&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_row custom_width_px=&#8221;1280px&#8221; custom_margin=&#8221;|||&#8221; _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; header_font=&#8221;|on|||&#8221; header_font_size=&#8221;42px&#8221; header_font_size_last_edited=&#8221;on|desktop&#8221; header_line_height=&#8221;1.3em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; text_orientation=&#8221;center&#8221; background_layout=&#8221;dark&#8221; max_width=&#8221;530px&#8221; module_alignment=&#8221;center&#8221; custom_padding=&#8221;|||&#8221; locked=&#8221;off&#8221;]<\/p>\n<h1>Courses Outline<\/h1>\n<p>Duration: 1 day<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Courses&#8221; _builder_version=&#8221;3.11.1&#8243; custom_padding=&#8221;0px|0px|0px|0px&#8221; prev_background_color=&#8221;#000000&#8243; next_background_color=&#8221;#202332&#8243;][et_pb_row custom_padding=&#8221;0px|0px|0px|0px&#8221; custom_margin=&#8221;|||&#8221; _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;1_2&#8243;][et_pb_blurb title=&#8221;1. PivotTable&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/database.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;-80px||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Getting to know a PivotTable<\/li>\n<li>The Best Practice Using a Database for PivotTable<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;2: Creating PivotTable&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/report-1.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Database Pre-requisite for preparing a PivotTable Report<\/li>\n<li>Designing a PivotTable<\/li>\n<li>Adding Elements to the Report<\/li>\n<li>Creating a Report Filter<br \/>\n&#8211; Use Table Field as Report Filter<br \/>\n&#8211; Use the Report Filter<br \/>\n&#8211; Reset the Filter<\/li>\n<li>Use Slicers to Filter Report<br \/>\n&#8211; What is Slicers?<br \/>\n&#8211; Remove Slicers<\/li>\n<li>Update the Data Source<br \/>\n&#8211; Changes Data Sources<br \/>\n&#8211; Create a Dynamic Range for the Data Table<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;3: Customizing a PivotTable&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/spreadsheet.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Format a PivotTable<br \/>\n&#8211; Use PivotTable Style<br \/>\n&#8211; Number and Text Format<br \/>\n&#8211; Explore the PivotTable Options<br \/>\n&#8211; Use the Value Field Settings<\/li>\n<li>Subtotals<\/li>\n<li>Show Value As<\/li>\n<li>PivotTable Print Options<\/li>\n<li>Grand Totals<\/li>\n<li>Report Layout<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243;][et_pb_blurb title=&#8221;4: Grouping. Sorting and Filtering&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/insert.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;-80px||10%|&#8221; custom_margin_tablet=&#8221;0px||10%|&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Grouping Pivot Fields<br \/>\n&#8211; Dates<br \/>\n&#8211; Number Fields<br \/>\n&#8211; Text<\/li>\n<li>Ungrouping<\/li>\n<li>Sort and Filtering the PivotTable<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;5: Use \u201cFields, Item and Sets\u201d&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/spreadsheet.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Creating Calculated Field<\/li>\n<li>Creating Calculated Item<\/li>\n<li>Edit and Delete Calculated Field or Item<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;6: PivotCharts&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/convert.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Convert PivotTable to PivotChart<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;7: PivotTable Wizards&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/insert.png&#8221; icon_placement=&#8221;left&#8221; content_max_width=&#8221;1100px&#8221; _builder_version=&#8221;3.11.1&#8243; header_font=&#8221;|on|||&#8221; header_text_color=&#8221;#2e2545&#8243; header_line_height=&#8221;1.5em&#8221; body_text_color=&#8221;#8585bd&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.9em&#8221; background_color=&#8221;#ffffff&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; box_shadow_style=&#8221;preset2&#8243; box_shadow_horizontal=&#8221;0px&#8221; box_shadow_vertical=&#8221;0px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_color=&#8221;rgba(71,74,182,0.12)&#8221; custom_margin=&#8221;||10%|&#8221; custom_padding=&#8221;30px|40px|30px|40px&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_zoom=&#8221;20%&#8221; animation_starting_opacity=&#8221;100%&#8221; locked=&#8221;off&#8221;]<\/p>\n<ul>\n<li>Multiple Consolidation Ranges<\/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;#ffffff&#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 File Here<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_button button_url=&#8221;\/wp-content\/uploads\/2020\/01\/ENSY-Mastering-MS-Excel-Analysing-Data-With-PivotTable.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: Mastering Microsoft Excel: Analysing Data With PivotTable||et_pb_line_break_holder||||et_pb_line_break_holder||Name: %%Name%%||et_pb_line_break_holder||Email: %%Email%%||et_pb_line_break_holder||Mobile: %%Mobile%%||et_pb_line_break_holder||Message: %%Message%%||et_pb_line_break_holder||&#8221; module_id=&#8221;et_pb_contact_form_0&#8243; _builder_version=&#8221;3.11.1&#8243;][et_pb_contact_field field_id=&#8221;Name&#8221; field_title=&#8221;Name *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Email&#8221; field_title=&#8221;Email *&#8221; field_type=&#8221;email&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Mobile&#8221; field_title=&#8221;Mobile *&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Message&#8221; field_title=&#8221;Message&#8221; field_type=&#8221;text&#8221; required_mark=&#8221;off&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243;][\/et_pb_contact_field][\/et_pb_contact_form][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Hero Section&#8221; fullwidth=&#8221;on&#8221; _builder_version=&#8221;3.11.1&#8243; background_image=&#8221;http:\/\/ensy.ioweb.studio\/wp-content\/uploads\/2019\/12\/job_recruitement_14.jpg&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;|||&#8221; next_background_color=&#8221;#ffffff&#8221;][et_pb_fullwidth_header subhead=&#8221;Mastering Microsoft Excel: Analysing Data With PivotTable&#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_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; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":36,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/312"}],"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=312"}],"version-history":[{"count":17,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/312\/revisions"}],"predecessor-version":[{"id":1109,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/312\/revisions\/1109"}],"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=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}