Learn everything about Analytics

Analytics using VBA- Palin

0-6 Month Multiple
Advanced Contact Institute
India MIS
Offline 711

DescriptionProgram StructureEligibilityToolsFacultyContact

Visual Basic for Applications (VBA) is an implementation of Microsoft’s event-driven programming language Visual Basic 6 and its associated integrated development environment (IDE), which are built into most Microsoft Office applications. VBA enables building user defined functions, automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs).

This course will cover in this Formulas, Funtions, VLOOKUP, HLOOKUP, Index, Match, PivotTable, Macros, VBA, SQL, Access.


  • Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by color.
  • Master pivot tables to summarize a million rows of transactional data into a flexible summary without writing a single formula.
  • Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don’t work and the one setting to change to allow many recorded macros to work.
  • Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarize data and when to use each method.


16 Sessions


Contact Institute

  • For Professionals

  • PivotTable
  • Macros
  • VBA
  • SQL
  • Access

  • Experience in Anaylitics
  • More than 5 years of industry experience.
  • Analytical Skills
  • Expert in Macros Development

Name :
Email :
Contact Number :
Message :
Code :

Join 100000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:

 P.S. We only publish awesome content. We will never share your information with anyone.