Set up and maintain prices, discounts, rebates, promotions, and commercial terms in business systems.
Verify the accuracy and consistency of collected data before completing system transactions.
Experience
Freshers
Must-have skills
MS ExcelCustomer Service
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Trainee - Sales Administrator
Trainee – Sales Administrator
Job Mission
We are looking for a detail-oriented and organized individual to join our Sales Administration team as a Trainee. The role involves supporting Sales and Commercial teams with day-to-day operational activities while ensuring accurate pricing administration, customer master-data maintenance, credit note processing, and customer request management. The ideal candidate should possess strong analytical, financial, and customer service skills, along with a keen interest in Sales Operations and Commercial Administration.
The trainee will undergo structured training across the following areas:
This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.
Questions you may be asked
What is the difference between relative, absolute and mixed cell references?
How does VLOOKUP work, and why do you usually set its last argument to FALSE?