What should a fresher do in the months before joining a tier-1 B-school to enhance the profile for SIP (summer internship)?

Freshers joining a tier-1 B-school should focus on building Excel fluency, earning relevant certifications, and competing in case competitions during the pre-joining window. These three activities directly translate into interview talking points and day-one productivity during your summer internship.

Master Excel and PowerPoint first

Spreadsheet work underpins consulting, finance, and marketing roles alike. Freshers often underestimate how much time they'll spend in Excel during the SIP.

Aim for comfort with pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and basic macros before orientation begins. PowerPoint storytelling matters equally for consulting roles.

McKinsey and BCG expect clean, structured decks from day one, and you won't have time to learn formatting shortcuts during your eight-week project.

From Reddit, we learnt that many freshers regret not learning these tools earlier, since the first term moves too fast to pick them up alongside coursework. Dedicate 20-30 hours across June and July to structured practice rather than passive YouTube watching.

Certifications that add interview value

Google certifications (Analytics, Digital Marketing, Data Analytics) are free and take 15-25 hours each. They won't replace your MBA curriculum, but they give you concrete proof of initiative and create natural talking points when recruiters ask, "What did you do to prepare?" HubSpot Inbound Marketing and SQL for Data Science (Coursera) are also lightweight additions that signal curiosity.

Avoid expensive or months-long programs. The goal is not another degree but rather 2-3 lines on your résumé that show you didn't spend the summer idle.

If you're targeting consulting, consider a case interview prep course (Victor Cheng's LOMS or CaseCoach) to get ahead of peers who start cold in September.

Case competitions are gold dust

Participating in pre-MBA case competitions (many IIMs, XLRI, and ISB host open contests) gives you real problem-solving reps and often a project to discuss in SIP interviews. Winning isn't essential; the experience of structuring a business problem, working in a team under time pressure, and presenting to judges mirrors the SIP selection process itself. Compare colleges to see which schools your peers are joining and scout their summer competition calendars.

Read industry reports and business news

Freshers often lack context for corporate strategy discussions. Spend 30 minutes daily reading Economic Times, Mint, or Ken to build a mental map of sectors, recent M&A, and regulatory shifts. Download annual reports from firms you admire (Unilever, Tata Steel, HDFC Bank) and skim the MD&A section to understand how executives frame performance. This habit pays off when interviewers ask, "Why consulting?" or "Which sector interests you?" and you can cite a recent deal or trend rather than generic platitudes.

Network with second-years early

Reach out to current students via LinkedIn or your admit group. Ask which electives pair well with consulting or finance SIPs, which clubs drive the most recruiter engagement, and whether any pre-reads (like *Case in Point* or *Investment Banking* by Rosenbaum) are worth tackling early. Second-years at IIM Ahmedabad, IIM Bangalore, and IIM Calcutta often share SIP preparation decks and mock interview slots if you ask politely in July or August. Build your MBA report to map out your two-year roadmap and identify which skills to prioritize now.