Unique Training with Vision Integrity & Commitment to Serve the World

Other Advanced Functions


Excel has become an essential computing tool in increasingly demanding corporate world. From tracking your assets, income, debt and net worth to creating graph and chart, importing data from the web, data conversion, data analysis and visualization tools, Excel support financial decision making for Business. Students at PIMS are given special Advanced Excel training and certification which equips them from basic functional skills to advanced logic based excel functions and formulas. Our trainers have divided Excel training into following modules:

Formulas & Other Advanced Functions

For data analysis and decision making assistance, students are given training on various formulas and functions like:

  • VLOOKUP, HLOOKUP functions
  • Mathematical functions - Count, Average, Mean, etc.
  • Pivot Table and Charts
  • Macro training
  • Macro training