VLOOKUP Job Vacancies in Delhi NCR

Required Skill Set:Strong knowledge of MS Excel (mandatory)Key Responsibilities:Maintain and manage MIS reports on a daily, weekly, and monthly basis.Prepare data reports using Excel.Ensure data accuracy and timely submission of reports.Handle database management and update records regularly.Support operations and management with ad-hoc reports and analysis

Report Preparation, Vlook up, Pivot table, email writing, cooridnation with various department, technically sound.

The MIS Executive will be responsible for managing and analyzing data to generate reports that support decision making within the organization. This role involves collecting data from various sources, maintaining databases, and creating visualizations to present insights to management.Key responsibilities include creating and updating databases to store business data, analyzing data to identify trends and patterns, preparing reports and presentations based on findings, and ensuring data accuracy and integrity. The MIS Executive will also collaborate with different departments to understand their data needs and provide support in creating custom reports.The ideal candidate should have a graduate degree with 2-5 years of experience in a similar role. Proficiency in Microsoft Excel, Access, and other data analysis tools is required. Strong analytical skills, attention to detail, and the ability to communicate findings effectively are also essential for this position. The MIS Executive should be able to work independently, prioritize tasks effectively, and have a strong problem-solving mindset.

The MIS Executive will be responsible for managing and analyzing data to support decision-making within the organization. Key responsibilities include generating reports, maintaining databases, and ensuring data accuracy. The candidate should have strong analytical skills, attention to detail, and proficiency in Microsoft Excel. Additionally, the ability to work independently and strong communication skills are essential for this role. A minimum of 2-5 years of experience in a similar role and a graduate degree is required for this position.

Key Responsibilities:Prepare daily, weekly, and monthly MIS reports.Maintain and update company data in Excel/Google Sheets.Analyze data and create dashboards, charts, and summaries.Coordinate with departments for data collection and verification.Manage large datasets with accuracy and efficiency.Prepare performance, sales, attendance, stock, or production reports (as per company need).Identify data errors and correct them promptly.Support management with ad-hoc reports and analysis.Maintain confidentiality of company data.Required Skills:Strong knowledge of MS Excel (VLOOKUP/XLOOKUP, Pivot Table, Filters, IF formula, Data Validation).Good understanding of Google Sheets.Basic knowledge of PowerPoint for presentations.Good communication and coordination skills.Strong attention to detail and accuracy.Ability to work under pressure and meet deadline

We are looking for a skilled MIS Executive to manage and maintain the client's Management InformationSystem (MIS). The role involves data analysis, report generation, automation, business intelligence (BI)reporting, and process optimization. The candidate must be proficient in Google Sheets, Google AppsScript, AppSheet, Looker Studio, and SQL to automate reports and enhance business intelligencecapabilities.Key Responsibilities-Data Management & Reporting- Collect, analyze, and interpret data from multiple sources.- Develop reports for business insights.- Develop interactive dashboards and reports using Looker Studio.- Ensure data accuracy, consistency, and timely report delivery.Google Workspace & Automation- Create automated reports using Google Sheets & Apps Script.- Develop custom Google Apps Script solutions to streamline processes.- Utilize AppSheet to develop business applications for workflow optimization.- Integrate Google Sheets with third-party platforms using APIs. (e.g. WhatsApp etc.)Business Intelligence & Decision Support- Analyze business trends and provide data-driven insights.- Design interactive dashboards to support real-time decision-making.- Monitor key performance indicators (KPIs) and report deviations.Process Automation & Optimization- Implement workflow automation in Google Workspace to reduce manual efforts.- Optimize reporting structures and improve efficiency using automation tools.- Maintain data integrity and compliance with internal policies.Coordination & Documentation- Collaborate with cross-functional teams for data collection and validation.- Document business processes, reporting structures, and automation workflows.- Ensure compliance with data security and company policies.Required Skills & Competencies-Technical Skills- Advanced Google Sheets (Formulas, Pivot Tables, Data Validation)- Google Apps Script (Automation, API Integration, Custom Scripts)- Google AppSheet (Low-code app development for workflows)- Looker Studio (Data visualization, Dashboard creation)- SQL Queries (Basic to Intermediate level)- MS Excel (Macros, VBA, Power Query)Analytical & Problem-Solving Skills- Strong logical and critical-thinking abilities.- Ability to analyze large datasets and generate insights.Communication & Interpersonal Skills- Ability to present reports clearly and effectively.- Strong collaboration skills with various teams.- Time Management & Multitasking- Ability to handle multiple reports and automation projects.- Work efficiently under tight deadlines.;

We are seeking a knowledgeable and detail-oriented Accounts Manager GST & Taxation to manage GST and TDS compliance processes. The ideal candidate must be proficient in reconciliation, have strong Excel skills, and be capable of handling communication with government departments. Key Responsibilities:Prepare and file GST Returns (GSTR-1 and GSTR-3B)and TDS Returns within prescribed timelines.Prepare Output and Input GST Reconciliationand ensure accuracy in data validation.Utilize advanced Excel formulassuch as SUMIF, VLOOKUP, and Pivot Tables for report preparation and analysis.Manage and generate E-Way Billsand E-Invoices as per statutory requirements.Draft and file replies to notices and queries from departmentsrelated to GST and TDS.Support the finance team with additional accounting or compliance tasks as required.Remain open and flexible to perform work beyond GST and TDS, as per team needs.Skills & Competencies:Strong working knowledge of GST (GSTR-1, GSTR-3B)and TDS.Hands-on experience with E-Way Billsand E-Invoicing systems.Proficiency in MS Excel(SUMIF, VLOOKUP, Pivot Table).Experience in preparing replies to departmental notices.Good understanding of accounting principlesand compliance procedures.Experience in a CA firmwill be preferred.Strong analytical, coordination, and communication skills.

Develop and maintain comprehensive MIS reports to capture key metrics and insights for variousdepartment.2. Create and manage FMS, IMS, PMS, Checklist, Delegation sheet and MIS of Doers in GoogleSheets3. Ensure the accuracy and reliability of data across all reporting.4. Collaborate with department heads and management to identify reporting needs and customizereports accordingly.5. Analyze data trends and make recommendations for efficiency improvements and strategy

MIS executive has to handle all data i.e. collection of data, compilation and report making

Hiring for MIS Executive (in HR Department) at Udyog Vihar, GurugramRole: - MIS Executive (HR Trainee)Department - HR DepartmentLocation - Udyog Vihar, GurugramEducation - GraduateSkill - Good in Advance excelOffice - Work from Office Working days - 6 days workingSalary - 12 k to 15 k Interested candidate can send his on nk.sharma@kanpekiworkforce.com or apply here.thanks Neeraj Sharma

Hiring for MIS Executive (in HR Department) at Udyog Vihar, GurugramRole: - MIS Executive (HR Trainee)Department - HR DepartmentLocation - Udyog Vihar, GurugramEducation - GraduateSkill - Good in Advance excelOffice - Work from Office Working days - 6 days workingSalary - 12 k to 15 k Interested candidate can send his on nk.sharma@kanpekiworkforce.com or apply here.thanks Neeraj Sharma

JD of E Commerce Executive.Roles and Responsibilities Maintain online product catalogue across multiple portals. Organize data with regards to listing, updating, uploading and specifications. Ensure the online store reflects information and inventory accurately. Communicate with all the portals to ensure timely addresses of issues with listings. Frequent and timely review of all the listings across the portals. Planning and preparation of New Launches and execution of review generation strategy. Execute short and long-term product launch strategies and daily operational priorities. Support in preparing internal daily/weekly/monthly operations reporting scorecard and MIS. Preparing excel spreadsheets for product upload, colors, pricing, etc. on various portals.Key Skills: Analysis Listing & Cataloging Management. Catalog Creation Amazon A+ content and Myntra CSV experience is must Portal Management. MS Excel, Vlookup, Hlookup, Index Match, Sumif, Countif, Remove Duplicate, If, Left, Right, Mid,Concatenate, Pivot Table, Shortcut Keys. Good Communication Skills

Key Responsibilities:1. Project Delivery Supervise, train, and mentor the project captive team. Ensuring key performance indicators are in place and productivity targets are met Lead strategic initiatives of the firm, capability demonstration to specific clients.2. Client Communication, Reporting & Management Extensive communication with clients on email. Conducting data analysis and prepare reports using Excel and PowerPoint. Interacting & engage with the manager for project updates & feedback.3. Skills Required:1. Excellent written & oral communication2. Data analysis & MIS3. Proficient in MS Office4. Analytical & conceptual thinking5. Efficient in planning and time management skills

EXPERIENCE IN TALLY, VLOOKUP, ADVANCE EXCEL, TDS, INVOICE MAKING, ACCOUNTING , BANK RECOINCILIATION ETC

We are seeking a skilled and organized MIS Executive to join our team. The ideal candidate will be responsible for managing and maintaining the companys Management Information Systems (MIS), analyzing data to generate actionable insights, and creating reports to support decision-making. This role is critical for ensuring data accuracy, system efficiency, and timely reporting.

We are looking for 1 mis executive Post in Delhi,MIS Executive,MIS Specialist, with deep knowledge in advanced excel,Word,MIS Reporting,VBA,HLOOKUP,VLOOKUP, MIS Executive,MIS Specialist and Required Educational Qualification is : Other Bachelor Degree, B.A, B.C.A, B.B.A, B.Com

Prepare Daily, Weekly, Monthly Report.Preparing Day End Report.Represent data for Higher Management.Managing all MIS activity of the process.Ensure timely resolution of queries from different departments.Coordinate with process managers for data collation and reporting.Preparing Power Point Presentation according to requirement.Build and maintain defined reports.Ability to work independently with minimum directions.Provide the new update regarding the process.

Urgent requirement of MIS executive at corporate office of Olive Heritage Gurgaon. Salary is negotiable and will depend on the knowledge and experience of the candidate.

Executive AssistantLocation: Noida(Uttar Pradesh-India)Description: Job Title:Executive Assistant to the Managing Director (MDO)Job Overview:The Executive Assistant to the Managing Director operates as an extension of the MD, ensuring the seamless execution of daily operations, upholding the MDs vision, and aligning all activities with the company's strategic goals. This role requires a high level of trust and authority, acting as a key liaison between the MD and various departments to drive organizational success.Responsibilities and Duties:1. Act as the primary liaison between the MD and internal/external stakeholders to ensure clear communication and alignment with the MD's objectives.2. Manage the MDs daily schedule, meetings, and travel arrangements to optimize time and productivity.3. Oversee coordination between departments, ensuring the timely execution of tasks, compliance with processes, and alignment with company goals.4. Organize and maintain all official and personal documents for the MD, ensuring confidentiality and accuracy.5. Monitor ongoing projects, track progress, and ensure deadlines are met, escalating issues when necessary.6. Assist with strategic planning by reviewing reports (including MIS) and providing actionable insights to drive company growth.7. Collaborate with Sales, HR, Finance, and other departments to streamline operations, track performance, and resolve operational issues.8. Manage personal tasks for the MD, including overseeing finances, property investments, and family-related activities.9. Maintain and manage the MDs social media accounts, ensuring timely updates and engagement.Strategic Importance of the Role:This position is essential in maintaining the companys strategic direction and supporting the MD in driving long-term business growth, focusing on strategic planning, sales expansion, innovation, and cost efficiency.Qualifications:- Education:

1. Excellent knowledge of excel is a must.2. Accounting, Math or finance degree with 2-5 years of relevant experience in Operations at financial institution (PMS/asset management companies (AMC), custodians, banks, brokers, etc.3. Attention to detail is a must.4. Ability to comprehend financial report5. Strong written and verbal communication skills will be an added advantage in this roleJob Responsibilities:Support Manager-Operations and work closely with the team to cover the following operations related deliverables:Operations and work closely with the team to cover the following operations related deliverables:Manage daily execution of trades, liquidity bifurcations and EOD bifurcations of tradesMaintain third party software package for clients' portfolios and related excel sheetsLiaison with brokers and custodian to resolve trades related issuesManage clients' fund flows for investments in third-parties' products (i.e., MFs, PMSs, AIFs PE/VC funds, etc.)Preparation of SEBI monthly reporting.Reconciliation of fees and expenses on a monthly basis.Reconciliation of clients accounts on daily, monthly and quarterly frequencies.Performance and attribution analyses of clients' portfolios on a quarterly basis.Preparation of tax computation for overseas clients.

We are looking for an experienced and detail-oriented MIS Executive with strong proficiency in Microsoft Excel and hands-on experience in managing, analyzing, and maintaining large operational and ERP data files. The candidate will be responsible for preparing MIS reports, data reconciliation, variance analysis, tracking exceptions, and providing accurate operational reports to management.Key ResponsibilitiesPrepare, maintain, consolidate, and analyze daily, weekly, and monthly MIS reports.Manage large operational and ERP data files and ensure data accuracy.Use XLOOKUP/VLOOKUP, IF functions, Pivot Tables, filters, sorting, conditional formatting, and other advanced Excel tools.Perform data reconciliation and identify discrepancies, mismatches, and data errors.Conduct variance analysis and prepare exception reports.Create and maintain complex Excel trackers and dashboards.Consolidate data from multiple sources and prepare management reports.Required SkillsStrong to advanced proficiency in Microsoft Excel.Hands-on experience with XLOOKUP/VLOOKUP, IF, Pivot Tables, Filters, Sorting, Conditional Formatting, etc.Good understanding of data reconciliation and variance analysis.Ability to independently create, edit, maintain, and analyze complex Excel reports and trackers.QualificationGraduate in any discipline.If you are Interested please share Ur CV

Required Skill Set:Strong knowledge of MS Excel (mandatory)Key Responsibilities:Maintain and manage MIS reports on a daily, weekly, and monthly basis.Prepare data reports using Excel.Ensure data accuracy and timely submission of reports.Handle database management and update records regularly.Support operations and management with ad-hoc reports and analysis.