VLOOKUP Job Vacancies in Guwahati

Job Title: MIS ExecutiveLocation: GuwahatiSalary: Up to 25,000 per month (based on experience)Qualification: Any GraduateKey Responsibilities:Prepare and maintain MIS reports using MS Excel.Handle data entry, documentation, and record management.Manage accounting entries using Tally.Perform data analysis using Excel functions such as VLOOKUP and HLOOKUP.Draft and manage official emails and correspondence.Ensure accurate maintenance of business records and reports.Coordinate with internal departments for data collection and reporting.Required Skills:Strong knowledge of MS Excel (VLOOKUP, HLOOKUP, Pivot Tables preferred).Hands-on experience with Tally.Basic accounting knowledge.Good documentation and record-keeping skills.Professional email drafting and communication skills.Strong attention to detail and accuracy.Preferred Experience: 1-3 years in MIS, Accounts, or a similar role.

#Job Responsibilities:-Manage and maintain executives' schedules, including scheduling appointments, meetings, and travel arrangements.-Act as the primary point of contact for internal and external stakeholders, including screening and prioritizing incoming communications.-Coordinate and organize meetings, conferences, and events, including preparing agendas, taking minutes, and ensuring all necessary materials are provided.-Prepare and edit correspondence, reports, presentations, and other documents as required.-Conduct research and compile data as needed for various projects and initiatives.-Handle confidential information with discretion and professionalism.-Anticipate the needs of executives and proactively address issues before they arise.-Assist with special projects and initiatives as assigned.-Manage expense reports and other financial documentation.-Coordinate with other administrative staff to ensure seamless office operations.Requirements:Bachelor's degree preferred.Proven experience as an executive assistant or similar administrative role.Proficiency in Microsoft Office Suite and other relevant software.Excellent communication skills, both written and verbal.Strong organizational and time management skills with the ability to multitask and prioritize effectively.High level of professionalism and discretion when handling confidential information.Ability to work independently with minimal supervision.Flexibility to adapt to changing priorities and deadlines.Strong attention to detail and accuracy.Ability to build and maintain positive relationships with internal and external stakeholders.Married Female Only

Tally ERP 9, Advance Excel, Vloopup, Hlookup, Accounting, TDS, MIS, Service Tax, Reconciliation, SAP,SAS,CRM, Oracle ERP.Creating budgets and forecasts for the management group to meet regular accounting deadlines. Managing all finance and accounting operations of a Regional. Support month-end and year-end close processes. Ensure quality control over financial transactions and financial reporting. Develop and document business processes and accounting policies to maintain and strengthen internal controls. Conducting Internal Audit for all branches. Reviewed accounting structures and procedures on a regular basis to identify areas in need of improvement. Managing accounts payable in ERP Software i.e.,Oracle of anEast Region. Reconciliation & Managing petty Cash. Identify and recommend cost effective solutions. Closely managed monthly reconciliation schedules of all assigned accounts. Additional controller duties as necessary. TDS reconciliation by ensuring all TDS is deducted at appropriate rates as an invoice process. Managing Vendor onboarding. Minimizing cost to the lowest on which the procurement can be completed. Accounts Receivable

We are looking for a diligent MIS Executive to join our team in Guwahati. This role requires 1 to 3 years of experience in managing information systems and supporting data-driven decision-making.Key Responsibilities:- Data Collection: Gather data from various sources to ensure comprehensive reporting and analysis.- Reporting: Prepare regular reports on performance metrics for management review, enabling informed decision-making.- Database Management: Maintain and update databases to ensure data accuracy and easy retrieval.- Analysis: Analyze data trends and patterns to provide insights that can improve operational efficiency.- Collaboration: Work with different departments to understand their information needs and provide them with relevant data.- System Maintenance: Ensure the information management system is functioning effectively and report any issues that need resolution.Required Skills and Expectations:- Proficient in Microsoft Excel and other data analysis tools to create reports and manage data effectively.- Strong analytical skills to interpret complex data and make actionable recommendations.- Attention to detail ensures accuracy in data management and reporting.- Good communication skills are essential for collaborating with team members and presenting findings.- Ability to work independently and take initiative to improve existing processes.- A background in Information Technology or related fields is preferred, along with experience in data management and analysis.

- Collect, organize, and maintain large sets of data related to vehicle sales, inventory, maintenance, customer interactions, and financial transactions to ensure accurate reporting.- Prepare and generate regular management reports, dashboards, and data analysis on sales performance, inventory levels, service history, and customer satisfaction, providing insights for decision-making.- Oversee the management of the companys databases, ensuring that vehicle-related data (such as sales records, maintenance logs, customer information) is accurate, up-to-date, and secure.- Work with various departments (sales, finance, service, etc.) to integrate systems and ensure seamless data flow across platforms, optimizing the efficiency of MIS operations.- Provide analytical support to senior management by preparing custom reports and performing data analysis to help with decision-making regarding inventory management, sales forecasting, and business growth strategies.- Track and monitor vehicle inventory, including new cars, used cars, and spare parts, ensuring that accurate stock levels are reflected in the system and reported regularly.- Track the sales performance of vehicles, analyze trends, and provide actionable insights to the sales and marketing teams to optimize sales strategies and improve performance.- Analyze customer data to understand purchasing behavior, demographics, and preferences, providing insights to enhance customer targeting, service offerings, and marketing campaigns.- Maintain records of vehicle servicing, repairs, and warranties, ensuring that data is easily accessible for customers and service teams, and ensuring proper scheduling and follow-ups.- Monitor key performance indicators (KPIs) related to vehicle sales, after-sales service, inventory turnover, and customer satisfaction, ensuring that the companys objectives are being met.