Advance Excel Dashboard


Course Overview

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 colorful 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 the professions of the participants.

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
  • PowerPivot
  • 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.

Participants must register online through CETA website by clicking and filling out a one-page form. Incorrect information provided during the registration process will lead towards cancellation of your enrolment at any stage and participants will not be entitled to claim a refund.

Registration Form

Name

Email

Contact Number

Training you want to Register?

Currently enrolled Degree

Program

Semester

Comment