EXCEL TRICKS (VIKAL JAIN)
930 posts
EXCEL TRICKS (VIKAL JAIN)
@VikalExcel
Excel Trainer l, trained more than 25k candidate accross the world. Holding CA degree from ICAI.
Shahdara, New Delhi Katılım Ağustos 2015
31 Takip Edilen790 Takipçiler
🚀 Create Positive & Negative Bar Charts in Excel Like a Pro!
Want to visualize profits vs losses, growth vs decline, or positive vs negative values clearly in Excel? In this video, I show you how to create a Positive & Negative Bar Chart that makes your data instantly understandable.
📊 Perfect for:
• Financial analysis
• Profit & Loss comparison
• Budget vs Actual reports
• Business dashboards
💡 Master Excel, Power BI, AI & Automation with practical projects.
🎓 Join my Paid Professional Courses
👉 xlgenai.com
Learn:
• Advanced Excel & Automation
• Power BI Dashboards
• AI tools for Finance
• Real-world data analysis projects
📩 Message me for upcoming batches.
#Excel #ExcelTips #DataVisualization #ExcelCharts #ExcelTraining #ExcelAutomation #PowerBI #DataAnalytics #LearnExcel #vikaljain
English
🔹 **Want to Remove Your Middle Name Easily? Here's How!** 🔹
Are you looking to remove your middle name from official documents like Aadhaar, PAN, Passport, or bank records? You're not alone—many people are simplifying their names for consistency and ease of use.
✅ **Why Remove Middle Name?**
• Avoid document mismatches
• Simplify official records
• Ensure uniform name across all IDs
• Reduce verification issues
📝 **Steps to Remove Middle Name:**
1. Prepare an affidavit for name change
2. Publish notice in newspaper (if required)
3. Update name in government IDs (Aadhaar, PAN, Passport)
4. Inform banks and other institutions
⚡ **Pro Tip:** Always keep supporting documents ready to avoid delays in updates.
📌 Removing your middle name can make your identity cleaner and hassle-free across all platforms. Start the process today and stay consistent everywhere!
---
#RemoveMiddleName #NameChange #LegalNameChange #AadhaarUpdate #PANUpdate #PassportUpdate #IdentityProof #DocumentUpdate #PersonalBranding #DigitalIdentity #IndiaServices #LegalProcess #KYCUpdate #OfficialDocuments #SimpleName #SEOContent #TrendingNow
English
English
English
English
English
T and N saga in Excel
Most people struggle to split text and numbers in Excel when both are mixed in one cell.
Example:
A2 = INV2024A15
Now we want:
Text Part → INV A
Number Part → 2024 15
Here are simple solutions 👇
Method 1 – Extract Numbers
=TEXTJOIN("",TRUE,IF(ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"")))
(Press Ctrl+Shift+Enter in older Excel)
Method 2 – Extract Text
=TEXTJOIN("",TRUE,IF(NOT(ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))),MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"")))
Modern Excel (Office 365) – Better Version
Numbers Only:
=TEXTJOIN("",,IF(ISNUMBER(--MID(A2,SEQUENCE(LEN(A2)),1)),MID(A2,SEQUENCE(LEN(A2)),1),""))
Text Only:
=TEXTJOIN("",,IF(NOT(ISNUMBER(--MID(A2,SEQUENCE(LEN(A2)),1))),MID(A2,SEQUENCE(LEN(A2)),1),""))
Now Create a LAMBDA Function (Reusable)
Step 1: Go to Name Manager
Step 2: New Name → SplitTN
Step 3: Paste this formula:
=LAMBDA(txt,type,
LET(
chars,MID(txt,SEQUENCE(LEN(txt)),1),
IF(type="N",
TEXTJOIN("",,IF(ISNUMBER(--chars),chars,"")),
TEXTJOIN("",,IF(NOT(ISNUMBER(--chars)),chars,""))
)
))
Now use it like:
=SplitTN(A2,"N") → Extract Numbers
=SplitTN(A2,"T") → Extract Text
Clean. Dynamic. Reusable.
Follow for more Excel automation tips. #vikaljain #excel #excelautomation
English
Replace ALT + ENTER Line Break with Space in Excel (Using CHAR(10))
Many times data comes like this:
Vikal
Jain
But we want it in a single line like:
Vikal Jain
✅ Use this formula:
=SUBSTITUTE(A1,CHAR(10)," ")
💡 How it works:
CHAR(10) = Line Break (ALT + ENTER)
SUBSTITUTE replaces line break with a space
#Excel #ExcelTips #DataCleaning #AdvancedExcel #Productivity #vikaljain
English