Advance Excel Dashboard

Advance Excel Dashboard

This one day training on Microsoft Excel has been designed to equip professionals with the correct tools to understand, interpret and visualize data. Test sets have been crafted to communicate the effectiveness of a variety of tools to set KPIs, find the variance in defects as well as production levels, use colourful and powerful indicators to display production reports, use multidimensionality on different sets of data, and a number of other related tasks. The activities during this interactive workshop will be customized to cater to professions of the participants.

Duration: 2 days 

Fee: 3000

The training program is best suitable for organizational members who have intermediate knowledge of Excel.

Course Objectives

By the end of this course participants will:

  • Use advanced analytics to understand data
  • Run a number of functions quickly without having to do them over again
  • Run advanced visualization of data
  • Aggregate reports using formula based techniques

Course Content

  • File management and safety
  • Macros
  • PowerPivots
  • Advanced Logic statements
  • Advanced lookups and referencing
  • Data Validation
  • Data charts
  • Sparklines
  • Dashboarding

Course Methodology

The training is going to be highly interactive combination of lectures, group discussions,  , individual reflections and simulations.

Target Audience

The training program is best suitable for organizational members who have intermediate knowledge of excel and are working with a fairly large amount of data.

Duration: 2 Days.