4639 Advanced Excel Jobs - Page 45

As the Accounts Manager, you will be responsible for overseeing accounts receivable and ensuring the timely collection of outstanding invoices. You will reconcile accounts and work closely with clients to resolve any discrepancies that may arise. Your role will also involve providing operational support by offering insights to improve credit control strategies and operational efficiency. In terms of client follow-up, you will be required to maintain regular communication with clients to address any queries or concerns they may have. Additionally, you will be involved in reporting and analysis, utilizing Excel tools such as pivot tables, dashboards, and conditional formatting to present data clearly and effectively. Compliance with TDS, GST, and other relevant accounting standards will be a key aspect of your responsibilities, ensuring that all documentation is in order and that financial regulations are adhered to. Your qualifications include a Bachelor's degree in Accounting, Finance, or a related field, along with proven experience in accounts receivable, credit control, or similar roles. Proficiency in advanced Excel functions is essential for this role, including pivot tables, conditional formatting, and the ability to create dashboards. Strong communication and negotiation skills will also be important, as well as the ability to work independently and efficiently manage multiple tasks. Preferred skills for this position include experience working with financial software and ERP systems, an analytical mindset with attention to detail, and the ability to explain financial data clearly and concisely. This is a full-time position with benefits such as Provident Fund and a performance bonus, working in a day shift schedule at an in-person location.,

We are looking for a detail-oriented MIS Executive with a strong background in Data Management . The ideal candidate should have hands-on experience in handling, analyzing, and reporting sales data, with expertise in Excel . Key Responsibilities: Manage, analyze, and interpret the data for performance tracking and reporting. Maintain and update MIS reports, dashboards, and databases for sales teams. Use advanced Excel functions (VLOOKUP, Pivot Tables, Macros, etc.) for data analysis. Prepare and automate reports to provide data-driven insights for business decisions. Collaborate with sales and operations teams to improve reporting efficiency. Ensure accuracy and integrity of sales data and coordinate with stakeholders for any discrepancies. Track and monitor key sales performance indicators (KPIs). Requirements: 2-5 years of experience in MIS & Sales Operations Data Management . Must be proficient in Advanced Excel (Pivot Tables, VLOOKUP, HLOOKUP, Macros, etc.). Experience in handling sales operations data is essential. Real estate industry experience is preferred. Strong analytical and problem-solving skills. Ability to work with large datasets and generate actionable insights. Excellent communication and coordination skills.

Responsibilities: * Collaborate with team on projects * Maintain data accuracy using advanced Excel skills * Analyze reports with pivot tables and lookups * Ensure system security and backups * Prepare and report daily progress of projects

Role & responsibilities Maintaining the report on daily of the employee, Maintaining reports as per management requires. Preferred candidate profile BCA candidates and minimum 4 years experienced

Overview Annalect India is seeking an Accounts Receivable Analyst (AR Billing/OTC Billing) with strong domain knowledge to support the AR and Billing functions under Finance Operations. This might be a great fit for you if you you would like to be part of a growing team. You will be closely working with our Global Agency Finance teams. About Annalect India We are an integral part of Annalect Global and Omnicom Group, the second largest advertising agency holding company in the world in terms of revenue and is the leading global marketing communications company. Our portfolio includes: three global advertising agency networks: BBDO, DDB and TBWA; three of the world’s premium media services: OMD, PHD and Hearts & Science. Annalect India plays a key role for our group companies and global agencies by providing stellar products and services in areas of Creative Services, Technology, Marketing Sciences (data & analytics), Business Support Services, Market Research and Media Services. Shift Timing : 2PM-11PM Location Hyderabad Responsibilities This is an exciting role and would entail you to • Main point of contact with our clients’ finance teams. Validate all invoices sent match our contracts. • Coordinate signatures, answer questions, follow up on outstanding payments and escalate issues. • Follow-up on the Aging’s as directed by SSC and handling Customer Queries and Issue resolution • Prepare & Review the Invoices and meeting the SLA’s & KPI’s. • Preparation of Aging Reports from Cognos • Perform cash applications and billing • Facilitate the setup of new clients • Prepare working capital commentary • Communicate current forecasting of receivables on a daily/weekly basis to applicable business partners • Month end close support for monthly / quarterly / Yearly close activities for all the businesses Qualifications This may be the right role for you if you have Bachelors or Post Graduate Degree in accounting or finance with 4-6 years of experience in O2C Operations (Accounts Receivable, Billing Ops etc) Strong knowledge on Accounting Basics and Accounts Receivable activities Proficient in Advanced Excel and ability to quickly learn any new ERP Flexibility to take up new assignenments and not limit oneself to specific set of activities Flexible and Result Oriented with Strong Written & Oral Communication Skills Strong problem solving skills, including ability to effectively address any issue Experience in Microsoft Dynamics AX, MediaOcean, and Hyperion Financial Management tool is a plus

Role Purpose The purpose of this role is to design, test and maintain software programs for operating systems or applications which needs to be deployed at a client end and ensure its meet 100% quality assurance parameters Do 1. Instrumental in understanding the requirements and design of the product/ software Develop software solutions by studying information needs, studying systems flow, data usage and work processes Investigating problem areas followed by the software development life cycle Facilitate root cause analysis of the system issues and problem statement Identify ideas to improve system performance and impact availability Analyze client requirements and convert requirements to feasible design Collaborate with functional teams or systems analysts who carry out the detailed investigation into software requirements Conferring with project managers to obtain information on software capabilities 2. Perform coding and ensure optimal software/ module development Determine operational feasibility by evaluating analysis, problem definition, requirements, software development and proposed software Develop and automate processes for software validation by setting up and designing test cases/scenarios/usage cases, and executing these cases Modifying software to fix errors, adapt it to new hardware, improve its performance, or upgrade interfaces. Analyzing information to recommend and plan the installation of new systems or modifications of an existing system Ensuring that code is error free or has no bugs and test failure Preparing reports on programming project specifications, activities and status Ensure all the codes are raised as per the norm defined for project / program / account with clear description and replication patterns Compile timely, comprehensive and accurate documentation and reports as requested Coordinating with the team on daily project status and progress and documenting it Providing feedback on usability and serviceability, trace the result to quality risk and report it to concerned stakeholders 3. Status Reporting and Customer Focus on an ongoing basis with respect to project and its execution Capturing all the requirements and clarifications from the client for better quality work Taking feedback on the regular basis to ensure smooth and on time delivery Participating in continuing education and training to remain current on best practices, learn new programming languages, and better assist other team members. Consulting with engineering staff to evaluate software-hardware interfaces and develop specifications and performance requirements Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code Documenting very necessary details and reports in a formal way for proper understanding of software from client proposal to implementation Ensure good quality of interaction with customer w.r.t. e-mail content, fault report tracking, voice calls, business etiquette etc Timely Response to customer requests and no instances of complaints either internally or externally Mandatory Skills: Anaplan. Experience:3-5 Years.

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators Experience: 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Mandatory Skills: Delivery(RPA). Experience:3-5 Years.

Responsibilities: Generate and send timely invoices to clients. Diligently follow up on outstanding payments. Validate vendor invoices for accuracy and completeness. Manage accounts receivable and accounts payable. Ensure compliance with GST regulations. Maintain accurate financial records in Tally and Excel. Utilize our background check portal for vendor verification. Prepare and analyze financial reports as needed. Collaborate with other team members to improve accounting processes. Handle other accounting-related tasks as assigned. Desired Candidate Profile 4-8 years of experience in accountancy or related field. Bachelor's degree in Commerce (B.Com) or equivalent qualification. Proficiency in Tally ERP software; knowledge of Excel is an added advantage. Benefits: Competitive salary based on experience Discretionary Bonus

Your Role Design and implement BPC Embedded models using BW Integrated Planning (BW-IP). Develop planning functions, sequences, and FOX formulas. Configure data models, aggregation levels, filters, and planning queries. Integrate BPC with S/4HANA and BW systems for real-time planning. Create input templates and reports using Analysis for Office (AO). Your Profile Strong experience with SAP BPC Embedded and BW-IP. Proficiency in Analysis for Office and SAP BW modeling. Knowledge of S/4HANA Finance and integration points. Experience with ABAP for custom planning What you will love about working here We recognise the significance of flexible work arrangements to provide support in hybrid mode, you will get an environment to maintain healthy work life balance Our focus will be your career growth & professional development to support you in exploring the world of opportunities. Equip yourself with valuable certifications & training programmes in the latest technologies such as SAP

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Mandatory Skills: Google BigQuery. Experience: 5-8 Years.

Your Role Configure and customize the Nexthink platform, including dashboards, alerts, and remote actions, to enhance digital experience monitoring. Deploy and manage Nexthink Collectors and browser extensions across enterprise devices while ensuring data privacy and security. Design investigations using NQL, integrate Nexthink with other IT systems, and automate tasks using PowerShell or Python. Monitor, analyze, and troubleshoot digital experience data to proactively resolve IT issues and support performance management. Collaborate with IT and business stakeholders to align Nexthink configurations with organizational goals and automation needs. Your Profile 4 to 6 years of experience in Dashboard creation, Investigation using NQL, Converting PowerShell into a Nexthink Remote Action. Digital workplace management. Experience with Nexthink modules such as Application configuration, Act (Remote Action), Engage (Campaigns) and Analytics (Investigation. Proficiency in working on incidents and change tickets. What You Will Love Working at Capgemini Work on enterprise-scale digital experience monitoring and automation using Nexthink, PowerShell, and NQL. Collaborate with global teams to configure Nexthink modules like Act, Engage, and Analytics for proactive IT operations. Clear career progression paths from engineering roles to architecture and consulting. Be part of mission-critical projects that ensure security, compliance, and operational efficiency for Fortune 500 clients. Location - Bengaluru,Bhubaneswar,Chennai,,Gurugram,Hyderabad,Kolkata,Mumbai,Noida

Your role In this role you will play a key role in. Create clear and concise reports, dashboards, and visualizations to effectively communicate findings to internal stakeholders. Gather raw data from various sources, conduct data integrity audits, validate, and analyse data to identify trends, patterns, and key performance indicators (KPIs). Collaborate with cross-functional teams to identify data needs, opportunities to improve data accuracy and alignment. Document statement of procedures (SOPs), Audit SOPs and implement process changes. Automate standard reports to increase efficiency and effectiveness. MS SharePoint support & audits to manage access and guide teams on proper use of sites. Shift timings2PM to 11:30PM IST. Your profile 6-8 years of analytics and reporting experience in a fast-paced and high-volume environment. Subject matter expertise / understanding of Americas immigration landscape will be an added advantage. Strong proficiency with MS Office Suite, Advanced Excel skills with proficiency in Word, and PowerPoint, Intermediate to Advanced working expertise in analytics tools (PowerBI preferred). Excellent time-management skills, accuracy and attention to detail are essential. Creative problem solving & analytical thinking. Strong communication skills to be able to respond to employee / business/ respective stakeholders queries within 24 hours. What you''ll love about working here Were committed to ensure that people of all backgrounds feel encouraged and have a sense of belonging at Capgemini. You are valued for who you are, and you canbring your original self to work. Every Monday, kick off the week with a musical performance by our in-house band - The Rubber Band. Also get to participate in internalsports events, yoga challenges, or marathons. At Capgemini, you can work oncutting-edge projectsin tech and engineering with industry leaders or createsolutionsto overcome societal and environmental challenges.

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Mandatory Skills: Google Cloud Dataflow. Experience: 5-8 Years.

What Youll Do: Develop and support brand and communication campaigns across social media, email, website content, and ads—building brand awareness and engagement. Assist in planning and executing digital campaigns (SEO/SEM, PPC, social media), and use analytics tools to measure performance, generate insights, and inform optimizations. Collaborate with the MARCOM team to create visual and written content—blogs, infographics, short videos, newsletters—and help maintain consistent brand messaging. Why Cyrix Healthcare Is a Great Place to Learn (https://www.cyrixhealthcare.com/index.php) Impactful Mission : Cyrix, established in Kochi (2004), ensures critical medical technologies are reliable across India and the Middle East—supporting over 25,000 hospitals and maintaining 550,000+ devices with 98% uptime. Innovation & Growth : The company recently launched Cyrix Academy for biomedical training and expanded with AI-driven dashboards and a “single-vendor” CYRIX Care360 servicing model. Vibrant Culture & Mentorship : Named the “XForce,” the MARCOM & digital team works closely with biomedical experts, service managers, and senior leadership—offering strong mentorship and real business impact. Internship Details Start Date: Immediate Duration: 3–6 months Location: Kochi

Role Purpose The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions. Do 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customers business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement Mandatory Skills: Network Operations - Utilities. Experience: 5-8 Years.

Role Purpose Anaplan, Anaplan Model Builder, SQL and Integrations 1) Ability to understand, interpret & normalize business processes and model requirements along with structured, semi-structured and unstructured financial datasets 2) Translate business/process requirements into technical & functional requirements and use cases 3) Design and build Anaplan application models to support business processes 4) Build, develop and configure Anaplan lists, modules, dashboards, actions, and other model settings to meet business needs 5) Transform and implement multi-dimensional structures to support business processes 6) Ability to explore multiple methods for developing a model and objectively determine the best approach 7) Monitor data flows to and from financial systems to ensure all data is up-to-date and accurate 8) Provide hands-on training to end users on Anaplan models and processes 9) Define and administer user roles and permissions in Anaplan 10) Partner and build trust with different teams across the organization

Facilitating relationships with external business partners, understanding their basic goals, drivers and metrics. Diving deep into vendor issues, gathering, analyzing and sharing data to help push data-driven business decisions. Participating in the coordination of vendors journey with Amazon, contributing to set expectations and facilitating discussion using a preset agenda. Acting as one point of contact and trainer for offshore team members and local teams, you will identify issues and make sure that they are addressed, documented and resolved in a timely and professional manner. Proactively scoping, participating in and delivering small local scale projects. You will define clear briefs and roadmaps, setting the expectations of stakeholders effectively. You will support projects with future EU rollout/constraints in mind. Auditing and supporting quality/efficiency of service processes, analyzing and fixing root cause. Serve as an innovative center of excellence, working on catalogue pilots and testing new initiatives. Providing value-added recommendations to enhance systems and programs. Operating with considerable autonomy, frugality and discretion, working efficiently with good prioritization and judgment. You will help identify and evaluate potential risks and contribute to determine appropriate corrective action. Communicating and collaborating effectively with EU peers and management. Sharing knowledge with others (both verbally and in writing), within and outside your team. Responding promptly and accurately to questions from both customers and internal business partners, including leadership teams. Escalating issues promptly and appropriately when necessary. 2+ years of program or project management experience Experience using data to influence business decisions Knowledge of SQL and Advanced Excel (Array and Statistical formulas) Knowledge of basic and systematic approaches to manage projects/programs Experience back office operations, escalation management and troubleshooting environments

Under general direction, independently perform routine & intermediate recurring procedures, analysis, and report preparation to support the lifecycle of investments in a global infrastructure Identify and resolve problems following established guidelines; raise complex problems or issue to senior team members Conduct special analyses and/or studies Responsible for account reconciliation, reporting, transaction management, portfolio analysis and reporting, compliance, data and/or trade support activities Support global investment initiatives through participation in projects, process reviews and/or system enhancements Qualifications At least 15 years of formal education preferably in Finance/Commerce Japanese lingual skill (Reading, writing, speaking and understanding) is must Minimum of 2-3.5 years Account/Finance/Reporting experience in the domain of Mutual Funds/Asset Management, Banking, or any other financial services organization Excellent knowledge of Excel/Advanced Excel is essential Hands on documentation, making SOP and willingness to work in multiple shifts Good comprehension skills, analytical skills, good typing skills, detail-oriented, multitasking, ability to prioritize, good written & verbal communication skills, experience in navigating the internet Ability to work on different applications Consistently able to meet timing requirements and maintain SLA and produce work with high degree of accuracy

Key responsibilities Prepare KPIs, financials, and insights for global business reviews. Conduct overcharge analysis and vendor invoice validation. Optimize expense through rate card digitization and remediation. Lead volume reporting, broker analysis, and strategic MI for automation. Drive key global initiatives, including cost optimization and governance for new product rollouts. Collaborate with Sales, Trading, IT, Ops, Risk, and Finance functions. Role requirements Excellent interpersonal and stakeholder management skills. Strong analytical mindset with advanced Excel and PowerPoint proficiency. Sound knowledge of Capital Markets and financial products. Ability to handle high-volume deliverables in a cross-functional setup. Familiarity with BI tools like Power BI / Tableau.

About the Job Searching for relevant data from various sources and ensuring its accuracy and completeness. Creating and maintaining databases to organize collected information efficiently. Inserting data accurately and promptly into our systems and databases. Screening data to identify errors, inconsistencies, or duplications, and rectifying them accordingly. Generating reports and performing data analysis as needed to support decision-making processes. Collaborating with team members to ensure data integrity and consistency across systems. Assisting with other administrative tasks as assigned. Required skills Microsoft Excel - (Must - Vlookup, Pivot) (Good to have - MIS, Chart) Follow-up with customer and internal team Working experience in a group of 2+ people Preferred Email writing Handle the situation under pressure Basic knowledge of CRM (Salesforce, Freshsales, MS Dynamics, Zoho CRM, Insightly) Coordinate with Sales and Client related to Input data for Commercials

Company: Remote Resource (www.remoteresource.com) Location: Noida, Sector 63 Shift Timing: 12:00 noon to 9:00 PM IST (Monday to Friday) Annual CTC: Up to 7 LPA About the Role: We are looking for a highly motivated and detail-oriented Financial Analyst to support a UAE-based project. The ideal candidate will have 2 to 5 years of experience in UK accounting, with a strong grasp of advanced Excel functions, and excellent communication and analytical skills. This role will also involve close collaboration with Financial Modellers, providing key data and insights for high-quality financial decision-making. Key Responsibilities: Prepare and analyze financial reports aligned with UK accounting standards. Assist Financial Modellers by providing reliable data, insights, and structured reports. Perform detailed variance analysis, financial performance tracking, and cost evaluations. Develop and maintain advanced Excel models, dashboards, and data summaries. Coordinate with internal and client-side teams for smooth information flow. Support in budgeting, forecasting, and month-end/year-end closures. Ensure timely and accurate delivery of financial data and compliance with relevant policies. Requirements: 2 to 5 years of relevant experience in UK accounting processes. Advanced Excel skills (Power Query, Pivot Tables, VLOOKUP/XLOOKUP, Macros, etc.). Excellent communication skills (spoken and written) for client interaction and documentation. Strong analytical mindset with the ability to work with large datasets. Must be from a premier institute or a CA Intermediate qualified professional. Ability to work independently in a fast-paced, client-driven environment. Compensation & Benefits: Exposure to international finance practices and modelling teams Professional growth opportunities in a collaborative work culture

Qualification: Reconciliation Excel Banking Partner Relationship Complaints and Disputes Management Sub-Merchant & Invoicing Management Good English communication #Only candidates from Salem will be considered

Should have experience in tally, advanced excel Should have experience in ecommerce

Role & responsibilities Consolidation of Budget & Presentation Monthly flash FRM & BRM, Quarterly SMG KPI Monitoring BEP , VAPE , VAPCO , FATR, ROCE , monthly controls. Closure of sub con and RMGP , review report and follow up with plant operations. Asset Tagging & Physical Verification Knowledge of SAP

Here are some typical duties and responsibilities for a Finance Intern : Assist with Financial Reporting Help prepare monthly, quarterly, and annual financial reports. Support in reconciling financial statements and verifying accuracy. Data Entry and Record-Keeping Enter financial data into accounting software or spreadsheets. Maintain organized and up-to-date financial records. Accounts Payable and Receivable Support Assist with invoice processing and follow-up on outstanding payments. Help prepare payment requests and track transactions. Budgeting and Forecasting Assistance Support the finance team in preparing budgets and forecasts. Conduct variance analysis and provide insights on budget adherence. Financial Analysis and Research Perform basic financial analysis such as ratio analysis, trend analysis, etc. Research financial data for use in reports and presentations.