10 Xlookup Jobs

As a candidate for the role, you should possess strong financial acumen and demonstrate a proven ability to solve complex problems through analytical thinking. You should be a self-starter with the capability to independently initiate projects and drive them to successful completion. You are expected to be proficient in SAP, PowerPoint, and advanced Excel, including skills in Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, IF statements, SUMIFS, INDEX/MATCH. Experience in VBA would be advantageous. Familiarity with Business Intelligence (BI) tools such as Databricks, Qlik, Tableau, SAP BW/BEx, etc., is considered a plus. In this role, you will collaborate closely with North American Sales Operations and Sales teams on various activities including month-end close, budgeting, forecasting, compensation, and scorecard activities. Your responsibilities will involve analyzing financial and operational KPIs to identify opportunities for process improvements with a positive financial impact. You will be required to develop actionable insights based on a deep understanding of sales operations KPIs and drive initiatives for further automation. Additionally, creating clear, concise, and effective reporting to simplify decision-making for business partners will be a key part of your role. It is crucial to maintain strong relationships with key stakeholders across the organization, including Sales, Marketing, Finance, IT, and Supply Chain, to inform, influence, and align on business objectives. Personal attributes essential for success in this role include a strong work ethic, proactive and positive attitude towards responsibilities, and the ability to be bold, responsive, and take ownership of the end-to-end process.,

As a PMO Executive at StatusNeo, a cutting-edge digital consulting firm located in Sec 67-Gurugram, you will be responsible for supporting PMO functions through expert-level Excel reporting, efficient data collection, and effective stakeholder management. With 4-7 years of experience, you will have the opportunity to create, manage, and optimize reports and dashboards using advanced Excel functions such as pivot tables, VLOOKUP/XLOOKUP, Power Query, and macros. Your role will involve supporting PMO activities including project tracking, reporting, and documentation, as well as collaborating with project managers and business teams to gather reporting requirements. Additionally, you will track key performance indicators (KPIs) and project milestones, identify process improvement opportunities, and ensure timely and accurate delivery of reports and data insights. Key Responsibilities: - Create, manage, and optimize reports and dashboards using advanced Excel functions. - Support PMO activities including project tracking, reporting, and documentation. - Collect, consolidate, and validate data from multiple sources. - Generate periodic reports and presentations for stakeholders. - Collaborate with project managers and business teams to gather reporting requirements. - Track KPIs and project milestones. - Identify process improvement opportunities within reporting and data management tasks. - Ensure timely and accurate delivery of reports and data insights. Key Skills & Qualifications: - 4 years of relevant experience in reporting, PMO support, or data analysis roles. - Expertise in Microsoft Excel including advanced formulas, pivot tables, charts, Power Query, and VBA. - Strong understanding of data collection and validation techniques. - Good knowledge of PMO functions and project reporting. - Excellent communication and stakeholder management skills. - Proactive approach with strong attention to detail. - Familiarity with tools like PowerPoint, MS Project, or project tracking tools is an added advantage. Preferred Qualifications: - Exposure to project management environments (Agile, Waterfall, etc.). - Experience with reporting tools like Power BI or Tableau. - Certification in MS Excel or project management is desirable but not mandatory.,

Profile Overview As the Customer Support Team Lead at Voylla, youll guide a dynamic team of support representatives to ensure exceptional service across phone, email, chat, and social channels. Youll oversee team performance, handle escalations, and streamline the returns/exchanges process, all while upholding brand values and delighting customers. Key Responsibilities Team Leadership & Supervision Lead, coach & mentor a team of customer support agents. Set clear KPIs and motivate the team to consistently exceed performance targets. Performance Monitoring Track and analyze metricssuch as CSAT, response time, resolution rateand deliver actionable insights. Escalated Issue Resolution Take ownership of complex customer complaints, ensuring prompt, empathetic, and professional outcomes. Return & Exchange Management Oversee the end-to-end returns/exchange process), coordinate with logistics/warehouse, and ensure seamless customer satisfaction. Training & Development Develop & deliver training sessions to elevate team capabilities in product knowledge, communication, and CRM usage. Process Improvement Identify and optimize workflowssuch as ticket routing, self-service content, or returns policyto elevate efficiency and customer experience. Cross-functional Collaboration Work closely with Product, Quality, and Warehouse teams to ensure quick issue resolution and rollout of service improvements. Reporting & Documentation Generate regular reports on performance, escalations, returns, and resolutions. Maintain up-to-date knowledge-base articles and SOPs. Skills & Qualifications Leadership & Management Proven ability to lead, coach, and inspire a customer support team. Customer Service Strong grasp of support operations, escalations, and quality standards. Communication Excellent verbal & written Englishmust be empathetic, clear, and persuasive with customers. Analytical & Data-driven Comfortable extracting insights from dataCSAT, ticket volume, resolution trends. Conflict Resolution Calm under pressure, adept at resolving escalations tactfully. Tools Proficiency Familiarity with CRM systems and Microsoft Office Suite. Organizational Skills Strong scheduling, prioritization, and multitasking abilities in a fast-paced retail environment. Training & Coaching Experience designing and delivering training and providing regular performance feedback. Educational Background Bachelors degree ideally in Business, Communication, or related field. Experience 2-3 years in customer support, including at least 1 year in a leadership role. What a Typical Day Looks Like Morning huddle to review KPIs (ticket count, backlog, CSAT) and assign priorities. Monitor escalations, intervene when needed. Conduct one-on-ones or coaching sessions with team members. Analyze daily performanceidentify trends or training needs. Lead cross-department syncs on escalations or process issues. Oversee returns/exchange queue, resolve pending issues. Update knowledgebase; refine SOPs. Review and finalize scheduling and shifts. Soft Skills Communication Clear, concise verbal and written interactions; active listening and empathy Empathy & Emotional Intelligence Understanding customer emotions and staying calm under pressure Adaptability & Multitasking Handling changing priorities and multiple tasks at once Problem-Solving & Conflict Resolution Diagnosing issues and mediating escalations calmly Hard Skills (with Excel focus) CRM & Helpdesk Tools Basic Excel Proficiency, including: Using SUM, AVERAGE, COUNT, MIN, MAX for data calculations Sorting/filtering to organize and segment data IF statements and VLOOKUP/XLOOKUP, to conditionally manage and lookup data PivotTables & Charts Summarise large datasets and visualize trends Conditional Formatting Instantly highlight important metrics Dashboard Basics Create simple performance dashboards using tables, charts, and formatting

Job Overview : We are seeking a highly motivated and detail-oriented individual to join our Finance team as an Entry-Level Finance Reporting Analyst. In this role, you will be responsible for assisting in the preparation and analysis of financial reports, ensuring accuracy and compliance with company standards. This is an excellent opportunity in finance reporting, working closely with experienced professionals in a fast-paced and dynamic environment. Key Responsibilities: Assist in the preparation of monthly, quarterly, and annual financial reports. Analyze financial data to ensure accuracy, identify trends, and provide insights into business performance. Support the Finance team in generating ad-hoc reports and financial summaries for internal stakeholders. Assist in the reconciliation of data. Maintain and update financial reports, ensuring that all information is accurate and up-to-date. Collaborate with other departments to collect necessary data for financial reporting. Assist in the creation and automation of financial reporting templates and tools. Identify and suggest improvements to reporting processes for greater efficiency and accuracy. Desirable Attributes: Positive attitude, proactive mindset, and willingness to take on new challenges. Strong problem-solving skills and the ability to think critically. Ability to work under pressure and manage tight deadlines. High level of confidentiality and professionalism when dealing with sensitive financial data.

MIS Executive should have the knowledge of Advance Excel - Pivot, Vlookup, Xlookup, Power Pivot, Power Query and Microsoft Power Point Presentation Skills.

Process: MIS Reporting BAND: A2(Senior Executive) Location: Bangalore - Work from office Transport: Cab provided for Pick up and drop. Shift: 4:00PM to 1:00AM Qualification: MBA, M. Com & BBA Must Have Skills: - Understanding of MS-Office (Excel functions and Formulas) VLOOKUP, HLookup, X-lookup, Index match, Data Validation, Filter, Pivot Table, Concatenation, Sumifs. Experience of 1 to 3 years in Non-Finance MIS Reporting process or any other product related domain or Retail business. Non-Finance Supply Chain Understanding of MS-Office (Excel functions and Formulas) VLOOKUP, HLookup, X-lookup, Index match, Data Validation, Filter, Pivot Table, Concatenation, Sumifs. Excellent spoken communication skills, stakeholder management and interaction, good presentation skills Analytical, Multi-tasking, Decision making Non-Finance Supply Chain Primary Responsibility Working on day-to-day activities with accuracy Responding to the emails Client call handling Preparing SOP/ Process document Performance Parameters Productivity Monitoring and Reporting TAT & Accuracy Schedule Adherence Analysis of data and Feedback Calibration Role Responsibilities Production with accuracy PO Creation, SKU Creation Reporting Email handling Team co ordination Primary Internal Interactions PE Assistant Manager PE Manager PE AVP Primary External Interactions Supervisors at the client end for the purpose of seeking clarifications & answering queries Operations, process owners for calibrations and process related updates. Client QA team for calibrations

QUALIFICATIONS: Bachelors degree in Computer Science, Information Systems, Statistics, or a related field. Proficiency in Advanced Excel is mandatory. Familiarity with data visualization tools (e.g., Power BI, Tableau) is a plus. KEY RESPONSIBILITIES: Advanced Excel: Proficient in using functions, pivot tables, VLOOKUP/XLOOKUP, Power Query, and data visualization tools for efficient data management and reporting. MIS Operations: Expertise data analysis, report generation, and maintenance of Management Information Systems to support business decision-making. Data Accuracy & Integrity: Ensure consistency, accuracy, and timeliness of data across reports and dashboards. Communication Skills: Strong verbal and written communication abilities for effective collaboration with cross-functional teams and presentation of data insights. EXPERIENCE: 6 Months to 2 Year of relevant experience in MIS, business analysis, or data reporting. Role & responsibilities

Designation: Accounts and Finance Executive Position Overview This position is required to work on the debtors reconciliations, accounting of debtors, ensuring the accounting is happening timely. Required to report to the Associate Manager Finance for all the purposes. Must adhere to the book-closure timelines and work with the team to comply with the same. Should be a good team-player. Academics and Experience B.com/ M Com/ MBA-Finance 2 Years experience in accounting domain Must have worked in a mid-sized company and have basic knowledge of SoX Compliances and statutory audit exposure Roles and Responsibilities 1.Good accounting knowledge is a must 2. Performing account reconciliations 3. The ability to communicate and articulate efficiently within the teams and cross teams. 4. Experience in an Saas company is an added advantage 5. Maintaining accounts receivable files and records 6. Good communication skills Skills 1. ERP- Tally and Microsoft D365 2. Good working knowledge of MS Excel is required (Vlookup, Xlookup, Sumif, Pivot tables etc) 3. Knowledge of Mail Merge 4. Usage of google- emails, chats, calendar 5. Proactive approach towards work, knowing when to escalate 6. Driving towards closure, detail oriented About Company Bitla Software is a dynamic and innovative product company that specializes in cutting-edge software solutions. We are the world's largest technology and solution provider to the Bus Industry. With SaaS, Cloud and Mobile Technology Solutions, Bitla has transformed the life of bus operators by maximizing revenue, optimizing operational costs, and helping bus operators stay fully in control of their business performance. Founded in 2007, Bitla is part of India's leading online travel company MakeMyTrip Limited. By offering products which adapt to the bus operator's business process, reliable under all conditions, easy to use by anyone, Bitla is serving 2500+ bus operators with 20,000+ buses on a daily basis. Other than India, Bitla has operations in Southeast Asia and Africa.

Executive MIS Job Description: We are seeking an experienced MIS Executive to support our hub operations through accurate data analysis, reporting, and coordination. MIS, excellent command of Excel (including Macros and Pivot Tables), and the ability to generate clear and actionable reports that support operational efficiency. Key Responsibilities: Collect, manage, and analyze operational data from the hub including logistics, inventory, and workforce productivity. Generate daily, weekly, and monthly reports for operational tracking and decision-making. Build and maintain dashboards and reporting tools to allow real-time visibility of hub performance. Coordinate with internal teams such as logistics, warehouse, and IT to ensure smooth and accurate data flow. Identify data inconsistencies and recommend improvements in data collection and processing. Maintain proper documentation of data and support audit processes by providing accurate and timely reports. Automate reporting processes where possible to reduce manual effort and error. Provide timely and accurate insights that contribute to hub performance improvements and strategic planning. Preferred Tools and Knowledge: Strong working knowledge of Microsoft Excel, including use of Macros and Pivot Tables Advanced excel skills including complex formulas and data analysis

Title: Senior Executive for VIBGYOR-NIBM, Pune Job Description: To oversee and manage the organization's data assets, ensuring their quality, governance, and security, while also extracting, analyzing, and interpreting data to support informed business decision-making. This role bridges the technical and analytical aspects of data, ensuring its correct use, governance, and value realization for strategic initiatives. Responsibilities: Extract, transform, and load (ETL) data from various sources into databases or data warehouses. Maintain data integrity and ensure high data quality standards. Work closely with different departments (e.g., finance, marketing, product) for data requirements. Ensure compliance with data governance policies and standards. Implement measures to secure sensitive data, ensuring compliance with relevant regulations Identify opportunities to improve data collection processes and systems. Stay updated with the latest industry trends, tools, and best practices. Requirements: Bachelors degree in Computer Science, Statistics, Mathematics, Data Science, or related field. 5-6 years of experience in a similar role, preferably in a data-driven environment. Relevant experience in extracting, transform, and load (ETL) data from various sources into databases. Advanced proficiency in Microsoft Excel, including XLOOKUP, VLOOKUP, INDEX-MATCH, pivot tables, macros, and complex formulae. Capability of Data cleansing, Data accuracy and Data validation. Understanding of database management systems and data warehousing. Strong logical reasoning and problem-solving abilities. Excellent attention to detail and accuracy in work. Effective communication skills, both verbal and written. Ability to prioritize tasks and manage time efficiently. Proven ability to work independently and collaboratively in a team environment. Interested candidates can send their resume to priya.chauhan@vgos.org