Job Title : MIS Executive
Experience Required : 2 To 4 Years
Primary Skills : VBA Macros
Secondary Skills : Power BI
Having excellent & experience knowledge in Advanced Excel, VBA Macros and Power BI.
Proficient in formulae’s and features like Index & match, Pivot tables, Power Pivot, Data Validation, Dynamic Name range and advanced filter.
Build dynamic pivot table ranges and charts by using excel functions.
Proficient Knowledge in developing excel automations and Excel VBA techniques.
A high level of proficiency in developing high quality VBA code needs to quickly understand the requirements of the task and deliver.
Must have Skills Excel Add in development using VBA User form Development using VBA Debugging in VBE Custom Functions development Excel Events like Excel Workbook Worksheets and other Objects.
Having experience to develop interactive Dashboards using excel and VBA.
Build many UDF and Add ins for various work groups to automate task.
Build Excel VBA functionality to send mass E-mails automatically by using outlook.
Proven Knowledge in DAX and Power Query.
Experience in build various charts and Dashboards as required in Power BI.
Good knowledge in Power BI Service like as administrative