Other Advanced Functions

Unique Training with Vision Integrity & Commitment to Serve the World

Proficiency Enhancement


Use of technology, automation & research tools provides a means to all the top multi-national companies to implement changes quickly to stay ahead in the competition. To succeed in the international marketplace, companies are putting efforts to hire management graduates having working knowledge of most commonly used software tools in the Corporate World. Industry is also demanding management graduates to have good research & analytical skills and proficiency in working with large data & numbers.

Understanding the technology and IT skills demands of the industry, PIBM has introduced training methods & certification courses inside the curriculum like Bloomberg Terminal, Ace Analyzer, Enterprise Resource Planning (ERP), Six Sigma (Green Belt), MS Project, Advanced Excel, Balance Sheet Analysis & Financial Modelling. This ensures that PIBM students acquire the skills and capabilities that would enable them to work effectively and efficiently in their workplace. IT, Research & Analytical skills are indispensable tools to survive and excel in the competitive corporate world and that's why is taught to students in the form of theoretical and practical training.

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 PIBM 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

datamain