11 Advanced Formulas Jobs

You will be responsible for performing and verifying the Monthly Closing Cockpit tasks according to the schedule. Additionally, you will be monitoring and reconciling inventory regularly to ensure the accuracy and integrity of stock records. It will be your duty to prepare and maintain the Fixed Assets Register, including tagging and physical verification. You will also be calculating depreciation in compliance with the Companies Act and Income Tax Act, ensuring timely booking. Handling GST compliances, including the preparation and filing of GSTR-1, GSTR-3B, and Annual Returns, will be a crucial part of your role. You will ensure timely deduction, deposit, and return filing for TDS as per prevailing laws. Furthermore, you will be responsible for booking prepaid expenses and managing their amortization accurately. Your tasks will also include posting accounting entries and ensuring the completeness and correctness of transactions in ERP/accounting software. Supporting the finance team in daily activities and assisting the Manager in the preparation of Financial Statements (FS), MIS, and other financial reporting tasks will be part of your responsibilities. You should be a proactive team player with the ability to support the team and handle multiple tasks effectively. In terms of skills and experience, you should have a strong knowledge of accounting principles, taxation (GST & TDS), and statutory compliances. A minimum of 3 to 4 years of hands-on experience in finance and accounting functions is required. Hands-on experience in inventory accounting and fixed asset management is essential. You should have a basic understanding of financial reporting and reconciliations. Proficiency in Microsoft Excel, including VLOOKUP, Pivot Tables, and advanced formulas, is crucial for this role. Experience in working with accounting software/ERP systems is preferred. Being a proactive team player is also essential for success in this position.,

As a Finance Assistant at Kwalee, you will play a crucial role in supporting the smooth day-to-day running of our financial operations. Your responsibilities will include accurately entering sales and purchase invoices into our accounting systems, assisting with the preparation of monthly management accounts and VAT returns, supporting the preparation of monthly and quarterly royalty statements, maintaining the employee expenses tracker, liaising with suppliers and customers to resolve any issues, and supporting management with monthly and quarterly reporting. To excel in this role, you should have at least 1 year of experience in a similar finance role, ideally within a UK/European company. Additionally, you should be full or part-qualified in finance-related certifications such as ICAI, B.Com/M.Com, AAT, ACCA, ACA, or CIMA, or possess a finance-related degree. Strong spreadsheet skills, including knowledge of advanced formulas like VLOOKUP and SUMIF, are essential. You should also have excellent attention to detail, strong organizational skills, and be a collaborative team player with great communication skills. This role is based in our Bangalore studio, where daily in-office collaboration fuels creativity and innovation. At Kwalee, we are committed to helping you thrive with a fantastic work-life balance and a range of great benefits. You will have access to group health insurance and 20 annual leave days, allowing you plenty of time to recharge. Stay energized throughout the day with unlimited snacks and drinks, and enjoy access to a discounted premium gym membership to keep you feeling your best. You will work with cutting-edge equipment in an environment designed for your success, with clear career progression and endless opportunities for growth. We host seasonal events, regular town halls, and share exclusive Kwalee merch to ensure there is always something exciting to look forward to. Join our team at Kwalee and be part of a space where ideas flow freely, innovation flourishes, and team spirit stays strong. Together, we can drive the commercial success of our games and business as a whole.,

Job Title: Google Sheets MIS Executive / Data Analyst Location: Andheri East, Mumbai Salary: ?45,000 ?50,000 per month Employment Type: Full-Time Company Overview We are hiring a skilled Google Sheets MIS Executive / Data Analyst to drive data management, reporting, and dashboard creation for internal business functions. This role is ideal for candidates with 3 to 5 years of experience in handling data analysis, MIS reporting, and Google Sheets-based automation in a fast-paced environment. Key Responsibilities Design and manage automated trackers using Google Sheets (QUERY, IMPORTRANGE, ARRAYFORMULA, FILTER, etc.) Create real-time dashboards and reporting tools for internal stakeholders Clean, merge, and structure raw datasets from various sources Collaborate with operations, sales, and finance teams to validate and gather data Ensure 100% data accuracy and completeness through regular audits Generate and distribute MIS reports on daily, weekly, and monthly basis Maintain structured sheets with formatting, version control, and error checks (Optional) Use basic AppScript to automate recurring tasks and enhance reporting KRAs & KPIs KRA 1: Data Accuracy & Timeliness 100% accurate updates with <2% error rate Timely data refresh within turnaround time KRA 2: Formula Expertise Proficient in advanced formulas with zero live errors 23 new dashboards or tracker enhancements monthly KRA 3: Reporting & Dashboards Timely delivery of MIS reports Real-time dashboard accuracy with minimal stakeholder follow-up KRA 4: Team Coordination Responsive data support across 3+ departments Smooth communication with cross-functional teams KRA 5: Sheet Hygiene Consistent formatting, structure, and no missing data Controlled versioning and clean backups Requirements 3 to 5 years of hands-on experience in MIS, data analysis, or reporting Proven expertise in Google Sheets with advanced formula application Strong analytical and problem-solving skills Experience in coordinating with multiple departments Basic understanding of AppScript (preferred but not mandatory) Excellent organizational and communication skills Preferred Industry Background Operations, Sales Support, Business Analytics, Reporting, Finance, or Admin If youre a data-driven professional who can independently manage sheets, reporting systems, and dashboards apply now to join a process-focused, dynamic team. Skills: audit,communication skills,excel dashboards,advanced formulas,dashboards,dashboard builder,problem-solving,data accuracy,mis reporting,reporting,data analysis,automation,google appscript,advanced excel skills,team management,google,collaboration,appscript,mis,google sheets,microsoft excel,data management,dashboard creation,stakeholder engagement Show more Show less

NTT DATA Services is a prominent global services company and a part of the NTT Group, a Fortune 29 telecommunications and services company headquartered in Japan. With a workforce of 60,000 professionals spread across 36 countries, we strive to assist clients worldwide in adapting to market dynamics swiftly, reducing costs with minimized risks, and enhancing productivity to foster growth. Over the past three decades, our Business Process Outsourcing (BPO) team has been instrumental in implementing transformative processes and technologies for clients of varying sizes. Our comprehensive administrative services aid in streamlining operations, boosting productivity, and fortifying cash flow, thereby ensuring our customers remain competitive and enhance member satisfaction. The opportunity at hand involves joining a leading global provider of asset and wealth management solutions. This client offers investment processing, investment management, and investment operations solutions tailored for corporations, financial institutions, financial advisors, and ultra-high net-worth families. We are currently seeking a Private Equity Analyst to be a part of our team based in Gurgaon. Your responsibilities will include booking journal entries based on bank statements and client information, preparing bank reconciliations, and maintaining financial logs. Additionally, you will be responsible for generating a monthly financial reporting package for Hedge Funds, determining "Net Asset Value," preparing the Statement of Asset and Liabilities, and Profit and Loss Statement. Ensuring adherence to accounting standards, accurately processing capital activities, deriving pricing for portfolio investments, and managing cash flow and cash movements are also key aspects of the role. In addition to the day-to-day tasks, you will be expected to lead a team of professionals, manage personnel duties such as performance evaluations and disciplinary actions, identify process improvements, and recommend enhancements in systems, services, and processes. Building and maintaining relationships with clients, managing the Risk and Control agenda, and working closely with senior management to identify opportunities for cost savings and optimization are also integral parts of the position. Desired qualities include a drive to expand knowledge in the financial services industry, meticulous attention to detail, a university degree or equivalent in Finance/Accounting, at least 4 years of experience in the financial services industry, proficiency in MS-Excel, and the ability to lead a team effectively. Regular shifts from Monday to Friday (starting after 5 pm) are expected. If you possess the necessary skills and experience and are eager to contribute to a dynamic and global team, we encourage you to apply for this exciting opportunity.,

You will be working as a Data Management Executive (DME) where your primary responsibility will be to efficiently manage and analyze data using Microsoft Excel and Google Sheets. Your role will involve tasks such as maintaining and updating data with precision, utilizing advanced formulas to streamline data management, creating Pivot Tables for analysis, developing Macros for task automation, generating MIS reports, and ensuring data integrity through regular audits. In this position, you will be required to work with large datasets to extract valuable insights and trends. Proficiency in Microsoft Excel and Google Sheets is essential, including knowledge of advanced formulas, Pivot Tables, Data Validation, VLOOKUP, HLOOKUP, etc. Additionally, familiarity with Macros/VBA is preferred but not mandatory. Strong mathematical and analytical skills are crucial for this role, and a background in Mathematics would be advantageous. The ideal candidate should have 3-5 years of experience as an MIS Executive or in a similar role. Attention to detail is key, as you will be handling large volumes of data on a regular basis. Your ability to generate MIS reports, develop dashboards for management review, and work efficiently with data sets will be critical for success in this role.,

Key Responsibilities: Data Management & Reporting: Collect, compile, and consolidate data from various sources (e.g., sales, operations, marketing) on a daily, weekly, and monthly basis. Ensure data accuracy, consistency.

As a SAP BI Planning Specialist at Vistra, you will be responsible for designing, implementing, and maintaining enterprise performance management and planning solutions using the SAP Business Intelligence suite, with a focus on SAP Analytics Cloud (SAC) Planning and SAP Datasphere. Your role will enable strategic decision-making through accurate planning models, financial forecasting, scenario simulations, and integrated reporting, with a primary emphasis on Planning related deliverables. Your key responsibilities will include engaging with business stakeholders to gather requirements, designing SAC Planning models, implementing advanced planning logic, integrating data from various sources, developing interactive dashboards in SAC, ensuring data accuracy and performance optimization, managing BI deliverables, and leading and mentoring a small team of analysts or consultants. To be successful in this role, you should have a minimum of 4 years of experience in SAP SAC BI and SAP SAC Workforce Planning, along with experience in integration with HR, Sales, and Finance Systems. You should also have expertise in SAC Planning models, advanced planning logic, and finance and reporting experience. Additionally, professional services experience, specifically in corporate services, would be beneficial. You will be joining a dynamic team based in Mumbai, India, with regional coverage, offering you the opportunity to contribute significantly to the growth of the Technology department. The company provides a hybrid working arrangement, attractive insurance benefits, excellent job exposure, and career prospects. If you are excited about the prospect of working in a collaborative environment where your contributions can make a real difference, we encourage you to apply for this position and be a part of our journey towards progress at Vistra.,

WE ARE ONLY LOOKING FOR FINANCIAL MODELING EXPERTS WITH A MINIMUM OF 3-5 years OF REAL WORLD EXPERENCE. The Role Position: Finance Associate Location: Remote Schedule: 7 days/week, unlimited hours Who We're Looking For You are an absolute machine. You live and breathe financial modeling. You've been in the trenches of FP&A for 3-5 years and you're ready to take it to the next level. This role is for early- to mid-career professionals who want to accelerate their trajectory. What You'll Be Doing Build 3-statement financial models from scratch - fast, accurate, bulletproof Own investor pitch decks that actually get funded Create KPI dashboards that executives check obsessively Analyze financial performance with surgical precision Work directly with startup founders and executives Deliver client work that exceeds expectations every single time Respond to urgent requests at 2am without complaint Support multiple clients simultaneously without dropping balls What We Expect Technical Excellence: Excel/Google Sheets mastery - advanced formulas, complex modeling, scenario logic PowerPoint/Slides expertise - investor-ready decks with compelling visuals BI tool experience - Looker, Tableau, or similar Understanding of SaaS, DTC, marketplace, and service business models Work Ethic: Always meet deadlines (preferably beat them by hours) Available 7 days/week for urgent requests Respond to messages within minutes, not hours Comfortable working across US and European time zones Never make excuses - only find solutions Communication: Explain complex financial concepts clearly to anyone Check in obsessively on project status Follow up relentlessly until things get done Comfortable being "annoying" if it means better results Your Background 3-5+ years in investment banking, private equity, venture finance, or FP&A Track record of working directly with executives and high-stakes deliverables History of holding yourself to an impossibly high standard Experience thriving under extreme pressure and tight deadlines Demonstrated ability to wear multiple hats and context-switch rapidly

Key Responsibilities: Analyze business processes and systems to identify opportunities for improvement. Develop and implement solutions to enhance business operations. Collaborate with stakeholders to gather requirements and translate them into functional specifications. Understand technical changes incl DB changes requirements and translate them into functional specifications. Create detailed user story on devops Perform detailed data analysis and come up with insights for further improvements incl corelations with multiple datasets Create detailed documentation, including process flows, system designs, and user guides. Conduct data analysis and generate reports to support decision-making. Provide training and support to end-users on new systems and processes. Ensure compliance with company policies and industry regulations. Minimum Skills and Experience: Bachelor s degree in business administration, information technology, or a related field. 7 to 10 years of experience as a business system analyst. Strong analytical skills with the ability to interpret complex data sets. Proficiency in Excel, including advanced formulas and Macros. Excellent communication and interpersonal skills. Ability to work independently and as part of a team. Strong problem-solving skills and attention to detail.

Key Responsibilities: Analyze business processes and systems to identify opportunities for improvement. Develop and implement solutions to enhance business operations. Collaborate with stakeholders to gather requirements and translate them into functional specifications. Understand technical changes incl DB changes requirements and translate them into functional specifications. Create detailed user story on devops Perform detailed data analysis and come up with insights for further improvements incl corelations with multiple datasets Create detailed documentation, including process flows, system designs, and user guides. Conduct data analysis and generate reports to support decision-making. Provide training and support to end-users on new systems and processes. Ensure compliance with company policies and industry regulations. Minimum Skills and Experience: Bachelor s degree in business administration, information technology, or a related field. 7 to 10 years of experience as a business system analyst. Strong analytical skills with the ability to interpret complex data sets. Proficiency in Excel, including advanced formulas and Macros. Excellent communication and interpersonal skills. Ability to work independently and as part of a team. Strong problem-solving skills and attention to detail.

Execute flawless day-to-day order processing and sales reporting to keep our supply chain moving and our leadership fully informed. You will own the routinebut business- critical—tasks that ensure every customer order is entered correctly, dispatched on time, and reflected in accurate, deadline-ready reports. Your discipline with ERP workflows, advanced Excel/Pivot skills, and basic Python automation will free the Sales Planning Manager to focus on strategic analysis while keeping growth engine running smoothly. Responsibilities Order Processing (SCM) Enter customer orders in ERP/OMS within 1 hour of receipt, validating pricing, SKU codes, and stock levels. Coordinate with Warehouse & Logistics teams to secure daily pick-lists and ensure OTIF (On- Time-In-Full) dispatch. Escalate stock-out risks immediately and log corrective actions. Sales Data Maintenance Cleanse and reconcile data to eliminate duplicates, mismatches, and missing values. Maintain master data tables (SKUs, outlets, price lists) with strict version control. Update daily sell-in / sell-out feeds from distributors, key accounts, and e-commerce portals. Reporting & Deadlines Produce daily flash, weekly trend, and month-end sales reports in Excel/Power Pivot with zero formula errors. Meet all reporting cut-offs agreed with the Sales Planning. Distribution Record-Keeping Keep outlet & distributor master files up-to-date (new openings, closures, territory changes). Track numeric & weighted distribution metrics for quick reference by the field team. Process Compliance & Improvement Follow standard operating procedures (SOPs) for order entry, data validation, and report circulation. Document any deviations and propose small-scale process tweaks that raise accuracy or speed. Success Metrics (KPIs) Order Entry:100 % of orders entered within 1 hour OTIF Dispatch Data Accuracy: 99 % Report On-Time Delivery: 100 % vs. calendar Reporting Error Rate: 0.5 % per month Master Data Update Cycle: 100 % daily/weekly refresh completion Key Skills & Competencies: Education: Bachelor’s degree in business, Supply Chain, Commerce, or related field. Experience: 2–4 years in order management, sales operations, or SCM support—preferably in FMCG or food. Technical: Advanced Excel (Advanced formulas, PivotTables, basic VBA/macros). Power Query/Power Pivot; familiarity with ERP/WMS. Intro-level Python (pandas) for simple automation a plus. Behavioral: Highly organized, deadline-driven, and fanatical about data accuracy; thrives on routine excellence. Communication: Clear written & verbal English; able to flag issues promptly and concisely. Excellent time-management, multitasking, and follow-through. High attention to detail and a proactive, service-oriented mindset. Contact Person Sofiya Sayyed SG OASIS Interested candidates can share their resumes on sofiyaoasis@gmail.com