MS Excel 2016 Expert Level


Students, Professionals, Freelancers, Executives and Managers who have already very good knowledge of Microsoft Excel, but now feel the need for learning super powerful features and options of Excel, to manage their worksheet-related tasks more efficiently using advance function in Excel and working with Excel VBA.

Course Outline

Pre-requisites: Participants attending this training should have a very good knowledge of Microsoft Excel, such as simple if , absolute and relative reference, sum-if and count-if function, conditional formatting , filter and simple pivot table.

Day 1

Module 1 Efficient way of using Excel
Module 2 Lookup and Reference function
Module 3 Conditional Formatting using Formula and Function
Module 4 Advance Pivot
Module 5 What-If Analysis
Module 6 Data Forms
Module 7 Working with External Data

Day 2

Module 8 Recording Macros
Module 9 The Visual Basic Editor
Module 10 Writing Procedures for Selection Techniques and Looping
Module 11 Writing Procedures for Worksheets and File related Objects

View Detail Course Content Here.

  • 10% Early Bird Discount if enrolled on or before 20 April 2018.
  • 15% Discount on group registration of 4 or more participants
  • 20% Discount on corporate group registration of 8 or more participants

Payment can be made using Debit card/Credit Card/NEFT/Cheque.


*Students have to produce id card to avail Student’s discount price.

*Students have to carry their own laptop.

*Pragati Software reserves the right to postpone any program due to insufficient nomination


Fees : Rs. 10000+GST and Student : Rs. 9000+GST

Date : 19-20 May 2018

Duration : 2 Days

Location : Mumbai

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