Excel Trainer | MIS | Power BI
Daily Excel Tips in Hindi
Learn Excel for Job & Growth
Stop Typing Month Names
Extract day, month & year instantly
=DAY(A2)
=MONTH(A2)
=YEAR(A2)
Build smarter reports
Save this reel
Follow for daily Excel hacks
03/03/2026
Before
Total changes with Region selection
After
Grand Total stays constant
Power BI DAX Trick
CALCULATE( SUM(Sales[Amount]), ALL(Sales[Region]))
Ignore slicer
Show real total
Build smarter dashboards
Save this
Share with BI learners
Hashtags (20–25):
01/03/2026
Sohan Dey GyanOnTube:
Before
Basic filters only
After
Smart dynamic filtering
Power BI Advanced DAX
CALCULATE(
SUM(Sales[Amount]),
FILTER(
Sales,
Sales[Revenue] > 0
)
)
Custom row logic
Advanced analytics
Next-level BI skill
Save this
Share with Power BI learners
Hashtags (20–25):
Sohan Dey GyanOnTube:
Excel Interview Question
Create connected dropdowns in Excel
Name your ranges
Create first dropdown
Use =INDIRECT(A2)
Boom 💥 Dynamic validation.
Save this reel
Follow for daily Excel hacks
Excel Trick You’re Not Using 😳
Make Excel formulas look PRO
Use Name Manager in Excel.
✔ Name your ranges
✔ Create dynamic formulas
✔ Build smart dashboards
Save this reel
Follow for daily Excel hacks
26/02/2026
Before
No proper total calculation
After
Dynamic Total Sales
Power BI SUMX Magic
SUMX(
Sales,
Sales[Quantity] * Sales[Price])
Row by row calculation
Cleaner dashboards
Advanced BI skill
Save this for later
Share with Power BI learners
Dependent List in 1 Formula 🔥
Excel can auto-generate city list 😎
Use:
=UNIQUE(FILTER(Table1[City],Table1[State]=O1))
Select state
Filter cities
Remove duplicates
Fully dynamic
Save this reel
Follow for daily Excel hacks
24/02/2026
Before
All years mixed together 😵
After
Only 2024 Sales 😍
Power BI DAX Trick
CALCULATE(
SUM(Sales[Amount]),
Sales[Year] = 2024
)
Change filter context
Get precise insights
Pro BI skill
Save this
Share with BI learners
Check 2 Conditions in 1 Formula 🔥
Excel can check TWO things at once 😎
Use this:
=IF(AND(D2>=E2,C2="Sales"),"Bonus","")
Target achieved
Department = Sales
Both TRUE → Bonus
That’s IF + AND 🔥
Save this reel
Follow for daily Excel hacks 💚
Need to calculate employee bonus automatically in Excel? 💰
Use this Nested IF formula:
=IF(D2>=E2*1.2,5000,IF(D2>=E2,2000,"Not Eligible"))
Excel checks:
First condition
Second condition
Otherwise result
Perfect for:
Incentives
Commission
Performance grading
Smart logic. Powerful reporting
Sohan Dey GyanOnTube:
Nested IF Made Simple
Excel can calculate bonus automatically
=IF(D2>=E2*1.2,5000,IF(D2>=E2,2000,"Not Eligible"))
Above 120% → 5000
Above 100% → 2000
Below Target → Not Eligible
That’s Nested IF
Save this reel
Follow for daily Excel tricks
17/02/2026
Before
Counting days manually
After
Instant working days calculation
=NETWORKDAYS(A2,B2)
No manual counting
Accurate results
Perfect for HR & projects
Save this
Share with Excel learners