Sales Support Intern

Roles & Responsibilities

• Expert in MS-Excel & MS-PowerPoint (PPT) & Charts that includes Vlookup,Hlookup,Index,Match,Sumif,Sumifs,Countif,Countifs,if,PivotTables,

Formulas,DataFilter,ConditionalFormatting,DataValidation,AdvancedFilter,Sorting,Hyperlinking,PasteSpecialFunctions,RemoveDuplicates,Concatenating,OtherFunctions,Charts,PPT etc.

• Data Collection in the required formats & Consolidation of MIS.
• Providing MIS Report & Analysis of Report.
• Preparing Reports on daily basis, Analysis of data, Monitoring and updating of data, coordinating with the other department for updating of various data.
• Preparing daily, weekly and monthly MIS reports / Dashboards. Should create, maintain and update Database. Should possess the ability to interpret requests on reporting metrics.
• Requirements Gathering from client. Data reading from various sources like Excel, CSV. Analyze the requirement and understanding business concepts. Data analyzing by using various functions in Excel. Giving the data into excel sheets based on users request. Stored completed documents in designated locations. Good knowledge on Excel concepts. Knowledge on Data Validation.
• Daily & Monthly Primary & Secondary sales reports.
• Outlets reports (Billed & Non Billed).
• Growth% & Contribution% reports.
• Invoicing & Redistribution reports.
• Claim & Scheme reports.