Job Description

Job Location – Dubai
Salary – AED 3000 - 4000 + Other benefits
 
Job Role –
• Should be an advance level excel expert.
• Proficient in using Lookup & reference functions, Math functions, Text functions, Logical functions & cell-info functions (Functions such as Index/Match, Search, vlookup, hlookup, countif, counta, sumif, countifs, sumifs, cell.address, clean, ceiling, floor, int, date, concatenate, find, text, datevalue,EOMonth, Hour, Minute, Networkdays,iserror, iferror, if, isformula, islogical, isnumber, And, Or, ifs, switch, choose, indirect, lookup, offset, abs, Mround, Roundup, rounddown, product, rand, sumproduct, average, averageif, averageifs, large, max, min, rank, char, left, right, mid, replace, substitute, join, textjoin, unique, filter, importrange etc).
• Should know writing clustered functions in a single formula cell.
• Should know how to building dynamic dashboards on MS excel as well as on Spreadsheet.
• Should always look to automate day-to-day activities & repetitive tasks.
• Should be an excel-macro-expert; capable of writing macros on any single dimensional array requirements as well as handling application properties, at all application-levels (such as cell, spreadsheet, ribbon & external database connection).
• Should have good exposure towards using spreadsheets, document & Presentations.
• Should be capable of creating, maintaining & consistently improving reports, dashboards & presentations for multiple Projects & Processes.
 
Job Qualifications and Experience-
• Minimum of 3 years’ experience as an MIS Analyst/Executive.
• Experience working in FMCG industry will be given preference.
 
Candidates with relevant experience can email your CV to info@aycaglobal.com

Skills Required