Home
Jobs

1051 Pivot Table Jobs - Page 7

Filter Interviews
Min: 0 years
Max: 25 years
Min: ₹0
Max: ₹10000000
Setup a job Alert
Filter
JobPe aggregates results for easy application access, but you actually apply on the job portal directly.

0.0 - 1.0 years

0 Lacs

Noida

Work from Office

Naukri logo

Scope of work: Assist in monthly payroll processing by gathering, verifying, and updating employee data. Maintain and update employee records in HR systems and spreadsheets. Generate and analyze Excel-based reports (e.g., headcount, attendance, leaves, payroll summaries). Support onboarding and offboarding documentation and coordination. Assist in HR audits and compliance checks for employee documentation. Support day-to-day HR operational activities and respond to employee queries. Participate in process improvement initiatives within the HR function. Skills Sets Required: Strong proficiency in Microsoft Excel (e.g., formulas, VLOOKUP, pivot tables, charts). High attention to detail, confidentiality, and organizational skills. Good written and verbal communication skills. What You'll Gain: Real-world experience in HR operations and payroll processes. Opportunity to develop advanced Excel and reporting skills. Insight into HR systems and employee lifecycle management. Mentorship from experienced HR professionals.

Posted 5 days ago

Apply

2.0 - 5.0 years

2 - 6 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging expert knowledge of Process Invoiceing, The Process Invoicing Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They ensure the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. They will manage the contract on a daily basis including operations and finance and complex operational issues and ensure that operations are run according to budget. They will build and develop the team. Their expert domain expertise means they process more complex transactions and producing outputs across Invoice processing activities and manage effective usage of resources in the service delivery Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity Skills (competencies)

Posted 5 days ago

Apply

2.0 - 5.0 years

2 - 6 Lacs

Bengaluru

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging expert knowledge of Process Invoiceing, The Process Invoicing Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They ensure the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. They will manage the contract on a daily basis including operations and finance and complex operational issues and ensure that operations are run according to budget. They will build and develop the team. Their expert domain expertise means they process more complex transactions and producing outputs across Invoice processing activities and manage effective usage of resources in the service delivery Job Description - Grade Specific Operating at entry level managerOperating as a Finance specialist supporting small and medium sized finance exercises.Will contribute to the transformation agenda and recognizes the importance of building a strategic mindset as well as being able to deliverAble to act on their own initiative with respect to the main perimeter of their roleKnows when to seek guidance/escalateAble to organize development for self and junior team member Skills (competencies)

Posted 5 days ago

Apply

2.0 - 6.0 years

1 - 4 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of one or more R2A processes (record, report, analyze etc), Record to Analyze Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They support the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for processing non complext to complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity

Posted 5 days ago

Apply

2.0 - 5.0 years

2 - 6 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging expert knowledge of Process Invoiceing, The Process Invoicing Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They ensure the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. They will manage the contract on a daily basis including operations and finance and complex operational issues and ensure that operations are run according to budget. They will build and develop the team. Their expert domain expertise means they process more complex transactions and producing outputs across Invoice processing activities and manage effective usage of resources in the service delivery Job Description - Grade Specific Operating in at Junior Mid Junior level in a Finance support/professional roleOperating as a Finance specialist supporting small and medium sized finance exercisesWill be building skills for a more specialized Finance service.May start to manage others.Manage working relationships with stakeholders for the business areas supportedAble to act on own initiative but will require supervision Skills (competencies)

Posted 5 days ago

Apply

2.0 - 5.0 years

3 - 7 Lacs

Mumbai

Work from Office

Naukri logo

Data analysts import, inspect, clean, transform, validate, model, or interpret collections of data with regard to the business goals of the company. They ensure that the data sources and repositories provide consistent and reliable data. Data analysts use different algorithms and IT tools as demanded by the situation and the current data. They might prepare reports in the form of visualizations such as graphs, charts, and dashboards. Job Description - Grade Specific The role combines leadership, technical expertise, and project management skills to ensure the successful delivery of data analysis projects and the development of a high-performing data analyst team. They play a critical role in leveraging data to drive business growth, optimize processes, and enable informed decision-making across the organization. Skills (competencies)

Posted 5 days ago

Apply

1.0 - 4.0 years

3 - 5 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging expert knowledge of Process Invoiceing, The Process Invoicing Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They ensure the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. They will manage the contract on a daily basis including operations and finance and complex operational issues and ensure that operations are run according to budget. They will build and develop the team. Their expert domain expertise means they process more complex transactions and producing outputs across Invoice processing activities and manage effective usage of resources in the service delivery Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity

Posted 5 days ago

Apply

4.0 - 8.0 years

3 - 7 Lacs

Kolkata

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of Collections, The Collections Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They ensure the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for chasing outstanding invoices from customers of our clients Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity Skills (competencies)

Posted 5 days ago

Apply

3.0 - 7.0 years

3 - 7 Lacs

Bengaluru

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of one or more R2A processes (record, report, analyze etc), Record to Analyze Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They support the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for processing non complext to complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. Job Description - Grade Specific Responsible for processing complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. The responsibilities will include, but will not be limited to:Preparation (calculation) and processing of complex General Ledger Journals, Accruals, Provisions, allocations and other entries according to the schedule and agreed Client Desktop ProceduresInitiation of accounting entries based on the non standard events and accounting rules not directly described in the Desktop Procedures, but resulting from other Policies and Accounting ManualsProcessing of fixed asset related entries, based on the requests and according to schedule and agreed Client Desktop ProceduresMonitoring of fixed assets related transactions and budgets and contacting the fixed asset owners to initiate the fixed asset capitalizationProcessing of bank statements on daily basis and reconciliation of bank related accounts, as well as clearing and monitoring the sub bank accountsReconciliation of intercompany transactions and agreement of Intercompany balances with counterpartiesInitiation and execution of Intercompany netting / settlementsPreparation and execution of Period End Close related activities according to agreed time table and procedures Monitoring of Period End Close progress, interacting (and escalating if required) with Clients Finance Controllers or Process Owners to ensure timely closure and reportingReconciliation of low/medium risk balance sheet accounts and review and approval of low risk reconciliationsPreparation of operational reports from the area of expertiseInitiation and monitoring of automated transactions, i.e. FX valuation or depreciationPreparation of data for financial, management and treasury reporting moving the data from source systems (ERP) to reporting and consolidation systemsReview and finalization of financial, management and treasury reportingPreparation of tax and statutory reportingExecution, monitoring and testing of financial controls, as per Client Controls Framework Skills (competencies)

Posted 5 days ago

Apply

2.0 - 4.0 years

2 - 4 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of one or more R2A processes (record, report, analyze etc), Record to Analyze Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They support the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for processing non complext to complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity Skills (competencies)

Posted 5 days ago

Apply

3.0 - 7.0 years

3 - 7 Lacs

Noida

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of one or more R2A processes (record, report, analyze etc), Record to Analyze Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They support the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for processing non complext to complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. Job Description - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity Skills (competencies)

Posted 5 days ago

Apply

3.0 - 7.0 years

3 - 7 Lacs

Kolkata

Work from Office

Naukri logo

Role based in BSv organisation. Leveraging deepening knowledge of one or more R2A processes (record, report, analyze etc), Record to Analyze Process Experts participate of in or lead the achievement of service levels, key measurement targets of the team and delivers a high quality and cost-effective service that drive compelling business outcomes. They support the delivery of a customer focused and compliant services through the adoption of frictionless finance, practice processes, technologies, methodologies which drive innovation and process improvements. Their domain expertise means they are responsible for processing non complext to complex transactions, resolving the standard process related issues, preparation and finalization of the period and close activities and reporting (including the interactions with Clients Financial Controllers) and performing the reconciliations. - Grade Specific Entry and mid-Junior level in a Finance Administration roleStrong team player with the ability to build good relationships with their stakeholders.Able to act on own initiative with regular supervision. Understands when to seek guidance/escalateSupports experienced Finance specialists delivering progress reporting, task management and documentation for Finance activity Skills (competencies)

Posted 5 days ago

Apply

7.0 - 12.0 years

10 - 20 Lacs

Hyderabad

Work from Office

Naukri logo

SUMMARY Job Opening: About the Client: Our client is a leading global Fortune 500 IT solutions company that specializes in providing straightforward and scalable solutions to solve intricate business challenges. With a team of over 1,500 professionals, they offer technical and domain expertise across various platforms and industries to assist enterprise companies in enhancing productivity, efficiency, and optimizing their technology investments. Designation: BI Analyst - Team Leader/ Team Manager Experience: 7-15 Yrs Location: Hyderabad Skills required: Attention to detail Problem Understanding Hands-On with Strong SQL Min 2yrs experience working with Large volume data set Good experience in working with End to End Data analytics project, from Data modelling, Data extraction to building the insights Strong Stats + Strong understanding of visualizations w.r.t. business use case. Create technical documentation, versioning, testing, change control, configuration solutions Experience in BI and dashboard Development areas is needed. Knowledge or working experience with machine learning models would be added advantage. Notice period: Immediate - 30 days

Posted 5 days ago

Apply

2.0 - 7.0 years

3 - 8 Lacs

Ahmedabad

Work from Office

Naukri logo

Job Summary: We are seeking a detail-oriented and process-driven SAP Assistant to support the team in managing Operational Expenditure (OpEx) and Capital Expenditure (CapEx) transactions, reporting, and tracking activities using SAP. This role plays a key part in ensuring data accuracy, timely reporting, and compliance with financial and procurement processes in alignment with corporate standards. Key Responsibilities: Create, process, and monitor SAP, including service entry sheets, purchase requisitions, and goods receipt entries. Track and update the status of all expenditure requests and approvals within SAP to ensure timely processing. Generate periodic budget utilization reports, order consumption summaries, and expenditure tracking sheets from SAP. Support the reconciliation of planned vs. actual expenditures and highlight any variances for corrective action. Assist project managers and department leads with SAP-related queries and provide guidance on standard processes. Coordinate with finance, procurement, and project teams to ensure data alignment across functions. Maintain master data accuracy in SAP, including order details, vendor codes, WBS elements, and cost center. Support internal audits and compliance checks by providing SAP-based data and transaction logs. Maintain documentation and records related to SAP transactions for future reference and audit trails. Assist in continuous improvement initiatives related to SAP workflows, reporting accuracy, and user support. Technical Skills and Proficiency: Proficiency in SAP ERP Modules (especially MM, FI, PM, or PS depending on project structure). Strong command over Excel for reporting, data cleaning, and tracking (pivot tables, VLOOKUP, etc.). Ability to extract and format reports from SAP (e.g., budget reports, PO tracking, order histories). Familiarity with procurement processes, service entry, GR/IR processes, and financial controls in SAP. Knowledge of WBS, cost center structures, and order types is highly desirable. Educational Qualifications: Bachelors degree in commerce, Business Administration, Finance, or a related field. Required Experience: Minimum 2 - 5 years of experience working with SAP in a similar support or operations role, preferably in engineering, construction, or infrastructure projects. Familiarity with Operational expenditure & capital expenditure workflows, procurement cycles, and cost control principles.

Posted 5 days ago

Apply

1.0 - 3.0 years

1 - 2 Lacs

Chennai

Work from Office

Naukri logo

Updating the accounts and transactions every day to Tally; Manage Accounts AP&AR functions, invoicing, payment processing& account reconciliation. PO creation, analyzing outstanding trend, followup with clients, sending remainder mails. Required Candidate profile B.Com graduates Experience req 1 to 3 Yrs Good working attitude&high discipline people preferred Excellent knowledge of Tally&Excel Int candidate pl share your cv to hr@ram-nath.com Perks and benefits Fixed Salary & Statutory benefits

Posted 5 days ago

Apply

1.0 - 5.0 years

2 - 4 Lacs

Bengaluru / Bangalore, Karnataka, India

On-site

Foundit logo

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

Posted 6 days ago

Apply

1.0 - 6.0 years

1 - 4 Lacs

Mumbai, Mumbai Suburban, Mumbai (All Areas)

Work from Office

Naukri logo

Adecco is hiring - MIS Executive (Excel Masters) Work Form Office mandatory Locations - 1. Worli 2. Andheri East 3. Powai Role & responsibilities Coordination, Team Work, Collection Data, Data management, MIS Reporting, MIS Report Preparation, Timely Publishing Reports to Management, Maintain and Track Reports. Preferred candidate profile Education - Graduation Skills - Advance Excel, Lookups, Formatting, Macros, Excel Master Salary - 25K (Sunday off) Payroll - Adecco If Interested Please share updated Resume with below details . Post - MIS Qualification - Present Location - Preferred Location - Notice Period - Experience in MIS Reporting - Are you ready to work on Adecco Payroll -

Posted 6 days ago

Apply

3.0 - 7.0 years

1 - 3 Lacs

Noida

Work from Office

Naukri logo

IEnergizer - Hiring for Team Lead MIS/WFM Analyst. Graduation is a MUST. Immediate joiners would be preferred. Job description Should be proficient with MS Excel, Logic building, knowledge of Advanced Excel will be an added advantage as we will be assigning MIS work. MIS reporting to management daily. Experience with Workforce Management software (performance tracking, reporting), Aspect, and Genesis preferred. Candidates with advanced excel skills can apply. The person would be responsible for preparing Daily/Weekly/Monthly reports using intermediate/advanced excel. Required Candidate profile At least 2 years experience in MIS Team lead Role Must have a good knowledge of advance Excel Must be aware of basic Terminology such as Attrition, Shrinkage, CSAT, SLA, Overtime Pay Calculation, Ageing, etc. Should have knowledge of Excel function like VLOOKUP, HLOOKUP, Pivot Table etc Graduation is must Call/Whatsapp HR Amit Latwal @ 8006200310

Posted 6 days ago

Apply

4.0 - 6.0 years

5 - 7 Lacs

Bengaluru

Work from Office

Naukri logo

About PhonePe: PhonePe Group is Indias leading fintech company. Its flagship product, the PhonePe digital payments app, was launched in Aug 2016. Within a short period of time, the company has scaled rapidly to become Indias leading consumer payments app. On the back of its leadership in digital payments, PhonePe Group has expanded into financial services - Insurance, Lending, & Wealth as well as new consumer tech businesses - Pincode and Indus Appstore. We are looking to hire an MIS Executive with the following criteria: Minimum 4+ years of relevant experience in MIS or data analysis Prior experience working with Sales Teams Strong proficiency in Microsoft Excel (including advanced functions such as VLOOKUP, Pivot Tables, Macros, etc.) Hands-on with Power BI and SQL queries Knowledge of Google Sheets Experience handling large datasets Good communication skills and ability to collaborate cross-functionally Additional Info: Work from office (5 days a week) No work-from-home option Immediate joiners preferred Roles & Responsibilities – MIS Executive: Develop, maintain, and update regular MIS reports and dashboards for individual, team, and region-level performance Collect, validate, and analyze large datasets from departments such as Sales, Operations, LMS Learning, Mandays, WOW, etc. Automate reporting processes to improve accuracy and reduce manual intervention Generate actionable insights through performance reports and data visualizations Design and maintain dashboards using Power BI, Excel, and Google Sheets Coordinate with Sales and cross-functional teams to understand and fulfill reporting requirements Track and report KPIs on a weekly and monthly basis Ensure data accuracy and consistency across all reporting platforms Troubleshoot and resolve any reporting-related issues or discrepancies Support ad-hoc data analysis and reporting needs of various stakeholders

Posted 6 days ago

Apply

3.0 - 5.0 years

6 - 14 Lacs

Thane

Work from Office

Naukri logo

presentations. Our client a science-driven pharma and biotech organization is on track to deliver excellence in healthcare. They are run by renowned scientists and business professionals focused on building Diabetes & Cancer biopharmaceuticals. Their mission is to provide affordable healthcare & ensure patients have access to state-of-the-art medical care. Their HQ & R&D centres are in Thane, with an office in Chennai. To meet their ever-growing demands, they are looking for an MIS EXECUTIVE for THANE location. Role : MIS Executive Department : MIS Experience : 3- 6 years Location : Thane Industry : Biotechnology or Pharmaceutical Educational Qualifications: B.Sc. or M.Sc. in Life Sciences/Biology/Chemistry/Biotechnology/Biochemistry/Bioanalytical Sciences/ Microbiology JOB DESCRIPTION 1. Compilation/updation of Gantt chart for all ongoing projects 2. Tracking of baseline vs actual for each project 3. Collation of non-financial MIS report from all HoDs 4. Compilation of financial MIS report from SAP B1 using data summarization tools such as tableau or Power BI 5. Compilation and report preparation of budget vs actual statements of all projects and Opex Skills required 1. MS project 2. SAP B1 3. MS Excel, including advanced Excel such as VLookup, Pivot 4. Tableau/Power BI 5. PowerPoint 6. Excellent English (written and spoken) 7. Candidates who have pursued a Full-time MBA-Finance/Operations with 2 to 4 years of experience, who have assisted CEO/COO as executive assistant in Pharma companies, understand pharma business, create MIS reports, and also make impactful PowerPoint presentations.

Posted 6 days ago

Apply

3.0 - 8.0 years

10 - 11 Lacs

Gurugram

Work from Office

Naukri logo

NAB is looking for Analyst to join our dynamic team and embark on a rewarding career journey Analyze data, interpret trends, prepare reports, and support decision-making through insights Develop models, work with tools like Excel, SQL, or Python ensure data accuracy, and contribute to business optimization and forecasting efforts

Posted 6 days ago

Apply

1.0 - 4.0 years

2 - 4 Lacs

Chennai

Work from Office

Naukri logo

Client Server Tech is looking for EDP Analyst to join our dynamic team and embark on a rewarding career journey Analyze data, interpret trends, prepare reports, and support decision-making through insights Develop models, work with tools like Excel, SQL, or Python, ensure data accuracy, and contribute to business optimization and forecasting efforts

Posted 6 days ago

Apply

7.0 - 12.0 years

10 - 15 Lacs

Thane

Work from Office

Naukri logo

Azzarosol Solutions Pvt Ltd is looking for Senior Lead F & O Functional Consultant to join our dynamic team and embark on a rewarding career journey Undertake short-term or long-term projects to address a variety of issues and needs Meet with management or appropriate staff to understand their requirements Use interviews, surveys etc. to collect necessary data Conduct situational and data analysis to identify and understand a problem or issue Present and explain findings to appropriate executives Provide advice or suggestions for improvement according to objectives Formulate plans to implement recommendations and overcome objections Arrange for or provide training to people affected by change Evaluate the situation periodically and make adjustments when needed Replenish knowledge of industry, products and field

Posted 6 days ago

Apply

1.0 - 2.0 years

1 - 2 Lacs

Kolkata

Work from Office

Naukri logo

Job description Designation:MIS Analyst Industry:BPO Experience :1-3yrs Location:Kolkata Job Description: Create and maintain Management reports including end-of-month, quarterly, and annual reports used by various departments Maintain process for Management to request reports, support and data back up Role & responsibilities Expert at using various MS Office tools - Run & create functions, pivot tables, Formulas, VLOOKUP, charts, Macros & Automatization - Use Excel formulas to add necessary formatting to report spreadsheets Ability to program, organize & to analyse data. Required Candidate profile Interested candidate can call Kamolika-8336067060 or share cv Komolika.RoyChoudhury@imarque.co.in Preferred candidate profile Expert at using various MS Office tools - Run & create functions, pivot tables, Formulas, VLOOKUP, charts, Macros & Automatization - Use Excel formulas to add necessary formatting to report spreadsheets Ability to program, organize & to analyse data. Perks and benefits

Posted 6 days ago

Apply

3.0 - 6.0 years

5 - 8 Lacs

Mumbai

Work from Office

Naukri logo

Job Title: F&A Senior Admin Assistant (Grade 7) Job Summary: We are seeking a highly organized and detail-oriented administrative assistant to perform a variety of general administrative tasks. This role includes preparing reports using various software packages, compiling information from multiple sources, and managing small-scale projects. The ideal candidate will have understanding of Logistics flow and be proficient in Microsoft Excel, with knowledge of billing processes. Key Responsibilities: Prepare reports and presentations using Microsoft Excel and other software tools Maintain confidentiality when dealing with sensitive information Assist with billing processes and documentation Provide general administrative support as needed Qualifications: Proficiency in Microsoft Excel (advanced functions such as pivot tables, formulas, and data visualization) Strong attention to detail and ability to handle confidential information Excellent organizational and communication skills Familiarity with billing processes is a plus

Posted 6 days ago

Apply

Exploring Pivot Table Jobs in India

The job market for pivot table professionals in India is growing rapidly, with a high demand for individuals who possess strong analytical skills and proficiency in data manipulation using pivot tables. Companies across various industries are actively seeking candidates who can effectively utilize pivot tables to analyze and present data insights.

Top Hiring Locations in India

  1. Bangalore
  2. Mumbai
  3. Delhi
  4. Hyderabad
  5. Pune

Average Salary Range

The average salary range for pivot table professionals in India varies based on experience levels. Entry-level positions may offer salaries ranging from INR 3-5 lakhs per annum, while experienced professionals can earn upwards of INR 10-15 lakhs per annum.

Career Path

Typically, a career in pivot table roles progresses from Junior Analyst to Senior Analyst, with opportunities to advance to roles such as Data Scientist or Business Intelligence Manager.

Related Skills

In addition to proficiency in pivot tables, employers often look for candidates with skills in data visualization, Excel, SQL, and statistical analysis.

Interview Questions

  • What is a pivot table and how is it useful in data analysis? (basic)
  • Explain the difference between a pivot table and a VLOOKUP function in Excel. (medium)
  • How would you handle missing data when creating a pivot table? (medium)
  • What are some common challenges you might face when working with pivot tables, and how would you address them? (advanced)
  • Can you walk us through a complex data analysis project where you used pivot tables to derive insights? (advanced)
  • How do you ensure the accuracy and integrity of data when using pivot tables for reporting? (medium)
  • Describe a scenario where you had to present complex data insights derived from pivot tables to non-technical stakeholders. How did you communicate the findings effectively? (advanced)
  • What are some best practices you follow when creating pivot tables to ensure efficiency and accuracy? (medium)
  • How do you handle large datasets when working with pivot tables in Excel? (medium)
  • Can you explain the concept of calculated fields in pivot tables and provide an example of when you used them in your analysis? (advanced)
  • How do you stay updated on the latest trends and advancements in pivot table techniques? (basic)
  • What are some common mistakes people make when working with pivot tables, and how can they be avoided? (medium)
  • Walk us through the process of creating a pivot chart based on data from a pivot table. (medium)
  • How do you deal with outliers or anomalies in data when creating pivot tables? (medium)
  • What are some advanced features in Excel that can enhance the functionality of pivot tables? (advanced)
  • Can you explain the concept of pivot caching and its significance in pivot table performance? (advanced)
  • How do you handle sensitive or confidential data when working with pivot tables? (medium)
  • Describe a time when you had to troubleshoot a technical issue related to pivot tables and how you resolved it. (medium)
  • How do you handle conflicting or inconsistent data sources when consolidating data in a pivot table? (medium)
  • What are some limitations of pivot tables, and how do you work around them in your analysis? (advanced)
  • Can you automate the process of updating pivot tables with new data sources in Excel? If so, how? (advanced)
  • Describe a scenario where you had to collaborate with cross-functional teams to gather data inputs for a pivot table analysis. How did you ensure data consistency and accuracy? (advanced)
  • How do you approach data validation and cleansing before creating pivot tables to ensure data accuracy? (medium)
  • Can you provide examples of how you have used pivot tables to identify trends or patterns in data that led to actionable insights for the business? (advanced)

Closing Remark

As you prepare for pivot table roles in India, remember to showcase your proficiency in data analysis, problem-solving skills, and attention to detail during interviews. With the right combination of technical expertise and communication skills, you can excel in this dynamic and rewarding field. Good luck with your job search!

cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Featured Companies