{"id":321,"date":"2020-01-10T18:03:58","date_gmt":"2020-01-10T10:03:58","guid":{"rendered":"http:\/\/ensy.ioweb.studio\/?page_id=321"},"modified":"2020-03-16T11:15:09","modified_gmt":"2020-03-16T03:15:09","slug":"mastering-microsoft-excel-pivottable-functions","status":"publish","type":"page","link":"https:\/\/ensy.my\/index.php\/public-training\/mastering-microsoft-excel-pivottable-functions\/","title":{"rendered":"Mastering Microsoft Excel: PivotTable &#038; Functions"},"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: PivotTable &amp; Functions&#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;1%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; custom_button_two=&#8221;on&#8221; button_two_text_size=&#8221;14px&#8221; button_two_text_color=&#8221;#29cb8b&#8221; button_two_bg_color=&#8221;#ffffff&#8221; button_two_border_width=&#8221;12px&#8221; button_two_border_color=&#8221;#ffffff&#8221; button_two_letter_spacing=&#8221;2px&#8221; button_two_font=&#8221;Poppins|600||on|||||&#8221; button_two_icon=&#8221;%%3%%&#8221; button_two_letter_spacing_hover=&#8221;2px&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;14px&#8221; button_one_bg_color=&#8221;#29cb8b&#8221; button_one_border_width=&#8221;12px&#8221; button_one_border_color=&#8221;#29cb8b&#8221; button_one_letter_spacing=&#8221;2px&#8221; button_one_font=&#8221;Poppins|600||on|||||&#8221; button_one_icon=&#8221;%%3%%&#8221; button_one_letter_spacing_hover=&#8221;2px&#8221; custom_padding=&#8221;25px||25px|&#8221; title_level=&#8221;h2&#8243; background_layout=&#8221;light&#8221; content_font=&#8221;||||||||&#8221; subhead_text_color=&#8221;#000000&#8243;]<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; _builder_version=&#8221;3.11.1&#8243; prev_background_color=&#8221;#000000&#8243; next_background_color=&#8221;#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\/Slide72.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_font=&#8221;||||||||&#8221; header_5_font=&#8221;||||||||&#8221; 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;\">Functions and Formulas are some of the advanced features of Microsoft Excel that allow you to become more productive and increase your day-to-day efficiency. The Mastering Microsoft Excel: Formulas &amp; Functions training will expose you to how Formulas and Functions are used to perform complex calculations and data analysis.<\/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_MS69f22e61ec535\" class=\"master-slider-parent ms-parent-id-5\"  >\n\n\t\t\t\n\t\t\t<!-- MasterSlider Main -->\n\t\t\t<div id=\"MS69f22e61ec535\" 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_c535 = new MasterSlider();\n\n\t\t\t\/\/ slider controls\n\t\t\tmasterslider_c535.control('arrows'     ,{ autohide:true, overVideo:true  });\n\t\t\tmasterslider_c535.control('timebar'    ,{ autohide:false, overVideo:true, align:'bottom', color:'#FFFFFF'  , width:4 });\n\t\t\t\/\/ slider setup\n\t\t\tmasterslider_c535.setup(\"MS69f22e61ec535\", {\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_c535 );\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|27px|20px&#8221; custom_padding_phone=&#8221;||20px|&#8221; custom_padding_last_edited=&#8221;on|desktop&#8221; animation_style=&#8221;fade&#8221; custom_css_main_element=&#8221;background:#f0f8ff;&#8221; background_color=&#8221;#F0F8FF&#8221;]<\/p>\n<h5><strong>You\u2019ll learn:<\/strong><\/h5>\n<ul>\n<li>\u00a0How to use PivotTable to Analyze &amp; Summarize your database for easy understanding<\/li>\n<li>Data, reports, graphs and formulas\u2014making the most of Excel\u2019s many talents<\/li>\n<li>How to solve the Break Even Point, convert calculations to Tables of Variable for analysis purposes<\/li>\n<li>Spreadsheets &amp; more\u2014easy ways 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; 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>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; custom_padding=&#8221;20px|20px|20px|20px&#8221; animation_style=&#8221;fade&#8221; background_color=&#8221;#C4E1FF&#8221;]<\/p>\n<h5><strong>About the Trainer<\/strong><\/h5>\n<p>Kelvin Ng is a Microsoft Certified Trainer (MCT) and Microsoft Office 2010 Master Specialist with 15 years of training experience. He is able to relate practical usage of Formulas and Excel Features in your daily work and save you a great deal of time.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.11.1&#8243;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.11.1&#8243; text_font=&#8221;||||||||&#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\/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: 2 Days<\/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;Module 1: Reporting Using Pivot Table&#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;-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>Introducing the Pivot Table<\/li>\n<li>Understanding the Anatomy of a Pivot Table<br \/>\n&#8211; Understanding the Values Area in your layout<br \/>\n&#8211; Assign the fieldnames in the Row &amp; Column Labels Area<br \/>\n&#8211; Display what you want to present using the Filter Area<\/li>\n<li>All you need to know on Creating the Basic Pivot Table Report<br \/>\n&#8211; Understanding the layout of the Pivot Table<br \/>\n&#8211; Change your report Layout the way you want to present the Pivot Table<br \/>\n&#8211; Using different view of a Pivot Table Report<br \/>\n&#8211; How to Update Your Pivot Table?<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 3: Formulas and functions\u2014Mathematical Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/formula.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>ROUND Function<\/li>\n<li>ROUNDDOWN Function<\/li>\n<li>ROUNDUP Function<\/li>\n<li>MROUND Function<\/li>\n<li>CEILING Function<\/li>\n<li>FLOOR Function<\/li>\n<li>Large and Small Functions<\/li>\n<li>SUMIF Function<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 5: Formulas and functions\u2014Statistical Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/formula.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>COUNT Function<\/li>\n<li>COUNTA Function<\/li>\n<li>COUNTIF Function<\/li>\n<li>COUNTIFS Function<\/li>\n<li>COUNTBLANK Function<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 7: Formulas and functions\u2014LOGICAL Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/formula.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>IF Function<\/li>\n<li>AND &amp; OR Functions<\/li>\n<li>IFERROR Function<\/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: Data Analysis\u2014What-If-Analysis&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/table.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>\u00a0Work your formula Backward by changing cell value using Goal Seek<\/li>\n<li>Analyze the potential of a calculation using Data Table<br \/>\n&#8211; Using One-Input Data Table when using single set of Variables<br \/>\n&#8211; Using Two-Input Data Table when using two sets of Variables<\/li>\n<li>How to multiple Case Studies using Scenario<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 4: Formulas and functions\u2014Date Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/calendar-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_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>TODAY Function<\/li>\n<li>NOW Function<\/li>\n<li>WORKDAY Function<\/li>\n<li>NETWORKDAYS Function<\/li>\n<li>EDATE Function<\/li>\n<li>EOMONTH Function<\/li>\n<li>DATEDIF Function<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 6: Formulas and functions\u2014TEXT Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/edit-tools.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>\u00a0CONCATENATE Function<\/li>\n<li>LEFT, RIGHT &amp; MID Functions<\/li>\n<li>UPPER &amp; Lower Functions<\/li>\n<li>TRIM Function<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 8: Formulas and functions\u2014LOOKUP Functions&#8221; url=&#8221;#&#8221; image=&#8221;\/wp-content\/uploads\/2020\/02\/loupe.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>VLOOKUP Function<\/li>\n<li>HLOOKUP Function<\/li>\n<li>CHOOSE Function<\/li>\n<\/ul>\n<p>[\/et_pb_blurb][et_pb_blurb title=&#8221;Module 9: Formulas and functions\u2014DATABASE Functions&#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;||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;]<\/p>\n<ul>\n<li>DSUM Function<\/li>\n<li>DAVERAGE Function<\/li>\n<li>DMAX Function<\/li>\n<li>DMIN Function<\/li>\n<li>DCOUNT Function<\/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;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;15px&#8221; header_font=&#8221;|700|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#ffffff&#8221; header_font_size=&#8221;35px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;|700|||||||&#8221; header_2_text_align=&#8221;left&#8221; header_2_text_color=&#8221;#ffffff&#8221; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.4em&#8221; custom_margin=&#8221;||| &#8220;]<\/p>\n<h2>Download PDF Version Here<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243;][et_pb_button button_url=&#8221;\/wp-content\/uploads\/2020\/01\/ENSY-Mastering-MS-Excel-PivotTable-Functions.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: PivotTable &amp; Functions||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: PivotTable &amp; Functions&#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;1%&#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":6,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/321"}],"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=321"}],"version-history":[{"count":14,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/321\/revisions"}],"predecessor-version":[{"id":1113,"href":"https:\/\/ensy.my\/index.php\/wp-json\/wp\/v2\/pages\/321\/revisions\/1113"}],"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=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}