Your cart is currently empty!
Tag: Excel Tips India
-
How to Calculate Standard Error of the Mean (SEM) in Excel
👨💼 Meet Rahul – The Interview Story Rahul, a recent graduate from Delhi, walks confidently into an Excel data analyst interview at a top MNC. He’s aced formulas like VLOOKUP, IF, and PivotTables. But then, the interviewer leans in and asks: “Rahul, how do you calculate the Standard Error of the Mean in Excel?” Rahul…
-
How to Add Quotes Around Numbers or Text in Excel
🎥 The Problem Begins… Meet Aman, a data analyst at a film production house in Mumbai. One fine Monday morning, his boss (let’s call him Kabir, the no-nonsense producer from War) walks in and says: “Aman, I need this actor list uploaded to our website, but make sure every name is in double quotes —…
-
How to Convert Numbers to Words in Indian Rupees in Excel (With VBA)
💰 How to Convert Numbers to Words in Indian Rupees in Excel Excel doesn’t have a built-in function to convert numbers to words (like “12345” → “Twelve Thousand Three Hundred Forty-Five”) — especially not in the Indian currency format like “Rupees Twelve Thousand Three Hundred Forty-Five Only”. But you can achieve this using a custom…
-
How to Add Country or Area Code to Phone Numbers in Excel
📞 How to Add Country/Area Code to a Phone Number List in Excel – With Example Adding a country code or area code to phone numbers in Excel is a common task in data cleaning and formatting. It’s especially useful when preparing lists for international communication, WhatsApp campaigns, or CRM uploads. ✅ Example Scenario: Add…