5 Excel skills that got me my first internship (and how to learn them in 2 weeks)
When I was applying for internships, I kept seeing the same thing on every job posting: "Proficient in Microsoft Excel."
I thought I knew Excel. I could type in cells and maybe do a SUM formula. That was not proficient.
Here are the 5 skills that actually matter at the entry level:
1. VLOOKUP / XLOOKUP — Every office job involves matching data across tables. This is the #1 skill interviewers test for.
2. Pivot Tables — You'll use these to summarize thousands of rows into actionable insights. Takes 10 minutes to learn, saves hours.
3. Conditional Formatting — Makes your spreadsheets look professional and highlights what matters. Managers love this.
4. Data Cleaning (TRIM, CLEAN, TEXT-TO-COLUMNS) — Real-world data is messy. Knowing how to clean it puts you ahead of 90% of applicants.
5. Charts & Data Visualization — Being able to turn numbers into a clean chart for a presentation is an instant credibility boost.
The good news? You can learn all of this in about 15 days if you practice consistently. I built a structured, day-by-day roadmap that takes you from absolute beginner to interview-ready.
If you're a college student prepping for internship season — this is for you.
