📊 EXCEL
5 min read
5 Excel Formulas Every MBA Graduate Must Know
Most graduates know SUM and AVERAGE. Here are the 5 that actually get you noticed in your first job.
🔑 VLOOKUP / XLOOKUPFind data across tables instantly. If you manage any kind of list or database at work, this is your most-used formula.
🔑 INDEX + MATCHMore powerful than VLOOKUP. Can look left, handle duplicates, and won't break when you insert columns.
🔑 SUMIF / COUNTIFAdd or count only the rows that match your condition. "Total sales in March" or "How many clients from Delhi?" — one formula.
🔑 IFERRORWraps any formula and shows a clean message instead of #N/A or #DIV/0!. Makes your sheets look professional.
🔑 TEXTConvert dates, numbers and codes into exactly the format you need. =TEXT(A1,"DD MMM YYYY") turns 44927 into "01 Jan 2023".
📊 EXCEL
4 min read
10 Excel Shortcuts That Will Save You 2 Hours Every Week
Stop clicking through menus. These keyboard shortcuts are what separate a slow user from an Excel power user.
Ctrl + Shift + L
Toggle Filters
Ctrl + Shift + +
Insert Row/Column
Alt + H + O + I
AutoFit Column
Ctrl + Shift + End
Select to Last Cell
📊 EXCEL
6 min read
What is a PivotTable? A Beginner's Guide for Students
PivotTables sound intimidating but they're the single most powerful Excel feature for anyone working with data.
What it does:Summarises thousands of rows of data into a neat, interactive report — in about 30 seconds, with no formulas.
When to use it:Any time you have a list and want to answer questions like "Total sales by region", "Average score by department", "Count of orders per month".
How to create one (3 steps):1. Click anywhere in your data table. 2. Go to Insert → PivotTable. 3. Drag fields into Rows, Columns and Values. That's it.
Pro tip:Always convert your data to a Table first (Ctrl+T). That way when you add new rows, your PivotTable refreshes to include them.
🤖 AI TOOLS
5 min read
How to Use ChatGPT at Work: A Practical Guide for Freshers
AI isn't replacing you — but someone who knows how to use AI might. Here's how to actually use it in your daily work.
✍️ Writing emails faster:Prompt: "Write a professional follow-up email to a client who hasn't responded in 3 days. Keep it short and polite." Then edit the output to sound like you.
📊 Summarising long documents:Paste any long report or policy doc and ask "Summarise the 5 most important points in bullet form." Saves 30–40 minutes per document.
💡 Brainstorming ideas:Stuck on a presentation? Ask "Give me 10 creative angles for a slide deck about Q2 sales performance for a retail company."
⚠️ What NOT to do:Don't paste confidential company data into ChatGPT. Don't use AI outputs without reading them. Always verify numbers and facts.
🤖 AI TOOLS
4 min read
ChatGPT vs Claude vs Gemini — Which AI Should You Use?
They all look similar on the surface. Here's when each one actually shines — and when to switch.
ChatGPT (OpenAI)
Best for: generating content, coding, brainstorming. Widest plugin ecosystem. GPT-4o is excellent for multimodal (images + text) tasks.
Claude (Anthropic)
Best for: long documents, nuanced writing, following complex instructions precisely. Handles 200,000 tokens — can read an entire book in one go.
Gemini (Google)
Best for: real-time web search, integrating with Google Workspace (Docs, Sheets, Gmail). Use it when you need current information.
Quick rule:Writing/editing → Claude. Coding/plugins → ChatGPT. Research/Google apps → Gemini.
📈 POWER BI
5 min read
What is Power BI? A Simple Explanation for Non-Technical Professionals
Power BI is one of the most in-demand skills in corporate India right now. Here's what it actually is — in plain English.
The one-line explanation:Power BI connects to your data (Excel, databases, Google Sheets) and turns it into interactive charts and dashboards that update automatically.
Why companies use it:Instead of emailing Excel files around every Monday morning, you publish one dashboard that everyone opens and the numbers are always current.
Is it hard to learn?The basics (connecting data, making charts, publishing) take a day to learn. The advanced stuff (DAX formulas, data modelling) takes longer — but you don't need all of it to get value from it.
Who should learn it?Anyone in finance, marketing, sales, operations, or consulting. If you're shown data in meetings, Power BI will make you the one creating those slides instead of waiting for them.
🗺️ PRODUCT MGMT
6 min read
How to Crack Your First PM Interview: 5 Frameworks That Actually Work
PM interviews are structured problems. Once you know the 5 frameworks, most questions become predictable.
1. Define the user first:Every PM answer starts with "Who is the user?" Before solving anything, segment your users and pick one to focus on.
2. RICE Prioritisation:Reach × Impact × Confidence ÷ Effort. Use this to rank features when asked "how would you prioritise your roadmap?"
3. The North Star Metric:Every product has one metric that matters most (e.g. WhatsApp = messages sent/day). Tie all your decisions back to it.
4. Root cause analysis:"DAU dropped 20% — why?" Walk through: is it a data issue, external, or product change? Then go deeper with each hypothesis.
5. User story format:"As a [user], I want to [action] so that [outcome]." Interviewers test if you think from the user's perspective, not the engineer's.
💼 CAREER
4 min read
Why 65% of MBA Graduates Are Underprepared for Their First Job
The gap between what colleges teach and what companies expect has never been wider. Here's what's actually missing.
The theory vs tools gap:Colleges teach Porter's Five Forces. Companies ask you to build a dashboard in Power BI and present it in 20 minutes. These are very different skills.
What hiring managers actually look for:Can you structure a problem? Can you work with data in Excel? Can you communicate clearly? Most freshers can't do all three confidently on day one.
The 3 skills that close the gap fastest:Excel (for data), AI Tools (for productivity), and clear communication. Master these and you'll be in the top 20% of any entry cohort.
What you can do today:Spend 3 hours on a live, practical workshop. You'll leave with a skill you can use at work on Monday — not a certificate collecting dust.
💼 CAREER
3 min read
How to Add a Workshop Certificate to Your LinkedIn Profile
A NextMile Labs certificate on your LinkedIn isn't just a badge — it tells recruiters you're proactively upskilling. Here's how to do it right.
Step 1 — Add to Licences & Certifications:Go to your LinkedIn profile → Add section → Licences & Certifications. Add "Excel for Professionals" under NextMile Labs with the issue date.
Step 2 — Add a verification ID:Your certificate includes a verification ID. Put it in the "Credential ID" field. Recruiters can verify it's real.
Step 3 — Post about it:A post saying "Just completed a 3-hour live workshop on Excel — here are 3 things I learned" gets 3–5× more engagement than just updating your profile silently. Tag @nextmilelabs.
Step 4 — Add skills:Go to your Skills section and add Microsoft Excel, Data Analysis, or AI Tools. These get endorsed by connections and show up in recruiter searches.