224 Advance Excel Jobs - Page 8

Role & responsibilities Banking and Accounting - R) Compilation of financial reports and discussion with Section Head Accounts regarding areas of improvement (R) Disbursement of various schemes for dealers and retailers (R) Ensure quarterly and annual balance sheet and P&L are prepared as per the applicable laws and accounting standards (R) Ensure updation of financial statements onto the system (Hyperion) as required (R) Finalize financial tally with books; monthly basis ledger scrutiny of all the GL and ensure the proper recording of transaction (R,A) Ensure all the reconciliation of RMC transaction and tally with books of accounts (R,A) Ensure the CFD formats are prepared and sent in time with accuracy (R,A) Prepare all cost audit formats within time and with accuracy and submit the same to Chief Marketing Officer . System Review and Internal Control - ) Co-ordinate for all statutory audits and resolve audit points; ensure all required entries are accurately posted in system (R) Monitor and ensure that the calendar for finalization and audit of accounts is followed . UBS Budgeting, Planning and Commercials - R) Preparation of budget for UBS business, month on month review of budgeted and actual parameters, framing and calculation of various schemes, control on margin distributions . Data and Trend Analysis and Comparisons - (R) Analysis of new Godowns, discount proposals / schemes, its effectiveness on implementation and suggest improvements (R) Analysis of Zonal data - analyze gain or loss due to change in mode mix, market mix, segment mix, plant mix, rural urban analysis (R) Prepare peer comparison of Company with other competitors and analyze and find out the areas of improvement; quarterly and annually review Company performance and comparison with other competitors . MIS, Tracking and Reporting 1 - R) Analyze and provide information about high / low NCR area to Marketing (R) Ensure accurate and timely preparation of monthly financials & MRP and other reports (R) Finalize and analyze monthly financial statements including the Profit and Loss Accounts, Chairman's MIS etc. (R) Generate monthly exception reports - price trends, payment defaulters whose cheques are not cleared by the banks, gap analysis, i.e. difference between sales and collection, variance analysis and action planning; provide highlights to Management regarding any exceptional item on real time basis (R) Generate monthly financial by the 2nd of every month, daily production and despatch report, daily production report and MRP (R) Prepare and analyze MIS for UBS and profitability reports, exception reports on critical matters, reports pertaining to visits to outlets, Zonal office, Regional office. MIS, Tracking and Reporting 2 - Prepare and submit periodical reports of sales volumes, realizations, stocks and receivables and costs (R) Prepare complete MIS up to 7th day of every month (R) Prepare rural and urban contribution, Depot wise profitability and dealer wise profitability statements; segment wise contribution, DI release details, daily price, damage sales details preparation (R) Prepare variance report by analyzing reason for variance in consultation with Sales personnel and Plant Manager (R) Provide data to assist fixation of dealers target and monitoring performance to highlight variances to the Zonal Head for necessary actions (R) Suggest improvement measures for enhancement of NCR (R,A) Prepare tax audit report, advance tax report, provision for tax report and other similar reports . NCR and TLC Analysis - (R) Analysis of NCR report every month after collecting data from all Regional offices, Depots and Units; finalize and review variance report indicating actual NCR vis- -vis budgeted NCR (R) Detailed analysis of TLC, identification of non economical areas and suggesting improvement of the same (R) Discuss with Accounts and Commercial and prepare reasons for gap and action plan for improvement (R) Prepare tally of NCR with books for NCR related expenses, discounts, sales, freight and excise (R) Solve post NCR related queries raised by Chief Marketing Officer efficiently (R,A) Review and analyze variable cost, below variable cost / MRP revision Preferred candidate profile Qualification: Chartered Accountant Age : Between 25 years to 35 years

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 Preferred candidate profile

Strong in VBA macros, Google Sheet programming, can write MIS on VBA & google sheet MIS, Vlookcup, Advance Excel, Data Analytics, Other MIS tools. Male, good exposure data interpretation, collaboration, presentation, reporting

Advance Excel, data Analytics, interpretation, MIS, CRM. english Comm. excellent support role -Inquiry Conversion, RFQ, Costing, ERP update, Project status, coordination, CRM, Order Mgmnt, sale pricing update, prepare quote, analysis, Forecasting

About the Role: We are looking for a highly motivated and detail-oriented Export Coordinator / Sales Assistant to join our team. This role will focus on building and maintaining relationships with international clients, ensuring smooth communication, and keeping track of client requirements and facilities. The ideal candidate should be fluent in English and Hindi, Knowledge of foreign languages is a big advantage, possess basic Microsoft Office skills, and be eager to learn and grow in an export sales environment. Key Responsibilities: Client Communication: Regularly contact and maintain strong relationships with clients, ensuring their requirements and expectations are met. Tracking Client Needs: Keep track of client requirements, facilities, and preferences, and provide regular updates. Sales Assistance: Support the sales team in export-related activities and client inquiries, ensuring that the necessary information is shared efficiently. Documentation & Reporting: Use basic Microsoft Office tools like Excel and Word to maintain accurate records, reports, and client files. Multitasking: Handle various administrative tasks simultaneously, ensuring tasks are completed in a timely manner. Email Etiquette: Correspond professionally and efficiently with clients via email, ensuring prompt and clear communication. Qualifications Bachelors degree in Commerce, Business, International Trade, or a related field. Previous experience in export sales & coordination is mandatory preferably in Building materials industry. Excellent organizational and multitasking abilities. Attention to detail and accuracy. Proficiency in MS Office (Word, Excel, Outlook). Familiarity with export documentation and regulations is a plus. Skills Strong , verbal, written and personal communication and interpersonal skills. SAP & Export documentation is an advantage but not mandatory International trade regulations is an advantage but not mandatory MS Office suite Interpersonal communication

Role & responsibilities Preparation of daily/weekly/monthly MIS as per the management requirements. Analyze the trends of Key Performance Indicators (KPIs), especially relating to financia.l metrics such as sales, expenditures, and profit margin. Monitor KPIs and identify the cause of any unexpected variances. Provide Support and maintenance to existing MIS System. Perform Data Analysis for generating reports which can be used in management review. Preparation of Ad-hoc reports as and when required by the management. Provide detailed analysis and commentary on cost center results. Present the monthly and quarterly financial reports of various units and departments. Implement a business intelligence tool and dashboard reports. Analysing actuals against budget/ forecast and prior year. Liasoning with banks and vendors as and when required. Aiding in Automation and Implementation of required tools for finance related work. Experience - Quality & Quantity Must possess strong Excel and PPT working experience Advanced computer software skills, including writing macros in Excel and other accounting packages Strong Oral and written communication skills Should have excellent analytical skills as well as a strong business acumen. Self-Motivated and Strong Analytical skills Attention to detail, able to manage time in an efficient manner Quick learner with a positive attitude Must be open to work in a dynamic environment and produce quality output under tight timelines Preferred candidate profile 1. Comfortable with night shift (05:30 - 02:30 am ) 2. Perks of cab and meal.

We are hiring for an HR Apprentice Exp - Fresher / Experienced Qualification - Any Skills- Hands on with Advance excel Loc- Andheri East Reporting to HRBP Role : Patner with cross functional departments / Zones Support in Data management Must have experience in advance excel Kindly share your resume at mahalaxmi.priya-v@adityabirla.com

Respond to queries from customer through Call Chat & Email information & handle complaints regarding the products/services Understands customer queries & responds to it ensuring that all queries are answered Salary upto 35000 Call Nivedita 7317810475

Urgent Opening for Fresher for Thaltej. Industry: Khushi Advertising Ideas Pvt Ltd. Location: Thaltej, Ahmedabad Qualification: Any Graduate Fresher can apply Preferred: Advance Excel, PPT, Good Communication, Vlookup, Hlookup, Pivot Table Role & responsibilities Maintaining Data Data Base, Coordination with Team, Client Excel Knowledge is important (Advance Excel, PPT, Good Communication, Vlookup, Hlookup, Pivot Table) Interested candidate can apply on rachana.vibhute@khushiadvertising.com & can contact on 9372748884

Key Accountabilities Execute data extraction processes from various sources including ERP systems, Middleware, banking portals, and historic invoices. Perform thorough data cleansing activities, including removing duplicate records, standardizing data formats, and correcting errors across all extracted datasets. Conduct comprehensive data validation procedures using a variety of online and in-house tools to ensure data accuracy and compliance with established standards. Carry out detailed data comparisons between existing data and newly gathered information, highlighting discrepancies for further investigation. Develop and maintain detailed documentation of data gathering and cleansing processes. Assist in creating and maintaining a centralized repository of supporting evidence for data changes in SharePoint and Excel. Advanced Excel skills, including expertise in VLOOKUPs, formulas, and data manipulation techniques. Collaborate with local finance teams to gather and verify data from various sources, including banking portals and offline databases. Support data migration and integration projects, ensuring data consistency across systems. Participate in the implementation of automated data cleansing processes. Assist in data loading processes into middleware systems across different environments. Essential: ( Knowledge, Experience & Skills) Bachelor's degree Strong experience with data analysis, data quality management tools, and data cleansing techniques Basic understanding of SQL and database management systems Familiarity with MDM concepts and best practices Experience with data extraction and transformation techniques. Strong attention to detail and analytical skills Strong communication skills working with people from different cultural backgrounds.

Preferred candidate profile Strong VBA development skills Excellent Excel proficiency Self-sufficient and able to work independently Ability to function as a business analyst, including gathering and documenting requirements after team meetings Knowledge of Azure DevOps (sprints/scrums/stories, etc.) C# knowledge would be a bonus Strong English communication skills

Role & responsibilities As an Accounts Executive , you will be responsible for supporting the finance and accounts department with day-to-day accounting and compliance activities. Key responsibilities include: 1. Accounting and Bookkeeping Maintain accurate books of accounts including journals, ledgers, and trial balances. Record day-to-day financial transactions and ensure correctness and compliance with applicable accounting standards. Posting entries into Tally or other accounting software. 2. GST Compliance Prepare and file monthly/quarterly GST returns (GSTR-1, GSTR-3B, GSTR-9, etc.). Reconciliation of GST input credit with GSTR-2A/2B. Handling notices and correspondence related to GST from the department. Ensuring timely payment and accurate input/output tax reconciliation. 3. TDS and Income Tax Assist in computation, deduction, and deposit of TDS as per statutory timelines. Filing TDS returns (Form 24Q, 26Q, etc.). Support in preparation of income tax returns for the organization or clients. Coordinate with auditors and consultants for tax assessments and compliance. 4. Statutory Compliance (PF, ESI) Calculation and payment of Provident Fund (PF) and Employee State Insurance (ESI). Filing of monthly/quarterly statutory returns. Coordination with HR for payroll and related deductions. 5. Balance Sheet and Finalization Assist in preparation and finalization of the Balance Sheet, Profit & Loss Account, and other financial statements. Ensure accuracy of closing entries and reconciliations (bank, vendor, customer, etc.). Coordinate with internal and external auditors during audits. 6. Reporting and MIS Prepare financial and operational reports as required by management. Regular MIS reporting on receivables, payables, cash flow, expenses, etc. 7. Advanced Excel Work Use of formulas like VLOOKUP, HLOOKUP, SUMIF, COUNTIF, IF statements, Pivot Tables, and data validation for reports and data analysis. Reconciliation reports and financial summaries using Excel tools. Preferred candidate profile Education & Qualifications B.Com / M.Com / CA Inter / Semi-qualified CA / MBA (Finance) or equivalent. Additional certifications in Tally, GST, or MS Excel will be a plus. Experience 15 years of experience in Accounting, Taxation, and Compliance. Hands-on experience with accounting software like Tally ERP, Zoho Books, Busy, QuickBooks, etc. Skills Required Sound knowledge of accounting principles and taxation (GST, TDS, Income Tax). Familiar with statutory compliance procedures including PF, ESI. Strong command over MS Excel (VLOOKUP, Pivot Table, SUMIF, etc.). Attention to detail and accuracy in handling financial data. Ability to work independently and handle deadlines. Good communication and interpersonal skills. Other Attributes Should be proactive and willing to learn. Ability to handle multiple tasks simultaneously. Team player with a positive attitude.

Responsibilities: * Prepare export documents: invoices, packing lists, certificates * Follow up on deliveries: timely shipments, communication with carriers * Manage export logistics: coordination, documentation, tracking

Roles and Responsibilities Manage financial records, including accounts payable, accounts receivable, bank reconciliations, and general ledger maintenance. Prepare monthly MIS reports using advanced Excel skills to analyze business performance. Ensure accurate accounting entries are recorded in Tally ERP software according to company policies. Assist with payroll processing and compliance with relevant laws and regulations. Perform other finance-related tasks as assigned by management. Desired Candidate Profile 0-1 year of experience in finance or accounting role preferred but not mandatory. Bachelor's degree in Commerce (B.Com) or equivalent qualification required; ICWA (CMA) certification an added advantage. Proficiency in MS Excel, especially advanced formulas and functions such as HLOOKUP, VLOOKUP, SUMIFS, COUNTIFS etc., is essential. Knowledge of Tally ERP software is also necessary.

Role & responsibilities Preparation in the development of Risk Based Audit Plan. Preparation of audit scope and work program. Supporting team in Field work. Review the work of team members Preparation of audit report Discussion of report with the concerned functional head Finalization of report & submission to the senior management Preparation of audit committee presentation Presenting the audit results to the pre-audit committee Tracking and follow-up on implementation of audit recommendation Leading the projects initiated within the team Training to the new and existing team members on auditing and recent developments Preferred candidate profile Internal Audit-Insurance Ability to manage teams (business as well as technical) Ability to perform review Independently Ability to interact will all levels of client management Ability to manage deadlines with flexibility and professionalism. Ability to handle multiple assignments, if needed Good oral / written communication skill Iaequate knowledge to perform technical reviews based on guidance providedI Perks and benefits

What You Need: 1-3 years of experience with revenue recognition audit/ review exposure, either in a public accounting firm or a high-growth software company. University degree with a focus in business or economics; advanced degree or accounting certification (CA, CPA, CMA or equivalent) preferred. Excellent communication skills. Exceptional attention to detail, time-management, and customer service skills. Proficiency in Excel functions, including but not limited to VLOOKUP, SUMIF, Pivot tables, and IF statements. Exceptional work ethic.

Please note that this opening is for Night Shift (US Shift) Coordinate with dentists, hygienists, to ensure smooth operations of the practice. Ensure compliance with all relevant regulations and standards. Updating patient records like x-rays and doctors description to ensure clarity in the preauthorization process with the insurance companies error free. Understand and determine the patients proposed treatment plan vis the coverage / benefits plan to ensure hassle free care to the patients. Understanding of dental CDT codes and aligning with the patient’s insurance benefits program Oversee daily operations of the dental practice thereby optimizing patient care. Understanding of insurance breakdowns in case of major procedures like crowns / bridges / implants. Staying updated with industry trends and best practices Responding to a patient's clinical complaints empathetically. Addressing their clinical concerns successfully to optimize retention rate of the patients. Qualifications : Graduate in any field Excellent English verbal and written communication

Required skills 4+ years experience in Payroll Experience in PF, ESIC & Salary salary processing manually Must e profecient in advance excel (Mandatory) Must have hands on experience in Vlookup, Hlookup, If formula, Pivot table.

Greetings From Ashkom! We are hiring for the role of Senior Logistic Executive for the well known MNC FMCG Company, Position based at Andheri Chakala, Mumbai. JOB DESCRIPTION- Designation : Senior Logistic Executive Location : Andheri Chakala, Mumbai Experience : 5-10Years Education : Any Graduate Job Objective:- Logistics Executive Order Planning and Management, DN generation, Stakeholder management (Supply, Transportation, Vendors, DCs, CHAs etc), day-to-day tracking of shipments, LCs, trucks etc. Key Responsibility:- 1. OF creation - Preparation of order form and sharing it across all markets 2. Order Planning - Work with Order Management to coordinate and build DNs from received orders. 3. Order checking - Checking the order correctness (VFR for orders) 4. Order punching - Punching orders into the system (SAP) 5. Order supply confirmation from the plants 6. Stock blocking, delivery creation and follow ups on the availability of stock 7. TMS planning - Plan load in TMS basis the DN/order details 8. Coordination with DCs, CHAs and Transporters 9. Coordinate with vendor, share necessary docs 10. Check PIPO and price setups 11. Regular follow ups on order form input, supply confirmation, LC tracking, CFR cuts, truck placements, order related issues 12. Coaching & guidance/capability building- Providing supports to team for day-to-day operation Key competencies Skill Required:- SAP Proficiency (Intermediate to Advance) MS Office (Advance Excel Skills preferred) Prior Experience in Logistics is preferred (2-4 yrs) Sound Communication (Speaking and writing both) Digital literacy (should be able to adapt to new systems) Interested applicants can share their resume on nidhi.j.ashkom@gmail.com You can share this among the relevant candidates. References are highly appreciated.

Job Title: Cluster Assistant Job Description: We are hiring a candidate whose responsible for assisting cluster in Sales Division. Role & responsibilities Calendar management and coordination:- meetings invites, agendas, luncheon arrangements, travel plans and department activities, meeting room bookings etc. Support logistics of internal and off site events through associated tasks:-booking conference rooms, requisitioning audio visual equipment, making copies, scheduling meetings and booking meeting rooms, gathering data, coordinating on RSVP tracking etc. Coordinate with external vendors:- on event logistics as required (ex. Off sites, OGSM meetings, promotion letters etc.) Maintain organization mailing lists, prepare organization announcements etc. sales domain:- collated end of day sales reports from multiple sales people and share insights on the sales trends for the day vs last day last week this year etc. , calculated sales incentive for sales persons based on their monthly earning etc. HR domain:- Worked on offline payroll management (excel based), computed monthly PF PT IT data and sent to payroll consulting firm, tracked inputs from talent team on relocation, joining bonus etc. etc. Requirements: Medium knowledge of scorecards, travel management, calendar management. Experience : 1-3 years Location : Kolkata

Job Title: Cluster Assistant for West Clusters Segment/Business Unit: SW Sales Division Location: Kolkata Shifts: General Working Days : 5 days work week; General Shift 9am 5:30 pm Job Objective: To extend administrative support to AM/AEs & CCEOs in 2 Clusters. Key Responsibilities: Co-ordination , data analysis , working on portals Coupa, Aravo, SAP) Excellent command in Excel, for maintaining multiple MIS reports, generate Dashboards as per team requirement Strong organizational and time management skills. Good written & verbal communication. Ability to multitask and prioritize tasks effectively. Ability to work independently with minimal supervision Excellent command in Excel, for maintaining multiple MIS reports, generate Dashboards as per team requirement Strong organizational and time management skills. Good written & verbal communication. Ability to multitask and prioritize tasks effectively. Ability to work independently with minimal supervision Qualifications: Bachelor’s degree Skills Required: Proficiency in English and Hindi Excellent communication skills for coordinating with internal and external stakeholders Advanced MS Excel skills (Basic Formulas, VLOOKUP, Pivot Tables, etc.) Ability to manage and analyze large data sets Payroll : Third party payroll

Prepare management reports for internal circulation (Presentation files & spreadsheets) 1. Monthly Org report 2. Customer account presentation reports. 3. Monthly rolling forecast (expense and invoice)report. 4. Onsite Employee tracking (DoD and Exit dates) report. 5. Customer satisfaction index report. 6. MRM report. 7. Support Managers for Employee PME-ratings, skill gap assessment repot and compile the data Finance related tasks: 1. Prepare Statement of work for PO. 2. Keep track of PO end dates/ hours. 3. Keep track of Customer agreement renewals. 4. Draft the MSA amendments

Journal entries and reconciliations review, investigation and resolution of all reconciling items IFRS 15 knowledge is required for revenue recognition Knowledge of monthly, quarterly and annual book close cycles General ledger transactional reporting In Depth knowledge of intercompany transactions and reconciliations to maintain consistency across entities. Balance sheets Preparation and Reconciliation Revenue reconciliation to verify income accuracy. Reconcile debtors and stock accounts to ensure proper tracking and reporting. knowledge of UK GAAP to ensure compliance in financial processes. Handle fixed assets accounting, including tracking and depreciation calculations. Analyze actuals vs. budget variances and provide actionable insights. Review and analyze profit and loss statements for strategic decision-making. Data gathering ability / eye for detail Ability to work with client independently Work Experience & Other Requirements Commerce Graduate with 5 to 9 years of experience Proficient in MS Office Proficient in MS Office Advance excel and Power BIare compulsory requirement Experience in any finance ERP Strong knowledge of UK GAAP Excellent communication and client interaction skills. Candidate with Power BI knowledge would be given preference.

Job description: We are looking for a detail-oriented and analytical MIS Executive to manage and streamline our data reporting and analysis functions. The ideal candidate will be responsible for generating accurate and timely management information reports that support decision-making processes across departments. Key Responsibilities: Collect, analyze, and interpret data to generate comprehensive MIS reports. Design, develop, and maintain dashboards and automated reporting tools. Work closely with different departments to understand reporting requirements and ensure data accuracy. Monitor data quality and perform regular audits to maintain data integrity. Assist management in making data-driven decisions by providing actionable insights. Maintain and update databases, ensuring smooth data flow across systems. Prepare presentations and reports for stakeholders and senior management. Identify process improvements and suggest automation to enhance reporting efficiency. Key Skills & Qualifications: Bachelors degree in Commerce, Computer Science, or related field. Proven experience (1-3 years) as MIS Executive or in a similar role. Advanced proficiency in MS Excel (Pivot tables, VLOOKUP). Knowledge of SQL and database management is a plus. Strong analytical and problem-solving skills. Excellent communication and interpersonal skills. Attention to detail and ability to work under deadlines.

We are looking for a skilled Data Entry Operator cum Supervisor with working knowledge of SAP to manage data entry operations and oversee a small team. The role involves accurate data input, report generation, and coordination with departments to ensure smooth workflow. Key Responsibilities : Enter and manage data in SAP (e.g., MM, SD, FICO modules). Supervise and guide data entry staff. Ensure data accuracy and timely updates. Generate reports and support audits. Coordinate with internal teams for seamless data flow. Requirements : Graduate with 2+ years of experience in data entry and supervision. Proficient in SAP and MS Excel. Strong attention to detail and team management skills. INTERESTED CANDIDATE CAN DIRECTLY CALL ME ON 8977540946(VISHAL)