ThinkTheta Excel

ThinkTheta Excel ThinkTheta helps you learn Excel for jobs, business & freelancing. Simple Hindi/Hinglish explanations. Grow your skills & work smarter. πŸš€

Learn practical Excel from basics to advanced with real-life examples, dashboards & automation.

14/04/2026

Can’t sum numbers like 8 kg, 9 kg, 10 kg in Excel? 🀯
Excel sees them as text ❌
But this trick fixes it instantly ⚑
πŸ‘‰ Use this formula:
SUMPRODUCT + SUBSTITUTE πŸ”₯
πŸ’‘ Now you can calculate totals even with units like kg, β‚Ή, %, etc.
🎯 Perfect for:
βœ” Inventory data
βœ” Weight calculations
βœ” Real-life messy Excel data
πŸ‘‰ Comment β€œSUM” if you want more powerful Excel tricks
πŸ‘‰ Follow for daily Excel tips
productivity thinktheta excelforjobs automation

13/04/2026

Stop doing DR/CR manually in Excel ❌
Use this simple IF formula and split data instantly ⚑
πŸ‘‰ DR β†’ goes to Dr column
πŸ‘‰ CR β†’ goes to Cr column
πŸ’‘ Formula: =IF(B2="Dr",C2,"")
=IF(B2="Cr",C2,"")
🎯 Perfect for: βœ” Accounting work
βœ” Tally users
βœ” Office reports
βœ” Beginners
πŸ”₯ Save hours of manual work!
πŸ‘‰ Comment β€œACCOUNT” if you want more tricks
πŸ‘‰ Follow for daily Excel tips
productivity thinktheta excelforjobs

12/04/2026

Reverse any list in Excel in seconds πŸ”βš‘
No manual work ❌
No copying & pasting ❌
Use this smart trick and flip your data instantly πŸ”₯
πŸ’‘ Perfect for:
βœ” Data cleaning
βœ” Reports
βœ” Sorting tasks
βœ” Excel interviews
πŸ‘‰ Comment β€œREVERSE” if you want more such tricks
πŸ‘‰ Follow for daily Excel tips
πŸ”— Learn more: https://m.youtube.com/⁠�
dataanalysis thinktheta excelforjobs automation

11/04/2026

Write powers & chemical formulas in Excel like a pro ⚑
Want to type:
πŸ‘‰ mΒ²
πŸ‘‰ Hβ‚‚O
Use Superscript & Subscript in Excel πŸ”₯
πŸ’‘ How: Select text β†’ Press Ctrl + 1 β†’ Font β†’ Choose Superscript/Subscript
🎯 Perfect for: βœ” Students
βœ” Reports
βœ” Scientific data
βœ” Professional formatting
πŸ‘‰ Comment β€œFORMAT” if you want more Excel tricks
πŸ‘‰ Follow for daily Excel tips
πŸ”— Learn more: https://m.youtube.com/⁠�
productivity thinktheta excelforjobs

09/04/2026

Make your Excel look professional in seconds ⚑
Use this hidden shortcut πŸ‘‡
πŸ‘‰ ALT + O + A = Auto Format
No need to format manually ❌
Just one shortcut and your data looks clean & structured πŸ”₯
πŸ’‘ Perfect for:
βœ” Reports
βœ” Tables
βœ” Office work
βœ” Quick formatting
πŸ‘‰ Select data β†’ Press ALT + O + A β†’ Choose style β†’ Done βœ…
πŸ‘‰ Comment β€œFORMAT” if you want more hidden shortcuts
πŸ‘‰ Follow for daily Excel tips
πŸ”— Learn more: https://m.youtube.com/⁠�
thinktheta excelforjobs automation

Address

New Delhi
New Delhi
110001

Website

Alerts

Be the first to know and let us send you an email when ThinkTheta Excel posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category