HLOOKUP Job Vacancies in Andheri

A job seeker trying to understand the intricacies of this role,A hiring manager outlining the perfect candidate,Or simply curious about the responsibilities of an MIS Executive,

Position Position Title: MIS Executive & Data AnalystLocation: Mumbai. Impact Guru Head Office (Andheri East)Reporting Manager: MIS ManagerWe hustle Monday - Friday (1st & 3rd Saturday)Industry: InsuretechRoles & ResponsibilitiesMIS Executive & Data Analyst.Making Data of working process sheet of excel. Prepare corresponding & sending regular reports via email. Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H-lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting)Working in excel as per data in Filter, Pivot table, & V-lookup. Preparing Reports and Dashboards for client and central management. MIS Preparation of Daily/Weekly/Monthly records & data management. Maintenance & sharing of Daily /Weekly/Monthly report and as company required. Will be required to support other internet software where logical understanding can be utilized for report preparation. To get the raw Data, Paste it in applicable spreadsheets. Generating MIS Reporting as per company requirement. The technique used for collecting, compiling, and storing information and skills for contributing in the manufacturing of quality products. Maintain and update records with accuracy. To keep records and information about deals with clients.Analyze the actual sales versus the projected ones for each department. Supporting the field sales team regarding his performance, new product information, upcoming product internal support etc. Utilize graphic design tools and software to develop create custom PowerPoint presentations and templates from pre-generated content Manage the library of PowerPoint creative materials. Built effective database solutions using Microsoft Access based on unique needs. Developed and maintained Microsoft Access database. Create powerful queries to extract large database information from Excel to Access.

Job Description: Maintain and verifying all data related to Sales department. Control Sales team expenses and daily reporting track. Sales Team attendance Report. Preparation of annually, quarterly, and monthly sales budget. Preparation of targets for head quarter-wise and analyzing product-wise targets. Cost /Achievement analysis of Sales department.Qualification & Experience: Experience 2-5 years of experience in MIS for Sales Department. Excellent in Excel, VB- Macros, v-lookup, h-lookup, pivot table, Advance Excel Knowledge (writing formulae, generating pivot tables and pivot charts) Familiarity with other MS Office products like MS PowerPoint.Skills: Flexible, Stable & detail-oriented with strong work ethic Good Inter-personal skills Exemplary ability to meet deadlines Ability to Get Things Done