SMC Global Securities

Advanced Excel & Analytics Intern

InternshipIn OfficeShillong, Meghalaya3 months10K/mo5 openingsImmediate / Rolling

About this internship

SMC Global Securities has an open Advanced Excel & Analytics Intern position in Shillong for motivated freshers and final-year students. You will work on live spreadsheet analytics and modelling projects and finish with something you can genuinely talk about in interviews. About the role As an…

Similar internships hiring now

View all

Not quite right? These internships in Shillong, Meghalaya match the same skills — apply to a few to improve your chances.

Data Analyst Intern

Zopper

In OfficeShillong, Meghalaya12K/mo

Apply

Flutter App Developer Intern

KreditBee

In OfficeShillong, Meghalaya18K/mo

Apply

Operations Data Analyst Intern

FINN

In OfficeShillong, Meghalaya13K/mo

Apply

Market Research & Data Analyst Intern

Great Learning

In OfficeShillong, Meghalaya8K/mo

Apply

Skills you'll use

Advanced ExcelPivot TablesPower QueryLookup & Reference FunctionsWhat-If & Scenario AnalysisCharts & Conditional FormattingData ValidationExcel ModellingGoogle SheetsSQL Basics

What you'll do

Work on building the models, trackers and what-if analyses the business runs on in Excel alongside the core team
Apply Advanced Excel, Pivot Tables, Power Query, Lookup & Reference Functions to live, production-facing problems
Document your work clearly for reviewers and stakeholders
Participate in reviews and act on the feedback you receive
Collaborate across engineering, product, design or business as required
Follow the team's quality, testing and documentation standards

Who can apply

Pursuing or recently completed B.Com/M.Com, BBA/MBA, B.Sc (Statistics / Mathematics) or any graduate
Graduating batch 2026 or 2027 — final-year students and recent graduates welcome
60% / 6.0 CGPA and above preferred; strong project work is considered alongside academics
Working knowledge of Advanced Excel, Pivot Tables, Power Query (or a genuine willingness to learn them)
Exposure to Lookup & Reference Functions, What-If & Scenario Analysis, Charts & Conditional Formatting is an advantage
Clear written and verbal communication in English, and care with detail in your work
No prior work experience required — this is a fresher-friendly internship
Based in Shillong, Meghalaya or willing to work from there for the internship period

Perks & benefits

Networking with senior professionalsInternship CertificateLetter of RecommendationMentorship from a named mentorLive project experienceDirect access to the team that owns the data you work on

Interview & selection process

3 rounds — typical selection flow for this role:

1Application screening & resume shortlisting by the talent team
2Online aptitude / domain assessment
3HR discussion — stipend, start date, expectations and offer

About SMC Global Securities

SMC Global Securities operates in the capital markets & broking sector and has an active presence in Shillong. Interns here are put on real work from the start, because the team's view is that the fastest way to learn a craft is to practise it under people who already do it well — not to watch it…

Visit SMC Global Securities’s official website ↗

Apply Now Find internships at SMC Global Securities

Searching for “SMC Global Securities internships” or “internship at SMC Global Securities”? You’re in the right place.