Salary: 1.8 upto 2.4 CTC (based on skills & experience)
Experience: 0–3 Years
Company: PREPCA
About PREPCA
PREPCA is a Leading Mentorship Platform for Chartered Accountancy Aspirants across India focused on Quality Education, Smart Learning Strategies, and Strong Career Guidance.
KEY RESPONSIBILITIES
- Collect, organize, and maintain business data
- Prepare daily, weekly, and monthly MIS reports
- Create Sales and Revenue dashboards using Advanced Excel
- Track KPIs and performance metrics
- Identify trends and highlight improvement areas
- Ensure data accuracy and consistency
SKILLS & REQUIREMENTS
Strong knowledge of Advanced Excel:
- CountIFs, SumIFs, Array Formla, Querry, Etc
- VLOOKUP / XLOOKUP
- Conditional Formatting
- Data Cleaning
- Interactive Dashboard Creation
- Robust analytical and logical thinking ability
- Good attention to detail
- Comfortable working with numbers and structured data
PREFERRED
- 0–3 years of experience in Data Analysis / MIS / Reporting
- Experience from any industry or domain welcome
- Freshers with strong Excel skills are encouraged to apply
Weekly Off - Rotational
Mode of Working- Work From Office
Office Location -
Sai Heritage, 3'rd floor, Baner Rd, near State Bank of Mysore, Baner, Pune, Maharashtra 411045