Dashboard using MS Excel


Executives and managers who have already good knowledge of Microsoft Excel, but now feel the need
for learning more powerful features and options of Excel, to manage their worksheet-related tasks more

Course Outline

Module 1 Efficient way of using Excel
Module 2 Conditional & Logical Functions
Module 3 Lookup and Reference function used to create Dashboard
Module 4 Conditional Formatting using Formula and Function
Module 5 Creating Dynamic Filter
Module 6 Advance Pivot and PowerPivot [PowerPivot is addins]
Module 7 Working with Form Control
Module 8 Creating Interactive Charts
Module 9 Creating Dashboard using Pivot and Forms control
Module 10 Recording Macros and Editing macros for creating Dashboard

Click here for detail course content.


  • 10% Early Bird Discount for enrolment on or before 25 Oct’18.
  • 15% Discount on group registration of 4 or more participants.
  • 20% Discount on corporate group booking of 8 or more participants.

All the payments to be made in advance using Debit Card/Credit Card/Cheque/NEFT.


  • Carry your own Laptop.
  • Pragati Software reserves the right to postpone any program due to insufficient number of enrolments.

Fees : Rs. 10000 + 18% GST

Date : 18 Nov 2018

Duration : 1 Day

Location : Mumbai

© 2017 Pragati Software Pvt. Ltd. All Rights Reserved.