Selected intern's day-to-day responsibilities include using advanced Excel and VBA to create programs for desktop automation in Finance processes
Requirements:
1. Deep knowledge on Advanced Excel skills Pivots, Formulas (Vlookup, Hlookup, Match, Index, If, AND, OR, SumIfs, CountIfs, SumProduct, etc.), Data Tables, Analysis ToolPak, working with named Ranges, Graphs, Charts, combination graphs, etc.
2. Deep knowledge of VBA Subroutines, Functions, Iterative Statements, Conditional Statements, Arrays, etc.