1016 Hlookup Jobs - Page 23

1. IF FUNCTION 2. SUMIF/SUMIFS 3. COUNTIF / COUNTIFS 4. IFERROR 5. PIVOT TABLES & PIVOT REPORTING 6. CELL FORMATTING 7. CONDITIONAL FORMATTING 8. DATA VALIDATION 9. VLOOKUP/HLOOKUP 10. INDEX + MATCH 11. MACROS

Position: Assistant Manager - MIS Business: Property and Asset management, Mumbai Job Overview You will be the face of JLL at the clients site and will be responsible for interacting and addressing the needs of guests / tenants by maintaining strong public relations, taking feedback / suggestions. You will also be responsible for: Understand business and ensures there is integration between business and technology. Work closely with the operations and technical teams and is a major contributor to the requirements specification deliverable Provides analytic support by coordinating data extraction from various databases and data interpretation. Create report templates and data gathering tools to meet desired future standard Data custodian & controller Trend analysis and aligning with account management team Technology Tools incl Helpdesk Trending and Analytics Deliver output files for reports and dashboards Sign off on data roadworthiness Facilitate Reporting on compliances Seek and collate data for analytics Generate MIS and reports as management requirement Predictive reporting Work with finance on budget targets Cross verification of data as per agreed TOR time to time Generate Daily reports, Weekly reports, MMR, QBR, ABR etc. and own the reports. Custodian of all Site team statutory compliances , their documentation and records Would be responsible for all Audits related to compliance and will upload the OGS Compliance tool with all requisite documents Building statutory compliances are to be tracked for expiration and renewals All documentation recording to be ensured on shared folders related to compliance Site details: You will be working at commercial site which is located at Gurgaon. Site dynamics: Work Schedule: Site team: e.g.: Property Manager +2 Other details if any Sound like you Here is what were looking for: Being Analytical and Meticulous Your role will involve coordination with various teams. You will be paying attention to detail and have excellent problem-solving skills. You will be using logic to trouble shoot problems; and assign and monitor maintenance projects. You should have a good knowledge of the working procedures. Qualifications You will have a Degree / Diploma in Electrical/Mechanical OR any equivalent, with min 3-5 years of work experience in Real Estate/ Hotel or Construction Industry. For residential sites candidates with residential experience will be preferred.

Job Title: MIS Executive in CRC Location: Invertis University, Bareilly Department: Corporate Resource Centre (CRC) Reports To: Director CRC Job Description: Manage and maintain student data across all departments in the Corporate Resource Centre (CRC). Prepare and update MIS reports related to training, placement, and student performance Use advanced Excel functions (VLOOKUP, HLOOKUP, Pivot Tables, IF, Macros, etc.) for reporting and data analysis. Create official documents and letters in MS Word. Design presentations using MS PowerPoint for internal and external meetings. Coordinate with academic departments for accurate and timely data collection. Support CRC in data management for placement drives, company visits, and student profiling. Key Skills: Expertise in MS Excel (Advanced Level) Proficient in MS Word , PowerPoint, Google Documents. Strong analytical, coordination, and communication skills Detail-oriented with the ability to manage large datasets Qualifications: Graduate in BBA, BCA, IT, or related field 0–2 years of relevant experience preferred (Fresher with strong skills can apply) Selection Process- Interested candidate can share cv at recruitment@invertis.org

ROLE : MIS Executive LOCATION: Hyderabad Position: Senior Analyst and Senior Manager Shift: US shift Desired Profile: Generate Management information (MIS) reports on business metrics, for analysts to assist and enhance their daily work activities. These reports act as a one stop shop for high-level-overview of business targets, achievements, variances & other associated work. PRIMARY RESPONSIBILITIES: MIS reporting to management on daily basis. Management accounts. Preparing and updating of monthly KPI data. Updating daily file. Preparation of specials report. Cost centre report. Downloading Data from Systems and mapping the same as per the requirement. Co-coordinating with different teams for the data and checking its accuracy. Preparing Daily, Weekly & Monthly MIS Reports. Preparing presentations, Graphs and analytical reports. Should be a team player and flexible enough for multitasking Analyse business information to identify improvements for efficiency and effectiveness improvements Ensuring correctness of the data and format Desired Skills: Advance Excel. (VLOOKUP, CONDITIONAL FORMATTING, CONCATENATE, SUMIFS, COUNTIFS & ETC) Good Typing Speed. Good Communication. Multi tasker. SECONDARY RESPONSIBILITIES: Supplier invoice processing. Preparing journals and updation. Checking daily reconciliation receipt. Instant credits. Any additional work as and when required.

Sodexo Food Solutions India Pvt. Ltd.cesHR Cum MIS Executive to join our dynamic team and embark on a rewarding career journey Sound Knowledge hands on experience on H-look Up, V-Look Up, Pivot Table, Conditional Formatting etc Good in preparing MIS Report Perform data analysis for generating reports on periodic basis Provide strong reporting and analytical information support Knowledge of various MIS reporting tools

Job Summary: We are seeking a detail-oriented and results-driven MIS Executive with strong expertise in Power BI and experience working with Salesforce CRM . The role involves managing sales, marketing, and inventory data, creating dynamic dashboards, and delivering actionable insights to support decision-making. Experience in the real estate industry and familiarity with Tableau is an added advantage. Key Responsibilities: Extract, clean, and manage data from Salesforce CRM , Excel sheets, and other internal databases. Build and maintain interactive dashboards and reports in Power BI for: Sales performance tracking Lead conversion funnel Inventory availability and status Campaign ROI and CPL analysis Coordinate closely with the Sales team for performance reporting and pipeline analysis. Collaborate with the Marketing team for lead source analysis and campaign evaluation. Automate recurring MIS reports to reduce manual effort and ensure data consistency. Provide real-time and scheduled reports to management for business review meetings. Maintain accuracy of project-wise inventory data and sales bookings. Qualifications: Bachelors degree in Commerce, IT, Data Science, or Business Administration Certification in MIS Reporting, Power BI , or Business Analytics preferred Prior experience in the real estate industry or a similar data-driven role is a plus Location :- Chennai Qualification:- Diploma or Graduation Mandatory Interested candidates please email your resume to Vinoth J HR G Square Email : vinoth@gsquarehousing.com

About The Role Collaborate with department heads to understand their staffing needs and job requirements. Manager and maintain TA databases, and prepare relevant dashboards. Utilize various sourcing methods, such as job portals, social media, networking, and referrals, to identify potential candidates. Create compelling job postings and advertisements to attract qualified candidates. Review resumes and applications, conduct preliminary screenings, and assess candidate qualifications and suitability for the position. Conduct phone or inperson interviews to evaluate candidates' skills, experience, and cultural fit. Schedule and coordinate interviews between candidates and interview panels. Provide guidance and support to both candidates and hiring teams throughout the interview process. Administer and evaluate pre-employment assessments, tests, or other screening methods to assess candidates' skills, aptitude, and compatibility with the role and organization. Facilitate the offer process by extending offers to selected candidates and negotiating compensation packages. Collaborate with other departmental heads and onboarding, to ensure a smooth transition for new hires. Stay informed about the latest recruitment trends, techniques, and best practices. Continuously improve recruitment processes and strategies to attract top talent.

Role & responsibilities 1) Downloading and preparation of the MIS reports from the ERP.. 2) Sending the prepared MIS reports to the customer / banks before cut- off time 3) Checking the MIS reports as per the check lists. 4) Taking care of the queries which are received from the banks and clients. 5) Monitoring delay in completion of MIS by Region and inform on mail. 6) Checking of Errors done by Regions in filling MIS. In normal Situation in a month 10,000 errors are pointed per month including maintenance of error tracker. 7) Monitor amendments highlighted by Region/banking team and send it to the client banks. 8) Do Burial & CD slip recon and compilation around 4000 pts. Responding to all Banks queries concerning error in amount, missed report , wrong/ duplicate slips etc. Preferred candidate profile Only male Candidates Perks and benefits Role: MIS Executive Industry Type: Financial Services Department: Finance & Accounting Employment Type: Full Time, Permanent Role Category: Finance Education UG: Any Graduate Key Skills Skills highlighted with ‘ are preferred keyskills Good communication and excel skills

Roles and Responsibilities Manage data validation, conditional formatting, advanced excel, pivot tables, vlookup, countif, mis operations, data management, hlookup, mis reporting, sumif functions in MS Excel. Prepare MIS reports using HLOOKUP and VLOOKUP formulas. Utilize COUNTIF function to count specific cells or ranges of cells. Create complex reports with SUMIF and COUNTIF functions. Ensure accurate data entry and maintenance through effective data management practices.

IT'S A DIRECT JOB ON COMPANY PAYROLL- Permanent Job Urgent Opening Experience Min- 1 Year Data Entry operator- Male Salary 16k CTC Per Month Available -ESI , PF, Bonus Good in Advance Excel- VLookup, Hlookup, pivot table Good typing Required Candidate profile Experience Min- 1 Year Minimum Graduate Good in Advance Excel- VLookup, Hlookup, pivot table Candidate should live in Noida or around Noida Location - Sector- 83, Noida Perks and benefits Salary 16 CTC PM Inhand-13k PM + PF, ESI, Bonus

We are looking for a MIS Executive to manage business performance reports, maintain key operational documentation, and support cross-functional coordination. The ideal candidate should be proficient in Excel, Power BI, and other reporting tools.

About the Role: We are seeking a dynamic and detail-oriented Operations Executive to join our team. The ideal candidate will be responsible for tracking, collecting, analyzing, and interpreting data to provide valuable insights that drive informed decision-making. Location : Chennai **Note : Freshers are also eligible for this role** *Candidates should have the knowledge of Chennai locations.* Responsibilities: Data Collection: Gather data from various sources, including databases, spreadsheets, and reports. Data Cleaning and Validation: Ensure data accuracy and consistency through cleaning, validation, and standardization processes. Data Analysis: Utilize statistical techniques and tools to analyze data and identify trends, patterns, and anomalies. Report Generation: Develop and maintain comprehensive reports that summarize key findings and insights. Dashboard Creation: Design and implement interactive dashboards to visualize data and facilitate easy access to information. KPI Tracking: Monitor and track key performance indicators (KPIs) to measure progress and identify areas for improvement. Problem-Solving: Analyze complex data sets to identify root causes of issues and propose solutions. Collaboration: Work closely with cross-functional teams to understand their data needs and provide relevant insights. Qualifications: Any Graduate Strong analytical and problem-solving skills. Excellent communication and interpersonal skills. Attention to detail and ability to work independently. Preferred Skills: MS Excel. Pivot Tables. V-Lookup, H-Lookup

The role involves preparing daily, weekly, and monthly reports, maintaining accurate databases, and coordinating with field teams for data collection and verification. Candidate should be proficient in MS Excel.

Scope of work: Assist in monthly payroll processing by gathering, verifying, and updating employee data. Maintain and update employee records in HR systems and spreadsheets. Generate and analyze Excel-based reports (e.g., headcount, attendance, leaves, payroll summaries). Support onboarding and offboarding documentation and coordination. Assist in HR audits and compliance checks for employee documentation. Support day-to-day HR operational activities and respond to employee queries. Participate in process improvement initiatives within the HR function. Skills Sets Required: Strong proficiency in Microsoft Excel (e.g., formulas, VLOOKUP, pivot tables, charts). High attention to detail, confidentiality, and organizational skills. Good written and verbal communication skills. What You'll Gain: Real-world experience in HR operations and payroll processes. Opportunity to develop advanced Excel and reporting skills. Insight into HR systems and employee lifecycle management. Mentorship from experienced HR professionals.

Data analysts import, inspect, clean, transform, validate, model, or interpret collections of data with regard to the business goals of the company. They ensure that the data sources and repositories provide consistent and reliable data. Data analysts use different algorithms and IT tools as demanded by the situation and the current data. They might prepare reports in the form of visualizations such as graphs, charts, and dashboards. Job Description - Grade Specific The role combines leadership, technical expertise, and project management skills to ensure the successful delivery of data analysis projects and the development of a high-performing data analyst team. They play a critical role in leveraging data to drive business growth, optimize processes, and enable informed decision-making across the organization. Skills (competencies)

SUMMARY Job Opening: About the Client: Our client is a leading global Fortune 500 IT solutions company that specializes in providing straightforward and scalable solutions to solve intricate business challenges. With a team of over 1,500 professionals, they offer technical and domain expertise across various platforms and industries to assist enterprise companies in enhancing productivity, efficiency, and optimizing their technology investments. Designation: BI Analyst - Team Leader/ Team Manager Experience: 7-15 Yrs Location: Hyderabad Skills required: Attention to detail Problem Understanding Hands-On with Strong SQL Min 2yrs experience working with Large volume data set Good experience in working with End to End Data analytics project, from Data modelling, Data extraction to building the insights Strong Stats + Strong understanding of visualizations w.r.t. business use case. Create technical documentation, versioning, testing, change control, configuration solutions Experience in BI and dashboard Development areas is needed. Knowledge or working experience with machine learning models would be added advantage. Notice period: Immediate - 30 days

Prepare flowcharts in every business process Calling up all staffs regarding work in progress Accumulate data in Excel Writing Emails Maintain project details Maintain all project bill Sharing Reports Required Candidate profile Gender Female candidate with Age 35 years to 40 years Skills Advance Excel, Google Sheet , PowerPoint Notice Period 15 days only preferred Salary Rs 15,000 pm

Role & responsibilities Collecting information about the technical requirements that each department must meet Developing and evaluating computer systems that satisfy company requirements Supplying resources and training required for subordinates to install and maintain new software programmes Creating, managing, analysing, and debugging IT systems Interpreting specifications and creating IT solutions that adhere to all requirements and financial restrictions Assessing the efficiency of computer systems and enhancing them as necessary Creating MIS documentation to facilitate efficient operations and simple system upkeep Ensuring the privacy of all customers, employees and company records

Adecco is hiring - MIS Executive (Excel Masters) Work Form Office mandatory Locations - 1. Worli 2. Andheri East 3. Powai Role & responsibilities Coordination, Team Work, Collection Data, Data management, MIS Reporting, MIS Report Preparation, Timely Publishing Reports to Management, Maintain and Track Reports. Preferred candidate profile Education - Graduation Skills - Advance Excel, Lookups, Formatting, Macros, Excel Master Salary - 25K (Sunday off) Payroll - Adecco If Interested Please share updated Resume with below details . Post - MIS Qualification - Present Location - Preferred Location - Notice Period - Experience in MIS Reporting - Are you ready to work on Adecco Payroll -

IEnergizer - Hiring for Team Lead MIS/WFM Analyst. Graduation is a MUST. Immediate joiners would be preferred. Job description Should be proficient with MS Excel, Logic building, knowledge of Advanced Excel will be an added advantage as we will be assigning MIS work. MIS reporting to management daily. Experience with Workforce Management software (performance tracking, reporting), Aspect, and Genesis preferred. Candidates with advanced excel skills can apply. The person would be responsible for preparing Daily/Weekly/Monthly reports using intermediate/advanced excel. Required Candidate profile At least 2 years experience in MIS Team lead Role Must have a good knowledge of advance Excel Must be aware of basic Terminology such as Attrition, Shrinkage, CSAT, SLA, Overtime Pay Calculation, Ageing, etc. Should have knowledge of Excel function like VLOOKUP, HLOOKUP, Pivot Table etc Graduation is must Call/Whatsapp HR Amit Latwal @ 8006200310

Job description Designation:MIS Analyst Industry:BPO Experience :1-3yrs Location:Kolkata Job Description: Create and maintain Management reports including end-of-month, quarterly, and annual reports used by various departments Maintain process for Management to request reports, support and data back up Role & responsibilities Expert at using various MS Office tools - Run & create functions, pivot tables, Formulas, VLOOKUP, charts, Macros & Automatization - Use Excel formulas to add necessary formatting to report spreadsheets Ability to program, organize & to analyse data. Required Candidate profile Interested candidate can call Kamolika-8336067060 or share cv Komolika.RoyChoudhury@imarque.co.in Preferred candidate profile Expert at using various MS Office tools - Run & create functions, pivot tables, Formulas, VLOOKUP, charts, Macros & Automatization - Use Excel formulas to add necessary formatting to report spreadsheets Ability to program, organize & to analyse data. Perks and benefits

1.Enter and update data in Excel and internal systems. 2.Verify accuracy and resolve discrepancies. 3.Maintain organized data records. 6 Coordinate with WH teams for data collection and validation

Interview Venue :Wisdom Bridge Management consultants singasandra, Hosur main Road Bangalore Interview date: 18th June 2025-18th July 2025 Landmark , Singasandra Govt school and Post office Timings-10AM to 1PM Contact Aswini -8147492898,080-49546910 Required Candidate profile Walk-in any Fresher's 2018-2025 Passed out for Big MNCs for MIS Reporting ,Data Reporting, MIS Operations, MIS Analyst and Advanced Excel Skills. Perks and benefits 5 days of Working Salary best in the Industry

Ducat Faridabad is looking for an experienced and passionate Data Analytics Trainer on a part-time basis. Will be responsible for delivering high-quality training sessions to students and working professionals.

About the Role: Grade Level (for internal use): 07 The Team The KY3P Managed Services team is responsible for supporting clients in managing third-party risk through consistent, scalable, and regulation-aligned processes. Our team thrives on collaboration, precision, and proactive communication, working across a wide variety of regulatory and compliance frameworks. We value integrity, efficiency, and a client-first mindset, making us a trusted partner to leading financial institutions worldwide. The Impact As an Analyst, you will play a vital role in helping clients maintain compliance with financial regulations and mitigate risks tied to third-party relationships. Your work directly supports operational resilience and transparency in the financial ecosystem, contributing to our clients regulatory adherence and reputational integrity. Whats in it for You Work with global clients and gain exposure to high-profile financial institutions Build expertise in regulatory compliance, third-party risk management, and operational due diligence Develop your professional skillset through ongoing training and mentorship Join a collaborative, fast-paced environment that values curiosity and continuous improvement Responsibilities Coordinate and conduct project-specific tasks in alignment with Third Party Risk Management processes Analyze and report on large datasets using Microsoft Excel and other tools to support client objectives Engage in regular, professional communication with internal and external stakeholders Participate in client meetings to discuss validation progress and resolve queries Ensure accuracy and attention to detail across all deliverables and compliance requirements Adhere to company data protection, confidentiality, and regulatory policies What Were Looking For Qualifications Bachelors degree required 13 years of experience in customer service or financial data operations Strong proficiency in Microsoft Excel; experience with large datasets preferred Familiarity with Third Party Risk Management, compliance, or banking operations is a plus Soft Skills Excellent communication skills, both written and verbal Strong analytical and problem-solving abilities Detail-oriented and highly organized with a commitment to accuracy Ability to work independently and collaboratively in a fast-paced environment About S&P Global Market Intelligence At S&P Global Market Intelligence, a division of S&P Global we understand the importance of accurate, deep and insightful information. Our team of experts delivers unrivaled insights and leading data and technology solutions, partnering with customers to expand their perspective, operate with confidence, andmake decisions with conviction.For more information, visit www.spglobal.com/marketintelligence . Whats In It For You Our Purpose: Progress is not a self-starter. It requires a catalyst to be set in motion. Information, imagination, people, technologythe right combination can unlock possibility and change the world.Our world is in transition and getting more complex by the day. We push past expected observations and seek out new levels of understanding so that we can help companies, governments and individuals make an impact on tomorrow. At S&P Global we transform data into Essential Intelligence, pinpointing risks and opening possibilities. We Accelerate Progress. Our People: Our Values: Integrity, Discovery, Partnership At S&P Global, we focus on Powering Global Markets. Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead. We start with a foundation of integrity in all we do, bring a spirit of discovery to our work, and collaborate in close partnership with each other and our customers to achieve shared goals. Benefits: We take care of you, so you cantake care of business. We care about our people. Thats why we provide everything youand your careerneed to thrive at S&P Global. Health & WellnessHealth care coverage designed for the mind and body. Continuous LearningAccess a wealth of resources to grow your career and learn valuable new skills. Invest in Your FutureSecure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs. Family Friendly PerksIts not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families. Beyond the BasicsFrom retail discounts to referral incentive awardssmall perks can make a big difference. For more information on benefits by country visithttps://spgbenefits.com/benefit-summaries Global Hiring and Opportunity at S&P Global: At S&P Global, we are committed to fostering a connected andengaged workplace where all individuals have access to opportunities based on their skills, experience, and contributions. Our hiring practices emphasize fairness, transparency, and merit, ensuring that we attract and retain top talent. By valuing different perspectives and promoting a culture of respect and collaboration, we drive innovation and power global markets. ----------------------------------------------------------- Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person. US Candidates Only The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. Pay Transparency Nondiscrimination Provision - https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf ----------------------------------------------------------- OPRTON203 - Entry Professional (EEO Job Group)