Opportunity brief
About the Company
VSPH Global is seeking a detail-oriented MIS Executive Intern to support business operations through accurate data management, structured reporting, and clear visual communication. The intern will work remotely with the founder and cross-functional departments, helping convert business data into useful dashboards, presentations, and documentation.
Responsibilities
- Create daily, weekly, and monthly MIS reports covering sales, leads, employees, clients, projects, revenue, expenses, attendance, and productivity.
- Maintain the founder and management dashboard along with department-wise Excel and Google Sheets trackers.
- Build professional Excel dashboards using graphs, KPIs, Pivot Tables, Pivot Charts, data validation, XLOOKUP or VLOOKUP, SUMIFS, COUNTIFS, IF, and related formulas.
- Collect, consolidate, and verify information from multiple departments, identifying missing data, errors, and inconsistencies.
- Prepare PowerPoint presentations, PDF reports, proposals, and professionally formatted Word or Google Docs.
- Maintain organized reporting templates and documentation, support ad-hoc analysis for the founder, and gradually identify opportunities to automate repetitive reporting.
Requirements
- Applicants may be pursuing or have recently completed B.Com, BBA, BCA, B.Sc. IT, or an MBA.
- Strong practical comfort with MS Excel, including intermediate to advanced formulas, Pivot Tables, and dashboard creation, is more important than a particular degree.
- Working knowledge of Google Sheets, PowerPoint, Word or Google Docs, basic data analysis, professional formatting, and clear communication.
- High attention to detail, numerical confidence, ownership of data accuracy, and an organized approach to documentation.
- Power BI, Power Query, Canva, Google Looker Studio, basic SQL, VBA or Excel automation, and AI productivity tools such as ChatGPT or Copilot will be advantageous but are not mandatory.