Powerful Data Analysis Tools In Excel
Powerful Data Analysis Tools In Excel MICROSOFT OFFICE PRO Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd

Powerful Data Analysis Tools In Excel

Course Durations: 1 Day


This course is intended for participants who wish to gain more knowledge from the intermediate level of Excel. For participants who are working with nested formulas, performs what if analysis and consolidating data to have in depth understanding of how an 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 apply Filter data using Auto & Advanced Filters
  • Able to clean duplicate records


  • Perform What If Analysis
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH functions
  • Combining and consolidate data
  • Use scenarios to consider many different variables
  • Use Goal Seek to find out how to get a desired result
  • Use Data Tables to see the effects of one or two variables on a formula
  • Prepare forecasts and advanced business models

Course Outlines

Module 1: What If Analysis

  • Using Data Analysis Tools
  • Exploring Scenarios
  • Using Solver

Module 2: Advanced Excel Task

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


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

*only support gif, jpeg, jpg, png, pdf
Switch To Desktop Version