MICROSOFT EXCEL - ADVANCED MICROSOFT OFFICE STANDARD Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd

Microsoft Excel - Advanced

Course Duration: 2 Days


This course is suitable for participants who are working with nested formulas, performs what if analysis, consolidating data and creates Pivot Table to have in depth understanding of how electronic spreadsheet works.


  • Have attended Microsoft Excel Foundation & Intermediate level
  • Able to switch between task applications
  • Able to create simple to complex formulas & functions
  • Able to validate data in a Worksheet
  • Able to filter data using Auto & Advanced Filters
  • Able to clean duplicate records


  • Create subtotal using the Subtotal Function
  • Analyze data using Pivot Tables
  • Perform What If Analysis
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & consolidating data
  • Record and run a Macro

Course Outlines:

Module 1: Getting the Most from Your Data

  • Outlining and Grouping Data

Module 2: What If Analysis

  • Using Data Analysis Tools
  • Exploring Scenarios
  • Using Solver

Module 3: Advanced Excel Task

  • Working with Array Formulas
  • Using VLOOKUP Function
  • Using the Advanced Function
  • Linking, Consolidating and Combining Data

Module 4: Advanced Chart

  • Create Advanced Chart

Module 5: Analyzing Data with PivotTable, Slicer and PivotCharts

  • Creating a PivotTable
  • Filter Data by Using Slicers
  • Analyzing Data with PivotChart

Module 6: Enhancing Workbooks

  • Customizing Workbooks

Module 7: Macros and Form Controls

  • Macros
  • Form Controls

Module 8: Publishing & Protections

  • Finishing Workbook
  • Protecting Worksheet and Workbook

Please leave your enquiry here, we will reply as soon as possible.

Switch To Desktop Version